eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_BC_XLA_PVT dependencies on XLA_ACCOUNTING_ERRORS

Line 70: DELETE psa_xla_accounting_errors p

66: IS
67: PRAGMA AUTONOMOUS_TRANSACTION;
68: l_path_name VARCHAR2(500);
69: BEGIN
70: DELETE psa_xla_accounting_errors p
71: WHERE p.entity_code = p_xla_transaction_entities.entity_code
72: AND NVL(p.source_id_int_1, -1) = NVL(p_xla_transaction_entities.source_id_int_1, -1)
73: AND NVL(p.source_id_int_2, -1) = NVL(p_xla_transaction_entities.source_id_int_2, -1)
74: AND NVL(p.source_id_int_3, -1) = NVL(p_xla_transaction_entities.source_id_int_3, -1)

Line 86: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;

82:
83: PROCEDURE psa_xla_error_cleanup
84: IS
85: l_path_name VARCHAR2(500);
86: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
87: BEGIN
88: FOR entity_rec IN (SELECT t.*
89: FROM xla_events e,
90: xla_transaction_entities t,

Line 105: p_psa_xla_accounting_errors IN psa_xla_accounting_errors%ROWTYPE

101: */
102:
103: PROCEDURE psa_xla_error
104: (
105: p_psa_xla_accounting_errors IN psa_xla_accounting_errors%ROWTYPE
106: )
107: IS
108: PRAGMA AUTONOMOUS_TRANSACTION;
109: l_path_name VARCHAR2(500);

Line 110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;

106: )
107: IS
108: PRAGMA AUTONOMOUS_TRANSACTION;
109: l_path_name VARCHAR2(500);
110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval

Line 112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;

108: PRAGMA AUTONOMOUS_TRANSACTION;
109: l_path_name VARCHAR2(500);
110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval
115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;

Line 113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN

109: l_path_name VARCHAR2(500);
110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval
115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;
117: END IF;

Line 114: SELECT psa_xla_accounting_errors_s.nextval

110: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval
115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;
117: END IF;
118:

Line 115: INTO l_psa_xla_accounting_errors.accounting_error_id

111: BEGIN
112: l_psa_xla_accounting_errors := p_psa_xla_accounting_errors;
113: IF (p_psa_xla_accounting_errors.accounting_error_id IS NULL) THEN
114: SELECT psa_xla_accounting_errors_s.nextval
115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;
117: END IF;
118:
119: /*INSERT INTO psa_xla_accounting_errors

Line 119: /*INSERT INTO psa_xla_accounting_errors

115: INTO l_psa_xla_accounting_errors.accounting_error_id
116: FROM DUAL;
117: END IF;
118:
119: /*INSERT INTO psa_xla_accounting_errors
120: VALUES l_psa_xla_accounting_errors;*/
121:
122: INSERT INTO psa_xla_accounting_errors
123: ( ACCOUNTING_ERROR_ID,

Line 120: VALUES l_psa_xla_accounting_errors;*/

116: FROM DUAL;
117: END IF;
118:
119: /*INSERT INTO psa_xla_accounting_errors
120: VALUES l_psa_xla_accounting_errors;*/
121:
122: INSERT INTO psa_xla_accounting_errors
123: ( ACCOUNTING_ERROR_ID,
124: APPLICATION_ID,

Line 122: INSERT INTO psa_xla_accounting_errors

118:
119: /*INSERT INTO psa_xla_accounting_errors
120: VALUES l_psa_xla_accounting_errors;*/
121:
122: INSERT INTO psa_xla_accounting_errors
123: ( ACCOUNTING_ERROR_ID,
124: APPLICATION_ID,
125: LEDGER_ID,
126: ENTITY_CODE,

Line 148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,

144: AUDSID,
145: CREATION_DATE,
146: CREATED_BY
147: )
148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,
149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,

Line 149: l_psa_xla_accounting_errors.APPLICATION_ID ,

145: CREATION_DATE,
146: CREATED_BY
147: )
148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,
149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,

Line 150: l_psa_xla_accounting_errors.LEDGER_ID,

146: CREATED_BY
147: )
148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,
149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,

Line 151: l_psa_xla_accounting_errors.ENTITY_CODE,

147: )
148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,
149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,

Line 152: l_psa_xla_accounting_errors.ENTITY_ID ,

148: VALUES ( l_psa_xla_accounting_errors.ACCOUNTING_ERROR_ID,
149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,

Line 153: l_psa_xla_accounting_errors.EVENT_DATE ,

149: l_psa_xla_accounting_errors.APPLICATION_ID ,
150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,

Line 154: l_psa_xla_accounting_errors.EVENT_ID,

150: l_psa_xla_accounting_errors.LEDGER_ID,
151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,

Line 155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,

151: l_psa_xla_accounting_errors.ENTITY_CODE,
152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,

Line 156: l_psa_xla_accounting_errors.AE_HEADER_ID,

152: l_psa_xla_accounting_errors.ENTITY_ID ,
153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,

Line 157: l_psa_xla_accounting_errors.AE_LINE_NUM ,

153: l_psa_xla_accounting_errors.EVENT_DATE ,
154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,

Line 158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,

154: l_psa_xla_accounting_errors.EVENT_ID,
155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,

Line 159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,

155: l_psa_xla_accounting_errors.TRANSACTION_NUMBER,
156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,

Line 160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,

156: l_psa_xla_accounting_errors.AE_HEADER_ID,
157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,

Line 161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,

157: l_psa_xla_accounting_errors.AE_LINE_NUM ,
158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,

Line 162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,

158: l_psa_xla_accounting_errors.SOURCE_ID_INT_1,
159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,

Line 163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,

159: l_psa_xla_accounting_errors.SOURCE_ID_INT_2,
160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,

Line 164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,

160: l_psa_xla_accounting_errors.SOURCE_ID_INT_3,
161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,

Line 165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,

161: l_psa_xla_accounting_errors.SOURCE_ID_INT_4,
162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,

Line 166: l_psa_xla_accounting_errors.MESSAGE_CODE ,

162: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_1,
163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,

Line 167: l_psa_xla_accounting_errors.MESSAGE_NUM,

163: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_2,
164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,
171: l_psa_xla_accounting_errors.CREATED_BY);

Line 168: l_psa_xla_accounting_errors.ENCODED_MSG,

164: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_3,
165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,
171: l_psa_xla_accounting_errors.CREATED_BY);
172:

Line 169: l_psa_xla_accounting_errors.AUDSID,

165: l_psa_xla_accounting_errors.SOURCE_ID_CHAR_4 ,
166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,
171: l_psa_xla_accounting_errors.CREATED_BY);
172:
173: COMMIT;

Line 170: l_psa_xla_accounting_errors.CREATION_DATE ,

166: l_psa_xla_accounting_errors.MESSAGE_CODE ,
167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,
171: l_psa_xla_accounting_errors.CREATED_BY);
172:
173: COMMIT;
174: END;

Line 171: l_psa_xla_accounting_errors.CREATED_BY);

167: l_psa_xla_accounting_errors.MESSAGE_NUM,
168: l_psa_xla_accounting_errors.ENCODED_MSG,
169: l_psa_xla_accounting_errors.AUDSID,
170: l_psa_xla_accounting_errors.CREATION_DATE ,
171: l_psa_xla_accounting_errors.CREATED_BY);
172:
173: COMMIT;
174: END;
175:

Line 183: l_message_text psa_xla_accounting_errors.encoded_msg%TYPE;

179: p_event_id IN NUMBER DEFAULT NULL
180: )
181: IS
182: l_path_name VARCHAR2(500);
183: l_message_text psa_xla_accounting_errors.encoded_msg%TYPE;
184: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
185: l_msg_index NUMBER;
186: BEGIN
187: FOR event_rec IN (SELECT e.event_id,

Line 184: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;

180: )
181: IS
182: l_path_name VARCHAR2(500);
183: l_message_text psa_xla_accounting_errors.encoded_msg%TYPE;
184: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
185: l_msg_index NUMBER;
186: BEGIN
187: FOR event_rec IN (SELECT e.event_id,
188: t.entity_id,

Line 209: l_psa_xla_accounting_errors.message_code := p_message_code;

205: WHERE p.event_id = e.event_id
206: AND e.entity_id = t.entity_id
207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP
208:
209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;

Line 210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;

206: AND e.entity_id = t.entity_id
207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP
208:
209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;

Line 211: l_psa_xla_accounting_errors.audsid := g_audsid;

207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP
208:
209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;

Line 212: l_psa_xla_accounting_errors.creation_date := SYSDATE;

208:
209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;

Line 213: l_psa_xla_accounting_errors.created_by := g_user_id;

209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;

Line 214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;

210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;

Line 215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;

211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;

Line 216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;

212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;

Line 217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;

213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;

Line 218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;

214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;
215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;

Line 219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;

215: l_psa_xla_accounting_errors.event_id := event_rec.event_id;
216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;

Line 220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;

216: l_psa_xla_accounting_errors.application_id := event_rec.application_id;
217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;

Line 221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;

217: l_psa_xla_accounting_errors.source_id_int_1 := event_rec.source_id_int_1;
218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;

Line 222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;

218: l_psa_xla_accounting_errors.source_id_int_2 := event_rec.source_id_int_2;
219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;

Line 223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;

219: l_psa_xla_accounting_errors.source_id_int_3 := event_rec.source_id_int_3;
220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;

Line 224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;

220: l_psa_xla_accounting_errors.source_id_int_4 := event_rec.source_id_int_4;
221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;

Line 225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;

221: l_psa_xla_accounting_errors.source_id_char_1 := event_rec.source_id_char_1;
222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;
229: psa_xla_error (l_psa_xla_accounting_errors);

Line 226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;

222: l_psa_xla_accounting_errors.source_id_char_2 := event_rec.source_id_char_2;
223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;
229: psa_xla_error (l_psa_xla_accounting_errors);
230: END LOOP;

Line 227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;

223: l_psa_xla_accounting_errors.source_id_char_3 := event_rec.source_id_char_3;
224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;
229: psa_xla_error (l_psa_xla_accounting_errors);
230: END LOOP;
231: END;

Line 228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;

224: l_psa_xla_accounting_errors.source_id_char_4 := event_rec.source_id_char_4;
225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;
229: psa_xla_error (l_psa_xla_accounting_errors);
230: END LOOP;
231: END;
232:

Line 229: psa_xla_error (l_psa_xla_accounting_errors);

225: l_psa_xla_accounting_errors.entity_code := event_rec.entity_code;
226: l_psa_xla_accounting_errors.transaction_number := event_rec.transaction_number;
227: l_psa_xla_accounting_errors.event_date := event_rec.event_date;
228: l_psa_xla_accounting_errors.ledger_id := event_rec.ledger_id;
229: psa_xla_error (l_psa_xla_accounting_errors);
230: END LOOP;
231: END;
232:
233: PROCEDURE copy_xla_error

Line 238: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;

234: (
235: p_error_found OUT NOCOPY VARCHAR2
236: )
237: IS
238: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
239: l_xla_error_found BOOLEAN := FALSE;
240: l_path_name VARCHAR2(500);
241: l_count NUMBER;
242: BEGIN

Line 265: FROM xla_accounting_errors er,

261: t.ledger_id,
262: e.event_date,
263: er.ae_header_id,
264: er.ae_line_num
265: FROM xla_accounting_errors er,
266: psa_bc_xla_events_gt p,
267: xla_events e,
268: xla_transaction_entities t
269: WHERE er.event_id = p.event_id

Line 273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;

269: WHERE er.event_id = p.event_id
270: AND e.event_id = p.event_id
271: AND t.entity_id = e.entity_id) LOOP
272: p_error_found := 'Y';
273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;
274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;

Line 274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;

270: AND e.event_id = p.event_id
271: AND t.entity_id = e.entity_id) LOOP
272: p_error_found := 'Y';
273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;
274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;

Line 275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;

271: AND t.entity_id = e.entity_id) LOOP
272: p_error_found := 'Y';
273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;
274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;

Line 276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';

272: p_error_found := 'Y';
273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;
274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;

Line 277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;

273: l_psa_xla_accounting_errors.entity_id := error_rec.entity_id;
274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;

Line 278: l_psa_xla_accounting_errors.audsid := g_audsid;

274: l_psa_xla_accounting_errors.event_id := error_rec.event_id;
275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;

Line 279: l_psa_xla_accounting_errors.creation_date := SYSDATE;

275: l_psa_xla_accounting_errors.message_num := error_rec.message_number;
276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;

Line 280: l_psa_xla_accounting_errors.created_by := g_user_id;

276: l_psa_xla_accounting_errors.message_code := 'XLA_ERROR';
277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;

Line 281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;

277: l_psa_xla_accounting_errors.encoded_msg := error_rec.encoded_msg;
278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;

Line 282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;

278: l_psa_xla_accounting_errors.audsid := g_audsid;
279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;

Line 283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;

279: l_psa_xla_accounting_errors.creation_date := SYSDATE;
280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;

Line 284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;

280: l_psa_xla_accounting_errors.created_by := g_user_id;
281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;

Line 285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;

281: l_psa_xla_accounting_errors.application_id := error_rec.application_id;
282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;

Line 286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;

282: l_psa_xla_accounting_errors.source_id_int_1 := error_rec.source_id_int_1;
283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;

Line 287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;

283: l_psa_xla_accounting_errors.source_id_int_2 := error_rec.source_id_int_2;
284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;

Line 288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;

284: l_psa_xla_accounting_errors.source_id_int_3 := error_rec.source_id_int_3;
285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;

Line 289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;

285: l_psa_xla_accounting_errors.source_id_int_4 := error_rec.source_id_int_4;
286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;

Line 290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;

286: l_psa_xla_accounting_errors.source_id_char_1 := error_rec.source_id_char_1;
287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;

Line 291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;

287: l_psa_xla_accounting_errors.source_id_char_2 := error_rec.source_id_char_2;
288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;

Line 292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;

288: l_psa_xla_accounting_errors.source_id_char_3 := error_rec.source_id_char_3;
289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;
296: psa_xla_error (l_psa_xla_accounting_errors);

Line 293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;

289: l_psa_xla_accounting_errors.source_id_char_4 := error_rec.source_id_char_4;
290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;
296: psa_xla_error (l_psa_xla_accounting_errors);
297: END LOOP;

Line 294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;

290: l_psa_xla_accounting_errors.entity_code := error_rec.entity_code;
291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;
296: psa_xla_error (l_psa_xla_accounting_errors);
297: END LOOP;
298: END;

Line 295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;

291: l_psa_xla_accounting_errors.transaction_number := error_rec.transaction_number;
292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;
296: psa_xla_error (l_psa_xla_accounting_errors);
297: END LOOP;
298: END;
299:

Line 296: psa_xla_error (l_psa_xla_accounting_errors);

292: l_psa_xla_accounting_errors.ledger_id := error_rec.ledger_id;
293: l_psa_xla_accounting_errors.event_date := error_rec.event_date;
294: l_psa_xla_accounting_errors.ae_header_id := error_rec.ae_header_id;
295: l_psa_xla_accounting_errors.ae_line_num := error_rec.ae_line_num;
296: psa_xla_error (l_psa_xla_accounting_errors);
297: END LOOP;
298: END;
299:
300: PROCEDURE try_to_interpret_xla_error

Line 302: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;

298: END;
299:
300: PROCEDURE try_to_interpret_xla_error
301: IS
302: l_psa_xla_accounting_errors psa_xla_accounting_errors%ROWTYPE;
303: l_xla_error_found BOOLEAN := FALSE;
304: l_path_name VARCHAR2(500);
305: l_count NUMBER;
306: BEGIN

Line 511: xla_accounting_errors xla_err,

507: SYSDATE CREATION_DATE,
508: 'Y' XLA_ERROR_FLAG
509: FROM psa_bc_xla_events_gt psa_evnt,
510: xla_events_gt xla_evnt,
511: xla_accounting_errors xla_err,
512: fnd_new_messages fnd_mesg
513: WHERE psa_evnt.event_id = xla_evnt.event_id
514: AND xla_evnt.event_id = xla_err.event_id
515: AND fnd_mesg.application_id = 602