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

Line 10: PO_LOG.get_package_base('PO_VALIDATIONS');

6: ---------------------------------------------------------------------------
7:
8: -- The module base for this package.
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
10: PO_LOG.get_package_base('PO_VALIDATIONS');
11:
12: -- The module base for the subprogram.
13: D_next_result_set_id CONSTANT VARCHAR2(100) :=
14: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'next_result_set_id');

Line 14: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'next_result_set_id');

10: PO_LOG.get_package_base('PO_VALIDATIONS');
11:
12: -- The module base for the subprogram.
13: D_next_result_set_id CONSTANT VARCHAR2(100) :=
14: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'next_result_set_id');
15:
16: -- The module base for the subprogram.
17: D_commit_validation_results_au CONSTANT VARCHAR2(100) :=
18: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_validation_results_auto');

Line 18: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_validation_results_auto');

14: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'next_result_set_id');
15:
16: -- The module base for the subprogram.
17: D_commit_validation_results_au CONSTANT VARCHAR2(100) :=
18: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_validation_results_auto');
19:
20: -- The module base for the subprogram.
21: D_update_result_set CONSTANT VARCHAR2(100) :=
22: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_result_set');

Line 22: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_result_set');

18: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_validation_results_auto');
19:
20: -- The module base for the subprogram.
21: D_update_result_set CONSTANT VARCHAR2(100) :=
22: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_result_set');
23:
24: -- The module base for the subprogram.
25: D_commit_result_set CONSTANT VARCHAR2(100) :=
26: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_result_set');

Line 26: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_result_set');

22: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_result_set');
23:
24: -- The module base for the subprogram.
25: D_commit_result_set CONSTANT VARCHAR2(100) :=
26: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_result_set');
27:
28: -- The module base for the subprogram.
29: D_validate_set CONSTANT VARCHAR2(100) :=
30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_set');

Line 30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_set');

26: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'commit_result_set');
27:
28: -- The module base for the subprogram.
29: D_validate_set CONSTANT VARCHAR2(100) :=
30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_set');
31:
32: -- The module base for the subprogram.
33: D_result_type_rank CONSTANT VARCHAR2(100) :=
34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'result_type_rank');

Line 34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'result_type_rank');

30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_set');
31:
32: -- The module base for the subprogram.
33: D_result_type_rank CONSTANT VARCHAR2(100) :=
34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'result_type_rank');
35:
36: -- The module base for the subprogram.
37: D_delete_result_set_auto CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set_auto');

Line 38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set_auto');

34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'result_type_rank');
35:
36: -- The module base for the subprogram.
37: D_delete_result_set_auto CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set_auto');
39:
40: -- The module base for the subprogram.
41: D_delete_result_set CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set');

Line 42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set');

38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set_auto');
39:
40: -- The module base for the subprogram.
41: D_delete_result_set CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set');
43:
44: -- The module base for the subprogram.
45: D_replace_result_set_id CONSTANT VARCHAR2(100) :=
46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'replace_result_set_id');

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

42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_result_set');
43:
44: -- The module base for the subprogram.
45: D_replace_result_set_id CONSTANT VARCHAR2(100) :=
46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'replace_result_set_id');
47:
48: -- The module base for the subprogram.
49: D_insert_result CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'insert_result');

Line 50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'insert_result');

46: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'replace_result_set_id');
47:
48: -- The module base for the subprogram.
49: D_insert_result CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'insert_result');
51:
52: -- The module base for the subprogram.
53: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');

Line 54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');

50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'insert_result');
51:
52: -- The module base for the subprogram.
53: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
55:
56: -- The module base for the subprogram.
57: D_validate_html_order CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_order');

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

54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
55:
56: -- The module base for the subprogram.
57: D_validate_html_order CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_order');
59: D_validate_html_agreement CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_agreement');
61: D_validate_pdoi CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_pdoi');

Line 60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_agreement');

56: -- The module base for the subprogram.
57: D_validate_html_order CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_order');
59: D_validate_html_agreement CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_agreement');
61: D_validate_pdoi CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_pdoi');
63:
64: -- Indicates that the calling program is the OA HTML UI.

Line 62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_pdoi');

58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_order');
59: D_validate_html_agreement CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_html_agreement');
61: D_validate_pdoi CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_pdoi');
63:
64: -- Indicates that the calling program is the OA HTML UI.
65: c_program_OA CONSTANT VARCHAR2(10) := 'OA';
66:

Line 988: IF PO_LOG.d_proc THEN

984: d_mod CONSTANT VARCHAR2(100) := D_next_result_set_id;
985: l_nextval NUMBER;
986: BEGIN
987:
988: IF PO_LOG.d_proc THEN
989: PO_LOG.proc_begin(d_mod);
990: END IF;
991:
992: SELECT PO_VALIDATION_RESULT_SET_ID_S.NEXTVAL

Line 989: PO_LOG.proc_begin(d_mod);

985: l_nextval NUMBER;
986: BEGIN
987:
988: IF PO_LOG.d_proc THEN
989: PO_LOG.proc_begin(d_mod);
990: END IF;
991:
992: SELECT PO_VALIDATION_RESULT_SET_ID_S.NEXTVAL
993: INTO l_nextval

Line 997: IF PO_LOG.d_proc THEN

993: INTO l_nextval
994: FROM DUAL
995: ;
996:
997: IF PO_LOG.d_proc THEN
998: PO_LOG.proc_return(d_mod,l_nextval);
999: END IF;
1000:
1001: RETURN l_nextval;

Line 998: PO_LOG.proc_return(d_mod,l_nextval);

994: FROM DUAL
995: ;
996:
997: IF PO_LOG.d_proc THEN
998: PO_LOG.proc_return(d_mod,l_nextval);
999: END IF;
1000:
1001: RETURN l_nextval;
1002:

Line 1005: IF PO_LOG.d_exc THEN

1001: RETURN l_nextval;
1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: IF PO_LOG.d_exc THEN
1006: PO_LOG.exc(d_mod,0,NULL);
1007: END IF;
1008: RAISE;
1009:

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

1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: IF PO_LOG.d_exc THEN
1006: PO_LOG.exc(d_mod,0,NULL);
1007: END IF;
1008: RAISE;
1009:
1010: END next_result_set_id;

Line 1034: IF PO_LOG.d_proc THEN

1030: IS
1031: d_mod CONSTANT VARCHAR2(100) := D_delete_result_set;
1032: BEGIN
1033:
1034: IF PO_LOG.d_proc THEN
1035: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1036: END IF;
1037:
1038: DELETE FROM PO_VALIDATION_RESULTS_GT

Line 1035: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);

1031: d_mod CONSTANT VARCHAR2(100) := D_delete_result_set;
1032: BEGIN
1033:
1034: IF PO_LOG.d_proc THEN
1035: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1036: END IF;
1037:
1038: DELETE FROM PO_VALIDATION_RESULTS_GT
1039: WHERE result_set_id = p_result_set_id

Line 1042: IF PO_LOG.d_proc THEN

1038: DELETE FROM PO_VALIDATION_RESULTS_GT
1039: WHERE result_set_id = p_result_set_id
1040: ;
1041:
1042: IF PO_LOG.d_proc THEN
1043: PO_LOG.stmt(d_mod,100,'Deleted result set. SQL%ROWCOUNT',SQL%ROWCOUNT);
1044: PO_LOG.proc_end(d_mod);
1045: END IF;
1046:

Line 1043: PO_LOG.stmt(d_mod,100,'Deleted result set. SQL%ROWCOUNT',SQL%ROWCOUNT);

1039: WHERE result_set_id = p_result_set_id
1040: ;
1041:
1042: IF PO_LOG.d_proc THEN
1043: PO_LOG.stmt(d_mod,100,'Deleted result set. SQL%ROWCOUNT',SQL%ROWCOUNT);
1044: PO_LOG.proc_end(d_mod);
1045: END IF;
1046:
1047: EXCEPTION

Line 1044: PO_LOG.proc_end(d_mod);

1040: ;
1041:
1042: IF PO_LOG.d_proc THEN
1043: PO_LOG.stmt(d_mod,100,'Deleted result set. SQL%ROWCOUNT',SQL%ROWCOUNT);
1044: PO_LOG.proc_end(d_mod);
1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN

Line 1049: IF PO_LOG.d_exc THEN

1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: IF PO_LOG.d_exc THEN
1050: PO_LOG.exc(d_mod,0,NULL);
1051: END IF;
1052: RAISE;
1053:

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

1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: IF PO_LOG.d_exc THEN
1050: PO_LOG.exc(d_mod,0,NULL);
1051: END IF;
1052: RAISE;
1053:
1054: END delete_result_set;

Line 1080: IF PO_LOG.d_proc THEN

1076: d_mod CONSTANT VARCHAR2(100) := D_delete_result_set_auto;
1077: d_position NUMBER := 0;
1078: BEGIN
1079:
1080: IF PO_LOG.d_proc THEN
1081: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1082: END IF;
1083:
1084: d_position := 1;

Line 1081: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);

1077: d_position NUMBER := 0;
1078: BEGIN
1079:
1080: IF PO_LOG.d_proc THEN
1081: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1082: END IF;
1083:
1084: d_position := 1;
1085:

Line 1094: IF PO_LOG.d_proc THEN

1090: COMMIT;
1091:
1092: d_position := 200;
1093:
1094: IF PO_LOG.d_proc THEN
1095: PO_LOG.proc_end(d_mod);
1096: END IF;
1097:
1098: EXCEPTION

Line 1095: PO_LOG.proc_end(d_mod);

1091:
1092: d_position := 200;
1093:
1094: IF PO_LOG.d_proc THEN
1095: PO_LOG.proc_end(d_mod);
1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN

Line 1100: IF PO_LOG.d_exc THEN

1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF PO_LOG.d_exc THEN
1101: PO_LOG.exc(d_mod,d_position,NULL);
1102: END IF;
1103: RAISE;
1104:

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

1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF PO_LOG.d_exc THEN
1101: PO_LOG.exc(d_mod,d_position,NULL);
1102: END IF;
1103: RAISE;
1104:
1105: END delete_result_set_auto;

Line 1149: IF PO_LOG.d_proc THEN

1145: d_mod CONSTANT VARCHAR2(100) := D_commit_validation_results_au;
1146: d_position NUMBER := 0;
1147: BEGIN
1148:
1149: IF PO_LOG.d_proc THEN
1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);

Line 1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);

1146: d_position NUMBER := 0;
1147: BEGIN
1148:
1149: IF PO_LOG.d_proc THEN
1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);

Line 1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);

1147: BEGIN
1148:
1149: IF PO_LOG.d_proc THEN
1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);

Line 1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);

1148:
1149: IF PO_LOG.d_proc THEN
1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);

Line 1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);

1149: IF PO_LOG.d_proc THEN
1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);

Line 1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);

1150: PO_LOG.proc_begin(d_mod,'p_result_id_tbl',p_result_id_tbl);
1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);

Line 1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);

1151: PO_LOG.proc_begin(d_mod,'p_result_set_id_tbl',p_result_set_id_tbl);
1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);

Line 1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);

1152: PO_LOG.proc_begin(d_mod,'p_result_type_tbl',p_result_type_tbl);
1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);

Line 1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);

1153: PO_LOG.proc_begin(d_mod,'p_table_name_tbl',p_table_name_tbl);
1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);

Line 1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);

1154: PO_LOG.proc_begin(d_mod,'p_table_id_tbl',p_table_id_tbl);
1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);

Line 1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);

1155: PO_LOG.proc_begin(d_mod,'p_message_application_tbl',p_message_application_tbl);
1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);

Line 1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);

1156: PO_LOG.proc_begin(d_mod,'p_message_name_tbl',p_message_name_tbl);
1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);

Line 1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);

1157: PO_LOG.proc_begin(d_mod,'p_column_name_tbl',p_column_name_tbl);
1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);

Line 1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);

1158: PO_LOG.proc_begin(d_mod,'p_token1_name_tbl',p_token1_name_tbl);
1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);

Line 1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);

1159: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);

Line 1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);

1160: PO_LOG.proc_begin(d_mod,'p_token2_name_tbl',p_token2_name_tbl);
1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);

Line 1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);

1161: PO_LOG.proc_begin(d_mod,'p_token2_value_tbl',p_token2_value_tbl);
1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);
1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);

Line 1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);

1162: PO_LOG.proc_begin(d_mod,'p_token3_name_tbl',p_token3_name_tbl);
1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);
1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);
1170: END IF;

Line 1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);

1163: PO_LOG.proc_begin(d_mod,'p_token3_value_tbl',p_token3_value_tbl);
1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);
1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);
1170: END IF;
1171:

Line 1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);

1164: PO_LOG.proc_begin(d_mod,'p_token4_name_tbl',p_token4_name_tbl);
1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);
1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);
1170: END IF;
1171:
1172: d_position := 1;

Line 1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);

1165: PO_LOG.proc_begin(d_mod,'p_token4_value_tbl',p_token4_value_tbl);
1166: PO_LOG.proc_begin(d_mod,'p_token5_name_tbl',p_token5_name_tbl);
1167: PO_LOG.proc_begin(d_mod,'p_token5_value_tbl',p_token5_value_tbl);
1168: PO_LOG.proc_begin(d_mod,'p_token6_name_tbl',p_token6_name_tbl);
1169: PO_LOG.proc_begin(d_mod,'p_token6_value_tbl',p_token6_value_tbl);
1170: END IF;
1171:
1172: d_position := 1;
1173:

Line 1220: IF PO_LOG.d_stmt THEN

1216: );
1217:
1218: d_position := 100;
1219:
1220: IF PO_LOG.d_stmt THEN
1221: PO_LOG.stmt(d_mod,d_position,'Inserted data. SQL%ROWCOUNT',SQL%ROWCOUNT);
1222: END IF;
1223:
1224: COMMIT WORK;

Line 1221: PO_LOG.stmt(d_mod,d_position,'Inserted data. SQL%ROWCOUNT',SQL%ROWCOUNT);

1217:
1218: d_position := 100;
1219:
1220: IF PO_LOG.d_stmt THEN
1221: PO_LOG.stmt(d_mod,d_position,'Inserted data. SQL%ROWCOUNT',SQL%ROWCOUNT);
1222: END IF;
1223:
1224: COMMIT WORK;
1225:

Line 1226: IF PO_LOG.d_proc THEN

1222: END IF;
1223:
1224: COMMIT WORK;
1225:
1226: IF PO_LOG.d_proc THEN
1227: PO_LOG.proc_end(d_mod);
1228: END IF;
1229:
1230: EXCEPTION

Line 1227: PO_LOG.proc_end(d_mod);

1223:
1224: COMMIT WORK;
1225:
1226: IF PO_LOG.d_proc THEN
1227: PO_LOG.proc_end(d_mod);
1228: END IF;
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN

Line 1232: IF PO_LOG.d_exc THEN

1228: END IF;
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF PO_LOG.d_exc THEN
1233: PO_LOG.exc(d_mod,d_position,NULL);
1234: END IF;
1235: RAISE;
1236:

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

1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF PO_LOG.d_exc THEN
1233: PO_LOG.exc(d_mod,d_position,NULL);
1234: END IF;
1235: RAISE;
1236:
1237: END commit_validation_results_auto;

Line 1263: IF PO_LOG.d_proc THEN

1259: IS
1260: d_mod CONSTANT VARCHAR2(100) := D_replace_result_set_id;
1261: BEGIN
1262:
1263: IF PO_LOG.d_proc THEN
1264: PO_LOG.proc_begin(d_mod,'p_old_result_set_id',p_old_result_set_id);
1265: PO_LOG.proc_begin(d_mod,'p_new_result_set_id',p_new_result_set_id);
1266: END IF;
1267:

Line 1264: PO_LOG.proc_begin(d_mod,'p_old_result_set_id',p_old_result_set_id);

1260: d_mod CONSTANT VARCHAR2(100) := D_replace_result_set_id;
1261: BEGIN
1262:
1263: IF PO_LOG.d_proc THEN
1264: PO_LOG.proc_begin(d_mod,'p_old_result_set_id',p_old_result_set_id);
1265: PO_LOG.proc_begin(d_mod,'p_new_result_set_id',p_new_result_set_id);
1266: END IF;
1267:
1268: -- Fix the result_set_id, message_application, and message_name.

Line 1265: PO_LOG.proc_begin(d_mod,'p_new_result_set_id',p_new_result_set_id);

1261: BEGIN
1262:
1263: IF PO_LOG.d_proc THEN
1264: PO_LOG.proc_begin(d_mod,'p_old_result_set_id',p_old_result_set_id);
1265: PO_LOG.proc_begin(d_mod,'p_new_result_set_id',p_new_result_set_id);
1266: END IF;
1267:
1268: -- Fix the result_set_id, message_application, and message_name.
1269:

Line 1277: IF PO_LOG.d_proc THEN

1273: WHERE
1274: result_set_id = p_old_result_set_id
1275: ;
1276:
1277: IF PO_LOG.d_proc THEN
1278: PO_LOG.proc_end(d_mod);
1279: END IF;
1280:
1281: EXCEPTION

Line 1278: PO_LOG.proc_end(d_mod);

1274: result_set_id = p_old_result_set_id
1275: ;
1276:
1277: IF PO_LOG.d_proc THEN
1278: PO_LOG.proc_end(d_mod);
1279: END IF;
1280:
1281: EXCEPTION
1282: WHEN OTHERS THEN

Line 1283: IF PO_LOG.d_exc THEN

1279: END IF;
1280:
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: IF PO_LOG.d_exc THEN
1284: PO_LOG.exc(d_mod,0,NULL);
1285: END IF;
1286: RAISE;
1287:

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

1280:
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: IF PO_LOG.d_exc THEN
1284: PO_LOG.exc(d_mod,0,NULL);
1285: END IF;
1286: RAISE;
1287:
1288: END replace_result_set_id;

Line 1336: IF PO_LOG.d_proc THEN

1332: l_token6_value_tbl PO_TBL_VARCHAR2000;
1333:
1334: BEGIN
1335:
1336: IF PO_LOG.d_proc THEN
1337: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1338: END IF;
1339:
1340: d_position := 1;

Line 1337: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);

1333:
1334: BEGIN
1335:
1336: IF PO_LOG.d_proc THEN
1337: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1338: END IF;
1339:
1340: d_position := 1;
1341:

Line 1392: IF PO_LOG.d_stmt THEN

1388: result_set_id = p_result_set_id
1389: ;
1390:
1391: d_position := 100;
1392: IF PO_LOG.d_stmt THEN
1393: PO_LOG.stmt(d_mod,d_position,'Retrieved data.');
1394: END IF;
1395:
1396: delete_result_set(p_result_set_id => p_result_set_id);

Line 1393: PO_LOG.stmt(d_mod,d_position,'Retrieved data.');

1389: ;
1390:
1391: d_position := 100;
1392: IF PO_LOG.d_stmt THEN
1393: PO_LOG.stmt(d_mod,d_position,'Retrieved data.');
1394: END IF;
1395:
1396: delete_result_set(p_result_set_id => p_result_set_id);
1397:

Line 1423: IF PO_LOG.d_proc THEN

1419: , p_token6_name_tbl => l_token6_name_tbl
1420: , p_token6_value_tbl => l_token6_value_tbl
1421: );
1422:
1423: IF PO_LOG.d_proc THEN
1424: PO_LOG.proc_end(d_mod);
1425: END IF;
1426:
1427: EXCEPTION

Line 1424: PO_LOG.proc_end(d_mod);

1420: , p_token6_value_tbl => l_token6_value_tbl
1421: );
1422:
1423: IF PO_LOG.d_proc THEN
1424: PO_LOG.proc_end(d_mod);
1425: END IF;
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN

Line 1429: IF PO_LOG.d_exc THEN

1425: END IF;
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF PO_LOG.d_exc THEN
1430: PO_LOG.exc(d_mod,d_position,NULL);
1431: END IF;
1432: RAISE;
1433:

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

1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF PO_LOG.d_exc THEN
1430: PO_LOG.exc(d_mod,d_position,NULL);
1431: END IF;
1432: RAISE;
1433:
1434: END commit_result_set;

Line 1639: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;

1635: )
1636: IS
1637: d_mod CONSTANT VARCHAR2(100) := D_validate_set;
1638: d_position NUMBER := 0;
1639: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
1640:
1641: l_result_set_id NUMBER;
1642: l_result_type VARCHAR2(30);
1643: l_val VARCHAR2(2000);

Line 1666: IF PO_LOG.d_proc THEN

1662: l_manual_quote_num_type PO_SYSTEM_PARAMETERS.manual_quote_num_type%TYPE;
1663:
1664: BEGIN
1665:
1666: IF PO_LOG.d_proc THEN
1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);

Line 1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);

1663:
1664: BEGIN
1665:
1666: IF PO_LOG.d_proc THEN
1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);

Line 1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);

1664: BEGIN
1665:
1666: IF PO_LOG.d_proc THEN
1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);

Line 1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);

1665:
1666: IF PO_LOG.d_proc THEN
1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);

1666: IF PO_LOG.d_proc THEN
1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);

Line 1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);

1667: PO_LOG.proc_begin(d_mod,'p_validation_set',p_validation_set);
1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1675: END IF;

Line 1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);

1668: PO_LOG.proc_begin(d_mod,'p_autocommit_results_flag',p_autocommit_results_flag);
1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1675: END IF;
1676: d_position := 1;

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

1669: PO_LOG.proc_begin(d_mod,'p_calling_program',p_calling_program);
1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1675: END IF;
1676: d_position := 1;
1677:

Line 1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);

1670: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
1671: PO_LOG.proc_begin(d_mod,'p_parameter_name_tbl',p_parameter_name_tbl);
1672: PO_LOG.proc_begin(d_mod,'p_parameter_value_tbl',p_parameter_value_tbl);
1673: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1674: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1675: END IF;
1676: d_position := 1;
1677:
1678: IF (p_parameter_name_tbl IS NOT NULL) THEN

Line 1747: PO_LOG.stmt(d_mod,d_position,'x_result_set_id',x_result_set_id);

1743: l_stop_rank := result_type_rank(p_stopping_result_type);
1744:
1745: d_position := 40;
1746: IF d_stmt THEN
1747: PO_LOG.stmt(d_mod,d_position,'x_result_set_id',x_result_set_id);
1748: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
1749: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
1750: PO_LOG.stmt(d_mod,d_position,'l_stop_rank',l_stop_rank);
1751: END IF;

Line 1748: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);

1744:
1745: d_position := 40;
1746: IF d_stmt THEN
1747: PO_LOG.stmt(d_mod,d_position,'x_result_set_id',x_result_set_id);
1748: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
1749: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
1750: PO_LOG.stmt(d_mod,d_position,'l_stop_rank',l_stop_rank);
1751: END IF;
1752:

Line 1749: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);

1745: d_position := 40;
1746: IF d_stmt THEN
1747: PO_LOG.stmt(d_mod,d_position,'x_result_set_id',x_result_set_id);
1748: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
1749: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
1750: PO_LOG.stmt(d_mod,d_position,'l_stop_rank',l_stop_rank);
1751: END IF;
1752:
1753: -- Loop through the validation set, executing each validation in turn.

Line 1750: PO_LOG.stmt(d_mod,d_position,'l_stop_rank',l_stop_rank);

1746: IF d_stmt THEN
1747: PO_LOG.stmt(d_mod,d_position,'x_result_set_id',x_result_set_id);
1748: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
1749: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
1750: PO_LOG.stmt(d_mod,d_position,'l_stop_rank',l_stop_rank);
1751: END IF;
1752:
1753: -- Loop through the validation set, executing each validation in turn.
1754:

Line 1761: PO_LOG.stmt(d_mod,d_position,'p_validation_set('||i||')',l_val);

1757:
1758: l_val := p_validation_set(i);
1759:
1760: IF d_stmt THEN
1761: PO_LOG.stmt(d_mod,d_position,'p_validation_set('||i||')',l_val);
1762: END IF;
1763:
1764: d_position := 110;
1765:

Line 4899: IF PO_LOG.d_exc THEN

4895: , x_result_type => l_result_type
4896: );
4897:
4898: ELSE
4899: IF PO_LOG.d_exc THEN
4900: PO_LOG.exc(d_mod,d_position,'Invalid identifier in validation set: '||l_val);
4901: END IF;
4902: RAISE CASE_NOT_FOUND;
4903:

Line 4900: PO_LOG.exc(d_mod,d_position,'Invalid identifier in validation set: '||l_val);

4896: );
4897:
4898: ELSE
4899: IF PO_LOG.d_exc THEN
4900: PO_LOG.exc(d_mod,d_position,'Invalid identifier in validation set: '||l_val);
4901: END IF;
4902: RAISE CASE_NOT_FOUND;
4903:
4904: END CASE;

Line 4908: IF PO_LOG.d_exc THEN

4904: END CASE;
4905:
4906: EXCEPTION
4907: WHEN OTHERS THEN
4908: IF PO_LOG.d_exc THEN
4909: PO_LOG.exc(d_mod,d_position,
4910: 'Validation subroutine '||l_val||' threw exception');
4911: END IF;
4912:

Line 4909: PO_LOG.exc(d_mod,d_position,

4905:
4906: EXCEPTION
4907: WHEN OTHERS THEN
4908: IF PO_LOG.d_exc THEN
4909: PO_LOG.exc(d_mod,d_position,
4910: 'Validation subroutine '||l_val||' threw exception');
4911: END IF;
4912:
4913: l_result_type := c_result_type_FATAL;

Line 4935: PO_LOG.stmt(d_mod,d_position,'l_result_type',l_result_type);

4931: END;
4932:
4933: d_position := 200;
4934: IF d_stmt THEN
4935: PO_LOG.stmt(d_mod,d_position,'l_result_type',l_result_type);
4936: PO_LOG.stmt(d_mod,d_position,'l_result_set_id',l_result_set_id);
4937: END IF;
4938:
4939: -- Fix the result set id.

Line 4936: PO_LOG.stmt(d_mod,d_position,'l_result_set_id',l_result_set_id);

4932:
4933: d_position := 200;
4934: IF d_stmt THEN
4935: PO_LOG.stmt(d_mod,d_position,'l_result_type',l_result_type);
4936: PO_LOG.stmt(d_mod,d_position,'l_result_set_id',l_result_set_id);
4937: END IF;
4938:
4939: -- Fix the result set id.
4940: IF (l_result_set_id <> x_result_set_id) THEN

Line 4962: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);

4958: x_result_type := l_result_type;
4959: l_result_rank := l_new_rank;
4960:
4961: IF d_stmt THEN
4962: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
4963: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
4964: END IF;
4965:
4966: -- If the validation has encountered a serious problem

Line 4963: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);

4959: l_result_rank := l_new_rank;
4960:
4961: IF d_stmt THEN
4962: PO_LOG.stmt(d_mod,d_position,'x_result_type',x_result_type);
4963: PO_LOG.stmt(d_mod,d_position,'l_result_rank',l_result_rank);
4964: END IF;
4965:
4966: -- If the validation has encountered a serious problem
4967: -- or the stopping result, stop processing.

Line 4974: PO_LOG.stmt(d_mod,d_position,'Stopping loop. x_result_type',x_result_type);

4970: )
4971: THEN
4972: d_position := 400;
4973: IF d_stmt THEN
4974: PO_LOG.stmt(d_mod,d_position,'Stopping loop. x_result_type',x_result_type);
4975: END IF;
4976:
4977: EXIT;
4978: END IF;

Line 4993: IF PO_LOG.d_proc THEN

4989: d_position := 600;
4990: commit_result_set(p_result_set_id => x_result_set_id);
4991: END IF;
4992:
4993: IF PO_LOG.d_proc THEN
4994: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
4995: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4996: END IF;
4997:

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

4990: commit_result_set(p_result_set_id => x_result_set_id);
4991: END IF;
4992:
4993: IF PO_LOG.d_proc THEN
4994: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
4995: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4996: END IF;
4997:
4998: EXCEPTION

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

4991: END IF;
4992:
4993: IF PO_LOG.d_proc THEN
4994: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
4995: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4996: END IF;
4997:
4998: EXCEPTION
4999: WHEN OTHERS THEN

Line 5000: IF PO_LOG.d_exc THEN

4996: END IF;
4997:
4998: EXCEPTION
4999: WHEN OTHERS THEN
5000: IF PO_LOG.d_exc THEN
5001: PO_LOG.exc(d_mod,d_position,NULL);
5002: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
5003: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5004: END IF;

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

4997:
4998: EXCEPTION
4999: WHEN OTHERS THEN
5000: IF PO_LOG.d_exc THEN
5001: PO_LOG.exc(d_mod,d_position,NULL);
5002: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
5003: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5004: END IF;
5005: RAISE;

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

4998: EXCEPTION
4999: WHEN OTHERS THEN
5000: IF PO_LOG.d_exc THEN
5001: PO_LOG.exc(d_mod,d_position,NULL);
5002: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
5003: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5004: END IF;
5005: RAISE;
5006:

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

4999: WHEN OTHERS THEN
5000: IF PO_LOG.d_exc THEN
5001: PO_LOG.exc(d_mod,d_position,NULL);
5002: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
5003: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5004: END IF;
5005: RAISE;
5006:
5007: END validate_set;

Line 5048: IF PO_LOG.d_proc THEN

5044: l_result_set_id NUMBER;
5045: l_table_results PO_VALIDATION_RESULTS_TYPE;
5046: BEGIN
5047:
5048: IF PO_LOG.d_proc THEN
5049: PO_LOG.proc_begin(d_mod);
5050: END IF;
5051:
5052: d_position := 100;

