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_MSG_PUB

Line 455: FND_MSG_PUB.ADD;

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');
459:

Line 639: FND_MSG_PUB.ADD;

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');
643: BEGIN

Line 669: FND_MSG_PUB.ADD;

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

Line 781: FND_MSG_PUB.ADD;

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

Line 1210: FND_MSG_PUB.ADD;

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
1214: print_log('In delete condition');

Line 1234: FND_MSG_PUB.ADD;

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

Line 1641: FND_MSG_PUB.ADD;

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

Line 1733: FND_MSG_PUB.ADD;

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

Line 2151: FND_MSG_PUB.ADD;

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

Line 2331: FND_MSG_PUB.ADD;

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

Line 2404: FND_MSG_PUB.ADD;

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:
2408: SELECT Max(document_disp_line_number) INTO l_last_line_num

Line 2494: FND_MSG_PUB.ADD;

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:
2498: print_log('END Validating the data in scores interface table');

Line 2588: FND_MSG_PUB.ADD;

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:
2592: add_price_breaks(

Line 2604: FND_MSG_PUB.ADD;

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'
2608:

Line 2620: FND_MSG_PUB.ADD;

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:
2624: /*

Line 2784: FND_MSG_PUB.ADD;

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:
2788: PROCEDURE VAL_PRICE_BREAKS

Line 3795: FND_MSG_PUB.ADD;

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:
3799: FOR rec IN group_negotiations_cur LOOP

Line 3818: FND_MSG_PUB.ADD;

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;
3822: IF ( neg_return_status = 'S') THEN

Line 3858: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

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:
3861: EXCEPTION
3862: WHEN OTHERS THEN

Line 3865: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

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:
3869:

Line 3921: FND_MSG_PUB.ADD;

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:
3925: print_log('pon_open_interface_pvt.create_negotiation: before calling process_negotiation_header');

Line 3938: FND_MSG_PUB.ADD;

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
3942: || ' x_return_status ' || x_return_status);

Line 3955: FND_MSG_PUB.ADD;

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

Line 3970: FND_MSG_PUB.ADD;

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);
3974:

Line 3986: FND_MSG_PUB.ADD;

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:
3990: -- UDA data insertion for lines

Line 4056: FND_MSG_PUB.ADD;

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

Line 4068: FND_MSG_PUB.ADD;

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;
4072: print_Log('Line level UDA insertion completed successfully');

Line 4085: FND_MSG_PUB.ADD;

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:
4089: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN

Line 4099: FND_MSG_PUB.ADD;

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:
4103:

Line 4111: FND_MSG_PUB.ADD;

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 );
4115: END IF;*/

Line 4197: FND_MSG_PUB.ADD;

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);
4201:

Line 4254: FND_MSG_PUB.ADD;

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);
4258:

Line 4281: FND_MSG_PUB.ADD;

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:
4285:

Line 5229: FND_MSG_PUB.ADD;

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:
5233: print_log(' Initial set of validations done ');

Line 5269: FND_MSG_PUB.ADD;

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

Line 5297: FND_MSG_PUB.ADD;

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:
5301: -- add any additional member to collab team

Line 5311: FND_MSG_PUB.ADD;

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:
5315: BEGIN

Line 5350: FND_MSG_PUB.ADD;

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:
5354: EXCEPTION

Line 5407: FND_MSG_PUB.ADD;

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

Line 5484: FND_MSG_PUB.ADD;

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:
5488: print_Log('validate_header: columns are successfully validated for allowed values' );

Line 6277: FND_MSG_PUB.ADD;

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:
6281: PROCEDURE populate_neg_header_rec(p_batch_id IN NUMBER,

Line 6924: FND_MSG_PUB.ADD;

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

Line 7014: FND_MSG_PUB.ADD;

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:
7018: FOR rec IN group_amendments_cur LOOP

Line 7031: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

7027: );
7028:
7029: EXCEPTION
7030: WHEN OTHERS THEN
7031: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
7032: p_data => x_msg_data
7033: );
7034: print_log('Exception in amendment for batch_id ' || l_batch_id);
7035: print_log('Message data ' || x_msg_data);

Line 7079: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

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

Line 7217: FND_MSG_PUB.ADD;

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:
7221: -- Call to populate neg_header_record_data record

Line 7254: FND_MSG_PUB.ADD;

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

Line 7353: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

7349:
7350: EXCEPTION
7351: WHEN OTHERS THEN
7352: x_return_status := 'E';
7353: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
7354: p_data => x_msg_data);
7355:
7356: END create_amendment;
7357: