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_VAL_HEADERS dependencies on PO_LOG

Line 36: PO_LOG.get_package_base('PO_VAL_HEADERS');

32: c_EMAIL CONSTANT VARCHAR2(30) := 'EMAIL';
33:
34: -- The module base for this package.
35: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
36: PO_LOG.get_package_base('PO_VAL_HEADERS');
37:
38: -- The module base for the subprogram.
39: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
40: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');

Line 40: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');

36: PO_LOG.get_package_base('PO_VAL_HEADERS');
37:
38: -- The module base for the subprogram.
39: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
40: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');
41:
42: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
44:

Line 43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');

39: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
40: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');
41:
42: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
44:
45: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
47:

Line 46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');

42: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
44:
45: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
47:
48: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
50:

Line 49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');

45: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
47:
48: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
50:
51: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
53:

Line 52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');

48: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
50:
51: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
53:
54: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
55: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
56:

Line 55: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');

51: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
53:
54: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
55: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
56:
57: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
59:

Line 58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');

54: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
55: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
56:
57: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
59:
60: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
62:

Line 61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');

57: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
59:
60: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
62:
63: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
65:

Line 64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');

60: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
62:
63: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
65:
66: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
68:

Line 67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');

63: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
65:
66: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
68:
69: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
71:

Line 70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');

66: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
68:
69: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
71:
72: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
74:

Line 73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');

69: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
71:
72: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
74:
75: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
77:

Line 76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');

72: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
74:
75: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
77:
78: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
80:

Line 79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');

75: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
77:
78: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
80:
81: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
83:

Line 82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');

78: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
80:
81: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
83:
84: D_doc_num_unique CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
86:

Line 85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');

81: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
83:
84: D_doc_num_unique CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
86:
87: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
89:

Line 88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');

84: D_doc_num_unique CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
86:
87: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
89:
90: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
92: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=

Line 91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');

87: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
89:
90: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
92: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
94: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');

Line 93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');

89:
90: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
92: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
94: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
96: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');

Line 95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');

91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
92: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
94: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
96: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
98: D_segment1_not_null CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');

Line 97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');

93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
94: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
96: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
98: D_segment1_not_null CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');
100:
101: ---------------------------------------------------------------------------

Line 99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');

95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
96: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
98: D_segment1_not_null CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');
100:
101: ---------------------------------------------------------------------------
102: -- Checks that the Price Update Tolerance is greater than or equal to zero.
103: -- Agreements only.

Line 230: IF PO_LOG.d_proc THEN

226: d_mod CONSTANT VARCHAR2(100) := D_amount_agreed_not_null;
227: l_results_count NUMBER;
228: BEGIN
229:
230: IF PO_LOG.d_proc THEN
231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

227: l_results_count NUMBER;
228: BEGIN
229:
230: IF PO_LOG.d_proc THEN
231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
235: END IF;

Line 232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);

228: BEGIN
229:
230: IF PO_LOG.d_proc THEN
231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
235: END IF;
236:

Line 233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);

229:
230: IF PO_LOG.d_proc THEN
231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
235: END IF;
236:
237: IF (x_results IS NULL) THEN

Line 234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

230: IF PO_LOG.d_proc THEN
231: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
232: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
233: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
234: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
235: END IF;
236:
237: IF (x_results IS NULL) THEN
238: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 263: IF PO_LOG.d_proc THEN

259: ELSE
260: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
261: END IF;
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
265: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
266: END IF;
267:

Line 264: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

260: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
261: END IF;
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
265: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
266: END IF;
267:
268: EXCEPTION

Line 265: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

261: END IF;
262:
263: IF PO_LOG.d_proc THEN
264: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
265: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
266: END IF;
267:
268: EXCEPTION
269: WHEN OTHERS THEN

Line 270: IF PO_LOG.d_exc THEN

266: END IF;
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF PO_LOG.d_exc THEN
271: PO_LOG.exc(d_mod,0,NULL);
272: END IF;
273: RAISE;
274:

Line 271: PO_LOG.exc(d_mod,0,NULL);

267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF PO_LOG.d_exc THEN
271: PO_LOG.exc(d_mod,0,NULL);
272: END IF;
273: RAISE;
274:
275: END amount_agreed_not_null;

Line 291: IF PO_LOG.d_proc THEN

287: IS
288: d_mod CONSTANT VARCHAR2(100) := D_warn_supplier_on_hold;
289: BEGIN
290:
291: IF PO_LOG.d_proc THEN
292: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
293: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
294: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
295: END IF;

Line 292: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

288: d_mod CONSTANT VARCHAR2(100) := D_warn_supplier_on_hold;
289: BEGIN
290:
291: IF PO_LOG.d_proc THEN
292: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
293: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
294: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
295: END IF;
296:

Line 293: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);

289: BEGIN
290:
291: IF PO_LOG.d_proc THEN
292: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
293: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
294: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
295: END IF;
296:
297: IF (x_result_set_id IS NULL) THEN

Line 294: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

290:
291: IF PO_LOG.d_proc THEN
292: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
293: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
294: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
295: END IF;
296:
297: IF (x_result_set_id IS NULL) THEN
298: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 332: IF PO_LOG.d_proc THEN

328: ELSE
329: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
330: END IF;
331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;

Line 334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

330: END IF;
331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;
337:
338: EXCEPTION

Line 335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;
337:
338: EXCEPTION
339: WHEN OTHERS THEN

Line 340: IF PO_LOG.d_exc THEN

336: END IF;
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF PO_LOG.d_exc THEN
341: PO_LOG.exc(d_mod,0,NULL);
342: END IF;
343: RAISE;
344:

Line 341: PO_LOG.exc(d_mod,0,NULL);

337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF PO_LOG.d_exc THEN
341: PO_LOG.exc(d_mod,0,NULL);
342: END IF;
343: RAISE;
344:
345: END warn_supplier_on_hold;

Line 400: IF PO_LOG.d_proc THEN

396: l_results_count NUMBER;
397: l_func_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
398: BEGIN
399:
400: IF PO_LOG.d_proc THEN
401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);

Line 401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

397: l_func_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
398: BEGIN
399:
400: IF PO_LOG.d_proc THEN
401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);

Line 402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

398: BEGIN
399:
400: IF PO_LOG.d_proc THEN
401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

Line 403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);

399:
400: IF PO_LOG.d_proc THEN
401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);

400: IF PO_LOG.d_proc THEN
401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
408: END IF;

Line 405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);

401: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
408: END IF;
409:

Line 406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

402: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
408: END IF;
409:
410: IF (x_results IS NULL) THEN

Line 407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

403: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
404: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
405: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
406: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
407: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
408: END IF;
409:
410: IF (x_results IS NULL) THEN
411: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 476: IF PO_LOG.d_proc THEN

472: ELSE
473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
474: END IF;
475:
476: IF PO_LOG.d_proc THEN
477: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
478: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
479: END IF;
480:

Line 477: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
474: END IF;
475:
476: IF PO_LOG.d_proc THEN
477: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
478: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
479: END IF;
480:
481: EXCEPTION

Line 478: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

474: END IF;
475:
476: IF PO_LOG.d_proc THEN
477: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
478: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN

Line 483: IF PO_LOG.d_exc THEN

479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF PO_LOG.d_exc THEN
484: PO_LOG.exc(d_mod,0,NULL);
485: END IF;
486: RAISE;
487:

Line 484: PO_LOG.exc(d_mod,0,NULL);

480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF PO_LOG.d_exc THEN
484: PO_LOG.exc(d_mod,0,NULL);
485: END IF;
486: RAISE;
487:
488: END rate_combination_valid;

Line 509: IF PO_LOG.d_proc THEN

505: d_mod CONSTANT VARCHAR2(100) := D_fax_email_address_valid;
506: l_results_count NUMBER;
507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);

Line 510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

506: l_results_count NUMBER;
507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);

507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;

Line 512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);

508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:

Line 513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);

509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN

Line 514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

510: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
512: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
513: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN
518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 551: IF PO_LOG.d_proc THEN

547: ELSE
548: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
549: END IF;
550:
551: IF PO_LOG.d_proc THEN
552: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
553: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
554: END IF;
555:

Line 552: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

548: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
549: END IF;
550:
551: IF PO_LOG.d_proc THEN
552: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
553: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
554: END IF;
555:
556: EXCEPTION

Line 553: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

549: END IF;
550:
551: IF PO_LOG.d_proc THEN
552: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
553: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
554: END IF;
555:
556: EXCEPTION
557: WHEN OTHERS THEN

Line 558: IF PO_LOG.d_exc THEN

554: END IF;
555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: IF PO_LOG.d_exc THEN
559: PO_LOG.exc(d_mod,0,NULL);
560: END IF;
561: RAISE;
562:

Line 559: PO_LOG.exc(d_mod,0,NULL);

555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: IF PO_LOG.d_exc THEN
559: PO_LOG.exc(d_mod,0,NULL);
560: END IF;
561: RAISE;
562:
563: END fax_email_address_valid;

Line 613: IF PO_LOG.d_proc THEN

609: IS
610: d_mod CONSTANT VARCHAR2(100) := D_effective_from_le_order_date;
611: BEGIN
612:
613: IF PO_LOG.d_proc THEN
614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

610: d_mod CONSTANT VARCHAR2(100) := D_effective_from_le_order_date;
611: BEGIN
612:
613: IF PO_LOG.d_proc THEN
614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
618: END IF;

Line 615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

611: BEGIN
612:
613: IF PO_LOG.d_proc THEN
614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
618: END IF;
619:

Line 616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);

612:
613: IF PO_LOG.d_proc THEN
614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
618: END IF;
619:
620: IF (x_result_set_id IS NULL) THEN

Line 617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

613: IF PO_LOG.d_proc THEN
614: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
615: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
616: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
617: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
618: END IF;
619:
620: IF (x_result_set_id IS NULL) THEN
621: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 659: IF PO_LOG.d_proc THEN

655: ELSE
656: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
657: END IF;
658:
659: IF PO_LOG.d_proc THEN
660: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
662: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
663: END IF;

Line 661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

657: END IF;
658:
659: IF PO_LOG.d_proc THEN
660: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
662: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
663: END IF;
664:
665: EXCEPTION

Line 662: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

658:
659: IF PO_LOG.d_proc THEN
660: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
662: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
663: END IF;
664:
665: EXCEPTION
666: WHEN OTHERS THEN

Line 667: IF PO_LOG.d_exc THEN

663: END IF;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF PO_LOG.d_exc THEN
668: PO_LOG.exc(d_mod,0,NULL);
669: END IF;
670: RAISE;
671:

Line 668: PO_LOG.exc(d_mod,0,NULL);

664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF PO_LOG.d_exc THEN
668: PO_LOG.exc(d_mod,0,NULL);
669: END IF;
670: RAISE;
671:
672: END effective_from_le_order_date;

Line 691: IF PO_LOG.d_proc THEN

687: IS
688: d_mod CONSTANT VARCHAR2(100) := D_effective_to_ge_order_date;
689: BEGIN
690:
691: IF PO_LOG.d_proc THEN
692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

688: d_mod CONSTANT VARCHAR2(100) := D_effective_to_ge_order_date;
689: BEGIN
690:
691: IF PO_LOG.d_proc THEN
692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
696: END IF;

Line 693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

689: BEGIN
690:
691: IF PO_LOG.d_proc THEN
692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
696: END IF;
697:

Line 694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);

690:
691: IF PO_LOG.d_proc THEN
692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
696: END IF;
697:
698: IF (x_result_set_id IS NULL) THEN

Line 695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

691: IF PO_LOG.d_proc THEN
692: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
693: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
694: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
695: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
696: END IF;
697:
698: IF (x_result_set_id IS NULL) THEN
699: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 737: IF PO_LOG.d_proc THEN

733: ELSE
734: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
735: END IF;
736:
737: IF PO_LOG.d_proc THEN
738: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
739: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
740: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
741: END IF;

Line 739: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

735: END IF;
736:
737: IF PO_LOG.d_proc THEN
738: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
739: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
740: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
741: END IF;
742:
743: EXCEPTION

Line 740: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

736:
737: IF PO_LOG.d_proc THEN
738: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
739: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
740: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
741: END IF;
742:
743: EXCEPTION
744: WHEN OTHERS THEN

Line 745: IF PO_LOG.d_exc THEN

741: END IF;
742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: IF PO_LOG.d_exc THEN
746: PO_LOG.exc(d_mod,0,NULL);
747: END IF;
748: RAISE;
749:

Line 746: PO_LOG.exc(d_mod,0,NULL);

742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: IF PO_LOG.d_exc THEN
746: PO_LOG.exc(d_mod,0,NULL);
747: END IF;
748: RAISE;
749:
750: END effective_to_ge_order_date;

Line 768: IF PO_LOG.d_proc THEN

764: IS
765: d_mod CONSTANT VARCHAR2(100) := D_contract_start_le_order_date;
766: BEGIN
767:
768: IF PO_LOG.d_proc THEN
769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

765: d_mod CONSTANT VARCHAR2(100) := D_contract_start_le_order_date;
766: BEGIN
767:
768: IF PO_LOG.d_proc THEN
769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
773: END IF;

Line 770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

766: BEGIN
767:
768: IF PO_LOG.d_proc THEN
769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
773: END IF;
774:

Line 771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);

767:
768: IF PO_LOG.d_proc THEN
769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
773: END IF;
774:
775: IF (x_result_set_id IS NULL) THEN

Line 772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

768: IF PO_LOG.d_proc THEN
769: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
770: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
771: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
772: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
773: END IF;
774:
775: IF (x_result_set_id IS NULL) THEN
776: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 821: IF PO_LOG.d_proc THEN

817: ELSE
818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
819: END IF;
820:
821: IF PO_LOG.d_proc THEN
822: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
823: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
824: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
825: END IF;

Line 823: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

819: END IF;
820:
821: IF PO_LOG.d_proc THEN
822: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
823: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
824: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
825: END IF;
826:
827: EXCEPTION

Line 824: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

820:
821: IF PO_LOG.d_proc THEN
822: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
823: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
824: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
825: END IF;
826:
827: EXCEPTION
828: WHEN OTHERS THEN

Line 829: IF PO_LOG.d_exc THEN

825: END IF;
826:
827: EXCEPTION
828: WHEN OTHERS THEN
829: IF PO_LOG.d_exc THEN
830: PO_LOG.exc(d_mod,0,NULL);
831: END IF;
832: RAISE;
833:

Line 830: PO_LOG.exc(d_mod,0,NULL);

826:
827: EXCEPTION
828: WHEN OTHERS THEN
829: IF PO_LOG.d_exc THEN
830: PO_LOG.exc(d_mod,0,NULL);
831: END IF;
832: RAISE;
833:
834: END contract_start_le_order_date;

Line 852: IF PO_LOG.d_proc THEN

848: IS
849: d_mod CONSTANT VARCHAR2(100) := D_contract_end_ge_order_date;
850: BEGIN
851:
852: IF PO_LOG.d_proc THEN
853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

849: d_mod CONSTANT VARCHAR2(100) := D_contract_end_ge_order_date;
850: BEGIN
851:
852: IF PO_LOG.d_proc THEN
853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;

Line 854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

850: BEGIN
851:
852: IF PO_LOG.d_proc THEN
853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:

Line 855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);

851:
852: IF PO_LOG.d_proc THEN
853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:
859: IF (x_result_set_id IS NULL) THEN

Line 856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

852: IF PO_LOG.d_proc THEN
853: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
854: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
855: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:
859: IF (x_result_set_id IS NULL) THEN
860: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 903: IF PO_LOG.d_proc THEN

899: ELSE
900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
905: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
906: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
907: END IF;

Line 905: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
905: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
906: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
907: END IF;
908:
909: EXCEPTION

Line 906: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

902:
903: IF PO_LOG.d_proc THEN
904: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
905: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
906: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN

Line 911: IF PO_LOG.d_exc THEN

907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF PO_LOG.d_exc THEN
912: PO_LOG.exc(d_mod,0,NULL);
913: END IF;
914: RAISE;
915:

Line 912: PO_LOG.exc(d_mod,0,NULL);

908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF PO_LOG.d_exc THEN
912: PO_LOG.exc(d_mod,0,NULL);
913: END IF;
914: RAISE;
915:
916: END contract_end_ge_order_date;

Line 939: IF PO_LOG.d_proc THEN

935: l_segment1_tbl PO_TBL_VARCHAR30;
936: l_num_test NUMBER;
937: BEGIN
938:
939: IF PO_LOG.d_proc THEN
940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

936: l_num_test NUMBER;
937: BEGIN
938:
939: IF PO_LOG.d_proc THEN
940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
944: END IF;

Line 941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

937: BEGIN
938:
939: IF PO_LOG.d_proc THEN
940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
944: END IF;
945:

Line 942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);

938:
939: IF PO_LOG.d_proc THEN
940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
944: END IF;
945:
946: IF (x_results IS NULL) THEN

Line 943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

939: IF PO_LOG.d_proc THEN
940: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
941: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
942: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
943: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
944: END IF;
945:
946: IF (x_results IS NULL) THEN
947: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1007: IF PO_LOG.d_proc THEN

1003: ELSE
1004: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1005: END IF;
1006:
1007: IF PO_LOG.d_proc THEN
1008: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1009: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1010: END IF;
1011:

Line 1008: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

1004: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1005: END IF;
1006:
1007: IF PO_LOG.d_proc THEN
1008: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1009: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1010: END IF;
1011:
1012: EXCEPTION

Line 1009: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

1005: END IF;
1006:
1007: IF PO_LOG.d_proc THEN
1008: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1009: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1010: END IF;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN

Line 1014: IF PO_LOG.d_exc THEN

1010: END IF;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF PO_LOG.d_exc THEN
1015: PO_LOG.exc(d_mod,0,NULL);
1016: END IF;
1017: RAISE;
1018:

Line 1015: PO_LOG.exc(d_mod,0,NULL);

1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF PO_LOG.d_exc THEN
1015: PO_LOG.exc(d_mod,0,NULL);
1016: END IF;
1017: RAISE;
1018:
1019: END doc_num_chars_valid;

Line 1050: IF PO_LOG.d_proc THEN

1046: l_pon_unique_status VARCHAR2(2000);
1047:
1048: BEGIN
1049:
1050: IF PO_LOG.d_proc THEN
1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

Line 1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1047:
1048: BEGIN
1049:
1050: IF PO_LOG.d_proc THEN
1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

1048: BEGIN
1049:
1050: IF PO_LOG.d_proc THEN
1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1056: END IF;

Line 1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);

1049:
1050: IF PO_LOG.d_proc THEN
1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1056: END IF;
1057:

Line 1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1050: IF PO_LOG.d_proc THEN
1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1056: END IF;
1057:
1058: d_position := 1;

Line 1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

1051: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1052: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1053: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1054: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1055: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1056: END IF;
1057:
1058: d_position := 1;
1059:

Line 1165: IF PO_LOG.d_stmt THEN

1161: PO_SETUP_S1.get_sourcing_startup(l_check_sourcing_flag);
1162:
1163: d_position := 210;
1164:
1165: IF PO_LOG.d_stmt THEN
1166: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);
1167: END IF;
1168:
1169: SELECT

Line 1166: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);

1162:
1163: d_position := 210;
1164:
1165: IF PO_LOG.d_stmt THEN
1166: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);
1167: END IF;
1168:
1169: SELECT
1170: SES.num1

Line 1194: IF PO_LOG.d_stmt THEN

1190: )
1191: ;
1192:
1193: d_position := 300;
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);

Line 1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);

1191: ;
1192:
1193: d_position := 300;
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1199: END IF;

Line 1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);

1192:
1193: d_position := 300;
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1199: END IF;
1200:

Line 1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);

1193: d_position := 300;
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1199: END IF;
1200:
1201: IF (l_check_sourcing_flag = 'I') THEN

Line 1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);

1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1196: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1197: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1198: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1199: END IF;
1200:
1201: IF (l_check_sourcing_flag = 'I') THEN
1202: FOR i IN 1 .. l_header_id_tbl.COUNT LOOP

Line 1240: IF PO_LOG.d_proc THEN

1236: ELSE
1237: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1238: END IF;
1239:
1240: IF PO_LOG.d_proc THEN
1241: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1243: END IF;
1244:

Line 1241: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

1237: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1238: END IF;
1239:
1240: IF PO_LOG.d_proc THEN
1241: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1243: END IF;
1244:
1245: EXCEPTION

Line 1242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

1238: END IF;
1239:
1240: IF PO_LOG.d_proc THEN
1241: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1243: END IF;
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN

Line 1247: IF PO_LOG.d_exc THEN

1243: END IF;
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF PO_LOG.d_exc THEN
1248: PO_LOG.exc(d_mod,d_position,NULL);
1249: END IF;
1250: RAISE;
1251:

Line 1248: PO_LOG.exc(d_mod,d_position,NULL);

1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: IF PO_LOG.d_exc THEN
1248: PO_LOG.exc(d_mod,d_position,NULL);
1249: END IF;
1250: RAISE;
1251:
1252: END doc_num_unique;

Line 1282: IF PO_LOG.d_proc THEN

1278: l_message_name VARCHAR2(30);
1279: l_text VARCHAR2(4000);
1280: BEGIN
1281:
1282: IF PO_LOG.d_proc THEN
1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

Line 1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);

1279: l_text VARCHAR2(4000);
1280: BEGIN
1281:
1282: IF PO_LOG.d_proc THEN
1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1287: END IF;

Line 1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);

1280: BEGIN
1281:
1282: IF PO_LOG.d_proc THEN
1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1287: END IF;
1288:

Line 1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);

1281:
1282: IF PO_LOG.d_proc THEN
1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1287: END IF;
1288:
1289:

Line 1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

1282: IF PO_LOG.d_proc THEN
1283: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1284: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1285: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1286: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1287: END IF;
1288:
1289:
1290: -- Check that the line's Expiration date is within the

Line 1527: IF PO_LOG.d_proc THEN

1523: ;
1524:
1525: x_sequence := x_sequence + SQL%ROWCOUNT;
1526:
1527: IF PO_LOG.d_proc THEN
1528: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);
1529: END IF;
1530:
1531: EXCEPTION

Line 1528: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);

1524:
1525: x_sequence := x_sequence + SQL%ROWCOUNT;
1526:
1527: IF PO_LOG.d_proc THEN
1528: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

Line 1533: IF PO_LOG.d_exc THEN

1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF PO_LOG.d_exc THEN
1534: PO_LOG.exc(d_mod,0,NULL);
1535: END IF;
1536: RAISE;
1537:

Line 1534: PO_LOG.exc(d_mod,0,NULL);

1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF PO_LOG.d_exc THEN
1534: PO_LOG.exc(d_mod,0,NULL);
1535: END IF;
1536: RAISE;
1537:
1538: END check_agreement_dates;