Line 5049: PO_LOG.proc_begin(d_mod);

5045: l_table_results PO_VALIDATION_RESULTS_TYPE;
5046: BEGIN
5047:
5048: IF PO_LOG.d_proc THEN
5049: PO_LOG.proc_begin(d_mod);
5050: END IF;
5051:
5052: d_position := 100;
5053:

Line 5092: IF PO_LOG.d_proc THEN

5088: x_results.append( p_results => l_table_results );
5089:
5090: d_position := 500;
5091:
5092: IF PO_LOG.d_proc THEN
5093: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5094: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5095: END IF;
5096:

Line 5093: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);

5089:
5090: d_position := 500;
5091:
5092: IF PO_LOG.d_proc THEN
5093: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5094: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5095: END IF;
5096:
5097: EXCEPTION

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

5090: d_position := 500;
5091:
5092: IF PO_LOG.d_proc THEN
5093: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5094: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5095: END IF;
5096:
5097: EXCEPTION
5098: WHEN OTHERS THEN

Line 5099: IF PO_LOG.d_exc THEN

5095: END IF;
5096:
5097: EXCEPTION
5098: WHEN OTHERS THEN
5099: IF PO_LOG.d_exc THEN
5100: PO_LOG.exc(d_mod,d_position,NULL);
5101: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5102: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5103: END IF;

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

5096:
5097: EXCEPTION
5098: WHEN OTHERS THEN
5099: IF PO_LOG.d_exc THEN
5100: PO_LOG.exc(d_mod,d_position,NULL);
5101: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5102: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5103: END IF;
5104: RAISE;

Line 5101: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);

5097: EXCEPTION
5098: WHEN OTHERS THEN
5099: IF PO_LOG.d_exc THEN
5100: PO_LOG.exc(d_mod,d_position,NULL);
5101: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5102: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5103: END IF;
5104: RAISE;
5105:

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

5098: WHEN OTHERS THEN
5099: IF PO_LOG.d_exc THEN
5100: PO_LOG.exc(d_mod,d_position,NULL);
5101: PO_LOG.proc_end(d_mod,'l_result_set_id',l_result_set_id);
5102: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5103: END IF;
5104: RAISE;
5105:
5106: END validate_set;

Line 5134: IF PO_LOG.d_proc THEN

5130: d_mod CONSTANT VARCHAR2(100) := D_result_type_rank;
5131: l_rank NUMBER;
5132: BEGIN
5133:
5134: IF PO_LOG.d_proc THEN
5135: PO_LOG.proc_begin(d_mod,'p_result_type',p_result_type);
5136: END IF;
5137:
5138: FOR i IN 1 .. c_result_type_rank_tbl.COUNT LOOP

Line 5135: PO_LOG.proc_begin(d_mod,'p_result_type',p_result_type);

5131: l_rank NUMBER;
5132: BEGIN
5133:
5134: IF PO_LOG.d_proc THEN
5135: PO_LOG.proc_begin(d_mod,'p_result_type',p_result_type);
5136: END IF;
5137:
5138: FOR i IN 1 .. c_result_type_rank_tbl.COUNT LOOP
5139: IF (c_result_type_rank_tbl(i) = p_result_type) THEN

Line 5149: IF PO_LOG.d_proc THEN

5145: IF (l_rank IS NULL) THEN
5146: l_rank := -1;
5147: END IF;
5148:
5149: IF PO_LOG.d_proc THEN
5150: PO_LOG.proc_return(d_mod,l_rank);
5151: END IF;
5152:
5153: RETURN l_rank;

Line 5150: PO_LOG.proc_return(d_mod,l_rank);

5146: l_rank := -1;
5147: END IF;
5148:
5149: IF PO_LOG.d_proc THEN
5150: PO_LOG.proc_return(d_mod,l_rank);
5151: END IF;
5152:
5153: RETURN l_rank;
5154:

Line 5198: IF PO_LOG.d_proc THEN

5194: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;
5195: l_lines PO_LINES_VAL_TYPE;
5196: BEGIN
5197:
5198: IF PO_LOG.d_proc THEN
5199: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5200: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
5201: END IF;
5202:

Line 5199: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

5195: l_lines PO_LINES_VAL_TYPE;
5196: BEGIN
5197:
5198: IF PO_LOG.d_proc THEN
5199: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5200: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
5201: END IF;
5202:
5203: l_lines := PO_LINES_VAL_TYPE();

Line 5200: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);

5196: BEGIN
5197:
5198: IF PO_LOG.d_proc THEN
5199: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5200: PO_LOG.proc_begin(d_mod,'p_stopping_result_type',p_stopping_result_type);
5201: END IF;
5202:
5203: l_lines := PO_LINES_VAL_TYPE();
5204: l_lines.po_line_id := p_line_id_tbl;

Line 5217: IF PO_LOG.d_proc THEN

5213: , x_result_set_id => x_result_set_id
5214: , x_results => x_results
5215: );
5216:
5217: IF PO_LOG.d_proc THEN
5218: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
5219: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5220: END IF;
5221:

Line 5218: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);

5214: , x_results => x_results
5215: );
5216:
5217: IF PO_LOG.d_proc THEN
5218: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
5219: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5220: END IF;
5221:
5222: EXCEPTION

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

5215: );
5216:
5217: IF PO_LOG.d_proc THEN
5218: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
5219: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5220: END IF;
5221:
5222: EXCEPTION
5223: WHEN OTHERS THEN

Line 5224: IF PO_LOG.d_exc THEN

5220: END IF;
5221:
5222: EXCEPTION
5223: WHEN OTHERS THEN
5224: IF PO_LOG.d_exc THEN
5225: PO_LOG.exc(d_mod,0,NULL);
5226: END IF;
5227: RAISE;
5228:

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

5221:
5222: EXCEPTION
5223: WHEN OTHERS THEN
5224: IF PO_LOG.d_exc THEN
5225: PO_LOG.exc(d_mod,0,NULL);
5226: END IF;
5227: RAISE;
5228:
5229: END validate_unit_price_change;

Line 5275: IF PO_LOG.d_proc THEN

5271: d_position NUMBER := 0;
5272: l_validation_set PO_TBL_VARCHAR2000;
5273: BEGIN
5274:
5275: IF PO_LOG.d_proc THEN
5276: PO_LOG.proc_begin(d_mod);
5277: END IF;
5278:
5279: d_position := 1;

Line 5276: PO_LOG.proc_begin(d_mod);

5272: l_validation_set PO_TBL_VARCHAR2000;
5273: BEGIN
5274:
5275: IF PO_LOG.d_proc THEN
5276: PO_LOG.proc_begin(d_mod);
5277: END IF;
5278:
5279: d_position := 1;
5280:

Line 5313: IF PO_LOG.d_stmt THEN

5309: l_validation_set :=
5310: l_validation_set MULTISET UNION DISTINCT c_html_order_price_diff_vs;
5311: END IF;
5312:
5313: IF PO_LOG.d_stmt THEN
5314: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5315: END IF;
5316:
5317: d_position := 100;

Line 5314: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);

5310: l_validation_set MULTISET UNION DISTINCT c_html_order_price_diff_vs;
5311: END IF;
5312:
5313: IF PO_LOG.d_stmt THEN
5314: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5315: END IF;
5316:
5317: d_position := 100;
5318:

Line 5331: IF PO_LOG.d_proc THEN

5327: , x_result_type => x_result_type
5328: , x_results => x_results
5329: );
5330:
5331: IF PO_LOG.d_proc THEN
5332: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5333: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5334: END IF;
5335:

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

5328: , x_results => x_results
5329: );
5330:
5331: IF PO_LOG.d_proc THEN
5332: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5333: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5334: END IF;
5335:
5336: EXCEPTION

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

5329: );
5330:
5331: IF PO_LOG.d_proc THEN
5332: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5333: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5334: END IF;
5335:
5336: EXCEPTION
5337: WHEN OTHERS THEN

Line 5338: IF PO_LOG.d_exc THEN

5334: END IF;
5335:
5336: EXCEPTION
5337: WHEN OTHERS THEN
5338: IF PO_LOG.d_exc THEN
5339: PO_LOG.exc(d_mod,d_position,NULL);
5340: END IF;
5341: RAISE;
5342:

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

5335:
5336: EXCEPTION
5337: WHEN OTHERS THEN
5338: IF PO_LOG.d_exc THEN
5339: PO_LOG.exc(d_mod,d_position,NULL);
5340: END IF;
5341: RAISE;
5342:
5343: END validate_html_order;

Line 5364: IF PO_LOG.d_proc THEN

5360: d_position NUMBER := 0;
5361: l_validation_set PO_TBL_VARCHAR2000;
5362: BEGIN
5363:
5364: IF PO_LOG.d_proc THEN
5365: PO_LOG.proc_begin(d_mod);
5366: END IF;
5367:
5368: d_position := 1;

Line 5365: PO_LOG.proc_begin(d_mod);

5361: l_validation_set PO_TBL_VARCHAR2000;
5362: BEGIN
5363:
5364: IF PO_LOG.d_proc THEN
5365: PO_LOG.proc_begin(d_mod);
5366: END IF;
5367:
5368: d_position := 1;
5369:

Line 5414: IF PO_LOG.d_stmt THEN

5410: l_validation_set :=
5411: l_validation_set MULTISET UNION DISTINCT c_html_agmt_distribution_vs;
5412: END IF;
5413:
5414: IF PO_LOG.d_stmt THEN
5415: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5416: END IF;
5417:
5418: d_position := 100;

Line 5415: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);

5411: l_validation_set MULTISET UNION DISTINCT c_html_agmt_distribution_vs;
5412: END IF;
5413:
5414: IF PO_LOG.d_stmt THEN
5415: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5416: END IF;
5417:
5418: d_position := 100;
5419:

Line 5434: IF PO_LOG.d_proc THEN

5430: , x_result_type => x_result_type
5431: , x_results => x_results
5432: );
5433:
5434: IF PO_LOG.d_proc THEN
5435: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5436: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5437: END IF;
5438:

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

5431: , x_results => x_results
5432: );
5433:
5434: IF PO_LOG.d_proc THEN
5435: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5436: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5437: END IF;
5438:
5439: EXCEPTION

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

5432: );
5433:
5434: IF PO_LOG.d_proc THEN
5435: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5436: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5437: END IF;
5438:
5439: EXCEPTION
5440: WHEN OTHERS THEN

Line 5441: IF PO_LOG.d_exc THEN

5437: END IF;
5438:
5439: EXCEPTION
5440: WHEN OTHERS THEN
5441: IF PO_LOG.d_exc THEN
5442: PO_LOG.exc(d_mod,d_position,NULL);
5443: END IF;
5444: RAISE;
5445:

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

5438:
5439: EXCEPTION
5440: WHEN OTHERS THEN
5441: IF PO_LOG.d_exc THEN
5442: PO_LOG.exc(d_mod,d_position,NULL);
5443: END IF;
5444: RAISE;
5445:
5446: END validate_html_agreement;

Line 5496: IF PO_LOG.d_proc THEN

5492: l_validation_set PO_TBL_VARCHAR2000;
5493:
5494: BEGIN
5495:
5496: IF PO_LOG.d_proc THEN
5497: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
5498: po_log.proc_begin(d_mod, 'p_action', p_action);
5499: END IF;
5500:

Line 5497: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);

5493:
5494: BEGIN
5495:
5496: IF PO_LOG.d_proc THEN
5497: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
5498: po_log.proc_begin(d_mod, 'p_action', p_action);
5499: END IF;
5500:
5501: d_position := 1;

Line 5498: po_log.proc_begin(d_mod, 'p_action', p_action);

5494: BEGIN
5495:
5496: IF PO_LOG.d_proc THEN
5497: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
5498: po_log.proc_begin(d_mod, 'p_action', p_action);
5499: END IF;
5500:
5501: d_position := 1;
5502:

Line 5522: IF PO_LOG.d_exc THEN

5518: WHEN c_doc_type_quotation THEN
5519: l_validation_set :=
5520: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_quotation_vs;
5521: ELSE
5522: IF PO_LOG.d_exc THEN
5523: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5524: END IF;
5525: END CASE;
5526:

Line 5523: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);

5519: l_validation_set :=
5520: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_quotation_vs;
5521: ELSE
5522: IF PO_LOG.d_exc THEN
5523: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5524: END IF;
5525: END CASE;
5526:
5527: ELSIF (p_lines IS NOT NULL AND p_action='CREATE' AND p_headers IS NULL AND p_line_locations IS NULL AND

Line 5544: IF PO_LOG.d_exc THEN

5540: WHEN c_doc_type_quotation THEN
5541: l_validation_set :=
5542: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_quotation_vs;
5543: ELSE
5544: IF PO_LOG.d_exc THEN
5545: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5546: END IF;
5547: END CASE;
5548:

Line 5545: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);

5541: l_validation_set :=
5542: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_quotation_vs;
5543: ELSE
5544: IF PO_LOG.d_exc THEN
5545: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5546: END IF;
5547: END CASE;
5548:
5549: ELSIF (p_lines IS NOT NULL AND p_action='UPDATE' AND p_headers IS NULL AND p_line_locations IS NULL AND

Line 5561: IF PO_LOG.d_exc THEN

5557: WHEN c_doc_type_blanket THEN
5558: l_validation_set :=
5559: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_update_vs;
5560: ELSE
5561: IF PO_LOG.d_exc THEN
5562: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5563: END IF;
5564: END CASE;
5565:

Line 5562: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);

5558: l_validation_set :=
5559: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_update_vs;
5560: ELSE
5561: IF PO_LOG.d_exc THEN
5562: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5563: END IF;
5564: END CASE;
5565:
5566: ELSIF (p_line_locations IS NOT NULL AND p_headers IS NULL AND p_lines IS NULL AND

Line 5584: IF PO_LOG.d_exc THEN

5580: WHEN c_doc_type_quotation THEN
5581: l_validation_set :=
5582: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_quotation_vs;
5583: ELSE
5584: IF PO_LOG.d_exc THEN
5585: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5586: END IF;
5587: END CASE;
5588:

Line 5585: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);

5581: l_validation_set :=
5582: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_quotation_vs;
5583: ELSE
5584: IF PO_LOG.d_exc THEN
5585: PO_LOG.exc(d_mod,d_position,'Invalid doc_type in validation_pdoi: '||p_doc_type);
5586: END IF;
5587: END CASE;
5588:
5589: ELSIF (p_distributions IS NOT NULL AND p_headers IS NULL AND p_lines IS NULL AND

Line 5605: IF PO_LOG.d_exc THEN

5601: l_validation_set MULTISET UNION DISTINCT c_pdoi_price_diff_common_vs;
5602:
5603: ELSE
5604:
5605: IF PO_LOG.d_exc THEN
5606: PO_LOG.exc(d_mod,d_position,'Call to validate_pdoi was incorrectly called.');
5607: END IF;
5608:
5609: END IF;

Line 5606: PO_LOG.exc(d_mod,d_position,'Call to validate_pdoi was incorrectly called.');

5602:
5603: ELSE
5604:
5605: IF PO_LOG.d_exc THEN
5606: PO_LOG.exc(d_mod,d_position,'Call to validate_pdoi was incorrectly called.');
5607: END IF;
5608:
5609: END IF;
5610:

Line 5611: IF PO_LOG.d_stmt THEN

5607: END IF;
5608:
5609: END IF;
5610:
5611: IF PO_LOG.d_stmt THEN
5612: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5613: END IF;
5614:
5615: d_position := 100;

Line 5612: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);

5608:
5609: END IF;
5610:
5611: IF PO_LOG.d_stmt THEN
5612: PO_LOG.stmt(d_mod,d_position,'l_validation_set',l_validation_set);
5613: END IF;
5614:
5615: d_position := 100;
5616:

Line 5630: IF PO_LOG.d_proc THEN

5626: x_result_type => x_result_type,
5627: x_results => x_results
5628: );
5629:
5630: IF PO_LOG.d_proc THEN
5631: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5632: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5633: END IF;
5634:

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

5627: x_results => x_results
5628: );
5629:
5630: IF PO_LOG.d_proc THEN
5631: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5632: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5633: END IF;
5634:
5635: EXCEPTION

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

5628: );
5629:
5630: IF PO_LOG.d_proc THEN
5631: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5632: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
5633: END IF;
5634:
5635: EXCEPTION
5636: WHEN OTHERS THEN

Line 5637: IF PO_LOG.d_exc THEN

5633: END IF;
5634:
5635: EXCEPTION
5636: WHEN OTHERS THEN
5637: IF PO_LOG.d_exc THEN
5638: PO_LOG.exc(d_mod,d_position,NULL);
5639: END IF;
5640: RAISE;
5641:

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

5634:
5635: EXCEPTION
5636: WHEN OTHERS THEN
5637: IF PO_LOG.d_exc THEN
5638: PO_LOG.exc(d_mod,d_position,NULL);
5639: END IF;
5640: RAISE;
5641:
5642: END validate_pdoi;

Line 5655: IF PO_LOG.d_stmt THEN

5651: )
5652: IS
5653: l_rowid_tbl PO_TBL_VARCHAR2000;
5654: BEGIN
5655: IF PO_LOG.d_stmt THEN
5656: SELECT VR.rowid
5657: BULK COLLECT INTO l_rowid_tbl
5658: FROM PO_VALIDATION_RESULTS_GT VR
5659: WHERE VR.result_set_id = p_result_set_id

Line 5661: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);

5657: BULK COLLECT INTO l_rowid_tbl
5658: FROM PO_VALIDATION_RESULTS_GT VR
5659: WHERE VR.result_set_id = p_result_set_id
5660: ;
5661: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);
5662: END IF;
5663: END log_validation_results_gt;
5664:
5665: