DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_HOLD dependencies on PO_LOG

Line 29: IF (PO_LOG.d_proc) THEN

25:
26: BEGIN
27:
28: d_progress := 0;
29: IF (PO_LOG.d_proc) THEN
30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 30: PO_LOG.proc_begin(d_module);

26: BEGIN
27:
28: d_progress := 0;
29: IF (PO_LOG.d_proc) THEN
30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

27:
28: d_progress := 0;
29: IF (PO_LOG.d_proc) THEN
30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
35: END IF;

Line 32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

28: d_progress := 0;
29: IF (PO_LOG.d_proc) THEN
30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
35: END IF;
36:

Line 33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

29: IF (PO_LOG.d_proc) THEN
30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
35: END IF;
36:
37: BEGIN

Line 34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

30: PO_LOG.proc_begin(d_module);
31: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
32: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
33: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
34: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
35: END IF;
36:
37: BEGIN
38:

Line 166: IF (PO_LOG.d_exc) THEN

162: EXCEPTION
163: WHEN PO_CORE_S.g_early_return_exc THEN
164: IF (l_ret_sts = 'U')
165: THEN
166: IF (PO_LOG.d_exc) THEN
167: PO_LOG.exc(d_module, d_progress, d_msg);
168: END IF;
169: END IF;
170:

Line 167: PO_LOG.exc(d_module, d_progress, d_msg);

163: WHEN PO_CORE_S.g_early_return_exc THEN
164: IF (l_ret_sts = 'U')
165: THEN
166: IF (PO_LOG.d_exc) THEN
167: PO_LOG.exc(d_module, d_progress, d_msg);
168: END IF;
169: END IF;
170:
171: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

Line 177: IF (PO_LOG.d_proc) THEN

173: END;
174:
175: p_action_ctl_rec.return_status := l_ret_sts;
176:
177: IF (PO_LOG.d_proc) THEN
178: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
179: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
180: PO_LOG.proc_end(d_module);
181: END IF;

Line 178: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

174:
175: p_action_ctl_rec.return_status := l_ret_sts;
176:
177: IF (PO_LOG.d_proc) THEN
178: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
179: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
180: PO_LOG.proc_end(d_module);
181: END IF;
182:

Line 179: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);

175: p_action_ctl_rec.return_status := l_ret_sts;
176:
177: IF (PO_LOG.d_proc) THEN
178: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
179: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
180: PO_LOG.proc_end(d_module);
181: END IF;
182:
183: RETURN;

Line 180: PO_LOG.proc_end(d_module);

176:
177: IF (PO_LOG.d_proc) THEN
178: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
179: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
180: PO_LOG.proc_end(d_module);
181: END IF;
182:
183: RETURN;
184:

Line 190: IF (PO_LOG.d_exc) THEN

186: WHEN OTHERS THEN
187: p_action_ctl_rec.return_status := 'U';
188:
189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
190: IF (PO_LOG.d_exc) THEN
191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
193: PO_LOG.proc_end(d_module);
194: END IF;

Line 191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

187: p_action_ctl_rec.return_status := 'U';
188:
189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
190: IF (PO_LOG.d_exc) THEN
191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
193: PO_LOG.proc_end(d_module);
194: END IF;
195:

Line 192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

188:
189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
190: IF (PO_LOG.d_exc) THEN
191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
193: PO_LOG.proc_end(d_module);
194: END IF;
195:
196: RETURN;

Line 193: PO_LOG.proc_end(d_module);

189: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
190: IF (PO_LOG.d_exc) THEN
191: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
192: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
193: PO_LOG.proc_end(d_module);
194: END IF;
195:
196: RETURN;
197:

Line 219: IF (PO_LOG.d_proc) THEN

215:
216: BEGIN
217:
218: d_progress := 0;
219: IF (PO_LOG.d_proc) THEN
220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 220: PO_LOG.proc_begin(d_module);

216: BEGIN
217:
218: d_progress := 0;
219: IF (PO_LOG.d_proc) THEN
220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

217:
218: d_progress := 0;
219: IF (PO_LOG.d_proc) THEN
220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
225: END IF;

Line 222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

218: d_progress := 0;
219: IF (PO_LOG.d_proc) THEN
220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
225: END IF;
226:

Line 223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

219: IF (PO_LOG.d_proc) THEN
220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
225: END IF;
226:
227: BEGIN

Line 224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

220: PO_LOG.proc_begin(d_module);
221: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
222: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
223: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
224: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
225: END IF;
226:
227: BEGIN
228:

Line 414: IF (PO_LOG.d_exc) THEN

410: EXCEPTION
411: WHEN PO_CORE_S.g_early_return_exc THEN
412: IF (l_ret_sts = 'U')
413: THEN
414: IF (PO_LOG.d_exc) THEN
415: PO_LOG.exc(d_module, d_progress, d_msg);
416: END IF;
417: END IF;
418:

Line 415: PO_LOG.exc(d_module, d_progress, d_msg);

411: WHEN PO_CORE_S.g_early_return_exc THEN
412: IF (l_ret_sts = 'U')
413: THEN
414: IF (PO_LOG.d_exc) THEN
415: PO_LOG.exc(d_module, d_progress, d_msg);
416: END IF;
417: END IF;
418:
419: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

Line 425: IF (PO_LOG.d_proc) THEN

421: END;
422:
423: p_action_ctl_rec.return_status := l_ret_sts;
424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
427: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
428: PO_LOG.proc_end(d_module);
429: END IF;

Line 426: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

422:
423: p_action_ctl_rec.return_status := l_ret_sts;
424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
427: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
428: PO_LOG.proc_end(d_module);
429: END IF;
430:

Line 427: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);

423: p_action_ctl_rec.return_status := l_ret_sts;
424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
427: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
428: PO_LOG.proc_end(d_module);
429: END IF;
430:
431: RETURN;

Line 428: PO_LOG.proc_end(d_module);

424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
427: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
428: PO_LOG.proc_end(d_module);
429: END IF;
430:
431: RETURN;
432:

Line 438: IF (PO_LOG.d_exc) THEN

434: WHEN OTHERS THEN
435: p_action_ctl_rec.return_status := 'U';
436:
437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
438: IF (PO_LOG.d_exc) THEN
439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
441: PO_LOG.proc_end(d_module);
442: END IF;

Line 439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

435: p_action_ctl_rec.return_status := 'U';
436:
437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
438: IF (PO_LOG.d_exc) THEN
439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
441: PO_LOG.proc_end(d_module);
442: END IF;
443:

Line 440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

436:
437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
438: IF (PO_LOG.d_exc) THEN
439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
441: PO_LOG.proc_end(d_module);
442: END IF;
443:
444: RETURN;

Line 441: PO_LOG.proc_end(d_module);

437: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
438: IF (PO_LOG.d_exc) THEN
439: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
440: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
441: PO_LOG.proc_end(d_module);
442: END IF;
443:
444: RETURN;
445: