DBA Data[Home] [Help]

APPS.PO_PDOI_TYPES dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_PDOI_TYPES');

1: PACKAGE BODY PO_PDOI_TYPES AS
2: /* $Header: PO_PDOI_TYPES.plb 120.14.12020000.3 2013/02/10 15:52:36 vegajula ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_TYPES');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 86: IF (PO_LOG.d_proc) THEN

82:
83: BEGIN
84: d_position := 0;
85:
86: IF (PO_LOG.d_proc) THEN
87: PO_LOG.proc_begin(d_module);
88: END IF;
89:
90: -- set record count

Line 87: PO_LOG.proc_begin(d_module);

83: BEGIN
84: d_position := 0;
85:
86: IF (PO_LOG.d_proc) THEN
87: PO_LOG.proc_begin(d_module);
88: END IF;
89:
90: -- set record count
91: x_headers.rec_count := p_num_records;

Line 247: IF (PO_LOG.d_proc) THEN

243: fill_tbl(p_num_records, x_headers.clm_contract_officer_tbl);
244: fill_tbl(p_num_records, x_headers.clm_source_document_disp_tbl);
245: fill_tbl(p_num_records, x_headers.draft_type_tbl);
246:
247: IF (PO_LOG.d_proc) THEN
248: PO_LOG.proc_end (d_module);
249: END IF;
250:
251: EXCEPTION

Line 248: PO_LOG.proc_end (d_module);

244: fill_tbl(p_num_records, x_headers.clm_source_document_disp_tbl);
245: fill_tbl(p_num_records, x_headers.draft_type_tbl);
246:
247: IF (PO_LOG.d_proc) THEN
248: PO_LOG.proc_end (d_module);
249: END IF;
250:
251: EXCEPTION
252: WHEN OTHERS THEN

Line 290: IF (PO_LOG.d_proc) THEN

286:
287: BEGIN
288: d_position := 0;
289:
290: IF (PO_LOG.d_proc) THEN
291: PO_LOG.proc_begin(d_module);
292: END IF;
293:
294: -- set record count

Line 291: PO_LOG.proc_begin(d_module);

287: BEGIN
288: d_position := 0;
289:
290: IF (PO_LOG.d_proc) THEN
291: PO_LOG.proc_begin(d_module);
292: END IF;
293:
294: -- set record count
295: x_lines.rec_count := p_num_records;

Line 470: IF (PO_LOG.d_proc) THEN

466: fill_tbl(p_num_records, x_lines.group_line_id_tbl);
467:
468:
469:
470: IF (PO_LOG.d_proc) THEN
471: PO_LOG.proc_end (d_module);
472: END IF;
473:
474: EXCEPTION

Line 471: PO_LOG.proc_end (d_module);

467:
468:
469:
470: IF (PO_LOG.d_proc) THEN
471: PO_LOG.proc_end (d_module);
472: END IF;
473:
474: EXCEPTION
475: WHEN OTHERS THEN

Line 513: IF (PO_LOG.d_proc) THEN

509:
510: BEGIN
511: d_position := 0;
512:
513: IF (PO_LOG.d_proc) THEN
514: PO_LOG.proc_begin(d_module);
515: END IF;
516:
517: -- set record count

Line 514: PO_LOG.proc_begin(d_module);

510: BEGIN
511: d_position := 0;
512:
513: IF (PO_LOG.d_proc) THEN
514: PO_LOG.proc_begin(d_module);
515: END IF;
516:
517: -- set record count
518: x_line_locs.rec_count := p_num_records;

Line 671: IF (PO_LOG.d_proc) THEN

667: fill_tbl(p_num_records, x_line_locs.shipment_num_unique_tbl);
668: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
669: fill_tbl(p_num_records, x_line_locs.hd_currency_code_tbl); --- Bug# 11834816
670:
671: IF (PO_LOG.d_proc) THEN
672: PO_LOG.proc_end (d_module);
673: END IF;
674:
675: EXCEPTION

Line 672: PO_LOG.proc_end (d_module);

668: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
669: fill_tbl(p_num_records, x_line_locs.hd_currency_code_tbl); --- Bug# 11834816
670:
671: IF (PO_LOG.d_proc) THEN
672: PO_LOG.proc_end (d_module);
673: END IF;
674:
675: EXCEPTION
676: WHEN OTHERS THEN

Line 713: IF (PO_LOG.d_proc) THEN

709:
710: BEGIN
711: d_position := 0;
712:
713: IF (PO_LOG.d_proc) THEN
714: PO_LOG.proc_begin(d_module);
715: END IF;
716:
717: -- set record count

Line 714: PO_LOG.proc_begin(d_module);

710: BEGIN
711: d_position := 0;
712:
713: IF (PO_LOG.d_proc) THEN
714: PO_LOG.proc_begin(d_module);
715: END IF;
716:
717: -- set record count
718: x_dists.rec_count := p_num_records;

Line 927: IF (PO_LOG.d_proc) THEN

923: fill_tbl(p_num_records, x_dists.quantity_funded_tbl);
924: fill_tbl(p_num_records, x_dists.amount_funded_tbl);
925:
926:
927: IF (PO_LOG.d_proc) THEN
928: PO_LOG.proc_end (d_module);
929: END IF;
930:
931:

Line 928: PO_LOG.proc_end (d_module);

924: fill_tbl(p_num_records, x_dists.amount_funded_tbl);
925:
926:
927: IF (PO_LOG.d_proc) THEN
928: PO_LOG.proc_end (d_module);
929: END IF;
930:
931:
932: EXCEPTION

Line 970: IF (PO_LOG.d_proc) THEN

966:
967: BEGIN
968: d_position := 0;
969:
970: IF (PO_LOG.d_proc) THEN
971: PO_LOG.proc_begin(d_module);
972: END IF;
973:
974: -- set record count

Line 971: PO_LOG.proc_begin(d_module);

967: BEGIN
968: d_position := 0;
969:
970: IF (PO_LOG.d_proc) THEN
971: PO_LOG.proc_begin(d_module);
972: END IF;
973:
974: -- set record count
975: x_price_diffs.rec_count := p_num_records;

Line 1003: IF (PO_LOG.d_proc) THEN

999: fill_tbl(p_num_records, x_price_diffs.error_flag_tbl);
1000: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
1001:
1002:
1003: IF (PO_LOG.d_proc) THEN
1004: PO_LOG.proc_end (d_module);
1005: END IF;
1006:
1007: EXCEPTION

Line 1004: PO_LOG.proc_end (d_module);

1000: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
1001:
1002:
1003: IF (PO_LOG.d_proc) THEN
1004: PO_LOG.proc_end (d_module);
1005: END IF;
1006:
1007: EXCEPTION
1008: WHEN OTHERS THEN

Line 1045: IF (PO_LOG.d_proc) THEN

1041:
1042: BEGIN
1043: d_position := 0;
1044:
1045: IF (PO_LOG.d_proc) THEN
1046: PO_LOG.proc_begin(d_module);
1047: END IF;
1048:
1049: -- set record count

Line 1046: PO_LOG.proc_begin(d_module);

1042: BEGIN
1043: d_position := 0;
1044:
1045: IF (PO_LOG.d_proc) THEN
1046: PO_LOG.proc_begin(d_module);
1047: END IF;
1048:
1049: -- set record count
1050: x_attr_values.rec_count := p_num_records;

Line 1068: IF (PO_LOG.d_proc) THEN

1064: -- attributes added for processing purpose
1065: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
1066: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
1067:
1068: IF (PO_LOG.d_proc) THEN
1069: PO_LOG.proc_end (d_module);
1070: END IF;
1071:
1072: EXCEPTION

Line 1069: PO_LOG.proc_end (d_module);

1065: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
1066: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
1067:
1068: IF (PO_LOG.d_proc) THEN
1069: PO_LOG.proc_end (d_module);
1070: END IF;
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN

Line 1110: IF (PO_LOG.d_proc) THEN

1106:
1107: BEGIN
1108: d_position := 0;
1109:
1110: IF (PO_LOG.d_proc) THEN
1111: PO_LOG.proc_begin(d_module);
1112: END IF;
1113:
1114: -- set record count

Line 1111: PO_LOG.proc_begin(d_module);

1107: BEGIN
1108: d_position := 0;
1109:
1110: IF (PO_LOG.d_proc) THEN
1111: PO_LOG.proc_begin(d_module);
1112: END IF;
1113:
1114: -- set record count
1115: x_attr_values_tlp.rec_count := p_num_records;

Line 1135: IF (PO_LOG.d_proc) THEN

1131: -- attributes added for processing purpose
1132: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1133: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1134:
1135: IF (PO_LOG.d_proc) THEN
1136: PO_LOG.proc_end (d_module);
1137: END IF;
1138:
1139: EXCEPTION

Line 1136: PO_LOG.proc_end (d_module);

1132: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1133: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1134:
1135: IF (PO_LOG.d_proc) THEN
1136: PO_LOG.proc_end (d_module);
1137: END IF;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN