APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DELIVERABLE_PROCESS_PVT

Line 1: PACKAGE BODY OKC_DELIVERABLE_PROCESS_PVT AS

1: PACKAGE BODY OKC_DELIVERABLE_PROCESS_PVT AS
2: /* $Header: OKCVDPRB.pls 120.11.12010000.3 2009/01/19 06:28:23 strivedi ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- package variables

Line 45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_allowed (OVERLOADED) ');

41: C_delTypeExists_rec C_delTypeExists%ROWTYPE;
42: BEGIN
43:
44: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_allowed (OVERLOADED) ');
46: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
47: ,'101: p_deliverable_type = '||p_deliverable_type);
48: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
49: ,'102: p_target_doc_type = '||p_target_doc_type);

Line 131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.event_mapping_allowed ');

127: C_delTypeExists_rec C_delTypeExists%ROWTYPE;
128: BEGIN
129:
130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.event_mapping_allowed ');
132: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
133: ,'101: p_deliverable_type = '||p_deliverable_type);
134: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
135: ,'102: p_target_doc_type = '||p_target_doc_type);

Line 532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.attachment_exists ');

528:
529: BEGIN
530:
531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.attachment_exists ');
533: END IF;
534: OPEN att_cur;
535: FETCH att_cur INTO att_rec;
536: IF att_cur%FOUND THEN

Line 641: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment'||

637: BEGIN
638:
639: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
641: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment'||
642: 'p_source_doc_id = '||p_source_doc_id||
643: 'p_source_doc_type = '||p_source_doc_type||
644: 'p_target_doc_type = '||p_target_doc_type||
645: 'p_target_doc_number = '||p_target_doc_number||

Line 1272: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'122: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment' );

1268: END IF; -- IF p_copy_del_attachments_yn = 'Y'
1269:
1270: x_return_status := l_return_status;
1271: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1272: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'122: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment' );
1273: END IF;
1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN

Line 1278: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_ERROR');

1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN
1277: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_ERROR');
1279: END IF;
1280: IF del_cur %ISOPEN THEN
1281: CLOSE del_cur ;
1282: END IF;

Line 1290: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));

1286: p_data => x_msg_data
1287: );
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1289: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));
1291: END IF;
1292: IF del_cur %ISOPEN THEN
1293: CLOSE del_cur ;
1294: END IF;

Line 1303: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));

1299: );
1300:
1301: WHEN OTHERS THEN
1302: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1303: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));
1304: END IF;
1305: IF del_cur %ISOPEN THEN
1306: CLOSE del_cur ;
1307: END IF;

Line 1341: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.event_matches');

1337:
1338: BEGIN
1339:
1340: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1341: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.event_matches');
1342: END IF;
1343: OPEN event_cur;
1344: FETCH event_cur INTO event_rec;
1345: IF event_cur%FOUND THEN

Line 1958: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables');

1954: --End of ER Code Modifications
1955:
1956: BEGIN
1957: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1958: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables');
1959: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: budoc id is:'||to_char(p_target_doc_id));
1960: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: budoc type:'||p_target_doc_type);
1961: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: target contractual doctype:'||p_target_contractual_doctype);
1962: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: target response doctype:'||p_target_response_doctype);

Line 2986: '100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables');

2982: END IF;
2983: x_return_status := l_return_status;
2984: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
2986: '100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables');
2987: END IF;
2988: EXCEPTION
2989: WHEN FND_API.G_EXC_ERROR THEN
2990: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2992: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with G_EXC_ERROR: '||

2988: EXCEPTION
2989: WHEN FND_API.G_EXC_ERROR THEN
2990: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2991: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name
2992: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with G_EXC_ERROR: '||
2993: substr(sqlerrm,1,200));
2994: END IF;
2995: IF del_cur %ISOPEN THEN
2996: CLOSE del_cur ;

Line 3007: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with '||

3003:
3004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3005: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3006: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
3007: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with '||
3008: 'G_EXC_UNEXPECTED_ERROR :'||substr(sqlerrm,1,200));
3009: END IF;
3010: IF del_cur %ISOPEN THEN
3011: CLOSE del_cur ;

Line 3022: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with '||

3018:
3019: WHEN OTHERS THEN
3020: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3021: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
3022: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables with '||
3023: 'G_EXC_UNEXPECTED_ERROR :'||substr(sqlerrm,1,200));
3024: END IF;
3025: IF del_cur %ISOPEN THEN
3026: CLOSE del_cur ;

Line 3123: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables');

3119: BEGIN
3120:
3121: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
3123: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables');
3124: END IF;
3125:
3126:
3127: /*****

Line 4008: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables');

4004:
4005:
4006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4008: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables');
4009: END IF;
4010:
4011: x_return_status := l_return_status;
4012: EXCEPTION

Line 4016: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_ERROR'||

4012: EXCEPTION
4013: WHEN FND_API.G_EXC_ERROR THEN
4014: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4015: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name
4016: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_ERROR'||
4017: substr(sqlerrm,1,200));
4018: END IF;
4019: IF del_cur %ISOPEN THEN
4020: CLOSE del_cur ;

Line 4036: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_UNEXPECTED_ERROR'||

4032: );
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4034: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4035: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
4036: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_UNEXPECTED_ERROR'||
4037: substr(sqlerrm,1,200));
4038: END IF;
4039: IF del_cur %ISOPEN THEN
4040: CLOSE del_cur ;

Line 4057: ,'100: In when others leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));

4053:
4054: WHEN OTHERS THEN
4055: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4056: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
4057: ,'100: In when others leaving OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));
4058: END IF;
4059: IF del_cur %ISOPEN THEN
4060: CLOSE del_cur ;
4061: END IF;

Line 4143: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');

4139: BEGIN
4140:
4141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4143: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
4144: END IF;
4145: ----------------------------------------
4146: /*****
4147: 8i compatability bug#3307941

Line 4549: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');

4545: CLOSE del_cur ;
4546: END IF;*** end bug#3618448 **/
4547: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4549: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
4550: END IF;
4551:
4552: x_return_status := l_return_status;
4553: EXCEPTION

Line 4557: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_ERROR'||

4553: EXCEPTION
4554: WHEN FND_API.G_EXC_ERROR THEN
4555: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4556: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name
4557: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_ERROR'||
4558: substr(sqlerrm,1,200));
4559: END IF;
4560: IF del_cur %ISOPEN THEN
4561: CLOSE del_cur ;

Line 4572: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_UNEXPECTED_ERROR'||

4568:
4569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4570: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4571: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
4572: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_UNEXPECTED_ERROR'||
4573: substr(sqlerrm,1,200));
4574: END IF;
4575: IF del_cur %ISOPEN THEN
4576: CLOSE del_cur ;

Line 4587: ,'100: In when others leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));

4583:
4584: WHEN OTHERS THEN
4585: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4586: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
4587: ,'100: In when others leaving OKC_DELIVERABLE_PROCESS_PVT.version_deliverables with G_EXC_UNEXPECTED_ERROR'||substr(sqlerrm,1,200));
4588: END IF;
4589: IF del_cur %ISOPEN THEN
4590: CLOSE del_cur ;
4591: END IF;

Line 4720: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.clear_amendments with G_EXC_UNEXPECTED_ERROR'||

4716: EXCEPTION
4717: WHEN OTHERS THEN
4718: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4719: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
4720: ,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.clear_amendments with G_EXC_UNEXPECTED_ERROR'||
4721: substr(sqlerrm,1,200));
4722: END IF;
4723: -- close any open cursors
4724: IF def_cur %ISOPEN THEN

Line 4767: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES');

4763:
4764: BEGIN
4765: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4766: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
4767: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES');
4768: END IF;
4769: OPEN del_cur;
4770: FETCH del_cur BULK COLLECT INTO delIdTab;
4771: IF delIdTab.COUNT <> 0 THEN

Line 4787: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_ERROR');

4783:
4784: EXCEPTION
4785: WHEN FND_API.G_EXC_ERROR THEN
4786: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4787: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_ERROR');
4788: END IF;
4789: IF del_cur %ISOPEN THEN
4790: CLOSE del_cur ;
4791: END IF;

Line 4799: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_UNEXPECTED_ERROR');

4795: p_data => x_msg_data
4796: );
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4799: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_UNEXPECTED_ERROR');
4800: END IF;
4801: IF del_cur %ISOPEN THEN
4802: CLOSE del_cur ;
4803: END IF;

Line 4812: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_UNEXPECTED_ERROR');

4808: );
4809:
4810: WHEN OTHERS THEN
4811: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4812: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.DISABLE_DELIVERABLES with G_EXC_UNEXPECTED_ERROR');
4813: END IF;
4814: IF del_cur %ISOPEN THEN
4815: CLOSE del_cur ;
4816: END IF;

Line 4975: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS');

4971:
4972: BEGIN
4973:
4974: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4975: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS');
4976: END IF;
4977: IF p_cancel_yn = 'N' THEN
4978: OPEN del_activate_cur;
4979: FETCH del_activate_cur BULK COLLECT INTO delIdTab;

Line 5133: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS');

5129: **/
5130: END IF; -- if operation is for CANCELLED
5131:
5132: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5133: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS');
5134: END IF;
5135: x_return_status := l_return_status;
5136: EXCEPTION
5137: WHEN FND_API.G_EXC_ERROR THEN

Line 5139: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_ERROR');

5135: x_return_status := l_return_status;
5136: EXCEPTION
5137: WHEN FND_API.G_EXC_ERROR THEN
5138: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5139: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_ERROR');
5140: END IF;
5141: IF del_activate_cur %ISOPEN THEN
5142: CLOSE del_activate_cur ;
5143: END IF;

Line 5152: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_UNEXPECTED_ERROR');

5148: );
5149:
5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5151: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5152: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_UNEXPECTED_ERROR');
5153: END IF;
5154: IF del_activate_cur %ISOPEN THEN
5155: CLOSE del_activate_cur ;
5156: END IF;

Line 5165: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_UNEXPECTED_ERROR');

5161: );
5162:
5163: WHEN OTHERS THEN
5164: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5165: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CHANGE_DELIVERABLE_STATUS with G_EXC_UNEXPECTED_ERROR');
5166: END IF;
5167: IF del_activate_cur %ISOPEN THEN
5168: CLOSE del_activate_cur ;
5169: END IF;

Line 5203: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager');

5199: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5200:
5201: BEGIN
5202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5203: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager');
5204: END IF;
5205: --Initialize the return code
5206: retcode := 0;
5207: --Invoke overdue_del_notifier

Line 5221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager');

5217: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5218: RAISE OKC_API.G_EXCEPTION_ERROR;
5219: END IF;
5220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager');
5222: END IF;
5223: EXCEPTION
5224: WHEN E_Resource_Busy THEN
5225: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5226: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager with resource busy state');

5222: END IF;
5223: EXCEPTION
5224: WHEN E_Resource_Busy THEN
5225: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5226: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager with resource busy state');
5227: END IF;
5228: l_return_status := okc_api.g_ret_sts_error;
5229: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5230: WHEN OTHERS THEN

Line 5232: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager with G_EXC_UNEXPECTED_ERROR');

5228: l_return_status := okc_api.g_ret_sts_error;
5229: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5230: WHEN OTHERS THEN
5231: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5232: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager with G_EXC_UNEXPECTED_ERROR');
5233: END IF;
5234: retcode := 2;
5235: errbuf := substr(sqlerrm,1,200);
5236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier');

5301:
5302:
5303: BEGIN
5304: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier');
5306: END IF;
5307:
5308: -- call start_activity to create savepoint, check comptability
5309: -- and initialize message list

Line 5408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier');

5404:
5405: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
5406:
5407: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier');
5409: END IF;
5410:
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN

Line 5414: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));

5410:
5411: EXCEPTION
5412: WHEN FND_API.G_EXC_ERROR THEN
5413: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5414: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));
5415: END IF;
5416:
5417: IF del_cur %ISOPEN THEN
5418: CLOSE del_cur ;

Line 5428: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

5424: p_data => x_msg_data);
5425:
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5428: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
5429: END IF;
5430:
5431: IF del_cur %ISOPEN THEN
5432: CLOSE del_cur ;

Line 5442: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

5438: p_data => x_msg_data);
5439:
5440: WHEN OTHERS THEN
5441: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5442: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
5443: END IF;
5444:
5445: IF del_cur %ISOPEN THEN
5446: CLOSE del_cur ;

Line 5483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.beforedue_deliverable_manager');

5479: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5480:
5481: BEGIN
5482: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.beforedue_deliverable_manager');
5484: END IF;
5485: --Initialize the return code
5486: retcode := 0;
5487: --Invoke beforedue_del_notifier

Line 5503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_deliverable_manager');

5499: RAISE OKC_API.G_EXCEPTION_ERROR;
5500: END IF;
5501:
5502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_deliverable_manager');
5504: END IF;
5505: EXCEPTION
5506: WHEN E_Resource_Busy THEN
5507: l_return_status := okc_api.g_ret_sts_error;

Line 5569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier');

5565: k PLS_INTEGER := 0;
5566: BEGIN
5567:
5568: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier');
5570: END IF;
5571: -- call start_activity to create savepoint, check comptability
5572: -- and initialize message list
5573: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 5775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier');

5771: END IF;
5772: x_return_status := l_return_status;
5773: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
5774: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier');
5776: END IF;
5777: EXCEPTION
5778: WHEN FND_API.G_EXC_ERROR THEN
5779: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5780: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));

5776: END IF;
5777: EXCEPTION
5778: WHEN FND_API.G_EXC_ERROR THEN
5779: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5780: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));
5781: END IF;
5782: IF del_cur %ISOPEN THEN
5783: CLOSE del_cur ;
5784: END IF;

Line 5793: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

5789: );
5790:
5791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5792: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5793: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
5794: END IF;
5795: IF del_cur %ISOPEN THEN
5796: CLOSE del_cur ;
5797: END IF;

Line 5806: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

5802: );
5803:
5804: WHEN OTHERS THEN
5805: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5806: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.beforedue_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
5807: END IF;
5808: IF del_cur %ISOPEN THEN
5809: CLOSE del_cur ;
5810: END IF;

Line 5842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.escalation_deliverable_manager');

5838: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5839:
5840: BEGIN
5841: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.escalation_deliverable_manager');
5843: END IF;
5844: --Initialize the return code
5845: retcode := 0;
5846: --Invoke escalation_deliverable_notifier

Line 5862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.escalation_deliverable_manager');

5858: RAISE OKC_API.G_EXCEPTION_ERROR;
5859: END IF;
5860:
5861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.escalation_deliverable_manager');
5863: END IF;
5864: EXCEPTION
5865: WHEN E_Resource_Busy THEN
5866: l_return_status := okc_api.g_ret_sts_error;

Line 5929: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier');

5925: k PLS_INTEGER := 0;
5926: BEGIN
5927:
5928: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5929: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier');
5930: END IF;
5931: -- call start_activity to create savepoint, check comptability
5932: -- and initialize message list
5933: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 6131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier');

6127: END IF;
6128: x_return_status := l_return_status;
6129: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
6130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier');
6132: END IF;
6133:
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN

Line 6137: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));

6133:
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6137: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_ERROR:'||substr(sqlerrm,1,200));
6138: END IF;
6139: IF del_cur %ISOPEN THEN
6140: CLOSE del_cur ;
6141: END IF;

Line 6150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

6146: );
6147:
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
6151: END IF;
6152: IF del_cur %ISOPEN THEN
6153: CLOSE del_cur ;
6154: END IF;

Line 6163: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));

6159: );
6160:
6161: WHEN OTHERS THEN
6162: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6163: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.esc_del_notifier with G_EXC_UNEXPECTED_ERROR:'||substr(sqlerrm,1,200));
6164: END IF;
6165: IF del_cur %ISOPEN THEN
6166: CLOSE del_cur ;
6167: END IF;

Line 6205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_attachments');

6201:
6202: BEGIN
6203:
6204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_attachments');
6206: END IF;
6207: l_att_exists := attachment_exists(
6208: p_entity_name => p_entity_name
6209: ,p_pk1_value => p_pk1_value );

Line 6224: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_attachments');

6220: CLOSE att_cur;
6221: END IF;
6222: x_result := l_result;
6223: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6224: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_attachments');
6225: END IF;
6226: EXCEPTION
6227: WHEN OTHERS THEN
6228: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6229: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_attachments in OTHERS');

6225: END IF;
6226: EXCEPTION
6227: WHEN OTHERS THEN
6228: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6229: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_attachments in OTHERS');
6230: END IF;
6231: IF att_cur %ISOPEN THEN
6232: CLOSE att_cur ;
6233: END IF;

Line 6269: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables');

6265: l_deliverable_id NUMBER;
6266: BEGIN
6267:
6268: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6269: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables');
6270: END IF;
6271: IF p_doc_table.COUNT <> 0 THEN
6272: FOR i in 1.. p_doc_table.COUNT LOOP
6273: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables');

6285: END LOOP;
6286: END IF;
6287: x_return_status := l_return_status;
6288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables');
6290: END IF;
6291:
6292: EXCEPTION
6293: WHEN FND_API.G_EXC_ERROR THEN

Line 6295: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_ERROR');

6291:
6292: EXCEPTION
6293: WHEN FND_API.G_EXC_ERROR THEN
6294: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6295: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_ERROR');
6296: END IF;
6297: x_return_status := G_RET_STS_ERROR;
6298: FND_MSG_PUB.Count_And_Get(
6299: p_count => x_msg_count,

Line 6305: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');

6301: );
6302:
6303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6304: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6305: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');
6306: END IF;
6307: x_return_status := G_RET_STS_UNEXP_ERROR;
6308: FND_MSG_PUB.Count_And_Get(
6309: p_count => x_msg_count,

Line 6315: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');

6311: );
6312:
6313: WHEN OTHERS THEN
6314: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6315: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');
6316: END IF;
6317: x_return_status := G_RET_STS_UNEXP_ERROR;
6318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6319: END IF;

Line 6363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables');

6359: delIdTab delIdTabType;
6360: BEGIN
6361:
6362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6363: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables');
6364: END IF;
6365: -- Delete specific version of deliverables or all deliverables
6366: -- based on p_doc_version
6367: IF p_doc_version IS NULL THEN

Line 6402: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables');

6398: CLOSE del_version_cur ;
6399: END IF;
6400: x_return_status := l_result;
6401: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6402: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables');
6403: END IF;
6404:
6405: EXCEPTION
6406: WHEN FND_API.G_EXC_ERROR THEN

Line 6408: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_ERROR');

6404:
6405: EXCEPTION
6406: WHEN FND_API.G_EXC_ERROR THEN
6407: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6408: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_ERROR');
6409: END IF;
6410: IF del_cur %ISOPEN THEN
6411: CLOSE del_cur ;
6412: END IF;

Line 6424: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_UNEXPECTED_ERROR');

6420: );
6421:
6422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6423: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6424: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_UNEXPECTED_ERROR');
6425: END IF;
6426: IF del_cur %ISOPEN THEN
6427: CLOSE del_cur ;
6428: END IF;

Line 6440: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_UNEXPECTED_ERROR');

6436: );
6437:
6438: WHEN OTHERS THEN
6439: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6440: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverables with G_EXC_UNEXPECTED_ERROR');
6441: END IF;
6442: IF del_cur %ISOPEN THEN
6443: CLOSE del_cur ;
6444: END IF;

Line 6486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge');

6482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6483: BEGIN
6484:
6485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge');
6487: END IF;
6488: OPEN del_cur;
6489: FETCH del_cur BULK COLLECT INTO delIdTab;
6490: IF delIdTab.COUNT <> 0 THEN

Line 6503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge');

6499: IF del_cur %ISOPEN THEN
6500: CLOSE del_cur ;
6501: END IF;
6502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge');
6504: END IF;
6505: x_return_status := l_return_status;
6506: EXCEPTION
6507: WHEN FND_API.G_EXC_ERROR THEN

Line 6509: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_ERROR');

6505: x_return_status := l_return_status;
6506: EXCEPTION
6507: WHEN FND_API.G_EXC_ERROR THEN
6508: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6509: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_ERROR');
6510: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: error is:'||substr(sqlerrm,1,200));
6511: END IF;
6512: IF del_cur %ISOPEN THEN
6513: CLOSE del_cur ;

Line 6523: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_UNEXPECTED_ERROR');

6519: );
6520:
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6523: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_UNEXPECTED_ERROR');
6524: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: error is:'||substr(sqlerrm,1,200));
6525: END IF;
6526: IF del_cur %ISOPEN THEN
6527: CLOSE del_cur ;

Line 6537: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_UNEXPECTED_ERROR');

6533: );
6534:
6535: WHEN OTHERS THEN
6536: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6537: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.update_del_for_template_merge with G_EXC_UNEXPECTED_ERROR');
6538: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: error is:'||substr(sqlerrm,1,200));
6539: END IF;
6540: IF del_cur %ISOPEN THEN
6541: CLOSE del_cur ;

Line 6609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.get_last_amendment_date');

6605: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6606:
6607:
6608: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.get_last_amendment_date');
6610: END IF;
6611: OPEN del_cur;
6612: FETCH del_cur INTO l_date;
6613: /*bug# 3641366 IF l_date is null THEN

Line 6623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_last_amendment_date');

6619: CLOSE del_cur ;
6620: END IF;
6621:
6622: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_last_amendment_date');
6624: END IF;
6625: RETURN l_date;
6626:
6627: EXCEPTION

Line 6882: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates with OTHER ERROR');

6878: end if;
6879: EXCEPTION
6880: WHEN OTHERS THEN
6881: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6882: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates with OTHER ERROR');
6883: END IF;
6884: x_return_status := OKC_API.G_RET_STS_ERROR;
6885: FND_MSG_PUB.Count_And_Get(
6886: p_count => x_msg_count,

Line 6916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');

6912:
6913:
6914: BEGIN
6915: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
6917: END IF;
6918: OPEN fnd_user_cur;
6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN

Line 6954: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid');

6950: END IF;
6951: CLOSE fnd_user_cur;
6952: CLOSE contact_cur;
6953: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6954: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid');
6955: END IF;
6956:
6957: EXCEPTION
6958: WHEN OTHERS THEN

Line 6960: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');

6956:
6957: EXCEPTION
6958: WHEN OTHERS THEN
6959: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6960: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');
6961: END IF;
6962: IF fnd_user_cur %ISOPEN THEN
6963: CLOSE fnd_user_cur ;
6964: END IF;

Line 6996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists ');

6992:
6993: BEGIN
6994:
6995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists ');
6997: END IF;
6998: OPEN contact_cur;
6999: FETCH contact_cur INTO contact_rec;
7000: IF contact_cur%FOUND THEN

Line 7007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists');

7003: RETURN('N');
7004: END IF;
7005: CLOSE contact_cur;
7006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists');
7008: END IF;
7009: EXCEPTION
7010: WHEN OTHERS THEN
7011: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7012: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists with Exception');

7008: END IF;
7009: EXCEPTION
7010: WHEN OTHERS THEN
7011: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7012: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_exists with Exception');
7013: END IF;
7014: IF contact_cur %ISOPEN THEN
7015: CLOSE contact_cur ;
7016: END IF;

Line 7070: ||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid ');

7066: BEGIN
7067:
7068: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module
7070: ||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid ');
7071: END IF;
7072: OPEN contact_cur;
7073: FETCH contact_cur INTO contact_rec;
7074: IF contact_cur%FOUND THEN

Line 7083: ||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid');

7079: CLOSE contact_cur;
7080:
7081: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7082: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module
7083: ||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid');
7084: END IF;
7085: EXCEPTION
7086: WHEN OTHERS THEN
7087: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7088: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid with Exception');

7084: END IF;
7085: EXCEPTION
7086: WHEN OTHERS THEN
7087: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7088: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.external_contact_valid with Exception');
7089: END IF;
7090: IF contact_cur %ISOPEN THEN
7091: CLOSE contact_cur ;
7092: END IF;

Line 7122: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.get_lookup_meaning with exception');

7118:
7119: EXCEPTION
7120: WHEN OTHERS THEN
7121: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7122: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.get_lookup_meaning with exception');
7123: END IF;
7124:
7125: RETURN '';
7126: END get_lookup_meaning;

Line 7228: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with G_EXC_ERROR');

7224:
7225: EXCEPTION
7226: WHEN FND_API.G_EXC_ERROR THEN
7227: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7228: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with G_EXC_ERROR');
7229: END IF;
7230:
7231: x_return_status := G_RET_STS_ERROR;
7232:

Line 7236: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with G_EXC_UNEXPECTED_ERROR');

7232:
7233:
7234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7235: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7236: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with G_EXC_UNEXPECTED_ERROR');
7237: END IF;
7238:
7239: x_return_status := G_RET_STS_UNEXP_ERROR;
7240:

Line 7244: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with OTHERS EXCEPTION');

7240:
7241:
7242: WHEN OTHERS THEN
7243: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7244: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with OTHERS EXCEPTION');
7245: END IF;
7246:
7247: x_return_status := G_RET_STS_UNEXP_ERROR;
7248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 7405: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_ERROR');

7401:
7402: EXCEPTION
7403: WHEN FND_API.G_EXC_ERROR THEN
7404: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7405: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_ERROR');
7406: END IF;
7407:
7408: x_return_status := G_RET_STS_ERROR;
7409:

Line 7413: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_UNEXPECTED_ERROR');

7409:
7410:
7411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7412: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7413: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_UNEXPECTED_ERROR');
7414: END IF;
7415:
7416: x_return_status := G_RET_STS_UNEXP_ERROR;
7417:

Line 7421: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with OTHERS EXCEPTION');

7417:
7418:
7419: WHEN OTHERS THEN
7420: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7421: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with OTHERS EXCEPTION');
7422: END IF;
7423:
7424: x_return_status := G_RET_STS_UNEXP_ERROR;
7425: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 7469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid');

7465: l_sugg_message_txt FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7466:
7467: BEGIN
7468: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid');
7470: END IF;
7471: l_qa_result_tbl := px_qa_result_tbl;
7472: l_index := px_qa_result_tbl.count;
7473: l_start := px_qa_result_tbl.count;

Line 7575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_UNEXPECTED_ERROR');

7571:
7572:
7573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7574: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with G_EXC_UNEXPECTED_ERROR');
7576: END IF;
7577:
7578: x_return_status := G_RET_STS_UNEXP_ERROR;
7579:

Line 7583: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid with OTHERS EXCEPTION');

7579:
7580:
7581: WHEN OTHERS THEN
7582: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7583: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid with OTHERS EXCEPTION');
7584: END IF;
7585:
7586: x_return_status := G_RET_STS_UNEXP_ERROR;
7587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 7711: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with G_EXC_ERROR');

7707:
7708: EXCEPTION
7709: WHEN FND_API.G_EXC_ERROR THEN
7710: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7711: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with G_EXC_ERROR');
7712: END IF;
7713:
7714: x_return_status := G_RET_STS_ERROR;
7715:

Line 7719: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with G_EXC_UNEXPECTED_ERROR');

7715:
7716:
7717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7718: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7719: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with G_EXC_UNEXPECTED_ERROR');
7720: END IF;
7721:
7722: x_return_status := G_RET_STS_UNEXP_ERROR;
7723:

Line 7727: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with OTHERS EXCEPTION');

7723:
7724:
7725: WHEN OTHERS THEN
7726: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7727: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with OTHERS EXCEPTION');
7728: END IF;
7729:
7730: x_return_status := G_RET_STS_UNEXP_ERROR;
7731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 7793: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.check_due_dates ');

7789: l_index := px_qa_result_tbl.count;
7790: l_start := px_qa_result_tbl.count;
7791: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',l_qa_code);
7792: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7793: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.check_due_dates ');
7794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: deliverable_id: '||to_char(del_rec.deliverable_id));
7795: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: deliverable_name: '||del_rec.deliverable_name);
7796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: deliverable_name: '||del_rec.recurring_yn);
7797: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: fixed_start_date: '||del_rec.fixed_start_date);

Line 8083: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with G_EXC_ERROR');

8079:
8080: EXCEPTION
8081: WHEN FND_API.G_EXC_ERROR THEN
8082: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8083: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with G_EXC_ERROR');
8084: END IF;
8085: x_return_status := G_RET_STS_ERROR;
8086:
8087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8089: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with G_EXC_UNEXPECTED_ERROR');

8085: x_return_status := G_RET_STS_ERROR;
8086:
8087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8088: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8089: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with G_EXC_UNEXPECTED_ERROR');
8090: END IF;
8091:
8092: x_return_status := G_RET_STS_UNEXP_ERROR;
8093:

Line 8097: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with OTHERS EXCEPTION');

8093:
8094:
8095: WHEN OTHERS THEN
8096: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8097: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with OTHERS EXCEPTION');
8098: END IF;
8099:
8100: x_return_status := G_RET_STS_UNEXP_ERROR;
8101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 8185: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with G_EXC_ERROR');

8181:
8182: EXCEPTION
8183: WHEN FND_API.G_EXC_ERROR THEN
8184: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8185: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with G_EXC_ERROR');
8186: END IF;
8187:
8188: x_return_status := G_RET_STS_ERROR;
8189:

Line 8193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with G_EXC_UNEXPECTED_ERROR');

8189:
8190:
8191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8192: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with G_EXC_UNEXPECTED_ERROR');
8194: END IF;
8195:
8196: x_return_status := G_RET_STS_UNEXP_ERROR;
8197:

Line 8201: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with OTHERS EXCEPTION');

8197:
8198:
8199: WHEN OTHERS THEN
8200: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8201: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with OTHERS EXCEPTION');
8202: END IF;
8203:
8204: x_return_status := G_RET_STS_UNEXP_ERROR;
8205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 8697: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with G_EXC_ERROR');

8693: EXCEPTION
8694: WHEN FND_API.G_EXC_ERROR THEN
8695: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8696: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module
8697: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with G_EXC_ERROR');
8698: END IF;
8699: x_return_status := G_RET_STS_ERROR;
8700:
8701:

Line 8705: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with G_EXC_UNEXPECTED_ERROR');

8701:
8702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8703: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8704: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module
8705: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with G_EXC_UNEXPECTED_ERROR');
8706: END IF;
8707:
8708: x_return_status := G_RET_STS_UNEXP_ERROR;
8709:

Line 8714: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with OTHERS EXCEPTION');

8710:
8711: WHEN OTHERS THEN
8712: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module
8714: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with OTHERS EXCEPTION');
8715: END IF;
8716: x_return_status := G_RET_STS_UNEXP_ERROR;
8717:
8718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 8839: okc_debug.Set_Indentation('OKC_DELIVERABLE_PROCESS_PVT');

8835:
8836: BEGIN
8837:
8838: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8839: okc_debug.Set_Indentation('OKC_DELIVERABLE_PROCESS_PVT');
8840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'21300: Entered validate_deliverable_for_qa');
8841: END IF;
8842:
8843: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 9364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa');

9360: x_qa_return_status := l_qa_return_status;
9361:
9362:
9363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa');
9365: END IF;
9366:
9367: EXCEPTION
9368: WHEN FND_API.G_EXC_ERROR THEN

Line 9371: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with G_EXC_ERROR');

9367: EXCEPTION
9368: WHEN FND_API.G_EXC_ERROR THEN
9369:
9370: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9371: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with G_EXC_ERROR');
9372: END IF;
9373: --close cursors
9374: IF (del_cur%ISOPEN) THEN
9375: CLOSE del_cur ;

Line 9395: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with G_EXC_UNEXPECTED_ERROR');

9391:
9392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9393:
9394: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9395: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with G_EXC_UNEXPECTED_ERROR');
9396: END IF;
9397: --close cursors
9398: IF (del_cur%ISOPEN) THEN
9399: CLOSE del_cur ;

Line 9419: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with OTHERS EXCEPTION');

9415: );
9416:
9417: WHEN OTHERS THEN
9418: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9419: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with OTHERS EXCEPTION');
9420: END IF;
9421: --close cursors
9422: IF (del_cur%ISOPEN) THEN
9423: CLOSE del_cur ;

Line 9470: okc_debug.Set_Indentation('OKC_DELIVERABLE_PROCESS_PVT');

9466:
9467: BEGIN
9468:
9469: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9470: okc_debug.Set_Indentation('OKC_DELIVERABLE_PROCESS_PVT');
9471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'21300: Entered validate_deliverable_for_qa');
9472: END IF;
9473:
9474: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 9500: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach');

9496:
9497: x_return_status := l_return_status;
9498:
9499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9500: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach');
9501: END IF;
9502:
9503: EXCEPTION
9504: WHEN FND_API.G_EXC_ERROR THEN

Line 9506: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_ERROR');

9502:
9503: EXCEPTION
9504: WHEN FND_API.G_EXC_ERROR THEN
9505: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9506: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_ERROR');
9507: END IF;
9508:
9509: x_return_status := G_RET_STS_ERROR;
9510: FND_MSG_PUB.Count_And_Get(

Line 9517: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_UNEXPECTED_ERROR');

9513: );
9514:
9515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9516: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9517: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_UNEXPECTED_ERROR');
9518: END IF;
9519:
9520: x_return_status := G_RET_STS_UNEXP_ERROR;
9521: FND_MSG_PUB.Count_And_Get(

Line 9528: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with OTHERS EXCEPTION');

9524: );
9525:
9526: WHEN OTHERS THEN
9527: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9528: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with OTHERS EXCEPTION');
9529: END IF;
9530:
9531: x_return_status := G_RET_STS_UNEXP_ERROR;
9532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 9636: p_delid_tab IN OKC_DELIVERABLE_PROCESS_PVT.delIdTabType,

9632: p_doc_id IN NUMBER,
9633: p_doc_type IN VARCHAR2,
9634: p_doc_version IN NUMBER DEFAULT NULL,
9635: p_Conditional_Delete_Flag IN VARCHAR2 DEFAULT 'N',
9636: p_delid_tab IN OKC_DELIVERABLE_PROCESS_PVT.delIdTabType,
9637: x_msg_data OUT NOCOPY VARCHAR2,
9638: x_msg_count OUT NOCOPY NUMBER,
9639: x_return_status OUT NOCOPY VARCHAR2)
9640: IS

Line 9651: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');

9647:
9648: BEGIN
9649:
9650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9651: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
9652: END IF;
9653: FOR i IN p_delid_tab.FIRST..p_delid_tab.LAST LOOP
9654: l_del_id := p_delid_tab(i);
9655:

Line 9699: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');

9695:
9696: END LOOP;
9697:
9698: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9699: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
9700: END IF;
9701:
9702: EXCEPTION
9703: WHEN OTHERS THEN

Line 9845: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable'||to_char(p_del_id));

9841:
9842: BEGIN
9843:
9844: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9845: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable'||to_char(p_del_id));
9846: END IF;
9847: -- delete deliverables status history
9848: DELETE FROM okc_del_status_history
9849: WHERE deliverable_id = p_del_id;

Line 9862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable');

9858: WHERE deliverable_id = p_del_id;
9859: END IF;
9860: x_return_status := l_result;
9861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable');
9863: END IF;
9864:
9865: EXCEPTION
9866: WHEN FND_API.G_EXC_ERROR THEN

Line 9868: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_ERROR');

9864:
9865: EXCEPTION
9866: WHEN FND_API.G_EXC_ERROR THEN
9867: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9868: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_ERROR');
9869: END IF;
9870: x_return_status := G_RET_STS_ERROR;
9871: FND_MSG_PUB.Count_And_Get(
9872: p_count => x_msg_count,

Line 9878: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');

9874: );
9875:
9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9877: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9878: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');
9879: END IF;
9880: x_return_status := G_RET_STS_UNEXP_ERROR;
9881: FND_MSG_PUB.Count_And_Get(
9882: p_count => x_msg_count,

Line 9888: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');

9884: );
9885:
9886: WHEN OTHERS THEN
9887: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9888: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');
9889: END IF;
9890: x_return_status := G_RET_STS_UNEXP_ERROR;
9891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9892: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 9936: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables');

9932: l_result VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
9933: l_api_name CONSTANT VARCHAR2(30) :='delete_template_deliverables';
9934: BEGIN
9935: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9936: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables');
9937: END IF;
9938: OPEN del_cur;
9939: FETCH del_cur BULK COLLECT INTO delIdTab;
9940: -- bug#3188413 check count before loop

Line 9966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables');

9962: CLOSE del_cur ;
9963: END IF;
9964: x_return_status := l_result;
9965: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables');
9967: END IF;
9968:
9969: EXCEPTION
9970: WHEN OTHERS THEN

Line 9975: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables with G_EXC_UNEXPECTED_ERROR');

9971: IF del_cur %ISOPEN THEN
9972: CLOSE del_cur ;
9973: END IF;
9974: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9975: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables with G_EXC_UNEXPECTED_ERROR');
9976: END IF;
9977: x_return_status := G_RET_STS_UNEXP_ERROR;
9978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 10056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.deliverables_amended :'||del_rec.deliverable_type);

10052:
10053:
10054: FOR del_rec IN del_cur LOOP
10055: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: inside OKC_DELIVERABLE_PROCESS_PVT.deliverables_amended :'||del_rec.deliverable_type);
10057: END IF;
10058:
10059: --Repository change to look at internal_flag in okc_deliverable_types_b
10060: If (del_rec.internal_flag = 'Y') then

Line 10326: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_response_deliverables');

10322:
10323: BEGIN
10324: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10325: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
10326: ,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.copy_response_deliverables');
10327: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
10328: ,'100: target budoc id is:'||to_char(p_target_doc_id));
10329: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
10330: ,'100: target budoc id type:'||p_target_doc_type);

Line 11271: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');

11267:
11268: BEGIN
11269:
11270: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11271: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');
11272: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: budoc id is:'||to_char(p_target_doc_id));
11273: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: budoc type:'||p_target_doc_type);
11274: END IF;
11275: -- initialize the table type variable

Line 11644: '100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');

11640: END IF;
11641: x_return_status := l_return_status;
11642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,
11644: '100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');
11645: END IF;
11646:
11647:
11648: EXCEPTION

Line 11654: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');

11650: IF del_cur %ISOPEN THEN
11651: CLOSE del_cur ;
11652: END IF;
11653: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11654: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');
11655: END IF;
11656: x_return_status := G_RET_STS_UNEXP_ERROR;
11657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11658: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 11839: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Enterred OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers');

11835:
11836: BEGIN
11837:
11838: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11839: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Enterred OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers');
11840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'p_bus_doc_id: '|| to_char(p_bus_doc_id));
11841: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'p_bus_doc_version: '|| to_char(p_bus_doc_version));
11842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'p_bus_doc_type: '|| p_bus_doc_type);
11843: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'p_prev_del_active: '|| p_prev_del_active);

Line 12246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Leaving OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers');

12242:
12243:
12244:
12245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Leaving OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers');
12247: END IF;
12248:
12249:
12250: EXCEPTION

Line 12255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'Leaving OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers with G_EXC_UNEXPECTED_ERROR');

12251:
12252: WHEN OTHERS THEN
12253:
12254: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'Leaving OKC_DELIVERABLE_PROCESS_PVT.RestoreDelsToPrevDocVers with G_EXC_UNEXPECTED_ERROR');
12256: END IF;
12257:
12258: IF prev_vers_del_csr %ISOPEN THEN
12259: CLOSE prev_vers_del_csr;

Line 12284: END OKC_DELIVERABLE_PROCESS_PVT;

12280:
12281:
12282: /**************************/
12283:
12284: END OKC_DELIVERABLE_PROCESS_PVT;