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.7 2006/09/15 22:25:45 jinwang noship $ */
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 80: IF (PO_LOG.d_proc) THEN

76:
77: BEGIN
78: d_position := 0;
79:
80: IF (PO_LOG.d_proc) THEN
81: PO_LOG.proc_begin(d_module);
82: END IF;
83:
84: -- set record count

Line 81: PO_LOG.proc_begin(d_module);

77: BEGIN
78: d_position := 0;
79:
80: IF (PO_LOG.d_proc) THEN
81: PO_LOG.proc_begin(d_module);
82: END IF;
83:
84: -- set record count
85: x_headers.rec_count := p_num_records;

Line 214: IF (PO_LOG.d_proc) THEN

210:
211: -- attributes added for processing purpose
212: fill_tbl(p_num_records, x_headers.error_flag_tbl);
213:
214: IF (PO_LOG.d_proc) THEN
215: PO_LOG.proc_end (d_module);
216: END IF;
217:
218: EXCEPTION

Line 215: PO_LOG.proc_end (d_module);

211: -- attributes added for processing purpose
212: fill_tbl(p_num_records, x_headers.error_flag_tbl);
213:
214: IF (PO_LOG.d_proc) THEN
215: PO_LOG.proc_end (d_module);
216: END IF;
217:
218: EXCEPTION
219: WHEN OTHERS THEN

Line 257: IF (PO_LOG.d_proc) THEN

253:
254: BEGIN
255: d_position := 0;
256:
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin(d_module);
259: END IF;
260:
261: -- set record count

Line 258: PO_LOG.proc_begin(d_module);

254: BEGIN
255: d_position := 0;
256:
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin(d_module);
259: END IF;
260:
261: -- set record count
262: x_lines.rec_count := p_num_records;

Line 390: IF (PO_LOG.d_proc) THEN

386: fill_tbl(p_num_records, x_lines.need_to_reject_flag_tbl);
387: fill_tbl(p_num_records, x_lines.allow_desc_update_flag_tbl);
388:
389:
390: IF (PO_LOG.d_proc) THEN
391: PO_LOG.proc_end (d_module);
392: END IF;
393:
394: EXCEPTION

Line 391: PO_LOG.proc_end (d_module);

387: fill_tbl(p_num_records, x_lines.allow_desc_update_flag_tbl);
388:
389:
390: IF (PO_LOG.d_proc) THEN
391: PO_LOG.proc_end (d_module);
392: END IF;
393:
394: EXCEPTION
395: WHEN OTHERS THEN

Line 433: IF (PO_LOG.d_proc) THEN

429:
430: BEGIN
431: d_position := 0;
432:
433: IF (PO_LOG.d_proc) THEN
434: PO_LOG.proc_begin(d_module);
435: END IF;
436:
437: -- set record count

Line 434: PO_LOG.proc_begin(d_module);

430: BEGIN
431: d_position := 0;
432:
433: IF (PO_LOG.d_proc) THEN
434: PO_LOG.proc_begin(d_module);
435: END IF;
436:
437: -- set record count
438: x_line_locs.rec_count := p_num_records;

Line 578: IF (PO_LOG.d_proc) THEN

574: -- attributes added for processing purpose
575: fill_tbl(p_num_records, x_line_locs.shipment_num_unique_tbl);
576: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
577:
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end (d_module);
580: END IF;
581:
582: EXCEPTION

Line 579: PO_LOG.proc_end (d_module);

575: fill_tbl(p_num_records, x_line_locs.shipment_num_unique_tbl);
576: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
577:
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end (d_module);
580: END IF;
581:
582: EXCEPTION
583: WHEN OTHERS THEN

Line 620: IF (PO_LOG.d_proc) THEN

616:
617: BEGIN
618: d_position := 0;
619:
620: IF (PO_LOG.d_proc) THEN
621: PO_LOG.proc_begin(d_module);
622: END IF;
623:
624: -- set record count

Line 621: PO_LOG.proc_begin(d_module);

617: BEGIN
618: d_position := 0;
619:
620: IF (PO_LOG.d_proc) THEN
621: PO_LOG.proc_begin(d_module);
622: END IF;
623:
624: -- set record count
625: x_dists.rec_count := p_num_records;

Line 822: IF (PO_LOG.d_proc) THEN

818: fill_tbl(p_num_records, x_dists.dist_num_unique_tbl);
819: fill_tbl(p_num_records, x_dists.error_flag_tbl);
820:
821:
822: IF (PO_LOG.d_proc) THEN
823: PO_LOG.proc_end (d_module);
824: END IF;
825:
826:

Line 823: PO_LOG.proc_end (d_module);

819: fill_tbl(p_num_records, x_dists.error_flag_tbl);
820:
821:
822: IF (PO_LOG.d_proc) THEN
823: PO_LOG.proc_end (d_module);
824: END IF;
825:
826:
827: EXCEPTION

Line 865: IF (PO_LOG.d_proc) THEN

861:
862: BEGIN
863: d_position := 0;
864:
865: IF (PO_LOG.d_proc) THEN
866: PO_LOG.proc_begin(d_module);
867: END IF;
868:
869: -- set record count

Line 866: PO_LOG.proc_begin(d_module);

862: BEGIN
863: d_position := 0;
864:
865: IF (PO_LOG.d_proc) THEN
866: PO_LOG.proc_begin(d_module);
867: END IF;
868:
869: -- set record count
870: x_price_diffs.rec_count := p_num_records;

Line 898: IF (PO_LOG.d_proc) THEN

894: fill_tbl(p_num_records, x_price_diffs.error_flag_tbl);
895: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
896:
897:
898: IF (PO_LOG.d_proc) THEN
899: PO_LOG.proc_end (d_module);
900: END IF;
901:
902: EXCEPTION

Line 899: PO_LOG.proc_end (d_module);

895: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
896:
897:
898: IF (PO_LOG.d_proc) THEN
899: PO_LOG.proc_end (d_module);
900: END IF;
901:
902: EXCEPTION
903: WHEN OTHERS THEN

Line 940: IF (PO_LOG.d_proc) THEN

936:
937: BEGIN
938: d_position := 0;
939:
940: IF (PO_LOG.d_proc) THEN
941: PO_LOG.proc_begin(d_module);
942: END IF;
943:
944: -- set record count

Line 941: PO_LOG.proc_begin(d_module);

937: BEGIN
938: d_position := 0;
939:
940: IF (PO_LOG.d_proc) THEN
941: PO_LOG.proc_begin(d_module);
942: END IF;
943:
944: -- set record count
945: x_attr_values.rec_count := p_num_records;

Line 963: IF (PO_LOG.d_proc) THEN

959: -- attributes added for processing purpose
960: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
961: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
962:
963: IF (PO_LOG.d_proc) THEN
964: PO_LOG.proc_end (d_module);
965: END IF;
966:
967: EXCEPTION

Line 964: PO_LOG.proc_end (d_module);

960: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
961: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
962:
963: IF (PO_LOG.d_proc) THEN
964: PO_LOG.proc_end (d_module);
965: END IF;
966:
967: EXCEPTION
968: WHEN OTHERS THEN

Line 1005: IF (PO_LOG.d_proc) THEN

1001:
1002: BEGIN
1003: d_position := 0;
1004:
1005: IF (PO_LOG.d_proc) THEN
1006: PO_LOG.proc_begin(d_module);
1007: END IF;
1008:
1009: -- set record count

Line 1006: PO_LOG.proc_begin(d_module);

1002: BEGIN
1003: d_position := 0;
1004:
1005: IF (PO_LOG.d_proc) THEN
1006: PO_LOG.proc_begin(d_module);
1007: END IF;
1008:
1009: -- set record count
1010: x_attr_values_tlp.rec_count := p_num_records;

Line 1030: IF (PO_LOG.d_proc) THEN

1026: -- attributes added for processing purpose
1027: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1028: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1029:
1030: IF (PO_LOG.d_proc) THEN
1031: PO_LOG.proc_end (d_module);
1032: END IF;
1033:
1034: EXCEPTION

Line 1031: PO_LOG.proc_end (d_module);

1027: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1028: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1029:
1030: IF (PO_LOG.d_proc) THEN
1031: PO_LOG.proc_end (d_module);
1032: END IF;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN