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_API

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: 'PON_AUCTION_HEADERS_INTERFACE',
220: p_batch_id
221: );
222:
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: END IF;
225: END LOOP;
226:
227:

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: --END IF;
330: print_log( 'Defaulted Document Number '||l_document_number||' status '||l_return_status);
331:
332: IF ( l_return_status = 'E' ) THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: RETURN;
335: ELSE
336: x_return_status := 'S';
337: END IF;

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: l_status:=NULL;
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;

Line 456: RAISE FND_API.G_EXC_ERROR;

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');
459:
460: print_log('BEGIN of section insertion');

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632:
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;

Line 640: RAISE FND_API.G_EXC_ERROR;

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');
643: BEGIN
644: SELECT MAX(score)

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 670: RAISE FND_API.G_EXC_ERROR;

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');
673: INSERT
674: INTO pon_auction_attributes

Line 778: x_return_status := FND_API.G_RET_STS_ERROR;

774:
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;

Line 782: RAISE FND_API.G_EXC_ERROR;

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: -----------------------------------------------------------------------
785: --Start of Comments
786: --Name: acceptance_values_insert

Line 1207: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN

1203: create_members_in_collteam(batchid, c_interface_neg_team_rec.user_name,'N',c_interface_neg_team_rec.access_value,
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;

Line 1235: x_return_status := FND_API.G_RET_STS_ERROR;

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: -----------------------------------------------------------------------
1238: --Start of Comments
1239: --Name: create_members_in_collteam

Line 1336: x_return_status := FND_API.G_RET_STS_ERROR;

1332: AND PAH.ORG_ID = FSP.ORG_ID
1333: AND FSP.BUSINESS_GROUP_ID = PER.BUSINESS_GROUP_ID;
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: RETURN;
1338: END;
1339: END IF;
1340: IF NOT (check_uniqueness(l_user_id,auction_header_id,ispreparer)) THEN

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: -- need to raise the sql exception if any encountered
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: RETURN;
1410: END;
1411:
1412: ELSE

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR;

1417: FROM pon_auction_headers_all
1418: WHERE auction_header_id = l_auction_header_id;
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: print_Log('Error '|| SQLERRM );
1423: END;
1424: IF ((l_neg_team_enabled_flag = 'N') AND (ispreparer = 'N')) THEN
1425: RETURN;

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR;

1443: EXCEPTION
1444: WHEN No_Data_Found THEN
1445: l_user_id:=NULL;
1446: print_log('Invalid username');
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: RETURN;
1449: END;
1450: IF NOT (check_uniqueness(l_user_id,auction_header_id,ispreparer)) THEN
1451: print_Log('User name already exists');

Line 1452: x_return_status := FND_API.G_RET_STS_ERROR;

1448: RETURN;
1449: END;
1450: IF NOT (check_uniqueness(l_user_id,auction_header_id,ispreparer)) THEN
1451: print_Log('User name already exists');
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: -- Error message must be thrown
1454: RETURN;
1455: ELSE
1456: print_log('Inserting the record');

Line 1475: x_return_status := FND_API.G_RET_STS_ERROR;

1471:
1472: EXCEPTION
1473: WHEN OTHERS THEN
1474: print_Log('Exception encountered in create_members_in_collteam');
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: END create_members_in_collteam;
1477:
1478:
1479:

Line 1634: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1630: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
1631: );
1632: EXCEPTION
1633: WHEN No_Data_Found THEN
1634: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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' );

Line 1637: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN

1633: WHEN No_Data_Found THEN
1634: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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;

Line 1642: RAISE FND_API.G_EXC_ERROR;

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:
1645: print_log('PON_BID_PARTIES_INTERFACE validation completed');
1646:

Line 1734: RAISE FND_API.G_EXC_ERROR;

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:
1737: /* getting the amendment number */
1738: BEGIN

Line 2148: x_return_status := FND_API.G_RET_STS_ERROR;

2144: EXCEPTION
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;

Line 2152: RAISE FND_API.G_EXC_ERROR;

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:
2155: END line_level_validation;
2156:

Line 2328: x_return_status := FND_API.G_RET_STS_ERROR;

2324: l_status:=NULL;
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;

Line 2332: --RAISE FND_API.G_EXC_ERROR;

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;
2335: print_log('Validations of lines interface tables completed');
2336:

Line 2401: x_return_status := FND_API.G_RET_STS_ERROR;

2397: x_error_message
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;

Line 2491: x_return_status := FND_API.G_RET_STS_ERROR;

2487: END;
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;

Line 2585: x_return_status := FND_API.G_RET_STS_ERROR;

2581: l_status:=NULL;
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;

Line 2601: x_return_status := FND_API.G_RET_STS_ERROR;

2597: x_error_message
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;

Line 2617: x_return_status := FND_API.G_RET_STS_ERROR;

2613:
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;

Line 3792: x_return_status := FND_API.G_RET_STS_ERROR;

3788: p_error_code,
3789: p_error_message);
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;

Line 3796: RAISE FND_API.G_EXC_ERROR;

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:
3799: FOR rec IN group_negotiations_cur LOOP
3800: SAVEPOINT NEG_CREATION;

Line 3819: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3822: IF ( neg_return_status = 'S') THEN
3823: print_log('Negotiation with auction_header_id ' || l_auction_header_id || ' has been created for batch id ' || l_batch_id);

Line 3820: neg_return_status := FND_API.G_RET_STS_ERROR;

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;
3822: IF ( neg_return_status = 'S') THEN
3823: print_log('Negotiation with auction_header_id ' || l_auction_header_id || ' has been created for batch id ' || l_batch_id);
3824: UPDATE pon_auction_headers_interface

Line 3830: x_return_status := FND_API.G_RET_STS_ERROR;

3826: WHERE batch_id = l_batch_id;
3827: COMMIT;
3828: ELSE
3829: print_log('Negotiation creation has failed for batch id ' || l_batch_id);
3830: x_return_status := FND_API.G_RET_STS_ERROR;
3831: --ROLLBACK TO NEG_CREATION;
3832: IF ( l_auction_header_id IS NOT NULL ) THEN
3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;

Line 3855: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

3851: COMMIT;
3852: END IF;
3853: END LOOP;
3854:
3855: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
3856: x_return_status := FND_API.G_RET_STS_SUCCESS;
3857: END IF;
3858: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
3859: p_data => x_msg_data);

Line 3856: x_return_status := FND_API.G_RET_STS_SUCCESS;

3852: END IF;
3853: END LOOP;
3854:
3855: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
3856: x_return_status := FND_API.G_RET_STS_SUCCESS;
3857: END IF;
3858: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
3859: p_data => x_msg_data);
3860:

Line 3864: x_return_status := FND_API.G_RET_STS_ERROR;

3860:
3861: EXCEPTION
3862: WHEN OTHERS THEN
3863: print_log('Exception in create_negotiations procedure.');
3864: x_return_status := FND_API.G_RET_STS_ERROR;
3865: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
3866: p_data => x_msg_data);
3867: END create_negotiations;
3868:

Line 3890: x_return_status := FND_API.G_RET_STS_SUCCESS;

3886: dummy2 NUMBER;
3887:
3888: BEGIN
3889:
3890: x_return_status := FND_API.G_RET_STS_SUCCESS;
3891: print_log('pon_open_interface_pvt.create_negotiation begin');
3892: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3893: neg_header_record_data := l_empty_header_rec;
3894:

Line 3892: --x_return_status := FND_API.G_RET_STS_SUCCESS;

3888: BEGIN
3889:
3890: x_return_status := FND_API.G_RET_STS_SUCCESS;
3891: print_log('pon_open_interface_pvt.create_negotiation begin');
3892: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3893: neg_header_record_data := l_empty_header_rec;
3894:
3895: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

Line 3917: x_return_status := FND_API.G_RET_STS_ERROR;

