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 FND_MESSAGE

Line 453: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');

449: END;
450: IF(l_status='N') THEN
451: print_log('An error occured while validating the requirements. please check the pon_interface_errors table for error information');
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
454: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
455: FND_MSG_PUB.ADD;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;

Line 454: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

450: IF(l_status='N') THEN
451: print_log('An error occured while validating the requirements. please check the pon_interface_errors table for error information');
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
454: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
455: FND_MSG_PUB.ADD;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458: print_log('END Validating the data in interface table');

Line 637: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');

633: print_log('l_status is '|| l_status);
634: IF (l_status='N')THEN
635: print_log('An error occured while validating the acceptable values. please check the pon_interface_errors table for error information');
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
638: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;

Line 638: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

634: IF (l_status='N')THEN
635: print_log('An error occured while validating the acceptable values. please check the pon_interface_errors table for error information');
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
638: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642: print_log('End validating AND INSERTING acceptable VALUES');

Line 667: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');

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');
668: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
669: FND_MSG_PUB.ADD;
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;

Line 668: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

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');
668: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
669: FND_MSG_PUB.ADD;
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672: print_log('END Validating the requirement before inserting');

Line 779: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');

775: EXCEPTION
776: WHEN OTHERS THEN
777: print_log('Exception occured in create_header_attr_inter procedure.');
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
780: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END create_header_attr_inter;

Line 780: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

776: WHEN OTHERS THEN
777: print_log('Exception occured in create_header_attr_inter procedure.');
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_REQ_ERR');
780: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END create_header_attr_inter;
784: -----------------------------------------------------------------------

Line 1208: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');

1204: c_interface_neg_team_rec.approver_flag,c_interface_neg_team_rec.auction_header_id,
1205: c_interface_neg_team_rec.task_name,c_interface_neg_team_rec.target_date,NULL,x_return_status);
1206: END IF;
1207: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1208: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');
1209: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
1210: FND_MSG_PUB.ADD;
1211: RETURN;
1212: END IF;

Line 1209: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

1205: c_interface_neg_team_rec.task_name,c_interface_neg_team_rec.target_date,NULL,x_return_status);
1206: END IF;
1207: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1208: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');
1209: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
1210: FND_MSG_PUB.ADD;
1211: RETURN;
1212: END IF;
1213: IF(c_interface_neg_team_rec.ACTION='DELETE') THEN

Line 1232: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');

1228: print_log('Exiting procedure create_neg_team');
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');
1233: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
1234: FND_MSG_PUB.ADD;
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: END;

Line 1233: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);

1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COLLAB_TEAM_ERR');
1233: FND_MESSAGE.SET_TOKEN('BATCH_ID',batchId);
1234: FND_MSG_PUB.ADD;
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: END;
1237: -----------------------------------------------------------------------

Line 1639: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_VAL_ERR');

1635: END;
1636:
1637: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
1638: print_Log('Error in PON_BID_PARTIES_INTERFACE table. Please check pon_interface_errors for more details' );
1639: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_VAL_ERR');
1640: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;

Line 1640: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

1636:
1637: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
1638: print_Log('Error in PON_BID_PARTIES_INTERFACE table. Please check pon_interface_errors for more details' );
1639: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_VAL_ERR');
1640: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:

Line 1730: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_MUL');

1726: END;
1727: IF(l_status='Y') THEN
1728: print_log('Supplier cannot be invited multiple times for the same Supplier Site or without a Supplier Site selection. Please select distinct Supplier Sites when inviting a supplier multiple times.');
1729: x_return_status := 'E';
1730: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_MUL');
1731: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
1732: FND_MESSAGE.SET_TOKEN('VENDOR_NAME',L_VENDOR_NAME);
1733: FND_MSG_PUB.ADD;
1734: RAISE FND_API.G_EXC_ERROR;

Line 1731: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

1727: IF(l_status='Y') THEN
1728: print_log('Supplier cannot be invited multiple times for the same Supplier Site or without a Supplier Site selection. Please select distinct Supplier Sites when inviting a supplier multiple times.');
1729: x_return_status := 'E';
1730: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_MUL');
1731: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
1732: FND_MESSAGE.SET_TOKEN('VENDOR_NAME',L_VENDOR_NAME);
1733: FND_MSG_PUB.ADD;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;

Line 1732: FND_MESSAGE.SET_TOKEN('VENDOR_NAME',L_VENDOR_NAME);

1728: print_log('Supplier cannot be invited multiple times for the same Supplier Site or without a Supplier Site selection. Please select distinct Supplier Sites when inviting a supplier multiple times.');
1729: x_return_status := 'E';
1730: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_MUL');
1731: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
1732: FND_MESSAGE.SET_TOKEN('VENDOR_NAME',L_VENDOR_NAME);
1733: FND_MSG_PUB.ADD;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736:

Line 2149: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');

2145: WHEN OTHERS THEN
2146: print_log('An error occured while validating the line. please check the pon_interface_errors table for error information');
2147: print_log('sqlcode ' || SQLCODE || 'sqlerror ' || SQLERRM);
2148: x_return_status := FND_API.G_RET_STS_ERROR;
2149: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');
2150: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153:

Line 2150: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2146: print_log('An error occured while validating the line. please check the pon_interface_errors table for error information');
2147: print_log('sqlcode ' || SQLCODE || 'sqlerror ' || SQLERRM);
2148: x_return_status := FND_API.G_RET_STS_ERROR;
2149: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');
2150: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153:
2154:

Line 2329: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');

2325: END;
2326: IF(l_status='N') THEN
2327: print_log('An error occured while validating the line. please check the pon_interface_errors table for error information');
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');
2330: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2331: FND_MSG_PUB.ADD;
2332: --RAISE FND_API.G_EXC_ERROR;
2333: RETURN;

Line 2330: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2326: IF(l_status='N') THEN
2327: print_log('An error occured while validating the line. please check the pon_interface_errors table for error information');
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINES_VAL_ERR');
2330: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2331: FND_MSG_PUB.ADD;
2332: --RAISE FND_API.G_EXC_ERROR;
2333: RETURN;
2334: END IF;

Line 2402: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');

2398: );
2399: print_log('create_lines_with_children returned from PON_CP_INTRFAC_TO_TRANSACTION.SYNCH_FROM_INTERFACE with x_error_message '|| x_error_message);
2400: IF (x_error_message <> 'S') THEN
2401: x_return_status := FND_API.G_RET_STS_ERROR;
2402: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');
2403: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2404: FND_MSG_PUB.ADD;
2405: RETURN;
2406: END IF;

Line 2403: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2399: print_log('create_lines_with_children returned from PON_CP_INTRFAC_TO_TRANSACTION.SYNCH_FROM_INTERFACE with x_error_message '|| x_error_message);
2400: IF (x_error_message <> 'S') THEN
2401: x_return_status := FND_API.G_RET_STS_ERROR;
2402: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');
2403: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2404: FND_MSG_PUB.ADD;
2405: RETURN;
2406: END IF;
2407:

Line 2492: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_ATTRSCORES_VAL_ERR');

2488: IF(l_status='N') THEN
2489: print_log('Errors found in validation of scores for line level attributes.' ||
2490: ' please check the pon_interface_errors table for error information');
2491: x_return_status := FND_API.G_RET_STS_ERROR;
2492: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_ATTRSCORES_VAL_ERR');
2493: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2494: FND_MSG_PUB.ADD;
2495: RETURN;
2496: END IF;

Line 2493: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2489: print_log('Errors found in validation of scores for line level attributes.' ||
2490: ' please check the pon_interface_errors table for error information');
2491: x_return_status := FND_API.G_RET_STS_ERROR;
2492: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_ATTRSCORES_VAL_ERR');
2493: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2494: FND_MSG_PUB.ADD;
2495: RETURN;
2496: END IF;
2497:

Line 2586: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_VAL_ERR');

2582: END;
2583: IF(l_status='N') THEN
2584: print_log('An error occured while validating the price breaks. please check the pon_interface_errors table for error information');
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_VAL_ERR');
2587: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2588: FND_MSG_PUB.ADD;
2589: RETURN;
2590: END IF;

Line 2587: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2583: IF(l_status='N') THEN
2584: print_log('An error occured while validating the price breaks. please check the pon_interface_errors table for error information');
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_VAL_ERR');
2587: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2588: FND_MSG_PUB.ADD;
2589: RETURN;
2590: END IF;
2591:

Line 2602: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');

2598: );
2599: IF(x_result='E') THEN
2600: print_log('Error in add_price_breaks.' || SQLERRM );
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');
2603: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2604: FND_MSG_PUB.ADD;
2605: RETURN;
2606: END IF;

Line 2603: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2599: IF(x_result='E') THEN
2600: print_log('Error in add_price_breaks.' || SQLERRM );
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');
2603: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2604: FND_MSG_PUB.ADD;
2605: RETURN;
2606: END IF;
2607: END IF; -- price_break_response <> 'NONE'

Line 2618: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');

2614: EXCEPTION
2615: WHEN OTHERS THEN
2616: print_log('exception increate_lines_with_children: sqlcode ' || SQLCODE || ' sqlerrm ' || SQLERRM );
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');
2619: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2620: FND_MSG_PUB.ADD;
2621: END create_lines_with_children;
2622:

Line 2619: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2615: WHEN OTHERS THEN
2616: print_log('exception increate_lines_with_children: sqlcode ' || SQLCODE || ' sqlerrm ' || SQLERRM );
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_CREATE_LINES_ERR');
2619: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2620: FND_MSG_PUB.ADD;
2621: END create_lines_with_children;
2622:
2623:

Line 2782: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');

2778:
2779: EXCEPTION
2780: WHEN OTHERS THEN
2781: print_log('error in add_price_breaks' || SQLCODE || SQLERRM );
2782: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');
2783: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2784: FND_MSG_PUB.ADD;
2785: x_result := 'E';
2786: END ADD_price_breaks;

Line 2783: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

2779: EXCEPTION
2780: WHEN OTHERS THEN
2781: print_log('error in add_price_breaks' || SQLCODE || SQLERRM );
2782: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PB_ERR');
2783: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
2784: FND_MSG_PUB.ADD;
2785: x_result := 'E';
2786: END ADD_price_breaks;
2787:

Line 3794: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_TPSETUP_ERR');

3790:
3791: IF(p_error_code = 'E' ) THEN
3792: x_return_status := FND_API.G_RET_STS_ERROR;
3793: print_Log('Trading partner set up is not done.' );
3794: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_TPSETUP_ERR');
3795: FND_MSG_PUB.ADD;
3796: RAISE FND_API.G_EXC_ERROR;
3797: END IF;
3798:

Line 3816: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEG_CREATION_FAIL');

3812:
3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: print_log('Exception in create_negotiation for batch_id ' || l_batch_id);
3816: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEG_CREATION_FAIL');
3817: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
3818: FND_MSG_PUB.ADD;
3819: x_return_status := FND_API.G_RET_STS_ERROR;
3820: neg_return_status := FND_API.G_RET_STS_ERROR;

Line 3817: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);

3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: print_log('Exception in create_negotiation for batch_id ' || l_batch_id);
3816: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEG_CREATION_FAIL');
3817: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
3818: FND_MSG_PUB.ADD;
3819: x_return_status := FND_API.G_RET_STS_ERROR;
3820: neg_return_status := FND_API.G_RET_STS_ERROR;
3821: END;

Line 3919: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_MUL_BATCHID');

