1: PACKAGE BODY PO_VAL_LINES2 AS
2: -- $Header: PO_VAL_LINES2.plb 120.35.12020000.3 2013/02/10 21:14:29 vegajula ship $
3: c_entity_type_line CONSTANT VARCHAR2(30) := po_validations.c_entity_type_line;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_LINES2');
6:
7: -- The module base for the subprogram.
8: d_over_tolerance_error_flag CONSTANT VARCHAR2(100)
9: := po_log.get_subprogram_base(d_package_base, 'OVER_TOLERANCE_ERROR_FLAG');
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_LINES2');
6:
7: -- The module base for the subprogram.
8: d_over_tolerance_error_flag CONSTANT VARCHAR2(100)
9: := po_log.get_subprogram_base(d_package_base, 'OVER_TOLERANCE_ERROR_FLAG');
10: d_expiration_date_blanket CONSTANT VARCHAR2(100)
11: := po_log.get_subprogram_base(d_package_base, 'EXPIRATION_DATE_BLANKET');
12: d_global_agreement_flag CONSTANT VARCHAR2(100)
13: := po_log.get_subprogram_base(d_package_base, 'GLOBAL_AGREEMENT_FLAG');
7: -- The module base for the subprogram.
8: d_over_tolerance_error_flag CONSTANT VARCHAR2(100)
9: := po_log.get_subprogram_base(d_package_base, 'OVER_TOLERANCE_ERROR_FLAG');
10: d_expiration_date_blanket CONSTANT VARCHAR2(100)
11: := po_log.get_subprogram_base(d_package_base, 'EXPIRATION_DATE_BLANKET');
12: d_global_agreement_flag CONSTANT VARCHAR2(100)
13: := po_log.get_subprogram_base(d_package_base, 'GLOBAL_AGREEMENT_FLAG');
14: d_amount_blanket CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
9: := po_log.get_subprogram_base(d_package_base, 'OVER_TOLERANCE_ERROR_FLAG');
10: d_expiration_date_blanket CONSTANT VARCHAR2(100)
11: := po_log.get_subprogram_base(d_package_base, 'EXPIRATION_DATE_BLANKET');
12: d_global_agreement_flag CONSTANT VARCHAR2(100)
13: := po_log.get_subprogram_base(d_package_base, 'GLOBAL_AGREEMENT_FLAG');
14: d_amount_blanket CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
16: d_order_type_lookup_code CONSTANT VARCHAR2(100)
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
11: := po_log.get_subprogram_base(d_package_base, 'EXPIRATION_DATE_BLANKET');
12: d_global_agreement_flag CONSTANT VARCHAR2(100)
13: := po_log.get_subprogram_base(d_package_base, 'GLOBAL_AGREEMENT_FLAG');
14: d_amount_blanket CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
16: d_order_type_lookup_code CONSTANT VARCHAR2(100)
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
18: d_contractor_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CONTRACTOR_NAME');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
13: := po_log.get_subprogram_base(d_package_base, 'GLOBAL_AGREEMENT_FLAG');
14: d_amount_blanket CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
16: d_order_type_lookup_code CONSTANT VARCHAR2(100)
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
18: d_contractor_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CONTRACTOR_NAME');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
14: d_amount_blanket CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
16: d_order_type_lookup_code CONSTANT VARCHAR2(100)
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
18: d_contractor_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CONTRACTOR_NAME');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
15: := po_log.get_subprogram_base(d_package_base, 'AMOUNT_BLANKET');
16: d_order_type_lookup_code CONSTANT VARCHAR2(100)
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
18: d_contractor_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CONTRACTOR_NAME');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
17: := po_log.get_subprogram_base(d_package_base, 'ORDER_TYPE_LOOKUP_CODE');
18: d_contractor_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CONTRACTOR_NAME');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
19: d_job_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'JOB_ID');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
20: d_job_business_group_id CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
21: := po_log.get_subprogram_base(d_package_base, 'JOB_BUSINESS_GROUP_ID');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
22: d_capital_expense_flag CONSTANT VARCHAR2(100)
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
23: := po_log.get_subprogram_base(d_package_base, 'CAPITAL_EXPENSE_FLAG');
24: d_un_number_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UN_NUMBER_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
25: d_hazard_class_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'HAZARD_CLASS_ID');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
26: d_item_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
27: d_item_description CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESCRIPTION');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
28: d_unit_meas_lookup_code CONSTANT VARCHAR2(100)
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
29: := po_log.get_subprogram_base(d_package_base, 'UNIT_MEAS_LOOKUP_CODE');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
30: d_item_revision CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_REVISION');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
31: d_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
32: d_ip_category_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
33: d_unit_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE');
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
34: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
35: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT');
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
36: d_rate_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_TYPE');
37: d_line_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_NUM');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
38: d_po_line_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_LINE_ID');
39: d_line_type_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LINE_TYPE_ID');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
40: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
41: d_price_type_lookup_code CONSTANT VARCHAR2(100)
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
42: := po_log.get_subprogram_base(d_package_base, 'PRICE_TYPE_LOOKUP_CODE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
43: d_start_date_standard CONSTANT VARCHAR2(100)
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
44: := po_log.get_subprogram_base(d_package_base, 'START_DATE_STANDARD');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
45: d_item_id_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_ID_STANDARD');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
46: d_quantity_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_STANDARD');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
47: d_amount_standard CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_STANDARD');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
48: d_price_break_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_LOOKUP_CODE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
49: d_not_to_exceed_price CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NOT_TO_EXCEED_PRICE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
50: d_ip_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'IP_CATEGORY_ID_UPDATE');
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
58: -- bug 8633959
51: d_uom_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UOM_UPDATE');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
58: -- bug 8633959
59: d_category_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_COMBINATION_VALID');
52: d_item_desc_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_DESC_UPDATE');
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
58: -- bug 8633959
59: d_category_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_COMBINATION_VALID');
60:
53: d_negotiated_by_preparer CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER');
54: d_negotiated_by_prep_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEGOTIATED_BY_PREPARER_UPDATE');
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
58: -- bug 8633959
59: d_category_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_COMBINATION_VALID');
60:
61: -- bug 14075368
55: d_category_id_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_ID_UPDATE');
56: d_unit_price_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'UNIT_PRICE_UPDATE');
57: d_amount_update CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_UPDATE');
58: -- bug 8633959
59: d_category_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_COMBINATION_VALID');
60:
61: -- bug 14075368
62: d_item_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_COMBINATION_VALID');
63:
58: -- bug 8633959
59: d_category_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CATEGORY_COMBINATION_VALID');
60:
61: -- bug 14075368
62: d_item_comb_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ITEM_COMBINATION_VALID');
63:
64: -- Indicates that the calling program is PDOI.
65: c_program_PDOI CONSTANT VARCHAR2(10) := 'PDOI';
66:
80: IF x_result_set_id IS NULL THEN
81: x_result_set_id := po_validations.next_result_set_id();
82: END IF;
83:
84: IF po_log.d_proc THEN
85: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
86: po_log.proc_begin(d_mod, 'p_over_tolerance_err_flag_tbl', p_over_tolerance_err_flag_tbl);
87: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
88: END IF;
81: x_result_set_id := po_validations.next_result_set_id();
82: END IF;
83:
84: IF po_log.d_proc THEN
85: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
86: po_log.proc_begin(d_mod, 'p_over_tolerance_err_flag_tbl', p_over_tolerance_err_flag_tbl);
87: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
88: END IF;
89:
82: END IF;
83:
84: IF po_log.d_proc THEN
85: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
86: po_log.proc_begin(d_mod, 'p_over_tolerance_err_flag_tbl', p_over_tolerance_err_flag_tbl);
87: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
88: END IF;
89:
90: FORALL i IN 1 .. p_id_tbl.COUNT
83:
84: IF po_log.d_proc THEN
85: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
86: po_log.proc_begin(d_mod, 'p_over_tolerance_err_flag_tbl', p_over_tolerance_err_flag_tbl);
87: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
88: END IF;
89:
90: FORALL i IN 1 .. p_id_tbl.COUNT
91: INSERT INTO po_validation_results_gt
123: ELSE
124: x_result_type := po_validations.c_result_type_success;
125: END IF;
126:
127: IF po_log.d_proc THEN
128: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
131: END IF;
125: END IF;
126:
127: IF po_log.d_proc THEN
128: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
126:
127: IF po_log.d_proc THEN
128: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN
130: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN
135: po_log.exc(d_mod, 0, NULL);
136: END IF;
137:
138: RAISE;
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN
135: po_log.exc(d_mod, 0, NULL);
136: END IF;
137:
138: RAISE;
139: END over_tolerance_err_flag;
157: END IF;
158:
159: x_result_type := po_validations.c_result_type_success;
160:
161: IF po_log.d_proc THEN
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
158:
159: x_result_type := po_validations.c_result_type_success;
160:
161: IF po_log.d_proc THEN
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
159: x_result_type := po_validations.c_result_type_success;
160:
161: IF po_log.d_proc THEN
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
167: END IF;
160:
161: IF po_log.d_proc THEN
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
167: END IF;
168:
161: IF po_log.d_proc THEN
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
167: END IF;
168:
169: FOR i IN 1 .. p_id_tbl.COUNT LOOP
162: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
163: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
164: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
165: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
166: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
167: END IF;
168:
169: FOR i IN 1 .. p_id_tbl.COUNT LOOP
170: IF p_expiration_date_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_DATE THEN
189: x_result_type := po_validations.c_result_type_failure;
190: END IF;
191: END LOOP;
192:
193: IF po_log.d_proc THEN
194: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
195: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
196: END IF;
197: EXCEPTION
190: END IF;
191: END LOOP;
192:
193: IF po_log.d_proc THEN
194: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
195: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
196: END IF;
197: EXCEPTION
198: WHEN OTHERS THEN
191: END LOOP;
192:
193: IF po_log.d_proc THEN
194: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
195: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
196: END IF;
197: EXCEPTION
198: WHEN OTHERS THEN
199: IF po_log.d_exc THEN
195: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
196: END IF;
197: EXCEPTION
198: WHEN OTHERS THEN
199: IF po_log.d_exc THEN
200: po_log.exc(d_mod, 0, NULL);
201: END IF;
202:
203: RAISE;
196: END IF;
197: EXCEPTION
198: WHEN OTHERS THEN
199: IF po_log.d_exc THEN
200: po_log.exc(d_mod, 0, NULL);
201: END IF;
202:
203: RAISE;
204: END expiration_date_blanket;
226: IF (x_results IS NULL) THEN
227: x_results := po_validation_results_type.new_instance();
228: END IF;
229:
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
227: x_results := po_validation_results_type.new_instance();
228: END IF;
229:
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
228: END IF;
229:
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
236: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
229:
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
236: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
237: END IF;
230: IF po_log.d_proc THEN
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
236: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
237: END IF;
238:
231: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
236: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
237: END IF;
238:
239: x_result_type := po_validations.c_result_type_success;
232: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
233: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
234: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
236: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
237: END IF;
238:
239: x_result_type := po_validations.c_result_type_success;
240:
281: x_result_type := po_validations.c_result_type_failure;
282: END IF;
283: END IF ;
284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
283: END IF ;
284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
290: END IF;
291: EXCEPTION
284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF po_log.d_exc THEN
289: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF po_log.d_exc THEN
294: po_log.exc(d_mod, 0, NULL);
295: END IF;
296:
297: RAISE;
290: END IF;
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF po_log.d_exc THEN
294: po_log.exc(d_mod, 0, NULL);
295: END IF;
296:
297: RAISE;
298: END global_agreement_flag;
314: IF (x_results IS NULL) THEN
315: x_results := po_validation_results_type.new_instance();
316: END IF;
317:
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
320: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
321: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
322: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
315: x_results := po_validation_results_type.new_instance();
316: END IF;
317:
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
320: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
321: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
322: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
323: END IF;
316: END IF;
317:
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
320: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
321: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
322: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
323: END IF;
324:
317:
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
320: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
321: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
322: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
323: END IF;
324:
325: x_result_type := po_validations.c_result_type_success;
318: IF po_log.d_proc THEN
319: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
320: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
321: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
322: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
323: END IF;
324:
325: x_result_type := po_validations.c_result_type_success;
326:
350: x_result_type := po_validations.c_result_type_failure;
351: END IF;
352: END LOOP;
353:
354: IF po_log.d_proc THEN
355: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
356: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
357: END IF;
358: EXCEPTION
351: END IF;
352: END LOOP;
353:
354: IF po_log.d_proc THEN
355: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
356: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN
352: END LOOP;
353:
354: IF po_log.d_proc THEN
355: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
356: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF po_log.d_exc THEN
356: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF po_log.d_exc THEN
361: po_log.exc(d_mod, 0, NULL);
362: END IF;
363:
364: RAISE;
357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF po_log.d_exc THEN
361: po_log.exc(d_mod, 0, NULL);
362: END IF;
363:
364: RAISE;
365: END amount_blanket;
379: IF (x_results IS NULL) THEN
380: x_results := po_validation_results_type.new_instance();
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
385: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
387: END IF;
380: x_results := po_validation_results_type.new_instance();
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
385: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
387: END IF;
388:
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
385: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
387: END IF;
388:
389: x_result_type := po_validations.c_result_type_success;
382:
383: IF po_log.d_proc THEN
384: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
385: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
387: END IF;
388:
389: x_result_type := po_validations.c_result_type_success;
390:
404: END IF;
405: END LOOP;
406: END IF;
407:
408: IF po_log.d_proc THEN
409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
411: END IF;
412: EXCEPTION
405: END LOOP;
406: END IF;
407:
408: IF po_log.d_proc THEN
409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
406: END IF;
407:
408: IF po_log.d_proc THEN
409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
414: IF po_log.d_exc THEN
410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
414: IF po_log.d_exc THEN
415: po_log.exc(d_mod, 0, NULL);
416: END IF;
417:
418: RAISE;
411: END IF;
412: EXCEPTION
413: WHEN OTHERS THEN
414: IF po_log.d_exc THEN
415: po_log.exc(d_mod, 0, NULL);
416: END IF;
417:
418: RAISE;
419: END order_type_lookup_code;
437: IF (x_results IS NULL) THEN
438: x_results := po_validation_results_type.new_instance();
439: END IF;
440:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
438: x_results := po_validation_results_type.new_instance();
439: END IF;
440:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
446: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
439: END IF;
440:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
446: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
447: END IF;
440:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
446: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
447: END IF;
448:
441: IF po_log.d_proc THEN
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
446: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
447: END IF;
448:
449: x_result_type := po_validations.c_result_type_success;
442: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
443: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
444: po_log.proc_begin(d_mod, 'p_contractor_last_name_tbl', p_contractor_last_name_tbl);
445: po_log.proc_begin(d_mod, 'p_contractor_first_name_tbl', p_contractor_first_name_tbl);
446: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
447: END IF;
448:
449: x_result_type := po_validations.c_result_type_success;
450:
462: x_result_type := po_validations.c_result_type_failure;
463: END IF;
464: END LOOP;
465:
466: IF po_log.d_proc THEN
467: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
468: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
469: END IF;
470: EXCEPTION
463: END IF;
464: END LOOP;
465:
466: IF po_log.d_proc THEN
467: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
468: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
464: END LOOP;
465:
466: IF po_log.d_proc THEN
467: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
468: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF po_log.d_exc THEN
468: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF po_log.d_exc THEN
473: po_log.exc(d_mod, 0, NULL);
474: END IF;
475:
476: RAISE;
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF po_log.d_exc THEN
473: po_log.exc(d_mod, 0, NULL);
474: END IF;
475:
476: RAISE;
477: END contractor_name;
498: IF (x_results IS NULL) THEN
499: x_results := po_validation_results_type.new_instance();
500: END IF;
501:
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
499: x_results := po_validation_results_type.new_instance();
500: END IF;
501:
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
500: END IF;
501:
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
508: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
501:
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
508: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
509: END IF;
502: IF po_log.d_proc THEN
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
508: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
509: END IF;
510:
503: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
508: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
509: END IF;
510:
511: x_result_type := po_validations.c_result_type_success;
504: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
505: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
506: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
507: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
508: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
509: END IF;
510:
511: x_result_type := po_validations.c_result_type_success;
512:
661: IF (SQL%ROWCOUNT > 0) THEN
662: x_result_type := po_validations.c_result_type_failure;
663: END IF;
664:
665: IF po_log.d_proc THEN
666: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
667: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
668: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
669: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
663: END IF;
664:
665: IF po_log.d_proc THEN
666: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
667: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
668: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
669: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
670: END IF;
671: EXCEPTION
664:
665: IF po_log.d_proc THEN
666: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
667: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
668: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
669: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
670: END IF;
671: EXCEPTION
672: WHEN OTHERS THEN
665: IF po_log.d_proc THEN
666: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
667: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
668: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
669: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
670: END IF;
671: EXCEPTION
672: WHEN OTHERS THEN
673: IF po_log.d_exc THEN
669: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
670: END IF;
671: EXCEPTION
672: WHEN OTHERS THEN
673: IF po_log.d_exc THEN
674: po_log.exc(d_mod, 0, NULL);
675: END IF;
676:
677: RAISE;
670: END IF;
671: EXCEPTION
672: WHEN OTHERS THEN
673: IF po_log.d_exc THEN
674: po_log.exc(d_mod, 0, NULL);
675: END IF;
676:
677: RAISE;
678: END job_id;
694: IF x_result_set_id IS NULL THEN
695: x_result_set_id := po_validations.next_result_set_id();
696: END IF;
697:
698: IF po_log.d_proc THEN
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
695: x_result_set_id := po_validations.next_result_set_id();
696: END IF;
697:
698: IF po_log.d_proc THEN
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
703: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
696: END IF;
697:
698: IF po_log.d_proc THEN
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
703: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
704: END IF;
697:
698: IF po_log.d_proc THEN
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
703: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
704: END IF;
705:
698: IF po_log.d_proc THEN
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
703: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
704: END IF;
705:
706: x_result_type := po_validations.c_result_type_success;
699: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
700: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
701: po_log.proc_begin(d_mod, 'p_job_business_group_id_tbl', p_job_business_group_id_tbl);
702: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
703: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
704: END IF;
705:
706: x_result_type := po_validations.c_result_type_success;
707:
769: x_result_type := po_validations.c_result_type_failure;
770: END IF;
771: END IF;
772:
773: IF po_log.d_proc THEN
774: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
775: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
776: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
777: END IF;
771: END IF;
772:
773: IF po_log.d_proc THEN
774: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
775: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
776: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
772:
773: IF po_log.d_proc THEN
774: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
775: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
776: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF po_log.d_exc THEN
776: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF po_log.d_exc THEN
781: po_log.exc(d_mod, 0, NULL);
782: END IF;
783:
784: RAISE;
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF po_log.d_exc THEN
781: po_log.exc(d_mod, 0, NULL);
782: END IF;
783:
784: RAISE;
785: END job_business_group_id;
799: IF (x_results IS NULL) THEN
800: x_results := po_validation_results_type.new_instance();
801: END IF;
802:
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
805: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
806: po_log.proc_begin(d_mod, 'p_capital_expense_flag_tbl', p_capital_expense_flag_tbl);
807: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
800: x_results := po_validation_results_type.new_instance();
801: END IF;
802:
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
805: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
806: po_log.proc_begin(d_mod, 'p_capital_expense_flag_tbl', p_capital_expense_flag_tbl);
807: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
808: END IF;
801: END IF;
802:
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
805: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
806: po_log.proc_begin(d_mod, 'p_capital_expense_flag_tbl', p_capital_expense_flag_tbl);
807: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
808: END IF;
809:
802:
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
805: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
806: po_log.proc_begin(d_mod, 'p_capital_expense_flag_tbl', p_capital_expense_flag_tbl);
807: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
808: END IF;
809:
810: x_result_type := po_validations.c_result_type_success;
803: IF po_log.d_proc THEN
804: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
805: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
806: po_log.proc_begin(d_mod, 'p_capital_expense_flag_tbl', p_capital_expense_flag_tbl);
807: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
808: END IF;
809:
810: x_result_type := po_validations.c_result_type_success;
811:
820: x_result_type := po_validations.c_result_type_failure;
821: END IF;
822: END LOOP;
823:
824: IF po_log.d_proc THEN
825: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
826: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
827: END IF;
828: EXCEPTION
821: END IF;
822: END LOOP;
823:
824: IF po_log.d_proc THEN
825: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
826: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
822: END LOOP;
823:
824: IF po_log.d_proc THEN
825: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
826: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF po_log.d_exc THEN
826: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF po_log.d_exc THEN
831: po_log.exc(d_mod, 0, NULL);
832: END IF;
833:
834: RAISE;
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF po_log.d_exc THEN
831: po_log.exc(d_mod, 0, NULL);
832: END IF;
833:
834: RAISE;
835: END capital_expense_flag;
854: IF (x_results IS NULL) THEN
855: x_results := po_validation_results_type.new_instance();
856: END IF;
857:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
855: x_results := po_validation_results_type.new_instance();
856: END IF;
857:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
863: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
856: END IF;
857:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
863: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
864: END IF;
857:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
863: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
864: END IF;
865:
858: IF po_log.d_proc THEN
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
863: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
864: END IF;
865:
866: x_result_type := po_validations.c_result_type_success;
859: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
860: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
861: po_log.proc_begin(d_mod, 'p_un_number_id_tbl', p_un_number_id_tbl);
862: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
863: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
864: END IF;
865:
866: x_result_type := po_validations.c_result_type_success;
867:
909: IF (SQL%ROWCOUNT > 0) THEN
910: x_result_type := po_validations.c_result_type_failure;
911: END IF;
912:
913: IF po_log.d_proc THEN
914: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
915: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
916: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
917: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
911: END IF;
912:
913: IF po_log.d_proc THEN
914: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
915: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
916: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
917: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
918: END IF;
919: EXCEPTION
912:
913: IF po_log.d_proc THEN
914: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
915: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
916: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
917: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
918: END IF;
919: EXCEPTION
920: WHEN OTHERS THEN
913: IF po_log.d_proc THEN
914: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
915: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
916: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
917: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
918: END IF;
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF po_log.d_exc THEN
917: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
918: END IF;
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF po_log.d_exc THEN
922: po_log.exc(d_mod, 0, NULL);
923: END IF;
924:
925: RAISE;
918: END IF;
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF po_log.d_exc THEN
922: po_log.exc(d_mod, 0, NULL);
923: END IF;
924:
925: RAISE;
926: END un_number_id;
945: IF (x_results IS NULL) THEN
946: x_results := po_validation_results_type.new_instance();
947: END IF;
948:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
946: x_results := po_validation_results_type.new_instance();
947: END IF;
948:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
954: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
947: END IF;
948:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
954: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
955: END IF;
948:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
954: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
955: END IF;
956:
949: IF po_log.d_proc THEN
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
954: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
955: END IF;
956:
957: x_result_type := po_validations.c_result_type_success;
950: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
951: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
952: po_log.proc_begin(d_mod, 'p_hazard_class_id_tbl', p_hazard_class_id_tbl);
953: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
954: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
955: END IF;
956:
957: x_result_type := po_validations.c_result_type_success;
958:
1000: IF (SQL%ROWCOUNT > 0) THEN
1001: x_result_type := po_validations.c_result_type_failure;
1002: END IF;
1003:
1004: IF po_log.d_proc THEN
1005: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1006: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1007: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1008: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1002: END IF;
1003:
1004: IF po_log.d_proc THEN
1005: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1006: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1007: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1008: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1009: END IF;
1010: EXCEPTION
1003:
1004: IF po_log.d_proc THEN
1005: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1006: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1007: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1008: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1009: END IF;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1004: IF po_log.d_proc THEN
1005: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1006: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1007: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1008: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1009: END IF;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF po_log.d_exc THEN
1008: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1009: END IF;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF po_log.d_exc THEN
1013: po_log.exc(d_mod, 0, NULL);
1014: END IF;
1015:
1016: RAISE;
1009: END IF;
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF po_log.d_exc THEN
1013: po_log.exc(d_mod, 0, NULL);
1014: END IF;
1015:
1016: RAISE;
1017: END hazard_class_id;
1038: IF (x_results IS NULL) THEN
1039: x_results := po_validation_results_type.new_instance();
1040: END IF;
1041:
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1039: x_results := po_validation_results_type.new_instance();
1040: END IF;
1041:
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1040: END IF;
1041:
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1041:
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1049: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1042: IF po_log.d_proc THEN
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1049: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1050: END IF;
1043: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1049: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1050: END IF;
1051:
1044: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1049: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1050: END IF;
1051:
1052: x_result_type := po_validations.c_result_type_success;
1045: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1046: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1048: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1049: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1050: END IF;
1051:
1052: x_result_type := po_validations.c_result_type_success;
1053:
1154: IF (SQL%ROWCOUNT > 0) THEN
1155: x_result_type := po_validations.c_result_type_failure;
1156: END IF;
1157:
1158: IF po_log.d_proc THEN
1159: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1160: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1161: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1162: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1156: END IF;
1157:
1158: IF po_log.d_proc THEN
1159: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1160: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1161: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1162: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1163: END IF;
1164: EXCEPTION
1157:
1158: IF po_log.d_proc THEN
1159: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1160: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1161: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1162: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1163: END IF;
1164: EXCEPTION
1165: WHEN OTHERS THEN
1158: IF po_log.d_proc THEN
1159: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1160: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1161: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1162: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1163: END IF;
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: IF po_log.d_exc THEN
1162: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1163: END IF;
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: IF po_log.d_exc THEN
1167: po_log.exc(d_mod, 0, NULL);
1168: END IF;
1169:
1170: RAISE;
1163: END IF;
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: IF po_log.d_exc THEN
1167: po_log.exc(d_mod, 0, NULL);
1168: END IF;
1169:
1170: RAISE;
1171: END item_id;
1190: IF x_result_set_id IS NULL THEN
1191: x_result_set_id := po_validations.next_result_set_id();
1192: END IF;
1193:
1194: IF po_log.d_proc THEN
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1191: x_result_set_id := po_validations.next_result_set_id();
1192: END IF;
1193:
1194: IF po_log.d_proc THEN
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1192: END IF;
1193:
1194: IF po_log.d_proc THEN
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1193:
1194: IF po_log.d_proc THEN
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1194: IF po_log.d_proc THEN
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1195: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1203:
1196: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1203:
1204: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1197: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1198: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1199: po_log.proc_begin(d_mod, 'p_create_or_update_item', p_create_or_update_item);
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1203:
1204: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1205: x_result_type := po_validations.c_result_type_success;
1249: IF (SQL%ROWCOUNT > 0) THEN
1250: x_result_type := po_validations.c_result_type_failure;
1251: END IF;
1252:
1253: IF po_log.d_proc THEN
1254: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1255: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1256: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1257: END IF;
1251: END IF;
1252:
1253: IF po_log.d_proc THEN
1254: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1255: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1256: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1257: END IF;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1252:
1253: IF po_log.d_proc THEN
1254: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1255: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1256: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1257: END IF;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: IF po_log.d_exc THEN
1256: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1257: END IF;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: IF po_log.d_exc THEN
1261: po_log.exc(d_mod, 0, NULL);
1262: END IF;
1263:
1264: RAISE;
1257: END IF;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: IF po_log.d_exc THEN
1261: po_log.exc(d_mod, 0, NULL);
1262: END IF;
1263:
1264: RAISE;
1265: END item_description;
1288: IF (x_results IS NULL) THEN
1289: x_results := po_validation_results_type.new_instance();
1290: END IF;
1291:
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1289: x_results := po_validation_results_type.new_instance();
1290: END IF;
1291:
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1290: END IF;
1291:
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1291:
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1292: IF po_log.d_proc THEN
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1300: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1293: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1300: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1301: END IF;
1294: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1300: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1301: END IF;
1302:
1295: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1300: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1301: END IF;
1302:
1303: x_result_type := po_validations.c_result_type_success;
1296: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1297: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1298: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1299: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1300: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1301: END IF;
1302:
1303: x_result_type := po_validations.c_result_type_success;
1304:
1485: IF (SQL%ROWCOUNT > 0) THEN
1486: x_result_type := po_validations.c_result_type_failure;
1487: END IF;
1488:
1489: IF po_log.d_proc THEN
1490: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1491: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1492: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1493: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1487: END IF;
1488:
1489: IF po_log.d_proc THEN
1490: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1491: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1492: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1493: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1494: END IF;
1495: EXCEPTION
1488:
1489: IF po_log.d_proc THEN
1490: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1491: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1492: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1493: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1494: END IF;
1495: EXCEPTION
1496: WHEN OTHERS THEN
1489: IF po_log.d_proc THEN
1490: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1491: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1492: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1493: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1494: END IF;
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: IF po_log.d_exc THEN
1493: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1494: END IF;
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: IF po_log.d_exc THEN
1498: po_log.exc(d_mod, 0, NULL);
1499: END IF;
1500:
1501: RAISE;
1494: END IF;
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: IF po_log.d_exc THEN
1498: po_log.exc(d_mod, 0, NULL);
1499: END IF;
1500:
1501: RAISE;
1502: END unit_meas_lookup_code;
1519: IF x_result_set_id IS NULL THEN
1520: x_result_set_id := po_validations.next_result_set_id();
1521: END IF;
1522:
1523: IF po_log.d_proc THEN
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1520: x_result_set_id := po_validations.next_result_set_id();
1521: END IF;
1522:
1523: IF po_log.d_proc THEN
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1521: END IF;
1522:
1523: IF po_log.d_proc THEN
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1529: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1522:
1523: IF po_log.d_proc THEN
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1529: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1530: END IF;
1523: IF po_log.d_proc THEN
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1529: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1530: END IF;
1531:
1524: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1529: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1530: END IF;
1531:
1532: x_result_type := po_validations.c_result_type_success;
1525: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1526: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
1527: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1528: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1529: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1530: END IF;
1531:
1532: x_result_type := po_validations.c_result_type_success;
1533:
1591: IF (SQL%ROWCOUNT > 0) THEN
1592: x_result_type := po_validations.c_result_type_failure;
1593: END IF;
1594:
1595: IF po_log.d_proc THEN
1596: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1597: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1598: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1599: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1593: END IF;
1594:
1595: IF po_log.d_proc THEN
1596: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1597: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1598: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1599: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601: EXCEPTION
1594:
1595: IF po_log.d_proc THEN
1596: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1597: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1598: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1599: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601: EXCEPTION
1602: WHEN OTHERS THEN
1595: IF po_log.d_proc THEN
1596: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1597: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1598: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1599: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: IF po_log.d_exc THEN
1599: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: IF po_log.d_exc THEN
1604: po_log.exc(d_mod, 0, NULL);
1605: END IF;
1606:
1607: RAISE;
1600: END IF;
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: IF po_log.d_exc THEN
1604: po_log.exc(d_mod, 0, NULL);
1605: END IF;
1606:
1607: RAISE;
1608: END item_revision;
1634: IF (x_results IS NULL) THEN
1635: x_results := po_validation_results_type.new_instance();
1636: END IF;
1637:
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1635: x_results := po_validation_results_type.new_instance();
1636: END IF;
1637:
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1636: END IF;
1637:
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1637:
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1638: IF po_log.d_proc THEN
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1639: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1647: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1640: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1647: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1648: END IF;
1641: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1647: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1648: END IF;
1649:
1642: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1647: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1648: END IF;
1649:
1650: x_result_type := po_validations.c_result_type_success;
1643: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1644: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
1645: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1646: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1647: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1648: END IF;
1649:
1650: x_result_type := po_validations.c_result_type_success;
1651:
1789: x_result_type := po_validations.c_result_type_failure;
1790: END IF;
1791: END IF;
1792:
1793: IF po_log.d_proc THEN
1794: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1795: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1796: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1797: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1791: END IF;
1792:
1793: IF po_log.d_proc THEN
1794: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1795: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1796: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1797: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1798: END IF;
1799: EXCEPTION
1792:
1793: IF po_log.d_proc THEN
1794: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1795: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1796: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1797: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1798: END IF;
1799: EXCEPTION
1800: WHEN OTHERS THEN
1793: IF po_log.d_proc THEN
1794: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1795: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1796: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1797: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1798: END IF;
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF po_log.d_exc THEN
1797: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1798: END IF;
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF po_log.d_exc THEN
1802: po_log.exc(d_mod, 0, NULL);
1803: END IF;
1804:
1805: RAISE;
1798: END IF;
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF po_log.d_exc THEN
1802: po_log.exc(d_mod, 0, NULL);
1803: END IF;
1804:
1805: RAISE;
1806: END category_id;
1825: IF (x_results IS NULL) THEN
1826: x_results := po_validation_results_type.new_instance();
1827: END IF;
1828:
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1831: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
1832: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1833: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1826: x_results := po_validation_results_type.new_instance();
1827: END IF;
1828:
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1831: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
1832: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1833: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1834: END IF;
1827: END IF;
1828:
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1831: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
1832: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1833: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1834: END IF;
1835:
1828:
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1831: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
1832: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1833: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1834: END IF;
1835:
1836: x_result_type := po_validations.c_result_type_success;
1829: IF po_log.d_proc THEN
1830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1831: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
1832: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1833: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1834: END IF;
1835:
1836: x_result_type := po_validations.c_result_type_success;
1837: -- validate ip_category_id is not null
1883: IF (SQL%ROWCOUNT > 0) THEN
1884: x_result_type := po_validations.c_result_type_failure;
1885: END IF;
1886:
1887: IF po_log.d_proc THEN
1888: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1889: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1890: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1885: END IF;
1886:
1887: IF po_log.d_proc THEN
1888: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1889: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1890: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1892: END IF;
1893: EXCEPTION
1886:
1887: IF po_log.d_proc THEN
1888: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1889: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1890: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1892: END IF;
1893: EXCEPTION
1894: WHEN OTHERS THEN
1887: IF po_log.d_proc THEN
1888: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1889: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1890: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1892: END IF;
1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: IF po_log.d_exc THEN
1891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1892: END IF;
1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: IF po_log.d_exc THEN
1896: po_log.exc(d_mod, 0, NULL);
1897: END IF;
1898:
1899: RAISE;
1892: END IF;
1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: IF po_log.d_exc THEN
1896: po_log.exc(d_mod, 0, NULL);
1897: END IF;
1898:
1899: RAISE;
1900: END ip_category_id;
1925: IF (x_results IS NULL) THEN
1926: x_results := po_validation_results_type.new_instance();
1927: END IF;
1928:
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1926: x_results := po_validation_results_type.new_instance();
1927: END IF;
1928:
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1927: END IF;
1928:
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1935: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1928:
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1935: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1936: END IF;
1929: IF po_log.d_proc THEN
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1935: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1936: END IF;
1937:
1930: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1935: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1936: END IF;
1937:
1938: x_result_type := po_validations.c_result_type_success;
1931: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
1934: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1935: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1936: END IF;
1937:
1938: x_result_type := po_validations.c_result_type_success;
1939: -- If order_type_lookup_code is not 'FIXED PRICE', unit_price cannot be
2071: x_result_type := po_validations.c_result_type_failure;
2072: END IF;
2073: END LOOP;
2074:
2075: IF po_log.d_proc THEN
2076: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2077: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2078: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2079: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2073: END LOOP;
2074:
2075: IF po_log.d_proc THEN
2076: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2077: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2078: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2079: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2080: END IF;
2081: EXCEPTION
2074:
2075: IF po_log.d_proc THEN
2076: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2077: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2078: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2079: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2075: IF po_log.d_proc THEN
2076: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2077: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2078: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2079: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: IF po_log.d_exc THEN
2079: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: IF po_log.d_exc THEN
2084: po_log.exc(d_mod, 0, NULL);
2085: END IF;
2086:
2087: RAISE;
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: IF po_log.d_exc THEN
2084: po_log.exc(d_mod, 0, NULL);
2085: END IF;
2086:
2087: RAISE;
2088: END unit_price;
2103: IF (x_results IS NULL) THEN
2104: x_results := po_validation_results_type.new_instance();
2105: END IF;
2106:
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2109: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2110: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2111: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2104: x_results := po_validation_results_type.new_instance();
2105: END IF;
2106:
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2109: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2110: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2111: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2112: END IF;
2105: END IF;
2106:
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2109: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2110: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2111: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2112: END IF;
2113:
2106:
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2109: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2110: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2111: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2112: END IF;
2113:
2114: x_result_type := po_validations.c_result_type_success;
2107: IF po_log.d_proc THEN
2108: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2109: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2110: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2111: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2112: END IF;
2113:
2114: x_result_type := po_validations.c_result_type_success;
2115:
2143: x_result_type := po_validations.c_result_type_failure;
2144: END IF;
2145: END LOOP;
2146:
2147: IF po_log.d_proc THEN
2148: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2149: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2150: END IF;
2151: EXCEPTION
2144: END IF;
2145: END LOOP;
2146:
2147: IF po_log.d_proc THEN
2148: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2149: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2150: END IF;
2151: EXCEPTION
2152: WHEN OTHERS THEN
2145: END LOOP;
2146:
2147: IF po_log.d_proc THEN
2148: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2149: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2150: END IF;
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: IF po_log.d_exc THEN
2149: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2150: END IF;
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: IF po_log.d_exc THEN
2154: po_log.exc(d_mod, 0, NULL);
2155: END IF;
2156:
2157: RAISE;
2150: END IF;
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: IF po_log.d_exc THEN
2154: po_log.exc(d_mod, 0, NULL);
2155: END IF;
2156:
2157: RAISE;
2158: END quantity;
2172: IF (x_results IS NULL) THEN
2173: x_results := po_validation_results_type.new_instance();
2174: END IF;
2175:
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2178: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2179: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2180: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2173: x_results := po_validation_results_type.new_instance();
2174: END IF;
2175:
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2178: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2179: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2180: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2181: END IF;
2174: END IF;
2175:
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2178: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2179: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2180: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2181: END IF;
2182:
2175:
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2178: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2179: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2180: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2181: END IF;
2182:
2183: x_result_type := po_validations.c_result_type_success;
2176: IF po_log.d_proc THEN
2177: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2178: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2179: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2180: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2181: END IF;
2182:
2183: x_result_type := po_validations.c_result_type_success;
2184:
2196: x_result_type := po_validations.c_result_type_failure;
2197: END IF;
2198: END LOOP;
2199:
2200: IF po_log.d_proc THEN
2201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2202: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2203: END IF;
2204: EXCEPTION
2197: END IF;
2198: END LOOP;
2199:
2200: IF po_log.d_proc THEN
2201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2202: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2198: END LOOP;
2199:
2200: IF po_log.d_proc THEN
2201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2202: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: IF po_log.d_exc THEN
2202: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: IF po_log.d_exc THEN
2207: po_log.exc(d_mod, 0, NULL);
2208: END IF;
2209:
2210: RAISE;
2203: END IF;
2204: EXCEPTION
2205: WHEN OTHERS THEN
2206: IF po_log.d_exc THEN
2207: po_log.exc(d_mod, 0, NULL);
2208: END IF;
2209:
2210: RAISE;
2211: END amount;
2225: IF (x_results IS NULL) THEN
2226: x_results := po_validation_results_type.new_instance();
2227: END IF;
2228:
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2231: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
2232: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2233: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2226: x_results := po_validation_results_type.new_instance();
2227: END IF;
2228:
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2231: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
2232: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2233: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2234: END IF;
2227: END IF;
2228:
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2231: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
2232: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2233: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2234: END IF;
2235:
2228:
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2231: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
2232: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2233: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2234: END IF;
2235:
2236: x_result_type := po_validations.c_result_type_success;
2229: IF po_log.d_proc THEN
2230: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2231: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
2232: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2233: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2234: END IF;
2235:
2236: x_result_type := po_validations.c_result_type_success;
2237:
2247: x_result_type := po_validations.c_result_type_failure;
2248: END IF;
2249: END LOOP;
2250:
2251: IF po_log.d_proc THEN
2252: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2253: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2254: END IF;
2255: EXCEPTION
2248: END IF;
2249: END LOOP;
2250:
2251: IF po_log.d_proc THEN
2252: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2253: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2254: END IF;
2255: EXCEPTION
2256: WHEN OTHERS THEN
2249: END LOOP;
2250:
2251: IF po_log.d_proc THEN
2252: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2253: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2254: END IF;
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF po_log.d_exc THEN
2253: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2254: END IF;
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF po_log.d_exc THEN
2258: po_log.exc(d_mod, 0, NULL);
2259: END IF;
2260:
2261: RAISE;
2254: END IF;
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF po_log.d_exc THEN
2258: po_log.exc(d_mod, 0, NULL);
2259: END IF;
2260:
2261: RAISE;
2262: END rate_type;
2284: IF x_result_set_id IS NULL THEN
2285: x_result_set_id := po_validations.next_result_set_id();
2286: END IF;
2287:
2288: IF po_log.d_proc THEN
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2285: x_result_set_id := po_validations.next_result_set_id();
2286: END IF;
2287:
2288: IF po_log.d_proc THEN
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2286: END IF;
2287:
2288: IF po_log.d_proc THEN
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2294: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2287:
2288: IF po_log.d_proc THEN
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2294: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2295: END IF;
2288: IF po_log.d_proc THEN
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2294: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2295: END IF;
2296:
2289: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2294: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2295: END IF;
2296:
2297: x_result_type := po_validations.c_result_type_success;
2290: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2291: po_log.proc_begin(d_mod, 'p_line_num_tbl', p_line_num_tbl);
2292: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2293: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2294: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2295: END IF;
2296:
2297: x_result_type := po_validations.c_result_type_success;
2298:
2372: IF (SQL%ROWCOUNT > 0) THEN
2373: x_result_type := po_validations.c_result_type_failure;
2374: END IF;
2375:
2376: IF po_log.d_proc THEN
2377: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2378: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2379: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2380: END IF;
2374: END IF;
2375:
2376: IF po_log.d_proc THEN
2377: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2378: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2379: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2380: END IF;
2381: EXCEPTION
2382: WHEN OTHERS THEN
2375:
2376: IF po_log.d_proc THEN
2377: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2378: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2379: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2380: END IF;
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: IF po_log.d_exc THEN
2379: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2380: END IF;
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: IF po_log.d_exc THEN
2384: po_log.exc(d_mod, 0, NULL);
2385: END IF;
2386:
2387: RAISE;
2380: END IF;
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: IF po_log.d_exc THEN
2384: po_log.exc(d_mod, 0, NULL);
2385: END IF;
2386:
2387: RAISE;
2388: END line_num;
2402: IF x_result_set_id IS NULL THEN
2403: x_result_set_id := po_validations.next_result_set_id();
2404: END IF;
2405:
2406: IF po_log.d_proc THEN
2407: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2408: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
2409: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2410: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2403: x_result_set_id := po_validations.next_result_set_id();
2404: END IF;
2405:
2406: IF po_log.d_proc THEN
2407: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2408: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
2409: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2410: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2411: END IF;
2404: END IF;
2405:
2406: IF po_log.d_proc THEN
2407: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2408: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
2409: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2410: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2411: END IF;
2412:
2405:
2406: IF po_log.d_proc THEN
2407: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2408: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
2409: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2410: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2411: END IF;
2412:
2413: x_result_type := po_validations.c_result_type_success;
2406: IF po_log.d_proc THEN
2407: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2408: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
2409: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
2410: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2411: END IF;
2412:
2413: x_result_type := po_validations.c_result_type_success;
2414: FORALL i IN 1 .. p_id_tbl.COUNT
2449: IF (SQL%ROWCOUNT > 0) THEN
2450: x_result_type := po_validations.c_result_type_failure;
2451: END IF;
2452:
2453: IF po_log.d_proc THEN
2454: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2455: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2456: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2457: END IF;
2451: END IF;
2452:
2453: IF po_log.d_proc THEN
2454: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2455: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2456: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2457: END IF;
2458: EXCEPTION
2459: WHEN OTHERS THEN
2452:
2453: IF po_log.d_proc THEN
2454: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2455: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2456: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2457: END IF;
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: IF po_log.d_exc THEN
2456: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2457: END IF;
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: IF po_log.d_exc THEN
2461: po_log.exc(d_mod, 0, NULL);
2462: END IF;
2463:
2464: RAISE;
2457: END IF;
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: IF po_log.d_exc THEN
2461: po_log.exc(d_mod, 0, NULL);
2462: END IF;
2463:
2464: RAISE;
2465: END po_line_id;
2478: IF x_result_set_id IS NULL THEN
2479: x_result_set_id := po_validations.next_result_set_id();
2480: END IF;
2481:
2482: IF po_log.d_proc THEN
2483: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2484: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2485: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2486: END IF;
2479: x_result_set_id := po_validations.next_result_set_id();
2480: END IF;
2481:
2482: IF po_log.d_proc THEN
2483: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2484: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2485: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2486: END IF;
2487:
2480: END IF;
2481:
2482: IF po_log.d_proc THEN
2483: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2484: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2485: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2486: END IF;
2487:
2488: x_result_type := po_validations.c_result_type_success;
2481:
2482: IF po_log.d_proc THEN
2483: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2484: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2485: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2486: END IF;
2487:
2488: x_result_type := po_validations.c_result_type_success;
2489: FORALL i IN 1 .. p_id_tbl.COUNT
2522: IF (SQL%ROWCOUNT > 0) THEN
2523: x_result_type := po_validations.c_result_type_failure;
2524: END IF;
2525:
2526: IF po_log.d_proc THEN
2527: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2528: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2529: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2530: END IF;
2524: END IF;
2525:
2526: IF po_log.d_proc THEN
2527: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2528: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2529: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2530: END IF;
2531: EXCEPTION
2532: WHEN OTHERS THEN
2525:
2526: IF po_log.d_proc THEN
2527: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2528: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2529: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2530: END IF;
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: IF po_log.d_exc THEN
2529: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2530: END IF;
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: IF po_log.d_exc THEN
2534: po_log.exc(d_mod, 0, NULL);
2535: END IF;
2536:
2537: RAISE;
2530: END IF;
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: IF po_log.d_exc THEN
2534: po_log.exc(d_mod, 0, NULL);
2535: END IF;
2536:
2537: RAISE;
2538: END line_type_id;
2553: IF x_result_set_id IS NULL THEN
2554: x_result_set_id := po_validations.next_result_set_id();
2555: END IF;
2556:
2557: IF po_log.d_proc THEN
2558: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2559: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
2560: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2561: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2554: x_result_set_id := po_validations.next_result_set_id();
2555: END IF;
2556:
2557: IF po_log.d_proc THEN
2558: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2559: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
2560: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2561: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2562: END IF;
2555: END IF;
2556:
2557: IF po_log.d_proc THEN
2558: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2559: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
2560: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2561: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2562: END IF;
2563:
2556:
2557: IF po_log.d_proc THEN
2558: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2559: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
2560: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2561: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2562: END IF;
2563:
2564: x_result_type := po_validations.c_result_type_success;
2557: IF po_log.d_proc THEN
2558: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2559: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
2560: po_log.proc_begin(d_mod, 'p_line_type_id_tbl', p_line_type_id_tbl);
2561: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2562: END IF;
2563:
2564: x_result_type := po_validations.c_result_type_success;
2565:
2643: IF (SQL%ROWCOUNT > 0) THEN
2644: x_result_type := po_validations.c_result_type_failure;
2645: END IF;
2646:
2647: IF po_log.d_proc THEN
2648: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2649: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2650: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2651: END IF;
2645: END IF;
2646:
2647: IF po_log.d_proc THEN
2648: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2649: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2650: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2651: END IF;
2652: EXCEPTION
2653: WHEN OTHERS THEN
2646:
2647: IF po_log.d_proc THEN
2648: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2649: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2650: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2651: END IF;
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: IF po_log.d_exc THEN
2650: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2651: END IF;
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: IF po_log.d_exc THEN
2655: po_log.exc(d_mod, 0, NULL);
2656: END IF;
2657:
2658: RAISE;
2651: END IF;
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: IF po_log.d_exc THEN
2655: po_log.exc(d_mod, 0, NULL);
2656: END IF;
2657:
2658: RAISE;
2659:
2673: IF x_result_set_id IS NULL THEN
2674: x_result_set_id := po_validations.next_result_set_id();
2675: END IF;
2676:
2677: IF po_log.d_proc THEN
2678: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2679: po_log.proc_begin(d_mod, 'p_price_type_lookup_code_tbl', p_price_type_lookup_code_tbl);
2680: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2681: END IF;
2674: x_result_set_id := po_validations.next_result_set_id();
2675: END IF;
2676:
2677: IF po_log.d_proc THEN
2678: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2679: po_log.proc_begin(d_mod, 'p_price_type_lookup_code_tbl', p_price_type_lookup_code_tbl);
2680: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2681: END IF;
2682:
2675: END IF;
2676:
2677: IF po_log.d_proc THEN
2678: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2679: po_log.proc_begin(d_mod, 'p_price_type_lookup_code_tbl', p_price_type_lookup_code_tbl);
2680: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2681: END IF;
2682:
2683: x_result_type := po_validations.c_result_type_success;
2676:
2677: IF po_log.d_proc THEN
2678: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2679: po_log.proc_begin(d_mod, 'p_price_type_lookup_code_tbl', p_price_type_lookup_code_tbl);
2680: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2681: END IF;
2682:
2683: x_result_type := po_validations.c_result_type_success;
2684: FORALL i IN 1 .. p_id_tbl.COUNT
2715: IF (SQL%ROWCOUNT > 0) THEN
2716: x_result_type := po_validations.c_result_type_failure;
2717: END IF;
2718:
2719: IF po_log.d_proc THEN
2720: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2721: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2722: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2723: END IF;
2717: END IF;
2718:
2719: IF po_log.d_proc THEN
2720: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2721: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2722: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2723: END IF;
2724: EXCEPTION
2725: WHEN OTHERS THEN
2718:
2719: IF po_log.d_proc THEN
2720: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2721: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2722: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2723: END IF;
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: IF po_log.d_exc THEN
2722: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2723: END IF;
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: IF po_log.d_exc THEN
2727: po_log.exc(d_mod, 0, NULL);
2728: END IF;
2729:
2730: RAISE;
2723: END IF;
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: IF po_log.d_exc THEN
2727: po_log.exc(d_mod, 0, NULL);
2728: END IF;
2729:
2730: RAISE;
2731: END price_type_lookup_code;
2748: IF (x_results IS NULL) THEN
2749: x_results := po_validation_results_type.new_instance();
2750: END IF;
2751:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2749: x_results := po_validation_results_type.new_instance();
2750: END IF;
2751:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2757: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2750: END IF;
2751:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2757: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2758: END IF;
2751:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2757: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2758: END IF;
2759:
2752: IF po_log.d_proc THEN
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2757: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2758: END IF;
2759:
2760: x_result_type := po_validations.c_result_type_success;
2753: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2754: po_log.proc_begin(d_mod, 'p_start_date_tbl', p_start_date_tbl);
2755: po_log.proc_begin(d_mod, 'p_expiration_date_tbl', p_expiration_date_tbl);
2756: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
2757: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2758: END IF;
2759:
2760: x_result_type := po_validations.c_result_type_success;
2761:
2801: END IF;
2802: END IF;
2803: END LOOP;
2804:
2805: IF po_log.d_proc THEN
2806: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2807: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2808: END IF;
2809: EXCEPTION
2802: END IF;
2803: END LOOP;
2804:
2805: IF po_log.d_proc THEN
2806: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2807: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2808: END IF;
2809: EXCEPTION
2810: WHEN OTHERS THEN
2803: END LOOP;
2804:
2805: IF po_log.d_proc THEN
2806: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2807: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2808: END IF;
2809: EXCEPTION
2810: WHEN OTHERS THEN
2811: IF po_log.d_exc THEN
2807: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2808: END IF;
2809: EXCEPTION
2810: WHEN OTHERS THEN
2811: IF po_log.d_exc THEN
2812: po_log.exc(d_mod, 0, NULL);
2813: END IF;
2814:
2815: RAISE;
2808: END IF;
2809: EXCEPTION
2810: WHEN OTHERS THEN
2811: IF po_log.d_exc THEN
2812: po_log.exc(d_mod, 0, NULL);
2813: END IF;
2814:
2815: RAISE;
2816: END start_date_standard;
2832: IF x_result_set_id IS NULL THEN
2833: x_result_set_id := po_validations.next_result_set_id();
2834: END IF;
2835:
2836: IF po_log.d_proc THEN
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2833: x_result_set_id := po_validations.next_result_set_id();
2834: END IF;
2835:
2836: IF po_log.d_proc THEN
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2841: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2834: END IF;
2835:
2836: IF po_log.d_proc THEN
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2841: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2842: END IF;
2835:
2836: IF po_log.d_proc THEN
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2841: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2842: END IF;
2843:
2836: IF po_log.d_proc THEN
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2841: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2842: END IF;
2843:
2844: x_result_type := po_validations.c_result_type_success;
2837: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2838: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
2839: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2840: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2841: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2842: END IF;
2843:
2844: x_result_type := po_validations.c_result_type_success;
2845: FORALL i IN 1 .. p_id_tbl.COUNT
2875: IF (SQL%ROWCOUNT > 0) THEN
2876: x_result_type := po_validations.c_result_type_failure;
2877: END IF;
2878:
2879: IF po_log.d_proc THEN
2880: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2881: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2882: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2883: END IF;
2877: END IF;
2878:
2879: IF po_log.d_proc THEN
2880: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2881: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2882: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2883: END IF;
2884: EXCEPTION
2885: WHEN OTHERS THEN
2878:
2879: IF po_log.d_proc THEN
2880: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2881: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2882: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2883: END IF;
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: IF po_log.d_exc THEN
2882: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2883: END IF;
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: IF po_log.d_exc THEN
2887: po_log.exc(d_mod, 0, NULL);
2888: END IF;
2889:
2890: RAISE;
2883: END IF;
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: IF po_log.d_exc THEN
2887: po_log.exc(d_mod, 0, NULL);
2888: END IF;
2889:
2890: RAISE;
2891: END item_id_standard;
2905: IF (x_results IS NULL) THEN
2906: x_results := po_validation_results_type.new_instance();
2907: END IF;
2908:
2909: IF po_log.d_proc THEN
2910: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2911: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2912: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2913: END IF;
2906: x_results := po_validation_results_type.new_instance();
2907: END IF;
2908:
2909: IF po_log.d_proc THEN
2910: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2911: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2912: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2913: END IF;
2914:
2907: END IF;
2908:
2909: IF po_log.d_proc THEN
2910: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2911: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2912: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2913: END IF;
2914:
2915: x_result_type := po_validations.c_result_type_success;
2908:
2909: IF po_log.d_proc THEN
2910: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2911: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
2912: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2913: END IF;
2914:
2915: x_result_type := po_validations.c_result_type_success;
2916:
2932: x_result_type := po_validations.c_result_type_failure;
2933: END IF;
2934: END LOOP;
2935:
2936: IF po_log.d_proc THEN
2937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2939: END IF;
2940: EXCEPTION
2933: END IF;
2934: END LOOP;
2935:
2936: IF po_log.d_proc THEN
2937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2939: END IF;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2934: END LOOP;
2935:
2936: IF po_log.d_proc THEN
2937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2939: END IF;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: IF po_log.d_exc THEN
2938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2939: END IF;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: IF po_log.d_exc THEN
2943: po_log.exc(d_mod, 0, NULL);
2944: END IF;
2945:
2946: RAISE;
2939: END IF;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: IF po_log.d_exc THEN
2943: po_log.exc(d_mod, 0, NULL);
2944: END IF;
2945:
2946: RAISE;
2947: END quantity_standard;
2963: IF (x_results IS NULL) THEN
2964: x_results := po_validation_results_type.new_instance();
2965: END IF;
2966:
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2969: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2970: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2971: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2964: x_results := po_validation_results_type.new_instance();
2965: END IF;
2966:
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2969: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2970: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2971: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2972: END IF;
2965: END IF;
2966:
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2969: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2970: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2971: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2972: END IF;
2973:
2966:
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2969: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2970: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2971: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2972: END IF;
2973:
2974: x_result_type := po_validations.c_result_type_success;
2967: IF po_log.d_proc THEN
2968: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2969: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
2970: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2971: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2972: END IF;
2973:
2974: x_result_type := po_validations.c_result_type_success;
2975:
2998:
2999: END IF;
3000: END LOOP;
3001:
3002: IF po_log.d_proc THEN
3003: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3004: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3005: END IF;
3006: EXCEPTION
2999: END IF;
3000: END LOOP;
3001:
3002: IF po_log.d_proc THEN
3003: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3004: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3005: END IF;
3006: EXCEPTION
3007: WHEN OTHERS THEN
3000: END LOOP;
3001:
3002: IF po_log.d_proc THEN
3003: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3004: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3005: END IF;
3006: EXCEPTION
3007: WHEN OTHERS THEN
3008: IF po_log.d_exc THEN
3004: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3005: END IF;
3006: EXCEPTION
3007: WHEN OTHERS THEN
3008: IF po_log.d_exc THEN
3009: po_log.exc(d_mod, 0, NULL);
3010: END IF;
3011:
3012: RAISE;
3005: END IF;
3006: EXCEPTION
3007: WHEN OTHERS THEN
3008: IF po_log.d_exc THEN
3009: po_log.exc(d_mod, 0, NULL);
3010: END IF;
3011:
3012: RAISE;
3013: END amount_standard;
3035: IF (x_results IS NULL) THEN
3036: x_results := po_validation_results_type.new_instance();
3037: END IF;
3038:
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3041: po_log.proc_begin(d_mod, 'p_price_break_lookup_code_tbl', p_price_break_lookup_code_tbl);
3042: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
3043: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3036: x_results := po_validation_results_type.new_instance();
3037: END IF;
3038:
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3041: po_log.proc_begin(d_mod, 'p_price_break_lookup_code_tbl', p_price_break_lookup_code_tbl);
3042: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
3043: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3044: END IF;
3037: END IF;
3038:
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3041: po_log.proc_begin(d_mod, 'p_price_break_lookup_code_tbl', p_price_break_lookup_code_tbl);
3042: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
3043: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3044: END IF;
3045:
3038:
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3041: po_log.proc_begin(d_mod, 'p_price_break_lookup_code_tbl', p_price_break_lookup_code_tbl);
3042: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
3043: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3044: END IF;
3045:
3046: -- If price break lookup code is provided, it has to be a valid lookup
3039: IF po_log.d_proc THEN
3040: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3041: po_log.proc_begin(d_mod, 'p_price_break_lookup_code_tbl', p_price_break_lookup_code_tbl);
3042: po_log.proc_begin(d_mod, 'p_global_agreement_flag_tbl', p_global_agreement_flag_tbl);
3043: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3044: END IF;
3045:
3046: -- If price break lookup code is provided, it has to be a valid lookup
3047: -- code
3104: END IF;
3105: END IF;
3106: END LOOP;
3107:
3108: IF po_log.d_proc THEN
3109: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3110: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3111: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3112: END IF;
3106: END LOOP;
3107:
3108: IF po_log.d_proc THEN
3109: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3110: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3111: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3112: END IF;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3107:
3108: IF po_log.d_proc THEN
3109: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3110: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3111: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3112: END IF;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3115: IF po_log.d_exc THEN
3111: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3112: END IF;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3115: IF po_log.d_exc THEN
3116: po_log.exc(d_mod, 0, NULL);
3117: END IF;
3118:
3119: RAISE;
3112: END IF;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3115: IF po_log.d_exc THEN
3116: po_log.exc(d_mod, 0, NULL);
3117: END IF;
3118:
3119: RAISE;
3120: END price_break_lookup_code;
3138: IF (x_results IS NULL) THEN
3139: x_results := po_validation_results_type.new_instance();
3140: END IF;
3141:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3139: x_results := po_validation_results_type.new_instance();
3140: END IF;
3141:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3147: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3140: END IF;
3141:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3147: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3148: END IF;
3141:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3147: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3148: END IF;
3149:
3142: IF po_log.d_proc THEN
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3147: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3148: END IF;
3149:
3150: x_result_type := po_validations.c_result_type_success;
3143: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3144: po_log.proc_begin(d_mod, 'p_not_to_exceed_price_tbl', p_not_to_exceed_price_tbl);
3145: po_log.proc_begin(d_mod, 'p_allow_price_override_tbl', p_allow_price_override_tbl);
3146: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3147: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3148: END IF;
3149:
3150: x_result_type := po_validations.c_result_type_success;
3151:
3175: x_result_type := po_validations.c_result_type_failure;
3176: END IF;
3177: END LOOP;
3178:
3179: IF po_log.d_proc THEN
3180: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3181: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3182: END IF;
3183: EXCEPTION
3176: END IF;
3177: END LOOP;
3178:
3179: IF po_log.d_proc THEN
3180: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3181: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3182: END IF;
3183: EXCEPTION
3184: WHEN OTHERS THEN
3177: END LOOP;
3178:
3179: IF po_log.d_proc THEN
3180: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3181: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3182: END IF;
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: IF po_log.d_exc THEN
3181: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3182: END IF;
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: IF po_log.d_exc THEN
3186: po_log.exc(d_mod, 0, NULL);
3187: END IF;
3188:
3189: RAISE;
3182: END IF;
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: IF po_log.d_exc THEN
3186: po_log.exc(d_mod, 0, NULL);
3187: END IF;
3188:
3189: RAISE;
3190: END not_to_exceed_price;
3208: IF (x_results IS NULL) THEN
3209: x_results := po_validation_results_type.new_instance();
3210: END IF;
3211:
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3214: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
3215: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3216: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3209: x_results := po_validation_results_type.new_instance();
3210: END IF;
3211:
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3214: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
3215: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3216: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3217: END IF;
3210: END IF;
3211:
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3214: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
3215: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3216: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3217: END IF;
3218:
3211:
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3214: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
3215: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3216: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3217: END IF;
3218:
3219: x_result_type := po_validations.c_result_type_success;
3212: IF po_log.d_proc THEN
3213: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3214: po_log.proc_begin(d_mod, 'p_ip_category_id_tbl', p_ip_category_id_tbl);
3215: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3216: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3217: END IF;
3218:
3219: x_result_type := po_validations.c_result_type_success;
3220:
3266: IF (SQL%ROWCOUNT > 0) THEN
3267: x_result_type := po_validations.c_result_type_failure;
3268: END IF;
3269:
3270: IF po_log.d_proc THEN
3271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3274: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3268: END IF;
3269:
3270: IF po_log.d_proc THEN
3271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3274: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3275: END IF;
3276: EXCEPTION
3269:
3270: IF po_log.d_proc THEN
3271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3274: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3275: END IF;
3276: EXCEPTION
3277: WHEN OTHERS THEN
3270: IF po_log.d_proc THEN
3271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3274: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3275: END IF;
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: IF po_log.d_exc THEN
3274: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3275: END IF;
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: IF po_log.d_exc THEN
3279: po_log.exc(d_mod, 0, NULL);
3280: END IF;
3281:
3282: RAISE;
3275: END IF;
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: IF po_log.d_exc THEN
3279: po_log.exc(d_mod, 0, NULL);
3280: END IF;
3281:
3282: RAISE;
3283: END ip_category_id_update;
3299: IF x_result_set_id IS NULL THEN
3300: x_result_set_id := po_validations.next_result_set_id();
3301: END IF;
3302:
3303: IF po_log.d_proc THEN
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3300: x_result_set_id := po_validations.next_result_set_id();
3301: END IF;
3302:
3303: IF po_log.d_proc THEN
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3301: END IF;
3302:
3303: IF po_log.d_proc THEN
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3309: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3302:
3303: IF po_log.d_proc THEN
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3309: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3310: END IF;
3303: IF po_log.d_proc THEN
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3309: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3310: END IF;
3311:
3304: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3309: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3310: END IF;
3311:
3312: x_result_type := po_validations.c_result_type_success;
3305: po_log.proc_begin(d_mod, 'p_unit_meas_lookup_code_tbl', p_unit_meas_lookup_code_tbl);
3306: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3307: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3308: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3309: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3310: END IF;
3311:
3312: x_result_type := po_validations.c_result_type_success;
3313: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3373: IF (SQL%ROWCOUNT > 0) THEN
3374: x_result_type := po_validations.c_result_type_failure;
3375: END IF;
3376:
3377: IF po_log.d_proc THEN
3378: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3379: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3380: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3381: END IF;
3375: END IF;
3376:
3377: IF po_log.d_proc THEN
3378: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3379: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3380: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3381: END IF;
3382: EXCEPTION
3383: WHEN OTHERS THEN
3376:
3377: IF po_log.d_proc THEN
3378: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3379: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3380: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3381: END IF;
3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: IF po_log.d_exc THEN
3380: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3381: END IF;
3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: IF po_log.d_exc THEN
3385: po_log.exc(d_mod, 0, NULL);
3386: END IF;
3387:
3388: RAISE;
3381: END IF;
3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: IF po_log.d_exc THEN
3385: po_log.exc(d_mod, 0, NULL);
3386: END IF;
3387:
3388: RAISE;
3389: END uom_update;
3408: IF x_result_set_id IS NULL THEN
3409: x_result_set_id := po_validations.next_result_set_id();
3410: END IF;
3411:
3412: IF po_log.d_proc THEN
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3409: x_result_set_id := po_validations.next_result_set_id();
3410: END IF;
3411:
3412: IF po_log.d_proc THEN
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3410: END IF;
3411:
3412: IF po_log.d_proc THEN
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3411:
3412: IF po_log.d_proc THEN
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3419: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3412: IF po_log.d_proc THEN
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3419: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3420: END IF;
3413: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3419: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3420: END IF;
3421:
3414: po_log.proc_begin(d_mod, 'p_item_description_tbl', p_item_description_tbl);
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3419: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3420: END IF;
3421:
3422: x_result_type := po_validations.c_result_type_success;
3415: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3416: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3417: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
3418: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3419: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3420: END IF;
3421:
3422: x_result_type := po_validations.c_result_type_success;
3423: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3494: IF (SQL%ROWCOUNT > 0) THEN
3495: x_result_type := po_validations.c_result_type_failure;
3496: END IF;
3497:
3498: IF po_log.d_proc THEN
3499: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3500: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3501: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3502: END IF;
3496: END IF;
3497:
3498: IF po_log.d_proc THEN
3499: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3500: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3501: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3502: END IF;
3503: EXCEPTION
3504: WHEN OTHERS THEN
3497:
3498: IF po_log.d_proc THEN
3499: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3500: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3501: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3502: END IF;
3503: EXCEPTION
3504: WHEN OTHERS THEN
3505: IF po_log.d_exc THEN
3501: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3502: END IF;
3503: EXCEPTION
3504: WHEN OTHERS THEN
3505: IF po_log.d_exc THEN
3506: po_log.exc(d_mod, 0, NULL);
3507: END IF;
3508:
3509: RAISE;
3502: END IF;
3503: EXCEPTION
3504: WHEN OTHERS THEN
3505: IF po_log.d_exc THEN
3506: po_log.exc(d_mod, 0, NULL);
3507: END IF;
3508:
3509: RAISE;
3510: END item_desc_update;
3520: IS
3521: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_preparer;
3522: BEGIN
3523:
3524: IF po_log.d_proc THEN
3525: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3526: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3527: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3528: END IF;
3521: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_preparer;
3522: BEGIN
3523:
3524: IF po_log.d_proc THEN
3525: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3526: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3527: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3528: END IF;
3529:
3522: BEGIN
3523:
3524: IF po_log.d_proc THEN
3525: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3526: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3527: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3528: END IF;
3529:
3530: x_result_type := po_validations.c_result_type_success;
3523:
3524: IF po_log.d_proc THEN
3525: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3526: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3527: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3528: END IF;
3529:
3530: x_result_type := po_validations.c_result_type_success;
3531: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3543: x_result_type := po_validations.c_result_type_failure;
3544: END IF;
3545: END LOOP;
3546:
3547: IF po_log.d_proc THEN
3548: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3549: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3550: END IF;
3551:
3544: END IF;
3545: END LOOP;
3546:
3547: IF po_log.d_proc THEN
3548: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3549: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3550: END IF;
3551:
3552: EXCEPTION
3545: END LOOP;
3546:
3547: IF po_log.d_proc THEN
3548: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3549: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3550: END IF;
3551:
3552: EXCEPTION
3553: WHEN OTHERS THEN
3550: END IF;
3551:
3552: EXCEPTION
3553: WHEN OTHERS THEN
3554: IF po_log.d_exc THEN
3555: po_log.exc(d_mod, 0, NULL);
3556: END IF;
3557:
3558: RAISE;
3551:
3552: EXCEPTION
3553: WHEN OTHERS THEN
3554: IF po_log.d_exc THEN
3555: po_log.exc(d_mod, 0, NULL);
3556: END IF;
3557:
3558: RAISE;
3559: END negotiated_by_preparer;
3569: IS
3570: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_prep_update;
3571: BEGIN
3572:
3573: IF po_log.d_proc THEN
3574: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3575: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3576: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3577: END IF;
3570: d_mod CONSTANT VARCHAR2(100) := d_negotiated_by_prep_update;
3571: BEGIN
3572:
3573: IF po_log.d_proc THEN
3574: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3575: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3576: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3577: END IF;
3578:
3571: BEGIN
3572:
3573: IF po_log.d_proc THEN
3574: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3575: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3576: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3577: END IF;
3578:
3579: x_result_type := po_validations.c_result_type_success;
3572:
3573: IF po_log.d_proc THEN
3574: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3575: po_log.proc_begin(d_mod, 'p_negotiated_by_preparer_tbl', p_negotiated_by_preparer_tbl);
3576: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3577: END IF;
3578:
3579: x_result_type := po_validations.c_result_type_success;
3580: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3602: x_result_type := po_validations.c_result_type_failure;
3603: END IF;
3604: END LOOP;
3605:
3606: IF po_log.d_proc THEN
3607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3608: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3609: END IF;
3610:
3603: END IF;
3604: END LOOP;
3605:
3606: IF po_log.d_proc THEN
3607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3608: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3609: END IF;
3610:
3611: EXCEPTION
3604: END LOOP;
3605:
3606: IF po_log.d_proc THEN
3607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3608: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3609: END IF;
3610:
3611: EXCEPTION
3612: WHEN OTHERS THEN
3609: END IF;
3610:
3611: EXCEPTION
3612: WHEN OTHERS THEN
3613: IF po_log.d_exc THEN
3614: po_log.exc(d_mod, 0, NULL);
3615: END IF;
3616:
3617: RAISE;
3610:
3611: EXCEPTION
3612: WHEN OTHERS THEN
3613: IF po_log.d_exc THEN
3614: po_log.exc(d_mod, 0, NULL);
3615: END IF;
3616:
3617: RAISE;
3618: END negotiated_by_prep_update;
3638: IF x_result_set_id IS NULL THEN
3639: x_result_set_id := po_validations.next_result_set_id();
3640: END IF;
3641:
3642: IF po_log.d_proc THEN
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3639: x_result_set_id := po_validations.next_result_set_id();
3640: END IF;
3641:
3642: IF po_log.d_proc THEN
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3640: END IF;
3641:
3642: IF po_log.d_proc THEN
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3641:
3642: IF po_log.d_proc THEN
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3642: IF po_log.d_proc THEN
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3643: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3651: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3644: po_log.proc_begin(d_mod, 'p_category_id_tbl', p_category_id_tbl);
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3651: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3652: END IF;
3645: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3651: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3652: END IF;
3653:
3646: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3651: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3652: END IF;
3653:
3654: x_result_type := po_validations.c_result_type_success;
3647: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
3648: po_log.proc_begin(d_mod, 'p_job_id_tbl', p_job_id_tbl);
3649: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
3650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3651: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
3652: END IF;
3653:
3654: x_result_type := po_validations.c_result_type_success;
3655: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3708: x_result_set_id => x_result_set_id,
3709: x_results => x_results,
3710: x_result_type => x_result_type);
3711:
3712: IF po_log.d_proc THEN
3713: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3714: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3715: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3716: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3710: x_result_type => x_result_type);
3711:
3712: IF po_log.d_proc THEN
3713: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3714: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3715: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3716: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3717: END IF;
3718:
3711:
3712: IF po_log.d_proc THEN
3713: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3714: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3715: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3716: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3717: END IF;
3718:
3719: EXCEPTION
3712: IF po_log.d_proc THEN
3713: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
3714: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3715: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3716: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3717: END IF;
3718:
3719: EXCEPTION
3720: WHEN OTHERS THEN
3717: END IF;
3718:
3719: EXCEPTION
3720: WHEN OTHERS THEN
3721: IF po_log.d_exc THEN
3722: po_log.exc(d_mod, 0, NULL);
3723: END IF;
3724:
3725: RAISE;
3718:
3719: EXCEPTION
3720: WHEN OTHERS THEN
3721: IF po_log.d_exc THEN
3722: po_log.exc(d_mod, 0, NULL);
3723: END IF;
3724:
3725: RAISE;
3726: END category_id_update;
3747: IF x_result_set_id IS NULL THEN
3748: x_result_set_id := po_validations.next_result_set_id();
3749: END IF;
3750:
3751: IF po_log.d_proc THEN
3752: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3753: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3754: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3755: END IF;
3748: x_result_set_id := po_validations.next_result_set_id();
3749: END IF;
3750:
3751: IF po_log.d_proc THEN
3752: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3753: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3754: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3755: END IF;
3756:
3749: END IF;
3750:
3751: IF po_log.d_proc THEN
3752: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3753: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3754: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3755: END IF;
3756:
3757: x_result_type := po_validations.c_result_type_success;
3750:
3751: IF po_log.d_proc THEN
3752: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3753: po_log.proc_begin(d_mod, 'p_unit_price_tbl', p_unit_price_tbl);
3754: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
3755: END IF;
3756:
3757: x_result_type := po_validations.c_result_type_success;
3758:
3895: x_result_type := po_validations.c_result_type_failure;
3896: END IF;
3897: -- Enhanced Pricing End
3898:
3899: IF po_log.d_proc THEN
3900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3901: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3902: END IF;
3903: EXCEPTION
3896: END IF;
3897: -- Enhanced Pricing End
3898:
3899: IF po_log.d_proc THEN
3900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3901: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3897: -- Enhanced Pricing End
3898:
3899: IF po_log.d_proc THEN
3900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3901: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3905: IF po_log.d_exc THEN
3901: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3905: IF po_log.d_exc THEN
3906: po_log.exc(d_mod, 0, NULL);
3907: END IF;
3908:
3909: RAISE;
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3905: IF po_log.d_exc THEN
3906: po_log.exc(d_mod, 0, NULL);
3907: END IF;
3908:
3909: RAISE;
3910: END unit_price_update;
3933: IF x_result_set_id IS NULL THEN
3934: x_result_set_id := po_validations.next_result_set_id();
3935: END IF;
3936:
3937: IF po_log.d_proc THEN
3938: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3939: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
3940: END IF;
3941:
3934: x_result_set_id := po_validations.next_result_set_id();
3935: END IF;
3936:
3937: IF po_log.d_proc THEN
3938: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3939: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
3940: END IF;
3941:
3942: x_result_type := po_validations.c_result_type_success;
3935: END IF;
3936:
3937: IF po_log.d_proc THEN
3938: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3939: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
3940: END IF;
3941:
3942: x_result_type := po_validations.c_result_type_success;
3943:
3985: IF (SQL%ROWCOUNT > 0) THEN
3986: x_result_type := po_validations.c_result_type_failure;
3987: END IF;
3988:
3989: IF po_log.d_proc THEN
3990: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3991: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3992: END IF;
3993: EXCEPTION
3986: x_result_type := po_validations.c_result_type_failure;
3987: END IF;
3988:
3989: IF po_log.d_proc THEN
3990: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3991: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3992: END IF;
3993: EXCEPTION
3994: WHEN OTHERS THEN
3987: END IF;
3988:
3989: IF po_log.d_proc THEN
3990: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
3991: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3992: END IF;
3993: EXCEPTION
3994: WHEN OTHERS THEN
3995: IF po_log.d_exc THEN
3991: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
3992: END IF;
3993: EXCEPTION
3994: WHEN OTHERS THEN
3995: IF po_log.d_exc THEN
3996: po_log.exc(d_mod, 0, NULL);
3997: END IF;
3998:
3999: RAISE;
3992: END IF;
3993: EXCEPTION
3994: WHEN OTHERS THEN
3995: IF po_log.d_exc THEN
3996: po_log.exc(d_mod, 0, NULL);
3997: END IF;
3998:
3999: RAISE;
4000: END amount_update;
4093: x_category Mtl_Categories_Kfv.Concatenated_Segments%type; --14050066
4094:
4095: BEGIN
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4099: PO_LOG.proc_begin(d_mod,'p_category_id_tbl',p_category_id_tbl);
4100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4101: END IF;
4094:
4095: BEGIN
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4099: PO_LOG.proc_begin(d_mod,'p_category_id_tbl',p_category_id_tbl);
4100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4101: END IF;
4102:
4095: BEGIN
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4099: PO_LOG.proc_begin(d_mod,'p_category_id_tbl',p_category_id_tbl);
4100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4101: END IF;
4102:
4103: IF (x_results IS NULL) THEN
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4099: PO_LOG.proc_begin(d_mod,'p_category_id_tbl',p_category_id_tbl);
4100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4101: END IF;
4102:
4103: IF (x_results IS NULL) THEN
4104: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4182: ELSE
4183: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4184: END IF;
4185:
4186: IF po_log.d_proc THEN
4187: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4188: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4189: END IF;
4190: EXCEPTION
4183: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4184: END IF;
4185:
4186: IF po_log.d_proc THEN
4187: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4188: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4189: END IF;
4190: EXCEPTION
4191: WHEN OTHERS THEN
4184: END IF;
4185:
4186: IF po_log.d_proc THEN
4187: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4188: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4189: END IF;
4190: EXCEPTION
4191: WHEN OTHERS THEN
4192: IF po_log.d_exc THEN
4188: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4189: END IF;
4190: EXCEPTION
4191: WHEN OTHERS THEN
4192: IF po_log.d_exc THEN
4193: po_log.exc(d_mod, 0, NULL);
4194: END IF;
4195: RAISE;
4196: END category_combination_valid;
4189: END IF;
4190: EXCEPTION
4191: WHEN OTHERS THEN
4192: IF po_log.d_exc THEN
4193: po_log.exc(d_mod, 0, NULL);
4194: END IF;
4195: RAISE;
4196: END category_combination_valid;
4197: -- bug 8633959 END
4286: x_item mtl_system_items_vl.Concatenated_Segments%type;
4287:
4288: BEGIN
4289:
4290: IF PO_LOG.d_proc THEN
4291: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4292: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
4293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4294: END IF;
4287:
4288: BEGIN
4289:
4290: IF PO_LOG.d_proc THEN
4291: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4292: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
4293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4294: END IF;
4295:
4288: BEGIN
4289:
4290: IF PO_LOG.d_proc THEN
4291: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4292: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
4293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4294: END IF;
4295:
4296: IF (x_results IS NULL) THEN
4289:
4290: IF PO_LOG.d_proc THEN
4291: PO_LOG.proc_begin(d_mod,'p_po_line_id_tbl',p_po_line_id_tbl);
4292: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
4293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
4294: END IF;
4295:
4296: IF (x_results IS NULL) THEN
4297: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4385: ELSE
4386: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4387: END IF;
4388:
4389: IF po_log.d_proc THEN
4390: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4391: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4392: END IF;
4393: EXCEPTION
4386: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4387: END IF;
4388:
4389: IF po_log.d_proc THEN
4390: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4391: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4392: END IF;
4393: EXCEPTION
4394: WHEN OTHERS THEN
4387: END IF;
4388:
4389: IF po_log.d_proc THEN
4390: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
4391: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4392: END IF;
4393: EXCEPTION
4394: WHEN OTHERS THEN
4395: IF po_log.d_exc THEN
4391: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
4392: END IF;
4393: EXCEPTION
4394: WHEN OTHERS THEN
4395: IF po_log.d_exc THEN
4396: po_log.exc(d_mod, 0, NULL);
4397: END IF;
4398: RAISE;
4399: END item_combination_valid;
4392: END IF;
4393: EXCEPTION
4394: WHEN OTHERS THEN
4395: IF po_log.d_exc THEN
4396: po_log.exc(d_mod, 0, NULL);
4397: END IF;
4398: RAISE;
4399: END item_combination_valid;
4400: -- bug 14075368 END