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.OKC_MANAGE_DELIVERABLES_GRP dependencies on STANDARD

Line 805: -- Standard Start of API savepoint

801: ,'OKC_DEL_NO_PARAMS');
802: RAISE FND_API.G_EXC_ERROR;
803: END IF;
804:
805: -- Standard Start of API savepoint
806: SAVEPOINT g_activate_del_GRP;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 808: -- Standard call to check for call compatibility.

804:
805: -- Standard Start of API savepoint
806: SAVEPOINT g_activate_del_GRP;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:

Line 916: -- Standard call to get message count and if count is 1, get message info.

912: IF FND_API.To_Boolean( p_commit ) THEN
913: COMMIT WORK;
914: END IF;
915:
916: -- Standard call to get message count and if count is 1, get message info.
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
918:
919: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
920: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: Leaving activateDeliverables');

Line 1171: -- Standard Start of API savepoint

1167: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1169: END IF;
1170:
1171: -- Standard Start of API savepoint
1172: SAVEPOINT g_resolve_del_GRP;
1173:
1174: -- Standard call to check for call compatibility.
1175: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1174: -- Standard call to check for call compatibility.

1170:
1171: -- Standard Start of API savepoint
1172: SAVEPOINT g_resolve_del_GRP;
1173:
1174: -- Standard call to check for call compatibility.
1175: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:

Line 2022: -- Standard Start of API savepoint

2018: -- start procedure
2019: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2020: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2021: END IF;
2022: -- Standard Start of API savepoint
2023: SAVEPOINT g_update_del_GRP;
2024:
2025: -- Standard call to check for call compatibility.
2026: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2025: -- Standard call to check for call compatibility.

2021: END IF;
2022: -- Standard Start of API savepoint
2023: SAVEPOINT g_update_del_GRP;
2024:
2025: -- Standard call to check for call compatibility.
2026: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:

Line 2707: -- Standard Start of API savepoint

2703: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2704: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
2705: END IF;
2706:
2707: -- Standard Start of API savepoint
2708: SAVEPOINT g_enable_del_ntf_GRP;
2709:
2710: -- Standard call to check for call compatibility.
2711: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2710: -- Standard call to check for call compatibility.

2706:
2707: -- Standard Start of API savepoint
2708: SAVEPOINT g_enable_del_ntf_GRP;
2709:
2710: -- Standard call to check for call compatibility.
2711: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:

Line 2792: -- Standard Start of API savepoint

2788: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2789: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
2790: END IF;
2791:
2792: -- Standard Start of API savepoint
2793: SAVEPOINT g_cancel_del_GRP;
2794:
2795: -- Standard call to check for call compatibility.
2796: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2795: -- Standard call to check for call compatibility.

2791:
2792: -- Standard Start of API savepoint
2793: SAVEPOINT g_cancel_del_GRP;
2794:
2795: -- Standard call to check for call compatibility.
2796: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: END IF;
2799:

Line 2845: -- Standard call to get message count and if count is 1, get message info.

2841: IF FND_API.To_Boolean( p_commit ) THEN
2842: COMMIT WORK;
2843: END IF;
2844:
2845: -- Standard call to get message count and if count is 1, get message info.
2846: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2847:
2848: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');

Line 2911: -- Standard Start of API savepoint

2907: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2908: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
2909: END IF;
2910:
2911: -- Standard Start of API savepoint
2912: SAVEPOINT g_cancel2_del_GRP;
2913:
2914: -- Standard call to check for call compatibility.
2915: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2914: -- Standard call to check for call compatibility.

2910:
2911: -- Standard Start of API savepoint
2912: SAVEPOINT g_cancel2_del_GRP;
2913:
2914: -- Standard call to check for call compatibility.
2915: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2917: END IF;
2918:

Line 3030: -- Standard call to get message count and if count is 1, get message info.

3026: IF FND_API.To_Boolean( p_commit ) THEN
3027: COMMIT WORK;
3028: END IF;
3029:
3030: -- Standard call to get message count and if count is 1, get message info.
3031: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3032:
3033: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3034: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');

Line 3096: -- Standard Start of API savepoint

3092: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3093: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3094: END IF;
3095:
3096: -- Standard Start of API savepoint
3097: SAVEPOINT g_update_del_GRP;
3098:
3099: -- Standard call to check for call compatibility.
3100: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3099: -- Standard call to check for call compatibility.

3095:
3096: -- Standard Start of API savepoint
3097: SAVEPOINT g_update_del_GRP;
3098:
3099: -- Standard call to check for call compatibility.
3100: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: END IF;
3103:

Line 3126: -- Standard call to get message count and if count is 1, get message info.

3122: IF FND_API.To_Boolean( p_commit ) THEN
3123: COMMIT WORK;
3124: END IF;
3125:
3126: -- Standard call to get message count and if count is 1, get message info.
3127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3128:
3129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3130: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateDeliverables');

Line 3199: -- Standard Start of API savepoint

3195: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3197: END IF;
3198:
3199: -- Standard Start of API savepoint
3200: SAVEPOINT g_update2_del_GRP;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3202: -- Standard call to check for call compatibility.

3198:
3199: -- Standard Start of API savepoint
3200: SAVEPOINT g_update2_del_GRP;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206:

Line 3238: -- Standard call to get message count and if count is 1, get message info.

3234: IF FND_API.To_Boolean( p_commit ) THEN
3235: COMMIT WORK;
3236: END IF;
3237:
3238: -- Standard call to get message count and if count is 1, get message info.
3239: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3240:
3241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateBuyerDeliverables');

Line 3301: -- Standard Start of API savepoint

3297: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3298: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3299: END IF;
3300:
3301: -- Standard Start of API savepoint
3302: SAVEPOINT g_disable_del_GRP;
3303:
3304: -- Standard call to check for call compatibility.
3305: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3304: -- Standard call to check for call compatibility.

3300:
3301: -- Standard Start of API savepoint
3302: SAVEPOINT g_disable_del_GRP;
3303:
3304: -- Standard call to check for call compatibility.
3305: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:

Line 3349: -- Standard call to get message count and if count is 1, get message info.

3345: IF FND_API.To_Boolean( p_commit ) THEN
3346: COMMIT WORK;
3347: END IF;
3348:
3349: -- Standard call to get message count and if count is 1, get message info.
3350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3351:
3352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Leaving disableDeliverables');

Line 3416: -- Standard Start of API savepoint

3412: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3413: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3414: END IF;
3415:
3416: -- Standard Start of API savepoint
3417: SAVEPOINT g_update_del_GRP;
3418:
3419: -- Standard call to check for call compatibility.
3420: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3419: -- Standard call to check for call compatibility.

3415:
3416: -- Standard Start of API savepoint
3417: SAVEPOINT g_update_del_GRP;
3418:
3419: -- Standard call to check for call compatibility.
3420: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: END IF;
3423:

Line 3447: -- Standard call to get message count and if count is 1, get message info.

3443: IF FND_API.To_Boolean( p_commit ) THEN
3444: COMMIT WORK;
3445: END IF;
3446:
3447: -- Standard call to get message count and if count is 1, get message info.
3448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3449:
3450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables');

Line 3521: -- Standard Start of API savepoint

3517: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3518: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3519: END IF;
3520:
3521: -- Standard Start of API savepoint
3522: SAVEPOINT g_update2_del_GRP;
3523:
3524: -- Standard call to check for call compatibility.
3525: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3524: -- Standard call to check for call compatibility.

3520:
3521: -- Standard Start of API savepoint
3522: SAVEPOINT g_update2_del_GRP;
3523:
3524: -- Standard call to check for call compatibility.
3525: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3527: END IF;
3528:

Line 3561: -- Standard call to get message count and if count is 1, get message info.

3557: IF FND_API.To_Boolean( p_commit ) THEN
3558: COMMIT WORK;
3559: END IF;
3560:
3561: -- Standard call to get message count and if count is 1, get message info.
3562: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3563:
3564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables');

Line 3627: -- Standard Start of API savepoint

3623: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3624: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3625: END IF;
3626:
3627: -- Standard Start of API savepoint
3628: SAVEPOINT g_update_del_GRP;
3629:
3630: -- Standard call to check for call compatibility.
3631: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3630: -- Standard call to check for call compatibility.

3626:
3627: -- Standard Start of API savepoint
3628: SAVEPOINT g_update_del_GRP;
3629:
3630: -- Standard call to check for call compatibility.
3631: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633: END IF;
3634:

Line 3658: -- Standard call to get message count and if count is 1, get message info.

3654: IF FND_API.To_Boolean( p_commit ) THEN
3655: COMMIT WORK;
3656: END IF;
3657:
3658: -- Standard call to get message count and if count is 1, get message info.
3659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3660:
3661: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3662: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables ');

Line 3745: -- Standard Start of API savepoint

3741: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: p_from_external_party_id and p_from_external_party_site_id : '||p_from_external_party_site_id ||' and '||p_from_external_party_site_id);
3742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: p_to_external_party_id and p_to_external_party_site_id : '||p_to_external_party_site_id ||' and '||p_to_external_party_site_id);
3743: END IF;
3744:
3745: -- Standard Start of API savepoint
3746: SAVEPOINT g_update_del_GRP;
3747:
3748: -- Standard call to check for call compatibility.
3749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3748: -- Standard call to check for call compatibility.

3744:
3745: -- Standard Start of API savepoint
3746: SAVEPOINT g_update_del_GRP;
3747:
3748: -- Standard call to check for call compatibility.
3749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3751: END IF;
3752:

Line 3927: -- Standard Start of API savepoint

3923: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3924: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3925: END IF;
3926:
3927: -- Standard Start of API savepoint
3928: SAVEPOINT g_createHistory_GRP;
3929:
3930: -- Standard call to check for call compatibility.
3931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3930: -- Standard call to check for call compatibility.

3926:
3927: -- Standard Start of API savepoint
3928: SAVEPOINT g_createHistory_GRP;
3929:
3930: -- Standard call to check for call compatibility.
3931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934:

Line 4286: -- Standard Start of API savepoint

4282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: p_from_external_party_id and p_from_external_party_site_id : '||p_from_external_party_site_id ||' and '||p_from_external_party_site_id);
4283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: p_to_external_party_id and p_to_external_party_site_id : '||p_to_external_party_site_id ||' and '||p_to_external_party_site_id);
4284: END IF;
4285:
4286: -- Standard Start of API savepoint
4287: SAVEPOINT g_update_del_GRP;
4288:
4289: -- Standard call to check for call compatibility.
4290: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4289: -- Standard call to check for call compatibility.

4285:
4286: -- Standard Start of API savepoint
4287: SAVEPOINT g_update_del_GRP;
4288:
4289: -- Standard call to check for call compatibility.
4290: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4292: END IF;
4293:

Line 4402: -- Standard Start of API savepoint

4398: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
4400: END IF;
4401:
4402: -- Standard Start of API savepoint
4403: SAVEPOINT g_activatecloseout_del_GRP;
4404:
4405: -- Standard call to check for call compatibility.
4406: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4405: -- Standard call to check for call compatibility.

4401:
4402: -- Standard Start of API savepoint
4403: SAVEPOINT g_activatecloseout_del_GRP;
4404:
4405: -- Standard call to check for call compatibility.
4406: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END IF;
4409:

Line 4486: -- Standard call to get message count and if count is 1, get message info.

4482: IF FND_API.To_Boolean( p_commit ) THEN
4483: COMMIT WORK;
4484: END IF;
4485:
4486: -- Standard call to get message count and if count is 1, get message info.
4487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4488:
4489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving activateCloseoutDeliverables');

Line 4529: -- : (The check will only be made for a Standard PO, and only for 'CONTRACTUAL' deliverables)

4525: /*-- Start of comments
4526: --API name : applyPaymentHolds
4527: --Type : Private.
4528: --Function : 1. This API returns TRUE if the Invoices for the concerned PO need to be held.False otherwise
4529: -- : (The check will only be made for a Standard PO, and only for 'CONTRACTUAL' deliverables)
4530: -- : 2. It runs through the pay_when_paid deliverables associated with the concerned PO.
4531: -- : It returns true based on which checkbox is checked and by comparing the sysdate with the actual due date.
4532: --Usage : This public API will be used only by the PO team to determine if invoices need to be held for the PO because of any deliverable
4533: --Pre-reqs : None.

Line 4539: -- Header ID of the Standard Purchase Order

4535: --IN : p_api_version IN NUMBER Required
4536: -- : p_init_msg_list IN VARCHAR2 Optional
4537: -- Default = FND_API.G_FALSE
4538: -- : p_bus_doc_id IN NUMBER Required
4539: -- Header ID of the Standard Purchase Order
4540: -- : p_bus_doc_version IN NUMBER Required
4541: -- Version number of the Standard Purchase Order
4542: --OUT : x_return_status OUT VARCHAR2
4543: -- : x_msg_count OUT NUMBER

Line 4541: -- Version number of the Standard Purchase Order

4537: -- Default = FND_API.G_FALSE
4538: -- : p_bus_doc_id IN NUMBER Required
4539: -- Header ID of the Standard Purchase Order
4540: -- : p_bus_doc_version IN NUMBER Required
4541: -- Version number of the Standard Purchase Order
4542: --OUT : x_return_status OUT VARCHAR2
4543: -- : x_msg_count OUT NUMBER
4544: -- : x_msg_data OUT VARCHAR2(2000)
4545: --Note :

Line 4567: AND business_document_type = 'PO_STANDARD'

4563: ACTUAL_DUE_DATE
4564: FROM okc_deliverables
4565: WHERE business_document_id = p_bus_doc_id
4566: AND business_document_version = p_bus_doc_version
4567: AND business_document_type = 'PO_STANDARD'
4568: AND deliverable_type = 'CONTRACTUAL'
4569: AND responsible_party = 'SUPPLIER_ORG'
4570: AND (PAY_HOLD_PRIOR_DUE_DATE_YN = 'Y' OR PAY_HOLD_OVERDUE_YN = 'Y')
4571: AND deliverable_status NOT IN ('COMPLETED','CANCELLED','INACTIVE');

Line 4665: AND business_document_type = 'PO_STANDARD'

4661: PAY_HOLD_OVERDUE_YN,
4662: ACTUAL_DUE_DATE
4663: FROM okc_deliverables
4664: WHERE deliverable_id = p_deliverable_id
4665: AND business_document_type = 'PO_STANDARD'
4666: AND deliverable_type = 'CONTRACTUAL'
4667: AND responsible_party = 'SUPPLIER_ORG'
4668: AND (PAY_HOLD_PRIOR_DUE_DATE_YN = 'Y' OR PAY_HOLD_OVERDUE_YN = 'Y')
4669: AND deliverable_status NOT IN ('COMPLETED','CANCELLED','INACTIVE');