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 879: -- Standard Start of API savepoint

875: ,'OKC_DEL_NO_PARAMS');
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: -- Standard Start of API savepoint
880: SAVEPOINT g_activate_del_GRP;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

878:
879: -- Standard Start of API savepoint
880: SAVEPOINT g_activate_del_GRP;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:

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

986: IF FND_API.To_Boolean( p_commit ) THEN
987: COMMIT WORK;
988: END IF;
989:
990: -- Standard call to get message count and if count is 1, get message info.
991: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
992:
993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: Leaving activateDeliverables');

Line 1247: -- Standard Start of API savepoint

1243: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1245: END IF;
1246:
1247: -- Standard Start of API savepoint
1248: SAVEPOINT g_resolve_del_GRP;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

1246:
1247: -- Standard Start of API savepoint
1248: SAVEPOINT g_resolve_del_GRP;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:

Line 2125: -- Standard Start of API savepoint

2121: -- start procedure
2122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2123: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2124: END IF;
2125: -- Standard Start of API savepoint
2126: SAVEPOINT g_update_del_GRP;
2127:
2128: -- Standard call to check for call compatibility.
2129: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

2124: END IF;
2125: -- Standard Start of API savepoint
2126: SAVEPOINT g_update_del_GRP;
2127:
2128: -- Standard call to check for call compatibility.
2129: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: END IF;
2132:

Line 2827: -- Standard Start of API savepoint

2823: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2824: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
2825: END IF;
2826:
2827: -- Standard Start of API savepoint
2828: SAVEPOINT g_enable_del_ntf_GRP;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

2826:
2827: -- Standard Start of API savepoint
2828: SAVEPOINT g_enable_del_ntf_GRP;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END IF;
2834:

Line 2912: -- Standard Start of API savepoint

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

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

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

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

2961: IF FND_API.To_Boolean( p_commit ) THEN
2962: COMMIT WORK;
2963: END IF;
2964:
2965: -- Standard call to get message count and if count is 1, get message info.
2966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2967:
2968: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');

Line 3031: -- Standard Start of API savepoint

3027: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3029: END IF;
3030:
3031: -- Standard Start of API savepoint
3032: SAVEPOINT g_cancel2_del_GRP;
3033:
3034: -- Standard call to check for call compatibility.
3035: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3030:
3031: -- Standard Start of API savepoint
3032: SAVEPOINT g_cancel2_del_GRP;
3033:
3034: -- Standard call to check for call compatibility.
3035: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037: END IF;
3038:

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

3146: IF FND_API.To_Boolean( p_commit ) THEN
3147: COMMIT WORK;
3148: END IF;
3149:
3150: -- Standard call to get message count and if count is 1, get message info.
3151: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3152:
3153: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3154: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');

Line 3216: -- Standard Start of API savepoint

3212: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3213: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3214: END IF;
3215:
3216: -- Standard Start of API savepoint
3217: SAVEPOINT g_update_del_GRP;
3218:
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3215:
3216: -- Standard Start of API savepoint
3217: SAVEPOINT g_update_del_GRP;
3218:
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END IF;
3223:

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

3242: IF FND_API.To_Boolean( p_commit ) THEN
3243: COMMIT WORK;
3244: END IF;
3245:
3246: -- Standard call to get message count and if count is 1, get message info.
3247: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3248:
3249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateDeliverables');

Line 3319: -- Standard Start of API savepoint

3315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3317: END IF;
3318:
3319: -- Standard Start of API savepoint
3320: SAVEPOINT g_update2_del_GRP;
3321:
3322: -- Standard call to check for call compatibility.
3323: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3318:
3319: -- Standard Start of API savepoint
3320: SAVEPOINT g_update2_del_GRP;
3321:
3322: -- Standard call to check for call compatibility.
3323: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:

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

3354: IF FND_API.To_Boolean( p_commit ) THEN
3355: COMMIT WORK;
3356: END IF;
3357:
3358: -- Standard call to get message count and if count is 1, get message info.
3359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3360:
3361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateBuyerDeliverables');

Line 3421: -- Standard Start of API savepoint

3417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3418: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3419: END IF;
3420:
3421: -- Standard Start of API savepoint
3422: SAVEPOINT g_disable_del_GRP;
3423:
3424: -- Standard call to check for call compatibility.
3425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3420:
3421: -- Standard Start of API savepoint
3422: SAVEPOINT g_disable_del_GRP;
3423:
3424: -- Standard call to check for call compatibility.
3425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: END IF;
3428:

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

3465: IF FND_API.To_Boolean( p_commit ) THEN
3466: COMMIT WORK;
3467: END IF;
3468:
3469: -- Standard call to get message count and if count is 1, get message info.
3470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3471:
3472: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3473: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Leaving disableDeliverables');

Line 3536: -- Standard Start of API savepoint

3532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3534: END IF;
3535:
3536: -- Standard Start of API savepoint
3537: SAVEPOINT g_update_del_GRP;
3538:
3539: -- Standard call to check for call compatibility.
3540: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3535:
3536: -- Standard Start of API savepoint
3537: SAVEPOINT g_update_del_GRP;
3538:
3539: -- Standard call to check for call compatibility.
3540: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3542: END IF;
3543:

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

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

Line 3641: -- Standard Start of API savepoint

3637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3639: END IF;
3640:
3641: -- Standard Start of API savepoint
3642: SAVEPOINT g_update2_del_GRP;
3643:
3644: -- Standard call to check for call compatibility.
3645: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3640:
3641: -- Standard Start of API savepoint
3642: SAVEPOINT g_update2_del_GRP;
3643:
3644: -- Standard call to check for call compatibility.
3645: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3647: END IF;
3648:

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

3677: IF FND_API.To_Boolean( p_commit ) THEN
3678: COMMIT WORK;
3679: END IF;
3680:
3681: -- Standard call to get message count and if count is 1, get message info.
3682: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3683:
3684: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables');

Line 3747: -- Standard Start of API savepoint

3743: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3744: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
3745: END IF;
3746:
3747: -- Standard Start of API savepoint
3748: SAVEPOINT g_update_del_GRP;
3749:
3750: -- Standard call to check for call compatibility.
3751: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

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

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

3774: IF FND_API.To_Boolean( p_commit ) THEN
3775: COMMIT WORK;
3776: END IF;
3777:
3778: -- Standard call to get message count and if count is 1, get message info.
3779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3780:
3781: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables ');

Line 3865: -- Standard Start of API savepoint

3861: 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);
3862: 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);
3863: END IF;
3864:
3865: -- Standard Start of API savepoint
3866: SAVEPOINT g_update_del_GRP;
3867:
3868: -- Standard call to check for call compatibility.
3869: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

3864:
3865: -- Standard Start of API savepoint
3866: SAVEPOINT g_update_del_GRP;
3867:
3868: -- Standard call to check for call compatibility.
3869: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END IF;
3872:

Line 4051: -- Standard Start of API savepoint

4047: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||G_PKG_NAME ||'.'||l_api_name);
4049: END IF;
4050:
4051: -- Standard Start of API savepoint
4052: SAVEPOINT g_createHistory_GRP;
4053:
4054: -- Standard call to check for call compatibility.
4055: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

4050:
4051: -- Standard Start of API savepoint
4052: SAVEPOINT g_createHistory_GRP;
4053:
4054: -- Standard call to check for call compatibility.
4055: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4057: END IF;
4058:

Line 4431: -- Standard Start of API savepoint

4427: 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);
4428: 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);
4429: END IF;
4430:
4431: -- Standard Start of API savepoint
4432: SAVEPOINT g_update_del_GRP;
4433:
4434: -- Standard call to check for call compatibility.
4435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

4430:
4431: -- Standard Start of API savepoint
4432: SAVEPOINT g_update_del_GRP;
4433:
4434: -- Standard call to check for call compatibility.
4435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END IF;
4438:

Line 4547: -- Standard Start of API savepoint

4543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
4545: END IF;
4546:
4547: -- Standard Start of API savepoint
4548: SAVEPOINT g_activatecloseout_del_GRP;
4549:
4550: -- Standard call to check for call compatibility.
4551: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

4546:
4547: -- Standard Start of API savepoint
4548: SAVEPOINT g_activatecloseout_del_GRP;
4549:
4550: -- Standard call to check for call compatibility.
4551: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;
4554:

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

4627: IF FND_API.To_Boolean( p_commit ) THEN
4628: COMMIT WORK;
4629: END IF;
4630:
4631: -- Standard call to get message count and if count is 1, get message info.
4632: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4633:
4634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving activateCloseoutDeliverables');

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

4670: /*-- Start of comments
4671: --API name : applyPaymentHolds
4672: --Type : Private.
4673: --Function : 1. This API returns TRUE if the Invoices for the concerned PO need to be held.False otherwise
4674: -- : (The check will only be made for a Standard PO, and only for 'CONTRACTUAL' deliverables)
4675: -- : 2. It runs through the pay_when_paid deliverables associated with the concerned PO.
4676: -- : It returns true based on which checkbox is checked and by comparing the sysdate with the actual due date.
4677: --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
4678: --Pre-reqs : None.

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

4680: --IN : p_api_version IN NUMBER Required
4681: -- : p_init_msg_list IN VARCHAR2 Optional
4682: -- Default = FND_API.G_FALSE
4683: -- : p_bus_doc_id IN NUMBER Required
4684: -- Header ID of the Standard Purchase Order
4685: -- : p_bus_doc_version IN NUMBER Required
4686: -- Version number of the Standard Purchase Order
4687: --OUT : x_return_status OUT VARCHAR2
4688: -- : x_msg_count OUT NUMBER

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

4682: -- Default = FND_API.G_FALSE
4683: -- : p_bus_doc_id IN NUMBER Required
4684: -- Header ID of the Standard Purchase Order
4685: -- : p_bus_doc_version IN NUMBER Required
4686: -- Version number of the Standard Purchase Order
4687: --OUT : x_return_status OUT VARCHAR2
4688: -- : x_msg_count OUT NUMBER
4689: -- : x_msg_data OUT VARCHAR2(2000)
4690: --Note :

Line 4712: AND business_document_type = 'PO_STANDARD'

4708: ACTUAL_DUE_DATE
4709: FROM okc_deliverables
4710: WHERE business_document_id = p_bus_doc_id
4711: AND business_document_version = p_bus_doc_version
4712: AND business_document_type = 'PO_STANDARD'
4713: AND deliverable_type = 'CONTRACTUAL'
4714: AND responsible_party = 'SUPPLIER_ORG'
4715: AND (PAY_HOLD_PRIOR_DUE_DATE_YN = 'Y' OR PAY_HOLD_OVERDUE_YN = 'Y')
4716: AND deliverable_status NOT IN ('COMPLETED','CANCELLED','INACTIVE');

Line 4810: AND business_document_type = 'PO_STANDARD'

4806: PAY_HOLD_OVERDUE_YN,
4807: ACTUAL_DUE_DATE
4808: FROM okc_deliverables
4809: WHERE deliverable_id = p_deliverable_id
4810: AND business_document_type = 'PO_STANDARD'
4811: AND deliverable_type = 'CONTRACTUAL'
4812: AND responsible_party = 'SUPPLIER_ORG'
4813: AND (PAY_HOLD_PRIOR_DUE_DATE_YN = 'Y' OR PAY_HOLD_OVERDUE_YN = 'Y')
4814: AND deliverable_status NOT IN ('COMPLETED','CANCELLED','INACTIVE');