eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUC_INTERFACE_TABLE_PKG

Line 435: /* calling the pon_auc_interface_table_pkg.validate_header_attributes procedure to validate the section and requirements and also to set the default values */

431: l_sum_wt_err VARCHAR(10);
432: BEGIN
433: print_log('inside of create_header_attr_inter procedure');
434:
435: /* calling the pon_auc_interface_table_pkg.validate_header_attributes procedure to validate the section and requirements and also to set the default values */
436: print_log('BEGIN Validating the data in interface table');
437:
438: pon_auc_interface_table_pkg.validate_header_attributes_api(NULL,batchId,-1);
439: BEGIN

Line 438: pon_auc_interface_table_pkg.validate_header_attributes_api(NULL,batchId,-1);

434:
435: /* calling the pon_auc_interface_table_pkg.validate_header_attributes procedure to validate the section and requirements and also to set the default values */
436: print_log('BEGIN Validating the data in interface table');
437:
438: pon_auc_interface_table_pkg.validate_header_attributes_api(NULL,batchId,-1);
439: BEGIN
440: SELECT 'N' status
441: INTO l_status
442: FROM dual

Line 663: pon_auc_interface_table_pkg.validate_requirement(NULL,batchId,-1,c_interface_attr_rec,l_status);

659: /* Validating the requirement before inserting */
660: l_status :=NULL;
661: c_interface_attr_rec.sequence_number:=l_sequence_number_attr;
662: print_log('BEGIN Validating the requirement before inserting');
663: pon_auc_interface_table_pkg.validate_requirement(NULL,batchId,-1,c_interface_attr_rec,l_status);
664: IF (l_status='N')THEN
665: print_log('An error occured while validating the requirements. please check the pon_interface_errors table for error information');
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');

Line 845: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD );

841: /* check if the value and score field is not null for text data type */
842: IF(p_interface_attr_rec1.l_SCORING_METHOD ='AUTOMATIC' AND p_interface_attr_rec1.l_datatype='TXT')THEN
843: IF(c_attr_score_rec.value IS NULL OR c_attr_score_rec.score IS NULL) THEN
844: print_log('score or value cannot be empty');
845: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD );
846: l_status:='N';
847: RETURN;
848: ELSE
849: /* check for the duplicate value */

Line 862: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_DUP_ACC_BID_VALUES',c_attr_score_rec.value );

858: WHEN No_Data_Found THEN
859: l_value:=NULL;
860: END;
861: IF(l_value IS NOT NULL) THEN
862: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_DUP_ACC_BID_VALUES',c_attr_score_rec.value );
863: l_status:='N';
864: RETURN;
865: END IF;
866: END IF;

Line 911: pon_auc_interface_table_pkg.insert_error_interface(c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD);

907: /* checkin the range values and score for the num and date datatype*/
908: IF(p_interface_attr_rec1.l_SCORING_METHOD='AUTOMATIC' AND (p_interface_attr_rec1.l_datatype='DAT' OR p_interface_attr_rec1.l_datatype='NUM')) THEN
909: IF((c_attr_score_rec.from_range IS NULL AND c_attr_score_rec.to_range IS NULL) OR c_attr_score_rec.score IS NULL) THEN
910: print_log('score or value cannot be empty');
911: pon_auc_interface_table_pkg.insert_error_interface(c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD);
912: l_status:='N';
913: RETURN;
914: END IF;
915: l_sequence_number_scr:=NVL(l_sequence_number_scr,0)+10;

Line 1022: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1018: l_from_range_num :=To_Number(p_attr_score_rec.l_from_range);
1019: l_to_range_num :=To_Number(p_attr_score_rec.l_to_range);
1020: IF(l_from_range_num IS NOT NULL AND l_to_range_num IS NOT NULL) THEN
1021: IF(l_from_range_num> l_to_range_num)THEN
1022: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1023: l_status :='N';
1024: RETURN;
1025: END IF;
1026: END IF;

Line 1048: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1044: t_from_range_num :=To_Number(l_from_range);
1045: t_to_range_num :=To_Number(l_to_range);
1046: IF(t_from_range_num IS NULL OR l_to_range_num IS NULL ) THEN
1047: IF(l_from_range_num <=t_to_range_num) THEN
1048: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1049: l_status :='N';
1050: RETURN;
1051: END IF;
1052: END IF;

