DBA Data[Home] [Help]

APPS.PON_AWARD_PKG dependencies on PON_BID_BACKING_REQUISITIONS

Line 811: When completing award, copy all the PR references of lines awarded to pon_bid_backing_requisitions table.

807: --Bug : 14134092
808: l_is_line_type_enabled := PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => p_auction_header_id);
809:
810: /* Line structure changes project:
811: When completing award, copy all the PR references of lines awarded to pon_bid_backing_requisitions table.
812: We can award unsolicited lines and relate to solicited lines. So, we should copy all PR references to pon_bid_backing_requisitions*/
813:
814: --CLM-LnSc-st
815: --copy only IF(IS CLm PO, outcome document is award and if encumberence is 'on' and if Outcome Document is created.

Line 812: We can award unsolicited lines and relate to solicited lines. So, we should copy all PR references to pon_bid_backing_requisitions*/

808: l_is_line_type_enabled := PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => p_auction_header_id);
809:
810: /* Line structure changes project:
811: When completing award, copy all the PR references of lines awarded to pon_bid_backing_requisitions table.
812: We can award unsolicited lines and relate to solicited lines. So, we should copy all PR references to pon_bid_backing_requisitions*/
813:
814: --CLM-LnSc-st
815: --copy only IF(IS CLm PO, outcome document is award and if encumberence is 'on' and if Outcome Document is created.
816:

Line 5565: Procedure to copy all backing requisition Associated to SOl lines from pon_backing_requisitions to pon_bid_backing_requisitions.*/

5561: RETURN 0;
5562: END GET_SAVING_PERCENT_INCENTIVE;
5563:
5564: /*Line Type and Structure Changes Project:
5565: Procedure to copy all backing requisition Associated to SOl lines from pon_backing_requisitions to pon_bid_backing_requisitions.*/
5566:
5567: PROCEDURE create_pon_bid_back_req(p_auction_header_id IN NUMBER)
5568: IS
5569:

Line 5589: INSERT INTO pon_bid_backing_requisitions(auction_header_id,

5585:
5586: l_user_id := fnd_global.user_id;
5587: l_login_id := fnd_global.login_id;
5588:
5589: INSERT INTO pon_bid_backing_requisitions(auction_header_id,
5590: auction_line_number,
5591: bid_number,
5592: bid_line_number,
5593: requisition_header_id ,

Line 5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');

5619: AND paip.line_number = pbr.line_number);
5620:
5621: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5622: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'END: ');
5623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'Insert into pon_bid_backing_requisitions Succesful');
5624: END IF;
5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN

Line 5630: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'An exception occurred during the INSERT INTO pon_bid_backing_requisitions.

5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: IF (g_debug_mode = 'Y') THEN
5629: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5630: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, 'An exception occurred during the INSERT INTO pon_bid_backing_requisitions.
5631: Raising the exception.....');
5632: END IF;
5633: END IF;
5634: RAISE;