APPS.AS_MESSAGE dependencies on AS_CONC_REQUEST_MESSAGES

Line 15: -- to table AS_CONC_REQUEST_MESSAGES.

11: -- HISTORY
12: --
13: -- 14-JAN-94 R Lee Created.
14: -- 23-FEB-94 R Lee Modified so that messages can be ouputed
15: -- to table AS_CONC_REQUEST_MESSAGES.
16: -- 27-FEB-94 R Lee Renamed Put_DB_Error to Set_Error
17: -- 28-FEB-94 R Lee Modified Initialize. The output buffers
18: -- (db tables or memory) of normal messages
19: -- and debugging messages can now be controlled

Line 23: -- AS_CONC_REQUEST_MESSAGES.

19: -- and debugging messages can now be controlled
20: -- independently.
21: -- 17-MAR-94 R Lee Added Set_Line to replace Put_Line.
22: -- 31-MAR-94 R Lee Changed references to AS_REPORT_ENTRIES to
23: -- AS_CONC_REQUEST_MESSAGES.
24: -- 20-APR-94 R Lee Added funtion Last_Message_Sequence()
25: -- 05-OCT-94 J Lewis Replaced calls to FND_PROFILE for who info
26: -- with calls to FND_GLOBAL
27: --

Line 58: -- AS_CONC_REQUEST_MESSAGES

54: -- messages will be stored.
55: G_Ins_Message_Flag VARCHAR2(1) := 'N'; -- Flag to indicate whether
56: -- the current message needs
57: -- to be inserted into
58: -- AS_CONC_REQUEST_MESSAGES
59:
60: G_User_Id NUMBER := FND_GLOBAL.User_Id;
61: G_Conc_Request_Id NUMBER := 0;
62:

Line 69: INSERT INTO as_conc_request_messages(conc_request_message_id,

65: PROCEDURE Insert_Row(X_Message_Text VARCHAR2,
66: X_Message_Type VARCHAR2,
67: X_Error_Number NUMBER) IS
68: BEGIN
69: INSERT INTO as_conc_request_messages(conc_request_message_id,
70: creation_date,
71: created_by,
72: request_id,
73: type,

Line 76: VALUES(as_conc_request_messages_s.nextval,

72: request_id,
73: type,
74: error_number,
75: text)
76: VALUES(as_conc_request_messages_s.nextval,
77: SYSDATE,
78: G_User_Id,
79: G_Conc_Request_Id,
80: X_Message_Type,

Line 106: -- Writes message either to the message stack or AS_CONC_REQUEST_MESSAGES

102: --
103: -- NAME
104: -- Set_Line
105: --
106: -- Writes message either to the message stack or AS_CONC_REQUEST_MESSAGES
107: --
108: --
109: PROCEDURE Set_Line(Message_Text IN VARCHAR2,
110: Message_Type IN VARCHAR2,

Line 137: -- AS_CONC_REQUEST_MESSAGES.

133: -- applicabale.
134: --
135: -- USAGE
136: -- When Output_Code = 'TABLE' messages will be inserted into
137: -- AS_CONC_REQUEST_MESSAGES.
138: --
139: -- When Output_Code = 'STACK' messages will be written to memory on
140: -- the message stack.
141: --

Line 181: -- inserted into AS_CONC_REQUEST_MESSAGES are inserted.

177: -- Flush
178: --
179: -- PURPOSE
180: -- Ensures that all messages on the message stack that need to be
181: -- inserted into AS_CONC_REQUEST_MESSAGES are inserted.
182: --
183: --
184: PROCEDURE Flush IS
185: BEGIN

Line 346: DELETE from as_conc_request_messages

342: END;
343:
344: PROCEDURE Purge_Messages(X_Request_Id IN NUMBER) IS
345: BEGIN
346: DELETE from as_conc_request_messages
347: WHERE request_id = X_Request_Id;
348: COMMIT;
349: END;
350:

Line 354: FROM as_conc_request_messages

350:
351: FUNCTION Last_Message_Sequence Return NUMBER IS
352: CURSOR C_Last_Seq IS
353: SELECT max(conc_request_message_id)
354: FROM as_conc_request_messages
355: WHERE request_id = G_Conc_Request_Id;
356:
357: Last_Msg_Seq NUMBER;
358: