DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_MSG_MAPPING_UTL

Line 27: x_mapped_err_msg OUT NOCOPY PO_MSG_MAPPING_UTL.msg_rec_type

23: p_interface_line_id IN NUMBER := NULL,
24: p_interface_line_location_id IN NUMBER := NULL,
25: p_price_diff_interface_id IN NUMBER := NULL,
26: x_mapping_exists OUT NOCOPY VARCHAR2,
27: x_mapped_err_msg OUT NOCOPY PO_MSG_MAPPING_UTL.msg_rec_type
28: );
29:
30: FUNCTION get_value_from_key
31: (

Line 322: l_mapped_err_msg PO_MSG_MAPPING_UTL.msg_rec_type;

318: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
319: d_position NUMBER;
320:
321: l_mapping_exists VARCHAR2(1) := FND_API.G_FALSE;
322: l_mapped_err_msg PO_MSG_MAPPING_UTL.msg_rec_type;
323:
324: BEGIN
325: d_position := 0;
326:

Line 452: l_mapped_err_msg PO_MSG_MAPPING_UTL.msg_rec_type;

448: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
449: d_position NUMBER;
450:
451: l_mapping_exists VARCHAR2(1);
452: l_mapped_err_msg PO_MSG_MAPPING_UTL.msg_rec_type;
453: l_app_name VARCHAR2(30) := NULL;
454: BEGIN
455: d_position := 0;
456:

Line 806: x_mapped_err_msg OUT NOCOPY PO_MSG_MAPPING_UTL.msg_rec_type

802: p_interface_line_id IN NUMBER := NULL,
803: p_interface_line_location_id IN NUMBER := NULL,
804: p_price_diff_interface_id IN NUMBER := NULL,
805: x_mapping_exists OUT NOCOPY VARCHAR2,
806: x_mapped_err_msg OUT NOCOPY PO_MSG_MAPPING_UTL.msg_rec_type
807: ) IS
808:
809: d_api_name CONSTANT VARCHAR2(30) := 'map_error_message';
810: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 829: PO_MSG_MAPPING_UTL.find_msg

825: p_price_diff_interface_id);
826: END IF;
827:
828: -- find the message mapping, if it exists
829: PO_MSG_MAPPING_UTL.find_msg
830: ( p_context => PO_PDOI_PARAMS.g_request.calling_module,
831: p_id => p_validation_id,
832: x_msg_exists => x_mapping_exists,
833: x_msg_rec => x_mapped_err_msg

Line 1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN

1072: CASE p_table_name
1073: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN
1074: d_position := 10;
1075: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1077: l_value := p_headers.rate_type_tbl(l_index);
1078: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_agent_name) THEN
1079: l_value := p_headers.agent_name_tbl(l_index);
1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN

Line 1078: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_agent_name) THEN

1074: d_position := 10;
1075: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1077: l_value := p_headers.rate_type_tbl(l_index);
1078: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_agent_name) THEN
1079: l_value := p_headers.agent_name_tbl(l_index);
1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN
1081: l_value := p_headers.ship_to_loc_tbl(l_index);
1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN

Line 1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN

1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1077: l_value := p_headers.rate_type_tbl(l_index);
1078: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_agent_name) THEN
1079: l_value := p_headers.agent_name_tbl(l_index);
1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN
1081: l_value := p_headers.ship_to_loc_tbl(l_index);
1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN
1083: l_value := p_headers.bill_to_loc_tbl(l_index);
1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN

Line 1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN

1078: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_agent_name) THEN
1079: l_value := p_headers.agent_name_tbl(l_index);
1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN
1081: l_value := p_headers.ship_to_loc_tbl(l_index);
1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN
1083: l_value := p_headers.bill_to_loc_tbl(l_index);
1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1085: l_value := p_headers.payment_terms_tbl(l_index);
1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN

Line 1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN

1080: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_location) THEN
1081: l_value := p_headers.ship_to_loc_tbl(l_index);
1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN
1083: l_value := p_headers.bill_to_loc_tbl(l_index);
1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1085: l_value := p_headers.payment_terms_tbl(l_index);
1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN
1087: l_value := p_headers.vendor_name_tbl(l_index);
1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN

Line 1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN

1082: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_bill_to_location) THEN
1083: l_value := p_headers.bill_to_loc_tbl(l_index);
1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1085: l_value := p_headers.payment_terms_tbl(l_index);
1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN
1087: l_value := p_headers.vendor_name_tbl(l_index);
1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN
1089: l_value := p_headers.vendor_site_code_tbl(l_index);
1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN

Line 1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN

1084: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1085: l_value := p_headers.payment_terms_tbl(l_index);
1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN
1087: l_value := p_headers.vendor_name_tbl(l_index);
1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN
1089: l_value := p_headers.vendor_site_code_tbl(l_index);
1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN
1091: l_value := p_headers.vendor_contact_tbl(l_index);
1092: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_display_name) THEN

Line 1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN

1086: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_name) THEN
1087: l_value := p_headers.vendor_name_tbl(l_index);
1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN
1089: l_value := p_headers.vendor_site_code_tbl(l_index);
1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN
1091: l_value := p_headers.vendor_contact_tbl(l_index);
1092: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_display_name) THEN
1093: l_value := p_headers.style_display_name_tbl(l_index);
1094: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_from_rfq_num) THEN

Line 1092: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_display_name) THEN

1088: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_site_code) THEN
1089: l_value := p_headers.vendor_site_code_tbl(l_index);
1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN
1091: l_value := p_headers.vendor_contact_tbl(l_index);
1092: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_display_name) THEN
1093: l_value := p_headers.style_display_name_tbl(l_index);
1094: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_from_rfq_num) THEN
1095: l_value := p_headers.from_rfq_num_tbl(l_index);
1096: ELSE

Line 1094: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_from_rfq_num) THEN

1090: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_vendor_contact) THEN
1091: l_value := p_headers.vendor_contact_tbl(l_index);
1092: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_display_name) THEN
1093: l_value := p_headers.style_display_name_tbl(l_index);
1094: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_from_rfq_num) THEN
1095: l_value := p_headers.from_rfq_num_tbl(l_index);
1096: ELSE
1097: NULL;
1098: END IF;

Line 1102: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN

1098: END IF;
1099: WHEN PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE THEN
1100: d_position := 20;
1101: l_index := p_lines.intf_id_index_tbl(p_interface_line_id);
1102: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN
1103: l_value := p_lines.item_tbl(l_index);
1104: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_desc) THEN
1105: l_value := p_lines.item_desc_tbl(l_index);
1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN

Line 1104: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_desc) THEN

1100: d_position := 20;
1101: l_index := p_lines.intf_id_index_tbl(p_interface_line_id);
1102: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN
1103: l_value := p_lines.item_tbl(l_index);
1104: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_desc) THEN
1105: l_value := p_lines.item_desc_tbl(l_index);
1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN
1107: l_value := p_lines.job_business_group_name_tbl(l_index);
1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN

Line 1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN

1102: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN
1103: l_value := p_lines.item_tbl(l_index);
1104: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_desc) THEN
1105: l_value := p_lines.item_desc_tbl(l_index);
1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN
1107: l_value := p_lines.job_business_group_name_tbl(l_index);
1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN
1109: l_value := p_lines.job_name_tbl(l_index);
1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN

Line 1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN

1104: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_desc) THEN
1105: l_value := p_lines.item_desc_tbl(l_index);
1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN
1107: l_value := p_lines.job_business_group_name_tbl(l_index);
1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN
1109: l_value := p_lines.job_name_tbl(l_index);
1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN
1111: l_value := p_lines.category_tbl(l_index);
1112: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ip_category) THEN

Line 1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN

1106: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_business_group_name) THEN
1107: l_value := p_lines.job_business_group_name_tbl(l_index);
1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN
1109: l_value := p_lines.job_name_tbl(l_index);
1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN
1111: l_value := p_lines.category_tbl(l_index);
1112: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ip_category) THEN
1113: l_value := p_lines.ip_category_tbl(l_index);
1114: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_uom_code) THEN

Line 1112: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ip_category) THEN

1108: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_job_name) THEN
1109: l_value := p_lines.job_name_tbl(l_index);
1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN
1111: l_value := p_lines.category_tbl(l_index);
1112: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ip_category) THEN
1113: l_value := p_lines.ip_category_tbl(l_index);
1114: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_uom_code) THEN
1115: -- bug5619358
1116: -- For Catalog Upload, we need to get the value from