Line 1055: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1051: END IF;
1052: END IF;
1053: IF(t_to_range_num IS NULL OR l_from_range_num IS NULL ) THEN
1054: IF(l_to_range_num >=t_from_range_num) THEN
1055: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1056: l_status :='N';
1057: RETURN;
1058: END IF;
1059: END IF;

Line 1074: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );

1070: END;
1071: END IF;
1072: l_status :=NVL(l_status,'Y');
1073: IF(l_status='N') THEN
1074: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );
1075: RETURN;
1076: END IF;
1077: END;
1078: END LOOP;

Line 1099: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1095: l_from_range_dat :=To_date(p_attr_score_rec.l_from_range,'dd-mm-yyyy');
1096: l_to_range_dat :=To_date(p_attr_score_rec.l_to_range,'dd-mm-yyyy');
1097: IF(l_from_range_dat IS NOT NULL AND l_to_range_dat IS NOT NULL) THEN
1098: IF(l_from_range_dat> l_to_range_dat)THEN
1099: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1100: l_status :='N';
1101: RETURN;
1102: END IF;
1103: END IF;

Line 1124: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1120: t_from_range_dat :=To_date(l_from_range,'dd-mm-yyyy');
1121: t_to_range_dat :=To_date(l_to_range,'dd-mm-yyyy');
1122: IF(t_from_range_dat IS NULL OR l_to_range_dat IS NULL ) THEN
1123: IF(l_from_range_dat <=t_to_range_dat) THEN
1124: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1125: l_status :='N';
1126: RETURN;
1127: END IF;
1128: END IF;

Line 1131: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1127: END IF;
1128: END IF;
1129: IF(t_to_range_dat IS NULL OR l_from_range_dat IS NULL ) THEN
1130: IF(l_to_range_dat >=t_from_range_dat) THEN
1131: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1132: l_status :='N';
1133: RETURN;
1134: END IF;
1135: END IF;

Line 1150: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );

1146: END;
1147: END IF;
1148: l_status :=NVL(l_status,'Y');
1149: IF(l_status='N') THEN
1150: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );
1151: RETURN;
1152: END IF;
1153: END;
1154: END LOOP;

Line 2118: pon_auc_interface_table_pkg.validate_price_elements('ITEMUPLOAD',

2114: p_org_id
2115: );
2116: print_log('line_level_validation: PON_VALIDATE_ITEM_PRICES_INT.VALIDATE completed');
2117:
2118: pon_auc_interface_table_pkg.validate_price_elements('ITEMUPLOAD',
2119: p_batch_id,
2120: p_precision,
2121: p_precision
2122: );

Line 2123: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_elements completed');

2119: p_batch_id,
2120: p_precision,
2121: p_precision
2122: );
2123: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_elements completed');
2124:
2125: pon_auc_interface_table_pkg.validate_price_differentials('ITEMUPLOAD',
2126: p_batch_id
2127: );

Line 2125: pon_auc_interface_table_pkg.validate_price_differentials('ITEMUPLOAD',

2121: p_precision
2122: );
2123: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_elements completed');
2124:
2125: pon_auc_interface_table_pkg.validate_price_differentials('ITEMUPLOAD',
2126: p_batch_id
2127: );
2128: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_differentials completed');
2129:

Line 2128: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_differentials completed');

2124:
2125: pon_auc_interface_table_pkg.validate_price_differentials('ITEMUPLOAD',
2126: p_batch_id
2127: );
2128: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_differentials completed');
2129:
2130: pon_auc_interface_table_pkg.validate_attributes('ITEMUPLOAD',
2131: p_batch_id,
2132: p_trading_partner_id

Line 2130: pon_auc_interface_table_pkg.validate_attributes('ITEMUPLOAD',

2126: p_batch_id
2127: );
2128: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_price_differentials completed');
2129:
2130: pon_auc_interface_table_pkg.validate_attributes('ITEMUPLOAD',
2131: p_batch_id,
2132: p_trading_partner_id
2133: );
2134: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_attributes completed');

Line 2134: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_attributes completed');

2130: pon_auc_interface_table_pkg.validate_attributes('ITEMUPLOAD',
2131: p_batch_id,
2132: p_trading_partner_id
2133: );
2134: print_log('line_level_validation: pon_auc_interface_table_pkg.validate_attributes completed');
2135:
2136: IF(NVL(p_is_complex,'N') = 'Y') THEN
2137: pon_validate_payments_int.validate_creation('NEGPYMTUPLOAD',
2138: p_batch_id);