3913: INTO dummy1
3914: FROM pon_auction_headers_Interface WHERE batch_id = p_batch_id;
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;

Line 3922: RAISE FND_API.G_EXC_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:
3925: print_log('pon_open_interface_pvt.create_negotiation: before calling process_negotiation_header');
3926: process_negotiation_header(

Line 3934: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

3930: x_return_status
3931: );
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;

Line 3951: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

3947: FROM pon_auction_Headers_all
3948: WHERE auction_header_id = x_auction_header_id;
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;

Line 3982: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

3978: x_return_status
3979: );
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;

Line 4049: x_return_status:=FND_API.G_RET_STS_SUCCESS;

4045: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
4046: );
4047: EXCEPTION
4048: WHEN No_Data_Found THEN
4049: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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);

Line 4052: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4048: WHEN No_Data_Found THEN
4049: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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;

Line 4064: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4060:
4061:
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;

Line 4081: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4077: x_return_status
4078: );
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;

Line 4095: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4091: END IF;
4092: print_Log('Document number created for auction_header_id ' || x_auction_header_id
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;

Line 4108: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4104: /*IF( neg_header_record_data.auction_published_flag = 'Y' ) THEN
4105: -- negotiation publish
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;

Line 4121: x_return_status := FND_API.G_RET_STS_ERROR;

4117:
4118: EXCEPTION
4119: WHEN OTHERS THEN
4120: print_log('Exception in create_negotiation');
4121: x_return_status := FND_API.G_RET_STS_ERROR;
4122: END create_negotiation;
4123:
4124: PROCEDURE process_uda_attributes(
4125: p_batch_id IN NUMBER,

Line 4185: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, ego_value_pairs_table);

4181:
4182: IF l_count > 0 THEN
4183: po_uda_array.extend;
4184: po_uda_array(1) := po_uda_usage_object.new_instance(p_uda_template_id,'GENERIC',NULL);
4185: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, ego_value_pairs_table);
4186: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', ego_value_pairs_table);
4187: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', ego_value_pairs_table);
4188: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', ego_value_pairs_table);
4189:

Line 4193: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

4189:
4190: PON_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS
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;

Line 4242: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, ego_value_pairs_table);

4238:
4239: IF l_count > 0 THEN
4240: po_uda_array.extend;
4241: po_uda_array(1) := po_uda_usage_object.new_instance(p_uda_template_id,'GENERIC',NULL);
4242: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, ego_value_pairs_table);
4243: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', ego_value_pairs_table);
4244: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', ego_value_pairs_table);
4245: PON_UDA_IMPORT_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', ego_value_pairs_table);
4246:

Line 4250: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

4246:
4247: PON_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS
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;

Line 4919: x_return_status := FND_API.G_RET_STS_ERROR;

4915:
4916: EXCEPTION
4917: WHEN OTHERS THEN
4918: print_log('Sqlcode ' || SQLCODE || 'sqlerrm ' || SQLERRM );
4919: x_return_status := FND_API.G_RET_STS_ERROR;
4920:
4921: END create_negotiation_header;
4922:
4923: PROCEDURE header_initial_validation(

Line 4983: RAISE FND_API.G_EXC_ERROR;

4979: l_exception_msg);
4980:
4981: IF ( l_row_in_hr <> 'Y' OR l_extra_info = 'Y'
4982: OR l_enterprise_relationship <> 'Y' ) THEN
4983: RAISE FND_API.G_EXC_ERROR;
4984: END IF;
4985: EXCEPTION
4986: WHEN OTHERS THEN
4987: INSERT INTO PON_INTERFACE_ERRORS

Line 5198: x_return_status:=FND_API.G_RET_STS_SUCCESS;

5194: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
5195: );
5196: EXCEPTION
5197: WHEN No_Data_Found THEN
5198: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5199: END;
5200:
5201: EXCEPTION
5202: WHEN OTHERS THEN

Line 5203: x_return_status := FND_API.G_RET_STS_ERROR;

5199: END;
5200:
5201: EXCEPTION
5202: WHEN OTHERS THEN
5203: x_return_status := FND_API.G_RET_STS_ERROR;
5204:
5205: END header_initial_validation;
5206:
5207: PROCEDURE process_negotiation_header(

Line 5262: x_return_status:=FND_API.G_RET_STS_SUCCESS;

5258: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
5259: );
5260: EXCEPTION
5261: WHEN No_Data_Found THEN
5262: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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' );

Line 5265: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN

5261: WHEN No_Data_Found THEN
5262: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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;

Line 5293: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN

5289: NULL,
5290: 'N',
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;

Line 5307: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN

5303: p_batch_id,
5304: x_return_status);
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;

Line 5337: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN

5333: SET approval_status = 'NOT_REQUIRED'
5334: WHERE auction_header_id = neg_header_record_data.auction_header_id;
5335: END IF;
5336:
5337: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN
5338: print_Log('member addition in collab team failed for batch id ' || p_batch_id);
5339: END IF;
5340:
5341: -- insert header requirements

Line 5346: IF( x_return_status = FND_API.G_RET_STS_ERROR) THEN

5342: create_header_attr_inter('N',
5343: p_batch_id,
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;

Line 5355: WHEN FND_API.G_EXC_ERROR THEN

5351: RETURN;
5352: END IF;
5353:
5354: EXCEPTION
5355: WHEN FND_API.G_EXC_ERROR THEN
5356: x_return_status := FND_API.G_RET_STS_ERROR;
5357: print_log('process_negotiation_header exception : ' || SQLCODE || SQLERRM );
5358: WHEN OTHERS THEN
5359: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5356: x_return_status := FND_API.G_RET_STS_ERROR;

5352: END IF;
5353:
5354: EXCEPTION
5355: WHEN FND_API.G_EXC_ERROR THEN
5356: x_return_status := FND_API.G_RET_STS_ERROR;
5357: print_log('process_negotiation_header exception : ' || SQLCODE || SQLERRM );
5358: WHEN OTHERS THEN
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360:

Line 5359: x_return_status := FND_API.G_RET_STS_ERROR;

5355: WHEN FND_API.G_EXC_ERROR THEN
5356: x_return_status := FND_API.G_RET_STS_ERROR;
5357: print_log('process_negotiation_header exception : ' || SQLCODE || SQLERRM );
5358: WHEN OTHERS THEN
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360:
5361: END process_negotiation_header;
5362:
5363:

Line 5402: IF( null_check_status = FND_API.G_RET_STS_ERROR) THEN

5398: null_check(
5399: p_batch_id,
5400: null_check_status
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);

Line 5408: RAISE FND_API.G_EXC_ERROR;

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' );
5411: END IF;
5412:

Line 6629: IF ( l_template_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

6625: p_document_level => 'HEADER',
6626: p_input_date => sysdate,
6627: x_return_status => l_template_return_status,
6628: x_err_msg => l_template_err_msg);
6629: IF ( l_template_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6630: print_log('Error in UDA template id defaulting');
6631: insert_error ('PON_IMPORT_UDA_TEMP_ERR',p_batch_id,'UDA_TEMPLATE_ID',
6632: NULL,fnd_global.user_id, fnd_global.login_id);
6633: RAISE FND_API.G_EXC_ERROR;

Line 6633: RAISE FND_API.G_EXC_ERROR;

6629: IF ( l_template_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6630: print_log('Error in UDA template id defaulting');
6631: insert_error ('PON_IMPORT_UDA_TEMP_ERR',p_batch_id,'UDA_TEMPLATE_ID',
6632: NULL,fnd_global.user_id, fnd_global.login_id);
6633: RAISE FND_API.G_EXC_ERROR;
6634: END IF;
6635: neg_header_record_data.uda_template_date := SYSDATE ;
6636: END IF;
6637:

Line 6641: RAISE FND_API.G_EXC_ERROR;

6637:
6638: EXCEPTION
6639: WHEN OTHERS THEN
6640: print_Log('Error in populate_neg_header_rec procedure' );
6641: RAISE FND_API.G_EXC_ERROR;
6642:
6643: END populate_neg_header_rec;
6644:
6645: PROCEDURE init_rule_based_header_data(p_is_amendment IN VARCHAR2,

Line 6925: RAISE FND_API.G_EXC_ERROR;

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;
6928:
6929:

Line 7011: x_return_status := FND_API.G_RET_STS_ERROR;

7007: p_error_code,
7008: p_error_message);
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;

Line 7047: x_return_status := FND_API.G_RET_STS_ERROR;

7043: COMMIT;
7044: ELSE
7045: print_log('Negotiation creation has failed for batch id ' || l_batch_id);
7046: -- return error status even if one batch fails
7047: x_return_status := FND_API.G_RET_STS_ERROR;
7048: --ROLLBACK TO NEG_CREATION;
7049: IF ( l_auction_header_id IS NOT NULL ) THEN
7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;

Line 7071: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

7067: COMMIT;
7068: END IF;
7069: END LOOP;
7070:
7071: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
7072: x_return_status := FND_API.G_RET_STS_SUCCESS;
7073: END IF;
7074:
7075: EXCEPTION

Line 7072: x_return_status := FND_API.G_RET_STS_SUCCESS;

7068: END IF;
7069: END LOOP;
7070:
7071: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
7072: x_return_status := FND_API.G_RET_STS_SUCCESS;
7073: END IF;
7074:
7075: EXCEPTION
7076: WHEN OTHERS THEN

Line 7078: x_return_status := FND_API.G_RET_STS_ERROR;

7074:
7075: EXCEPTION
7076: WHEN OTHERS THEN
7077: print_log('Exception in create_negotiations procedure.');
7078: x_return_status := FND_API.G_RET_STS_ERROR;
7079: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
7080: p_data => x_msg_data);
7081:
7082: END create_amendments;

Line 7175: x_return_status := FND_API.G_RET_STS_ERROR;

7171: AND PER.PERSON_ID = SUP.EMPLOYEE_ID
7172: AND EMP.user_name = l_tpc_name;
7173: EXCEPTION
7174: WHEN No_Data_Found THEN
7175: x_return_status := FND_API.G_RET_STS_ERROR;
7176: insert_error ('PON_INT_TPC_INV',p_batch_id,'TRADING_PARTNER_CONTACT_NAME',
7177: NULL,fnd_global.user_id, fnd_global.login_id);
7178:
7179: print_Log('trading parter name given is invalid for batch_id ' || p_batch_id );

Line 7180: RAISE FND_API.G_EXC_ERROR;

7176: insert_error ('PON_INT_TPC_INV',p_batch_id,'TRADING_PARTNER_CONTACT_NAME',
7177: NULL,fnd_global.user_id, fnd_global.login_id);
7178:
7179: print_Log('trading parter name given is invalid for batch_id ' || p_batch_id );
7180: RAISE FND_API.G_EXC_ERROR;
7181: END;
7182:
7183: IF(can_create_amendment(p_batch_id,l_tpc_id,l_auction_header_id)) THEN
7184: print_log('Ammendement can be created ' || x_return_status);

Line 7218: RAISE FND_API.G_EXC_ERROR;

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:
7221: -- Call to populate neg_header_record_data record
7222: -- This record will be used to insert data in pon_auction_headers_all table

Line 7248: x_return_status:=FND_API.G_RET_STS_SUCCESS;

7244: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
7245: );
7246: EXCEPTION
7247: WHEN No_Data_Found THEN
7248: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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' );

Line 7251: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN

7247: WHEN No_Data_Found THEN
7248: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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;

Line 7255: RAISE FND_API.G_EXC_ERROR;

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:
7258: print_log(' Header validations are completed ');
7259:

Line 7271: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

7267: FROM pon_auction_Headers_all
7268: WHERE auction_header_id = x_auction_header_id;
7269:
7270: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id,'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
7271: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7272: print_log('failure from create_amendment');
7273: insert_error ('PON_INT_UDA_ERR',p_batch_id,'UDA',
7274: NULL,fnd_global.user_id, fnd_global.login_id);
7275: RETURN;

Line 7286: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

7282: create_neg_team('N',
7283: p_batch_id,
7284: x_return_status);
7285:
7286: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7287: print_log('failure from create_neg_team');
7288: insert_error ('PON_INT_COLL_FAIL',p_batch_id,'COLLABORATION_TEAM',
7289: NULL,fnd_global.user_id, fnd_global.login_id);
7290: RAISE FND_API.G_EXC_ERROR;

Line 7290: RAISE FND_API.G_EXC_ERROR;

7286: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7287: print_log('failure from create_neg_team');
7288: insert_error ('PON_INT_COLL_FAIL',p_batch_id,'COLLABORATION_TEAM',
7289: NULL,fnd_global.user_id, fnd_global.login_id);
7290: RAISE FND_API.G_EXC_ERROR;
7291: END IF;
7292:
7293: print_log('Negotiation team members insertion completed');
7294:

Line 7300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

7296: create_header_attr_inter('N',
7297: p_batch_id,
7298: x_return_status);
7299:
7300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7301: print_log('failure from create_header_attr_inter');
7302: insert_error ('PON_INT_ATT_FAIL',p_batch_id,'HEADER_ATTRIBUTES',
7303: NULL,fnd_global.user_id, fnd_global.login_id);
7304: RAISE FND_API.G_EXC_ERROR;

Line 7304: RAISE FND_API.G_EXC_ERROR;

7300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7301: print_log('failure from create_header_attr_inter');
7302: insert_error ('PON_INT_ATT_FAIL',p_batch_id,'HEADER_ATTRIBUTES',
7303: NULL,fnd_global.user_id, fnd_global.login_id);
7304: RAISE FND_API.G_EXC_ERROR;
7305: END IF;
7306:
7307: print_log('Header requirements insertion completed');
7308:

Line 7316: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

7312: x_return_status
7313: );
7314: print_log('Lines information inserted for batch_id ' || p_batch_id || ' auction_header_id ' || x_auction_header_id
7315: || ' x_return_status ' || x_return_status);
7316: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7317: print_log('failure from create_lines_with_children');
7318: insert_error ('PON_INT_LINE_FAIL',p_batch_id,'LINE',
7319: NULL,fnd_global.user_id, fnd_global.login_id);
7320: RAISE FND_API.G_EXC_ERROR;

Line 7320: RAISE FND_API.G_EXC_ERROR;

7316: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7317: print_log('failure from create_lines_with_children');
7318: insert_error ('PON_INT_LINE_FAIL',p_batch_id,'LINE',
7319: NULL,fnd_global.user_id, fnd_global.login_id);
7320: RAISE FND_API.G_EXC_ERROR;
7321: END IF;
7322:
7323: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN
7324: SELECT uda_template_id INTO l_uda_template_id

Line 7331: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

7327: AND ROWNUM=1;
7328:
7329: FOR rec IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_Header_id = x_auction_header_id ) LOOP
7330: 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);
7331: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
7332: print_log('failure in Line UDA insertion for line ' || rec.line_number);
7333: insert_error ('PON_INT_LINEUDA_FAIL',p_batch_id,'LINE_UDA',
7334: NULL,fnd_global.user_id, fnd_global.login_id);
7335: RETURN;

Line 7346: RAISE FND_API.G_EXC_ERROR;

7342: ELSE
7343: print_log('Amendment can not be created for the auction_header_id given for batch ' || p_batch_id);
7344: insert_error ('PON_INT_AMENDCHECK_FAIL',p_batch_id,'AMENDMENT',
7345: NULL,fnd_global.user_id, fnd_global.login_id);
7346: RAISE FND_API.G_EXC_ERROR;
7347:
7348: END IF;
7349:
7350: EXCEPTION