[Home] [Help]
688: BEGIN
689:
690: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
691:
692: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
693:
694: FOR l_err in c_error_records LOOP
695:
696: l_counter := length(l_err.attribute_status)/3;
772: BEGIN
773:
774: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
775:
776: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
777:
778: FOR l_err in c_error_records LOOP
779:
780: IF l_err.attribute_status is not NULL then
886:
887: BEGIN
888: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
889:
890: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
891:
892: FOR l_err in c_error_records LOOP
893: IF l_err.attribute_status is NULL then
894: if l_err.pac is not NULL and l_err.pa is NULL then
936: NULL,NULL, 'PRL',l_err.table_name, NULL,
937: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
938: end if;
939: if l_err.pavd is NULL and l_err.pav is NULL then
940: l_msg_txt := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
941: INSERT INTO QP_INTERFACE_ERRORS
942: (error_id,last_update_date, last_updated_by, creation_date,
943: created_by, last_update_login, request_id, program_application_id,
944: program_id, program_update_date, entity_type, table_name, column_name,
979: l_attribute := 'PRICING_ATTRIBUTE_VALUE_TO';
980:
981: END IF;
982: IF l_attr_code = '008' THEN
983: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
984: l_attribute := ' ';
985: END IF;
986:
987: l_msg_txt:=l_msg_data||' '||l_attribute;