APPS.ARP_MESSAGE dependencies on AR_CONC_REQUEST_MESSAGES

Line 28: -- ar_conc_request_messages, as previous call

24: -- 31-MAR-94 W Smith AR copies this package for its own use.
25: --
26: -- 10-FEB-97 V Ahluwalia When others then exception is raised into the
27: -- outer block in insert into
28: -- ar_conc_request_messages, as previous call
29: -- caused looping when table extents are full
30: -- 29-MAR-01 J Huang Bug 1706869: Modified procedure Insert_Row to
31: -- make it as AUTONOMOUS_TRANSACTION.
32: -- 02-14-02 Added one more procedure to get last few messages

Line 85: -- AR_CONC_REQUEST_MESSAGES

81: -- messages will be stored.
82: G_Ins_Message_Flag VARCHAR2(1) := 'N'; -- Flag to indicate whether
83: -- the current message needs
84: -- to be inserted into
85: -- AR_CONC_REQUEST_MESSAGES
86:
87: G_User_Id NUMBER := FND_PROFILE.Value('USER_ID');
88: G_Conc_Request_Id NUMBER;
89: G_Account_Merge_Logging VARCHAR2(1);

Line 97: INSERT INTO ar_conc_request_messages(conc_request_message_id,

93: PROCEDURE Insert_Row(X_Message_Text VARCHAR2,
94: X_Message_Type VARCHAR2,
95: X_Error_Number NUMBER) IS
96: BEGIN
97: INSERT INTO ar_conc_request_messages(conc_request_message_id,
98: creation_date,
99: created_by,
100: request_id,
101: type,

Line 104: VALUES(ar_conc_request_messages_s.nextval,

100: request_id,
101: type,
102: error_number,
103: text)
104: VALUES(ar_conc_request_messages_s.nextval,
105: SYSDATE,
106: G_User_Id,
107: G_Conc_Request_Id,
108: X_Message_Type,

Line 135: -- Writes message either to the message stack or AR_CONC_REQUEST_MESSAGES

131: --
132: -- NAME
133: -- Set_Line
134: --
135: -- Writes message either to the message stack or AR_CONC_REQUEST_MESSAGES
136: --
137: --
138: PROCEDURE Set_Line(Message_Text IN VARCHAR2,
139: Message_Type IN VARCHAR2,

Line 278: -- AR_CONC_REQUEST_MESSAGES.

274: -- applicabale.
275: --
276: -- USAGE
277: -- When Output_Code = 'TABLE' messages will be inserted into
278: -- AR_CONC_REQUEST_MESSAGES.
279: --
280: -- When Output_Code = 'STACK' messages will be written to memory on
281: -- the message stack.
282: --

Line 325: -- inserted into AR_CONC_REQUEST_MESSAGES are inserted.

321: -- Flush
322: --
323: -- PURPOSE
324: -- Ensures that all messages on the message stack that need to be
325: -- inserted into AR_CONC_REQUEST_MESSAGES are inserted.
326: --
327: --
328: PROCEDURE Flush IS
329: BEGIN

Line 523: DELETE from ar_conc_request_messages

519: END;
520:
521: PROCEDURE Purge_Messages(X_Request_Id IN NUMBER) IS
522: BEGIN
523: DELETE from ar_conc_request_messages
524: WHERE request_id = X_Request_Id;
525: END;
526:
527: FUNCTION Last_Message_Sequence Return NUMBER IS

Line 530: FROM ar_conc_request_messages

526:
527: FUNCTION Last_Message_Sequence Return NUMBER IS
528: CURSOR C_Last_Seq IS
529: SELECT max(conc_request_message_id)
530: FROM ar_conc_request_messages
531: WHERE request_id = G_Conc_Request_Id;
532:
533: Last_Msg_Seq NUMBER;
534: