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 159: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

155: -- Public methods
156:
157:
158: PROCEDURE approve_status_check(
159: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
160: )
161: IS
162:
163: d_progress NUMBER;

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

182: BEGIN
183:
184: d_progress := 10;
185:
186: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

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

183:
184: d_progress := 10;
185:
186: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

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

184: d_progress := 10;
185:
186: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';

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

185:
186: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';
193: l_allowed_states.frozen_flag := 'N';

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

186: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';
193: l_allowed_states.frozen_flag := 'N';
194: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

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

187: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
188: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
189: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';
193: l_allowed_states.frozen_flag := 'N';
194: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
195: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

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

190: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';
193: l_allowed_states.frozen_flag := 'N';
194: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
195: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
196: l_allowed_states.fully_reserved_flag := NULL;
197:
198: d_progress := 20;

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

191: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
192: l_allowed_states.hold_flag := 'N';
193: l_allowed_states.frozen_flag := 'N';
194: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
195: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
196: l_allowed_states.fully_reserved_flag := NULL;
197:
198: d_progress := 20;
199:

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

231:
232: EXCEPTION
233: WHEN PO_CORE_S.g_early_return_exc THEN
234: l_ret_sts := 'U';
235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
236: IF (PO_LOG.d_exc) THEN
237: PO_LOG.exc(d_module, d_progress, d_msg);
238: END IF;
239: END;

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

251: EXCEPTION
252: WHEN OTHERS THEN
253: p_action_ctl_rec.return_status := 'U';
254:
255: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
256: IF (PO_LOG.d_exc) THEN
257: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
258: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
259: PO_LOG.proc_end(d_module);

Line 267: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

263:
264: END approve_status_check;
265:
266: PROCEDURE reject_status_check(
267: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
268: )
269: IS
270:
271: d_progress NUMBER;

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

290: BEGIN
291:
292: d_progress := 10;
293:
294: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
295: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
296: l_allowed_states.hold_flag := 'N';
297: l_allowed_states.frozen_flag := 'N';
298: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

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

291:
292: d_progress := 10;
293:
294: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
295: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
296: l_allowed_states.hold_flag := 'N';
297: l_allowed_states.frozen_flag := 'N';
298: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
299: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

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

294: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
295: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
296: l_allowed_states.hold_flag := 'N';
297: l_allowed_states.frozen_flag := 'N';
298: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
299: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
300: l_allowed_states.fully_reserved_flag := NULL;
301:
302: d_progress := 20;

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

295: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
296: l_allowed_states.hold_flag := 'N';
297: l_allowed_states.frozen_flag := 'N';
298: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
299: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
300: l_allowed_states.fully_reserved_flag := NULL;
301:
302: d_progress := 20;
303:

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

335:
336: EXCEPTION
337: WHEN PO_CORE_S.g_early_return_exc THEN
338: l_ret_sts := 'U';
339: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
340: IF (PO_LOG.d_exc) THEN
341: PO_LOG.exc(d_module, d_progress, d_msg);
342: END IF;
343: END;

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

355: EXCEPTION
356: WHEN OTHERS THEN
357: p_action_ctl_rec.return_status := 'U';
358:
359: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
360: IF (PO_LOG.d_exc) THEN
361: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
362: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
363: PO_LOG.proc_end(d_module);

Line 370: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

366: RETURN;
367: END reject_status_check;
368:
369: PROCEDURE authority_check(
370: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
371: )
372: IS
373:
374: d_progress NUMBER;

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

374: d_progress NUMBER;
375: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check';
376:
377: l_authority_verified VARCHAR2(1);
378: l_action_to_verify VARCHAR2(30) := PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE;
379: l_auth_checks_to_do AUTH_CHECK_TYPES_REC;
380: l_auth_check_ids AUTH_CHECK_IDS_REC;
381: l_using_positions BOOLEAN;
382:

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

664: l_authority_verified := 'Y';
665:
666: EXCEPTION
667: WHEN PO_CORE_S.g_early_return_exc THEN
668: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
669: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
670: PO_LOG.exc(d_module, d_progress, d_msg);
671: END IF;
672: IF (l_ret_sts = 'E' OR (NVL(l_authorized_yn, 'N') <> 'Y')) THEN

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

699: EXCEPTION
700: WHEN OTHERS THEN
701: p_action_ctl_rec.return_status := 'U';
702:
703: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
704: IF (PO_LOG.d_exc) THEN
705: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
706: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
707: PO_LOG.proc_end(d_module);

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

986: l_ret_sts := 'S';
987:
988: EXCEPTION
989: WHEN PO_CORE_S.g_early_return_exc THEN
990: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
991: IF ((l_ret_sts = 'U') and (PO_LOG.d_exc)) THEN
992: PO_LOG.exc(d_module, d_progress, d_msg);
993: END IF;
994: IF (l_ret_sts = 'E') THEN

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

1008:
1009: EXCEPTION
1010: WHEN others THEN
1011: x_return_status := 'U';
1012: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1013: IF (PO_LOG.d_exc) THEN
1014: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1015: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1016: PO_LOG.proc_end(d_module);

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

1125:
1126: EXCEPTION
1127: WHEN others THEN
1128: x_return_status := 'U';
1129: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1130: IF (PO_LOG.d_exc) THEN
1131: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1132: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1133: PO_LOG.proc_end(d_module);

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

1224:
1225: EXCEPTION
1226: WHEN others THEN
1227: x_return_status := 'U';
1228: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1229: IF (PO_LOG.d_exc) THEN
1230: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1231: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1232: PO_LOG.proc_end(d_module);

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

1322: l_ret_sts := 'S';
1323:
1324: EXCEPTION
1325: WHEN PO_CORE_S.g_early_return_exc THEN
1326: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1327: IF (PO_LOG.d_exc) THEN
1328: PO_LOG.exc(d_module, d_progress, d_msg);
1329: END IF;
1330: END;

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

1341:
1342: EXCEPTION
1343: WHEN others THEN
1344: x_return_status := 'U';
1345: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1346: IF (PO_LOG.d_exc) THEN
1347: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1348: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1349: PO_LOG.proc_end(d_module);

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

1437: l_ret_sts := 'S';
1438:
1439: EXCEPTION
1440: WHEN PO_CORE_S.g_early_return_exc THEN
1441: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1442: IF (PO_LOG.d_exc) THEN
1443: PO_LOG.exc(d_module, d_progress, d_msg);
1444: END IF;
1445: END;

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

1456:
1457: EXCEPTION
1458: WHEN others THEN
1459: x_return_status := 'U';
1460: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1461: IF (PO_LOG.d_exc) THEN
1462: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1463: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1464: PO_LOG.proc_end(d_module);

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

1554: l_ret_sts := 'S';
1555:
1556: EXCEPTION
1557: WHEN PO_CORE_S.g_early_return_exc THEN
1558: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1559: IF (PO_LOG.d_exc) THEN
1560: PO_LOG.exc(d_module, d_progress, d_msg);
1561: END IF;
1562: END;

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

1573:
1574: EXCEPTION
1575: WHEN others THEN
1576: x_return_status := 'U';
1577: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1578: IF (PO_LOG.d_exc) THEN
1579: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1580: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1581: PO_LOG.proc_end(d_module);

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

1671: l_ret_sts := 'S';
1672:
1673: EXCEPTION
1674: WHEN PO_CORE_S.g_early_return_exc THEN
1675: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1676: IF (PO_LOG.d_exc) THEN
1677: PO_LOG.exc(d_module, d_progress, d_msg);
1678: END IF;
1679: END;

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

1690:
1691: EXCEPTION
1692: WHEN others THEN
1693: x_return_status := 'U';
1694: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1695: IF (PO_LOG.d_exc) THEN
1696: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1697: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1698: PO_LOG.proc_end(d_module);

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

1852: l_ret_sts := 'S';
1853:
1854: EXCEPTION
1855: WHEN PO_CORE_S.g_early_return_exc THEN
1856: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1857: IF (PO_LOG.d_exc) THEN
1858: PO_LOG.exc(d_module, d_progress, d_msg);
1859: END IF;
1860: END;

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

1871:
1872: EXCEPTION
1873: WHEN others THEN
1874: x_return_status := 'U';
1875: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1876: IF (PO_LOG.d_exc) THEN
1877: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1878: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1879: PO_LOG.proc_end(d_module);

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

2000: l_ret_sts := 'S';
2001:
2002: EXCEPTION
2003: WHEN PO_CORE_S.g_early_return_exc THEN
2004: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
2005: IF (PO_LOG.d_exc) THEN
2006: PO_LOG.exc(d_module, d_progress, d_msg);
2007: END IF;
2008: END;

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

2019:
2020: EXCEPTION
2021: WHEN others THEN
2022: x_return_status := 'U';
2023: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2024: IF (PO_LOG.d_exc) THEN
2025: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2026: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2027: PO_LOG.proc_end(d_module);

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

2162:
2163: EXCEPTION
2164: WHEN others THEN
2165: x_return_status := 'U';
2166: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2167: IF (PO_LOG.d_exc) THEN
2168: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2169: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2170: PO_LOG.proc_end(d_module);

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

2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: x_return_status := 'U';
2418:
2419: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2420: IF (PO_LOG.d_exc) THEN
2421: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2422: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2423: PO_LOG.proc_end(d_module);