[Home] [Help]
719: BEGIN
720:
721: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
722:
723: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
724:
725: FOR l_err in c_error_records LOOP
726:
727: l_counter := length(l_err.attribute_status)/3;
803: BEGIN
804:
805: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
806:
807: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
808:
809: FOR l_err in c_error_records LOOP
810:
811: IF l_err.attribute_status is not NULL then
917:
918: BEGIN
919: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
920:
921: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
922:
923: FOR l_err in c_error_records LOOP
924: IF l_err.attribute_status is NULL then
925: if l_err.pac is not NULL and l_err.pa is NULL then
967: NULL,NULL, 'PRL',l_err.table_name, NULL,
968: l_err.orig_header_ref,l_err.orig_line_ref,null,l_err.orig_attr_ref,l_msg_txt);
969: end if;
970: if l_err.pavd is NULL and l_err.pav is NULL then
971: l_msg_txt := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
972: INSERT INTO QP_INTERFACE_ERRORS
973: (error_id,last_update_date, last_updated_by, creation_date,
974: created_by, last_update_login, request_id, program_application_id,
975: program_id, program_update_date, entity_type, table_name, column_name,
1010: l_attribute := 'PRICING_ATTRIBUTE_VALUE_TO';
1011:
1012: END IF;
1013: IF l_attr_code = '008' THEN
1014: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_INVALID_PROD_VALUE');
1015: l_attribute := ' ';
1016: END IF;
1017:
1018: l_msg_txt:=l_msg_data||' '||l_attribute;