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.PO_DOCUMENT_ACTION_CHECK dependencies on PO_DOCUMENT_ACTION_PVT

Line 172: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

168: -- Public methods
169:
170:
171: PROCEDURE approve_status_check(
172: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
173: )
174: IS
175:
176: d_progress NUMBER;

Line 199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;

195: BEGIN
196:
197: d_progress := 10;
198:
199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

Line 200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

196:
197: d_progress := 10;
198:
199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

Line 201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;

197: d_progress := 10;
198:
199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';

Line 202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;

198:
199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';
206: l_allowed_states.frozen_flag := 'N';

Line 203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

199: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';
206: l_allowed_states.frozen_flag := 'N';
207: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

Line 204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

200: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
201: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
202: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';
206: l_allowed_states.frozen_flag := 'N';
207: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
208: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

Line 207: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

203: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';
206: l_allowed_states.frozen_flag := 'N';
207: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
208: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
209: l_allowed_states.fully_reserved_flag := NULL;
210:
211: d_progress := 20;

Line 208: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

204: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
205: l_allowed_states.hold_flag := 'N';
206: l_allowed_states.frozen_flag := 'N';
207: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
208: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
209: l_allowed_states.fully_reserved_flag := NULL;
210:
211: d_progress := 20;
212:

Line 249: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

245:
246: EXCEPTION
247: WHEN PO_CORE_S.g_early_return_exc THEN
248: l_ret_sts := 'U';
249: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
250: IF (PO_LOG.d_exc) THEN
251: PO_LOG.exc(d_module, d_progress, d_msg);
252: END IF;
253: END;

Line 269: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

265: EXCEPTION
266: WHEN OTHERS THEN
267: p_action_ctl_rec.return_status := 'U';
268:
269: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
270: IF (PO_LOG.d_exc) THEN
271: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
272: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
273: PO_LOG.proc_end(d_module);

Line 281: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

277:
278: END approve_status_check;
279:
280: PROCEDURE reject_status_check(
281: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
282: )
283: IS
284:
285: d_progress NUMBER;

Line 309: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;

305: BEGIN
306:
307: d_progress := 10;
308:
309: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
310: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
311: l_allowed_states.hold_flag := 'N';
312: l_allowed_states.frozen_flag := 'N';
313: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

Line 310: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

306:
307: d_progress := 10;
308:
309: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
310: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
311: l_allowed_states.hold_flag := 'N';
312: l_allowed_states.frozen_flag := 'N';
313: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
314: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

Line 313: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

309: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
310: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
311: l_allowed_states.hold_flag := 'N';
312: l_allowed_states.frozen_flag := 'N';
313: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
314: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
315: l_allowed_states.fully_reserved_flag := NULL;
316:
317: d_progress := 20;

Line 314: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

310: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
311: l_allowed_states.hold_flag := 'N';
312: l_allowed_states.frozen_flag := 'N';
313: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
314: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
315: l_allowed_states.fully_reserved_flag := NULL;
316:
317: d_progress := 20;
318:

Line 355: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

351:
352: EXCEPTION
353: WHEN PO_CORE_S.g_early_return_exc THEN
354: l_ret_sts := 'U';
355: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
356: IF (PO_LOG.d_exc) THEN
357: PO_LOG.exc(d_module, d_progress, d_msg);
358: END IF;
359: END;

Line 375: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

371: EXCEPTION
372: WHEN OTHERS THEN
373: p_action_ctl_rec.return_status := 'U';
374:
375: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
376: IF (PO_LOG.d_exc) THEN
377: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
378: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
379: PO_LOG.proc_end(d_module);

Line 386: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

382: RETURN;
383: END reject_status_check;
384:
385: PROCEDURE authority_check(
386: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
387: )
388: IS
389:
390: d_progress NUMBER;

Line 394: l_action_to_verify VARCHAR2(30) := PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE;

390: d_progress NUMBER;
391: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check';
392:
393: l_authority_verified VARCHAR2(1);
394: l_action_to_verify VARCHAR2(30) := PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE;
395: l_auth_checks_to_do AUTH_CHECK_TYPES_REC;
396: l_auth_check_ids AUTH_CHECK_IDS_REC;
397: l_using_positions BOOLEAN;
398:

Line 684: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

680: l_authority_verified := 'Y';
681:
682: EXCEPTION
683: WHEN PO_CORE_S.g_early_return_exc THEN
684: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
685: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
686: PO_LOG.exc(d_module, d_progress, d_msg);
687: END IF;
688: IF (l_ret_sts = 'E' OR (NVL(l_authorized_yn, 'N') <> 'Y')) THEN

Line 719: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

715: EXCEPTION
716: WHEN OTHERS THEN
717: p_action_ctl_rec.return_status := 'U';
718:
719: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
720: IF (PO_LOG.d_exc) THEN
721: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
722: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
723: PO_LOG.proc_end(d_module);

Line 1006: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1002: l_ret_sts := 'S';
1003:
1004: EXCEPTION
1005: WHEN PO_CORE_S.g_early_return_exc THEN
1006: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1007: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
1008: PO_LOG.exc(d_module, d_progress, d_msg);
1009: END IF;
1010: IF (l_ret_sts = 'E') THEN

Line 1028: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1024:
1025: EXCEPTION
1026: WHEN others THEN
1027: x_return_status := 'U';
1028: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1029: IF (PO_LOG.d_exc) THEN
1030: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1031: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1032: PO_LOG.proc_end(d_module);

Line 1145: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1141:
1142: EXCEPTION
1143: WHEN others THEN
1144: x_return_status := 'U';
1145: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1146: IF (PO_LOG.d_exc) THEN
1147: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1148: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1149: PO_LOG.proc_end(d_module);

Line 1244: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1240:
1241: EXCEPTION
1242: WHEN others THEN
1243: x_return_status := 'U';
1244: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1245: IF (PO_LOG.d_exc) THEN
1246: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1247: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1248: PO_LOG.proc_end(d_module);

Line 1342: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1338: l_ret_sts := 'S';
1339:
1340: EXCEPTION
1341: WHEN PO_CORE_S.g_early_return_exc THEN
1342: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1343: IF (PO_LOG.d_exc) THEN
1344: PO_LOG.exc(d_module, d_progress, d_msg);
1345: END IF;
1346: END;

Line 1361: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1357:
1358: EXCEPTION
1359: WHEN others THEN
1360: x_return_status := 'U';
1361: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1362: IF (PO_LOG.d_exc) THEN
1363: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1364: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1365: PO_LOG.proc_end(d_module);

Line 1457: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1453: l_ret_sts := 'S';
1454:
1455: EXCEPTION
1456: WHEN PO_CORE_S.g_early_return_exc THEN
1457: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1458: IF (PO_LOG.d_exc) THEN
1459: PO_LOG.exc(d_module, d_progress, d_msg);
1460: END IF;
1461: END;

Line 1476: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1472:
1473: EXCEPTION
1474: WHEN others THEN
1475: x_return_status := 'U';
1476: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1477: IF (PO_LOG.d_exc) THEN
1478: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1479: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1480: PO_LOG.proc_end(d_module);

Line 1574: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1570: l_ret_sts := 'S';
1571:
1572: EXCEPTION
1573: WHEN PO_CORE_S.g_early_return_exc THEN
1574: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1575: IF (PO_LOG.d_exc) THEN
1576: PO_LOG.exc(d_module, d_progress, d_msg);
1577: END IF;
1578: END;

Line 1593: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1589:
1590: EXCEPTION
1591: WHEN others THEN
1592: x_return_status := 'U';
1593: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1594: IF (PO_LOG.d_exc) THEN
1595: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1596: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1597: PO_LOG.proc_end(d_module);

Line 1691: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1687: l_ret_sts := 'S';
1688:
1689: EXCEPTION
1690: WHEN PO_CORE_S.g_early_return_exc THEN
1691: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1692: IF (PO_LOG.d_exc) THEN
1693: PO_LOG.exc(d_module, d_progress, d_msg);
1694: END IF;
1695: END;

Line 1710: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1706:
1707: EXCEPTION
1708: WHEN others THEN
1709: x_return_status := 'U';
1710: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1711: IF (PO_LOG.d_exc) THEN
1712: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1713: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1714: PO_LOG.proc_end(d_module);

Line 1882: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1878: l_ret_sts := 'S';
1879:
1880: EXCEPTION
1881: WHEN PO_CORE_S.g_early_return_exc THEN
1882: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1883: IF (PO_LOG.d_exc) THEN
1884: PO_LOG.exc(d_module, d_progress, d_msg);
1885: END IF;
1886: END;

Line 1901: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1897:
1898: EXCEPTION
1899: WHEN others THEN
1900: x_return_status := 'U';
1901: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1902: IF (PO_LOG.d_exc) THEN
1903: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1904: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1905: PO_LOG.proc_end(d_module);

Line 2031: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

2027: l_ret_sts := 'S';
2028:
2029: EXCEPTION
2030: WHEN PO_CORE_S.g_early_return_exc THEN
2031: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
2032: IF (PO_LOG.d_exc) THEN
2033: PO_LOG.exc(d_module, d_progress, d_msg);
2034: END IF;
2035: END;

Line 2050: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2046:
2047: EXCEPTION
2048: WHEN others THEN
2049: x_return_status := 'U';
2050: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2051: IF (PO_LOG.d_exc) THEN
2052: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2053: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2054: PO_LOG.proc_end(d_module);

Line 2193: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2189:
2190: EXCEPTION
2191: WHEN others THEN
2192: x_return_status := 'U';
2193: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2194: IF (PO_LOG.d_exc) THEN
2195: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2196: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2197: PO_LOG.proc_end(d_module);

Line 2473: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2469: EXCEPTION
2470: WHEN OTHERS THEN
2471: x_return_status := 'U';
2472:
2473: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2474: IF (PO_LOG.d_exc) THEN
2475: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2476: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2477: PO_LOG.proc_end(d_module);