Line 1114: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_uom_code) THEN

1110: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_category) THEN
1111: l_value := p_lines.category_tbl(l_index);
1112: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ip_category) THEN
1113: l_value := p_lines.ip_category_tbl(l_index);
1114: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_uom_code) THEN
1115: -- bug5619358
1116: -- For Catalog Upload, we need to get the value from
1117: -- UNI_MEAS_LOOKUP_CODE if UOM_CODE is NULL
1118: IF (PO_PDOI_PARAMS.g_request.calling_module =

Line 1124: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_type) THEN

1120:
1121: l_value := NVL(p_lines.uom_code_tbl(l_index),
1122: p_lines.unit_of_measure_tbl(l_index));
1123: END IF;
1124: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_type) THEN
1125: l_value := p_lines.line_type_tbl(l_index);
1126: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_un_number) THEN
1127: l_value := p_lines.un_number_tbl(l_index);
1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN

Line 1126: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_un_number) THEN

1122: p_lines.unit_of_measure_tbl(l_index));
1123: END IF;
1124: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_type) THEN
1125: l_value := p_lines.line_type_tbl(l_index);
1126: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_un_number) THEN
1127: l_value := p_lines.un_number_tbl(l_index);
1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN
1129: l_value := p_lines.hazard_class_tbl(l_index);
1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN

Line 1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN

1124: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_type) THEN
1125: l_value := p_lines.line_type_tbl(l_index);
1126: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_un_number) THEN
1127: l_value := p_lines.un_number_tbl(l_index);
1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN
1129: l_value := p_lines.hazard_class_tbl(l_index);
1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN
1131: l_value := p_lines.template_name_tbl(l_index);
1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN

Line 1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN

1126: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_un_number) THEN
1127: l_value := p_lines.un_number_tbl(l_index);
1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN
1129: l_value := p_lines.hazard_class_tbl(l_index);
1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN
1131: l_value := p_lines.template_name_tbl(l_index);
1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN
1133: l_value := p_lines.amount_tbl(l_index);
1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN

Line 1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN

1128: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_hazard_class) THEN
1129: l_value := p_lines.hazard_class_tbl(l_index);
1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN
1131: l_value := p_lines.template_name_tbl(l_index);
1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN
1133: l_value := p_lines.amount_tbl(l_index);
1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN
1135: l_value := p_lines.unit_price_tbl(l_index);
1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN

Line 1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN

1130: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_template_name) THEN
1131: l_value := p_lines.template_name_tbl(l_index);
1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN
1133: l_value := p_lines.amount_tbl(l_index);
1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN
1135: l_value := p_lines.unit_price_tbl(l_index);
1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN
1137: l_value := p_lines.line_num_tbl(l_index);
1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN

Line 1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN

1132: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_amount) THEN
1133: l_value := p_lines.amount_tbl(l_index);
1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN
1135: l_value := p_lines.unit_price_tbl(l_index);
1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN
1137: l_value := p_lines.line_num_tbl(l_index);
1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN
1139: l_value := p_lines.quantity_tbl(l_index);
1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN

Line 1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN

1134: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_unit_price) THEN
1135: l_value := p_lines.unit_price_tbl(l_index);
1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN
1137: l_value := p_lines.line_num_tbl(l_index);
1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN
1139: l_value := p_lines.quantity_tbl(l_index);
1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN
1141: l_value := p_lines.item_revision_tbl(l_index);
1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN

Line 1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN

1136: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_line_num) THEN
1137: l_value := p_lines.line_num_tbl(l_index);
1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN
1139: l_value := p_lines.quantity_tbl(l_index);
1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN
1141: l_value := p_lines.item_revision_tbl(l_index);
1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN
1143: l_value := p_lines.hd_global_agreement_flag_tbl(l_index);
1144: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_negotiated_flag) THEN

Line 1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN

1138: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_quantity) THEN
1139: l_value := p_lines.quantity_tbl(l_index);
1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN
1141: l_value := p_lines.item_revision_tbl(l_index);
1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN
1143: l_value := p_lines.hd_global_agreement_flag_tbl(l_index);
1144: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_negotiated_flag) THEN
1145: l_value := p_lines.negotiated_flag_tbl(l_index);
1146: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_created_language) THEN

Line 1144: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_negotiated_flag) THEN

1140: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_item_revision) THEN
1141: l_value := p_lines.item_revision_tbl(l_index);
1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN
1143: l_value := p_lines.hd_global_agreement_flag_tbl(l_index);
1144: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_negotiated_flag) THEN
1145: l_value := p_lines.negotiated_flag_tbl(l_index);
1146: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_created_language) THEN
1147: l_value := p_lines.hd_created_language_tbl(l_index);
1148: ELSE

Line 1146: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_created_language) THEN

1142: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_ga_flag) THEN
1143: l_value := p_lines.hd_global_agreement_flag_tbl(l_index);
1144: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_negotiated_flag) THEN
1145: l_value := p_lines.negotiated_flag_tbl(l_index);
1146: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_created_language) THEN
1147: l_value := p_lines.hd_created_language_tbl(l_index);
1148: ELSE
1149: NULL;
1150: END IF;

Line 1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN

1150: END IF;
1151: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN
1152: d_position := 30;
1153: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1155: l_value := p_line_locs.ship_to_org_code_tbl(l_index);
1156: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_loc_ship_to_location) THEN
1157: l_value := p_line_locs.ship_to_loc_tbl(l_index);
1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN

Line 1156: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_loc_ship_to_location) THEN

1152: d_position := 30;
1153: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1155: l_value := p_line_locs.ship_to_org_code_tbl(l_index);
1156: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_loc_ship_to_location) THEN
1157: l_value := p_line_locs.ship_to_loc_tbl(l_index);
1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1159: l_value := p_line_locs.payment_terms_tbl(l_index);
1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN

Line 1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN

1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1155: l_value := p_line_locs.ship_to_org_code_tbl(l_index);
1156: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_loc_ship_to_location) THEN
1157: l_value := p_line_locs.ship_to_loc_tbl(l_index);
1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1159: l_value := p_line_locs.payment_terms_tbl(l_index);
1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN
1161: l_value := p_line_locs.receiving_routing_tbl(l_index);
1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN

Line 1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN

1156: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_loc_ship_to_location) THEN
1157: l_value := p_line_locs.ship_to_loc_tbl(l_index);
1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1159: l_value := p_line_locs.payment_terms_tbl(l_index);
1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN
1161: l_value := p_line_locs.receiving_routing_tbl(l_index);
1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN
1163: l_value := p_line_locs.tax_code_id_tbl(l_index);
1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN

Line 1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN

1158: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_payment_terms) THEN
1159: l_value := p_line_locs.payment_terms_tbl(l_index);
1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN
1161: l_value := p_line_locs.receiving_routing_tbl(l_index);
1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN
1163: l_value := p_line_locs.tax_code_id_tbl(l_index);
1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN
1165: l_value := p_line_locs.price_discount_tbl(l_index);
1166: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_id) THEN

Line 1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN

1160: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_receiving_routing) THEN
1161: l_value := p_line_locs.receiving_routing_tbl(l_index);
1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN
1163: l_value := p_line_locs.tax_code_id_tbl(l_index);
1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN
1165: l_value := p_line_locs.price_discount_tbl(l_index);
1166: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_id) THEN
1167: l_value := p_line_locs.hd_style_id_tbl(l_index);
1168: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_start_date) THEN

Line 1166: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_id) THEN

1162: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_tax_code_id) THEN
1163: l_value := p_line_locs.tax_code_id_tbl(l_index);
1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN
1165: l_value := p_line_locs.price_discount_tbl(l_index);
1166: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_id) THEN
1167: l_value := p_line_locs.hd_style_id_tbl(l_index);
1168: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_start_date) THEN
1169: l_value := p_line_locs.start_date_tbl(l_index);
1170: ELSE

Line 1168: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_start_date) THEN

1164: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_price_discount) THEN
1165: l_value := p_line_locs.price_discount_tbl(l_index);
1166: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_style_id) THEN
1167: l_value := p_line_locs.hd_style_id_tbl(l_index);
1168: ELSIF (p_key = PO_MSG_MAPPING_UTL.c_start_date) THEN
1169: l_value := p_line_locs.start_date_tbl(l_index);
1170: ELSE
1171: NULL;
1172: END IF;