3915: EXCEPTION
3916: WHEN Too_Many_Rows THEN
3917: x_return_status := FND_API.G_RET_STS_ERROR;
3918: print_Log('Multiple rows found in pon_auction_headers_Interface table for the batch_id' || p_batch_id);
3919: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_MUL_BATCHID');
3920: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;
3923: END;

Line 3920: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

3916: WHEN Too_Many_Rows THEN
3917: x_return_status := FND_API.G_RET_STS_ERROR;
3918: print_Log('Multiple rows found in pon_auction_headers_Interface table for the batch_id' || p_batch_id);
3919: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_MUL_BATCHID');
3920: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3921: FND_MSG_PUB.ADD;
3922: RAISE FND_API.G_EXC_ERROR;
3923: END;
3924:

Line 3936: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_PROC_FAIL');

3932: --x_auction_header_id := 169670;
3933:
3934: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3935: print_log('failure from create_negotiation_header');
3936: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_PROC_FAIL');
3937: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3938: FND_MSG_PUB.ADD;
3939: RETURN;
3940: END IF;

Line 3937: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

3933:
3934: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3935: print_log('failure from create_negotiation_header');
3936: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_PROC_FAIL');
3937: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3938: FND_MSG_PUB.ADD;
3939: RETURN;
3940: END IF;
3941: print_log('Header record created for batch_id ' || p_batch_id || ' auction_header_id ' || x_auction_header_id

Line 3953: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_UDA_FAIL');

3949:
3950: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id, 'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
3951: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3952: print_log('failure from create_negotiation_header');
3953: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_UDA_FAIL');
3954: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3955: FND_MSG_PUB.ADD;
3956: RETURN;
3957: END IF;

Line 3954: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

3950: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id, 'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
3951: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3952: print_log('failure from create_negotiation_header');
3953: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_UDA_FAIL');
3954: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3955: FND_MSG_PUB.ADD;
3956: RETURN;
3957: END IF;
3958: print_log('Header UDA information inserted' );

Line 3968: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NO_LINES');

3964: AND ROWNUM=1;
3965: EXCEPTION
3966: WHEN No_Data_Found THEN
3967: print_log('No lines present for the given batch_id');
3968: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NO_LINES');
3969: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3970: FND_MSG_PUB.ADD;
3971: RETURN;
3972: END;

Line 3969: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

3965: EXCEPTION
3966: WHEN No_Data_Found THEN
3967: print_log('No lines present for the given batch_id');
3968: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NO_LINES');
3969: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3970: FND_MSG_PUB.ADD;
3971: RETURN;
3972: END;
3973: print_log('Before calling create_lines_with_children with auction_Header_id ' || x_auction_header_id);

Line 3984: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINE_FAIL');

3980: print_log('Lines information inserted for batch_id ' || p_batch_id || ' auction_header_id ' || x_auction_header_id
3981: || ' x_return_status ' || x_return_status);
3982: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3983: print_log('failure from create_lines_with_children');
3984: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINE_FAIL');
3985: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3986: FND_MSG_PUB.ADD;
3987: RETURN;
3988: END IF;

Line 3985: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

3981: || ' x_return_status ' || x_return_status);
3982: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3983: print_log('failure from create_lines_with_children');
3984: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINE_FAIL');
3985: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
3986: FND_MSG_PUB.ADD;
3987: RETURN;
3988: END IF;
3989:

Line 4054: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COMPPRIC_FAIL');

4050: END;
4051:
4052: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4053: print_log('Failure in complex pricing validation: p_batch_Id' || p_batch_Id);
4054: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COMPPRIC_FAIL');
4055: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4056: FND_MSG_PUB.ADD;
4057: RETURN;
4058: END IF;

Line 4055: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4051:
4052: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4053: print_log('Failure in complex pricing validation: p_batch_Id' || p_batch_Id);
4054: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_COMPPRIC_FAIL');
4055: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4056: FND_MSG_PUB.ADD;
4057: RETURN;
4058: END IF;
4059:

Line 4066: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINEUDA_FAIL');

4062: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP
4063: process_uda_attributes(p_batch_id, x_auction_header_id, rec.line_number, l_uda_template_id, 'PON_AUC_PRICES_EXT_ATTRS', x_return_status);
4064: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4065: print_log('failure in Line UDA insertion for line ' || rec.line_number);
4066: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINEUDA_FAIL');
4067: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4068: FND_MSG_PUB.ADD;
4069: RETURN;
4070: END IF;

Line 4067: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4063: process_uda_attributes(p_batch_id, x_auction_header_id, rec.line_number, l_uda_template_id, 'PON_AUC_PRICES_EXT_ATTRS', x_return_status);
4064: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4065: print_log('failure in Line UDA insertion for line ' || rec.line_number);
4066: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_LINEUDA_FAIL');
4067: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4068: FND_MSG_PUB.ADD;
4069: RETURN;
4070: END IF;
4071: END LOOP;

Line 4083: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_FAIL');

4079: print_Log('Supplier information inserted for batch_id ' || p_batch_id || ' auction_header_id ' || x_auction_header_id
4080: || ' x_return_status ' || x_return_status);
4081: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4082: print_log('failure from create_lines_with_children');
4083: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_FAIL');
4084: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4085: FND_MSG_PUB.ADD;
4086: RETURN;
4087: END IF;

Line 4084: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4080: || ' x_return_status ' || x_return_status);
4081: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4082: print_log('failure from create_lines_with_children');
4083: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_FAIL');
4084: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4085: FND_MSG_PUB.ADD;
4086: RETURN;
4087: END IF;
4088:

Line 4097: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_DOCNUM_FAIL');

4093: || ' x_return_status ' || x_return_status);
4094:
4095: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4096: print_log('Failure in document number procedure');
4097: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_DOCNUM_FAIL');
4098: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4099: FND_MSG_PUB.ADD;
4100: RETURN;
4101: END IF;

Line 4098: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4094:
4095: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4096: print_log('Failure in document number procedure');
4097: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_DOCNUM_FAIL');
4098: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4099: FND_MSG_PUB.ADD;
4100: RETURN;
4101: END IF;
4102:

Line 4110: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PUBLISH_FAIL');

4106: print_log('Invoking publish_negotiation for batch id ' || p_batch_id );
4107: publish_negotiation(x_auction_header_id, x_return_status);
4108: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4109: print_log('Failure in negotiation publish for p_batch_id ' || p_batch_id);
4110: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_PUBLISH_FAIL');
4111: FND_MSG_PUB.ADD;
4112: RETURN;
4113: END IF;
4114: print_Log('Negotiation published for batch id ' || p_batch_id );

Line 4195: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');

4191: (p_level,p_auction_Header_id,p_Line_number,null,null,null,po_uda_array,ego_value_pairs_table,x_return_status,l_errorcode,msgCount,msgData);
4192:
4193: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4194: print_log('failure from UDA import with l_errorcode ' || l_errorcode || ' x_return_status ' || x_return_status );
4195: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4196: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4197: FND_MSG_PUB.ADD;
4198: END IF;
4199:

Line 4196: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4192:
4193: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4194: print_log('failure from UDA import with l_errorcode ' || l_errorcode || ' x_return_status ' || x_return_status );
4195: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4196: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4197: FND_MSG_PUB.ADD;
4198: END IF;
4199:
4200: print_log(' UDA import completed for ' || p_level);

Line 4252: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');

4248: (p_level,p_auction_Header_id,p_Line_number,null,null,null,po_uda_array,ego_value_pairs_table,x_return_status,l_errorcode,msgCount,msgData);
4249:
4250: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4251: print_log('failure from UDA import with l_errorcode ' || l_errorcode || ' x_return_status ' || x_return_status );
4252: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4253: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4254: FND_MSG_PUB.ADD;
4255: END IF;
4256:

Line 4253: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4249:
4250: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
4251: print_log('failure from UDA import with l_errorcode ' || l_errorcode || ' x_return_status ' || x_return_status );
4252: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4253: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4254: FND_MSG_PUB.ADD;
4255: END IF;
4256:
4257: print_log(' UDA import completed for ' || p_level);

Line 4279: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');

4275: EXCEPTION
4276: WHEN OTHERS THEN
4277: print_log('Unexpected error in process_uda_attributes procedure: sqlerrm ' || SQLERRM);
4278: rollback;
4279: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4280: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4281: FND_MSG_PUB.ADD;
4282: x_return_status := 'E';
4283: END process_uda_attributes;

Line 4280: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);

4276: WHEN OTHERS THEN
4277: print_log('Unexpected error in process_uda_attributes procedure: sqlerrm ' || SQLERRM);
4278: rollback;
4279: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_UDA_FAIL');
4280: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
4281: FND_MSG_PUB.ADD;
4282: x_return_status := 'E';
4283: END process_uda_attributes;
4284:

Line 5227: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');

5223: );
5224:
5225: IF( x_return_status = 'E') THEN
5226: print_Log('process_negotiation_header: Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5227: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5228: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5229: FND_MSG_PUB.ADD;
5230: RETURN;
5231: END IF;

Line 5228: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5224:
5225: IF( x_return_status = 'E') THEN
5226: print_Log('process_negotiation_header: Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5227: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5228: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5229: FND_MSG_PUB.ADD;
5230: RETURN;
5231: END IF;
5232:

Line 5267: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');

5263: END;
5264:
5265: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
5266: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5267: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5268: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5269: FND_MSG_PUB.ADD;
5270: RETURN;
5271: END IF;

Line 5268: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5264:
5265: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
5266: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
5267: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_VAL_ERR');
5268: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5269: FND_MSG_PUB.ADD;
5270: RETURN;
5271: END IF;
5272:

Line 5295: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');

5291: x_return_status);
5292:
5293: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5294: print_Log('member addition in collab team failed' );
5295: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5296: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5297: FND_MSG_PUB.ADD;
5298: RETURN;
5299: END IF;

Line 5296: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5292:
5293: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5294: print_Log('member addition in collab team failed' );
5295: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5296: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5297: FND_MSG_PUB.ADD;
5298: RETURN;
5299: END IF;
5300:

Line 5309: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');

5305: print_log('Collobaration team created for batch id ' || p_batch_id);
5306:
5307: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5308: print_Log('Adding negotiation team member has failed for batch id ' || p_batch_id);
5309: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5310: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5311: FND_MSG_PUB.ADD;
5312: RETURN;
5313: END IF;

Line 5310: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5306:
5307: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5308: print_Log('Adding negotiation team member has failed for batch id ' || p_batch_id);
5309: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5310: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5311: FND_MSG_PUB.ADD;
5312: RETURN;
5313: END IF;
5314:

Line 5348: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');

5344: x_return_status);
5345: print_log('Header requirements inserted for for batch id ' || p_batch_id);
5346: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5347: print_Log('Header requirement creation has failed for for batch id ' || p_batch_id);
5348: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5349: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5350: FND_MSG_PUB.ADD;
5351: RETURN;
5352: END IF;

Line 5349: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5345: print_log('Header requirements inserted for for batch id ' || p_batch_id);
5346: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5347: print_Log('Header requirement creation has failed for for batch id ' || p_batch_id);
5348: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_NEGTEAM_ERR');
5349: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5350: FND_MSG_PUB.ADD;
5351: RETURN;
5352: END IF;
5353:

Line 5405: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_NULL_VALUES');

5401: );
5402: IF( null_check_status = FND_API.G_RET_STS_ERROR) THEN
5403: print_log('Some mandatory fields in pon_auction_headers_interface table are having null values. Please check '
5404: || ' pon_interface_errors table for more details');
5405: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_NULL_VALUES');
5406: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5407: FND_MSG_PUB.ADD;
5408: RAISE FND_API.G_EXC_ERROR;
5409: END IF;

Line 5406: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5402: IF( null_check_status = FND_API.G_RET_STS_ERROR) THEN
5403: print_log('Some mandatory fields in pon_auction_headers_interface table are having null values. Please check '
5404: || ' pon_interface_errors table for more details');
5405: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_NULL_VALUES');
5406: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5407: FND_MSG_PUB.ADD;
5408: RAISE FND_API.G_EXC_ERROR;
5409: END IF;
5410: print_Log('validate_header: columns are successfully validated for null values' );

Line 5482: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_INV_VALUES');

5478:
5479: IF (invalid_val_exist_flag = 'Y' ) THEN
5480: print_log('Some fields in pon_auction_headers_interface table are having invalid values. '
5481: || 'Please check pon_interface_errors table for more details');
5482: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_INV_VALUES');
5483: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5484: FND_MSG_PUB.ADD;
5485: RETURN;
5486: END IF;

Line 5483: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);

5479: IF (invalid_val_exist_flag = 'Y' ) THEN
5480: print_log('Some fields in pon_auction_headers_interface table are having invalid values. '
5481: || 'Please check pon_interface_errors table for more details');
5482: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HDR_INV_VALUES');
5483: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_id);
5484: FND_MSG_PUB.ADD;
5485: RETURN;
5486: END IF;
5487:

Line 6275: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_VAL_HEADER_ERR');

6271:
6272: EXCEPTION
6273: WHEN OTHERS THEN
6274: print_log('Exception in validate_Header procedure for batch_id ' || l_batch_id);
6275: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_VAL_HEADER_ERR');
6276: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
6277: FND_MSG_PUB.ADD;
6278:
6279: END validate_header;

Line 6276: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);

6272: EXCEPTION
6273: WHEN OTHERS THEN
6274: print_log('Exception in validate_Header procedure for batch_id ' || l_batch_id);
6275: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_VAL_HEADER_ERR');
6276: FND_MESSAGE.SET_TOKEN('BATCH_ID',l_batch_id);
6277: FND_MSG_PUB.ADD;
6278:
6279: END validate_header;
6280:

Line 6923: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_INIT_ERR');

6919:
6920: EXCEPTION
6921: WHEN OTHERS THEN
6922: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
6923: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_HEADER_INIT_ERR');
6924: FND_MSG_PUB.ADD;
6925: RAISE FND_API.G_EXC_ERROR;
6926:
6927: END init_rule_based_header_data;

Line 7013: FND_MESSAGE.SET_NAME('PON','PON_INT_TPSETUP_ERR');

7009:
7010: IF(p_error_code = 'E' ) THEN
7011: x_return_status := FND_API.G_RET_STS_ERROR;
7012: print_Log('Trading partner set up is not done.' );
7013: FND_MESSAGE.SET_NAME('PON','PON_INT_TPSETUP_ERR');
7014: FND_MSG_PUB.ADD;
7015: RETURN;
7016: END IF;
7017:

Line 7216: FND_MESSAGE.SET_NAME('PON','PON_INT_AMEND_FAIL');

7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7213: update pon_auc_price_differ_int SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7214: ELSE
7215: print_log('Amendment creation failed for batch ' || p_batch_id);
7216: FND_MESSAGE.SET_NAME('PON','PON_INT_AMEND_FAIL');
7217: FND_MSG_PUB.ADD;
7218: RAISE FND_API.G_EXC_ERROR;
7219: END IF;
7220:

Line 7253: FND_MESSAGE.SET_NAME('PON','PON_INT_HEADER_VAL_ERR');

7249: END;
7250:
7251: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
7252: print_Log('Error in pon_auction_headers_interface table. Please check pon_interface_errors for more details' );
7253: FND_MESSAGE.SET_NAME('PON','PON_INT_HEADER_VAL_ERR');
7254: FND_MSG_PUB.ADD;
7255: RAISE FND_API.G_EXC_ERROR;
7256: END IF;
7257: