APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on FND_API

Line 411: RAISE FND_API.G_EXC_ERROR;

407: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
408: END IF;
409: Okc_Api.Set_Message(G_APP_NAME,
410: 'OKC_DEL_ERR_EVT_DTLS');
411: RAISE FND_API.G_EXC_ERROR;
412:
413: END;
414:
415: /* FUNCTION isQaMessageAlreadyExist(p_event_id NUMBER,

Line 461: RAISE FND_API.G_EXC_ERROR;

457: END IF;
458: IF p_event_id is NULL THEN
459: Okc_Api.Set_Message(G_APP_NAME,
460: 'OKC_DEL_NOT_RSLV_EVTS');
461: RAISE FND_API.G_EXC_ERROR;
462:
463: END IF;
464:
465: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 579: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

575: Carry forward original deliverable id. Copy attachments.
576: ***/
577: PROCEDURE copy_del_for_amendment (
578: p_api_version IN NUMBER,
579: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
580: p_source_doc_id IN NUMBER,
581: p_source_doc_type IN VARCHAR2,
582: p_target_doc_id IN NUMBER,
583: p_target_doc_type IN VARCHAR2,

Line 813: RAISE FND_API.G_EXC_ERROR;

809: -- raise error if could not resolve target event id
810: IF l_target_start_event_id is null THEN
811: Okc_Api.Set_Message(G_APP_NAME
812: ,'OKC_DEL_COULD_NT_RESOLVE_EVT');
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815: END IF; -- IF delRecTab(i).RELATIVE_ST_DATE_EVENT_ID is not null
816:
817: IF delRecTab(i).RELATIVE_END_DATE_EVENT_ID is not null THEN

Line 831: RAISE FND_API.G_EXC_ERROR;

827: -- raise error if could not resolve target event id
828: IF l_target_end_event_id is null THEN
829: Okc_Api.Set_Message(G_APP_NAME
830: ,'OKC_DEL_COULD_NT_RESOLVE_EVT');
831: RAISE FND_API.G_EXC_ERROR;
832: END IF;
833: END IF; -- IF delRecTab(i).RELATIVE_END_DATE_EVENT_ID is not null
834:
835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1276: WHEN FND_API.G_EXC_ERROR 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
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

Line 1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1284: FND_MSG_PUB.Count_And_Get(
1285: p_count => x_msg_count,
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

Line 1887: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

1883: ***/
1884:
1885: PROCEDURE copy_deliverables (
1886: p_api_version IN NUMBER,
1887: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
1888: p_source_doc_id IN NUMBER,
1889: p_source_doc_type IN VARCHAR2,
1890: p_target_doc_id IN NUMBER,
1891: p_target_doc_type IN VARCHAR2,

Line 2989: WHEN FND_API.G_EXC_ERROR 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
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));

Line 3004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3000: p_count => x_msg_count,
3001: p_data => x_msg_data
3002: );
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));

Line 3667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3663: x_msg_count => l_msg_count,
3664: x_return_status => l_return_status);
3665:
3666: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3668: END IF;
3669:
3670: END IF;
3671: IF del_ins_cur %ISOPEN THEN

Line 4013: WHEN FND_API.G_EXC_ERROR THEN

4009: END IF;
4010:
4011: x_return_status := l_return_status;
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));

Line 4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4029: FND_MSG_PUB.Count_And_Get(
4030: p_count => x_msg_count,
4031: p_data => x_msg_data
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));

Line 4554: WHEN FND_API.G_EXC_ERROR THEN

4550: END IF;
4551:
4552: x_return_status := l_return_status;
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));

Line 4569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4565: p_count => x_msg_count,
4566: p_data => x_msg_data
4567: );
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));

Line 4785: WHEN FND_API.G_EXC_ERROR THEN

4781: END IF;
4782: x_return_status := l_return_status;
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

Line 4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4793: FND_MSG_PUB.Count_And_Get(
4794: p_count => x_msg_count,
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

Line 4885: WHEN FND_API.G_EXC_ERROR THEN

4881: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving ');
4882: END IF;
4883: x_return_status := l_return_status;
4884: EXCEPTION
4885: WHEN FND_API.G_EXC_ERROR THEN
4886: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4887: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
4888: END IF;
4889: x_return_status := G_RET_STS_ERROR;

Line 4895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4891: p_count => x_msg_count,
4892: p_data => x_msg_data
4893: );
4894:
4895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4896: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4897: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
4898: END IF;
4899: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 5051: p_init_msg_list => FND_API.G_FALSE ,

5047: -- disable deliverables that are currently being managed.
5048: -- before activating deliverables on new version
5049: disable_deliverables (
5050: p_api_version => l_api_version ,
5051: p_init_msg_list => FND_API.G_FALSE ,
5052: p_doc_id => p_doc_id ,
5053: p_doc_version => p_doc_version ,
5054: p_doc_type => p_doc_type ,
5055: x_msg_data => l_msg_data ,

Line 5125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5121: ,delStsTab(i).LAST_UPDATE_LOGIN
5122: );
5123: END LOOP;
5124: ELSE
5125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5126: END IF;
5127: END IF;
5128: CLOSE del_cancel_cur;
5129: **/

Line 5137: WHEN FND_API.G_EXC_ERROR 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
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

Line 5150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5146: p_count => x_msg_count,
5147: p_data => x_msg_data
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

Line 5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5242: END LOOP;
5243: END IF;
5244: FND_MSG_PUB.initialize;
5245:

Line 5346: p_init_msg_list => FND_API.G_TRUE,

5342: to_char(selected_dels(i).deliverable_id));
5343:
5344: okc_deliverable_wf_pvt.deliverables_notifier(
5345: p_api_version => 1.0,
5346: p_init_msg_list => FND_API.G_TRUE,
5347: p_deliverable_id => selected_dels(i).deliverable_id,
5348: p_deliverable_name => selected_dels(i).deliverable_name,
5349: p_deliverable_type => selected_dels(i).deliverable_type,
5350: p_business_document_id => selected_dels(i).business_document_id,

Line 5412: WHEN FND_API.G_EXC_ERROR 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
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:

Line 5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5422: FND_MSG_PUB.Count_And_Get(
5423: p_count => x_msg_count,
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:

Line 5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5507: l_return_status := okc_api.g_ret_sts_error;
5508: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5509: IF FND_MSG_PUB.Count_Msg > 0 Then
5510: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5512: END LOOP;
5513: END IF;
5514: FND_MSG_PUB.initialize;
5515: WHEN OTHERS THEN

Line 5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5524: END LOOP;
5525: END IF;
5526: FND_MSG_PUB.initialize;
5527:

Line 5711: p_init_msg_list => FND_API.G_TRUE,

5707: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100:Del Id :'||to_char(delRecTab(i).deliverable_id));
5708: END IF;
5709: okc_deliverable_wf_pvt.deliverables_notifier(
5710: p_api_version => 1.0,
5711: p_init_msg_list => FND_API.G_TRUE,
5712: p_deliverable_id => delRecTab(i).deliverable_id,
5713: p_deliverable_name => delRecTab(i).deliverable_name,
5714: p_deliverable_type => delRecTab(i).deliverable_type,
5715: p_business_document_id => delRecTab(i).business_document_id,

Line 5778: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5787: p_count => x_msg_count,
5788: p_data => x_msg_data
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

Line 5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5866: l_return_status := okc_api.g_ret_sts_error;
5867: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5868: IF FND_MSG_PUB.Count_Msg > 0 Then
5869: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5871: END LOOP;
5872: END IF;
5873: FND_MSG_PUB.initialize;
5874: WHEN OTHERS THEN

Line 5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5883: END LOOP;
5884: END IF;
5885: FND_MSG_PUB.initialize;
5886:

Line 6068: p_init_msg_list => FND_API.G_TRUE,

6064: IF trunc(l_notification_date) = trunc(sysdate) OR
6065: trunc(l_notification_date) < trunc(sysdate) THEN -- call to notifier
6066: okc_deliverable_wf_pvt.deliverables_notifier(
6067: p_api_version => 1.0,
6068: p_init_msg_list => FND_API.G_TRUE,
6069: p_deliverable_id => delRecTab(i).deliverable_id,
6070: p_deliverable_name => delRecTab(i).deliverable_name,
6071: p_deliverable_type => delRecTab(i).deliverable_type,
6072: p_business_document_id => delRecTab(i).business_document_id,

Line 6135: WHEN FND_API.G_EXC_ERROR 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
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

Line 6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6144: p_count => x_msg_count,
6145: p_data => x_msg_data
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

Line 6254: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

6250: delete the deliverable, status history and attachments.
6251: ***/
6252: PROCEDURE purge_doc_deliverables (
6253: p_api_version IN NUMBER,
6254: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
6255: p_doc_table IN OKC_TERMS_UTIL_GRP.doc_tbl_type,
6256: x_msg_data OUT NOCOPY VARCHAR2,
6257: x_msg_count OUT NOCOPY NUMBER,
6258: x_return_status OUT NOCOPY VARCHAR2)

Line 6293: WHEN FND_API.G_EXC_ERROR 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
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;

Line 6303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6299: p_count => x_msg_count,
6300: p_data => x_msg_data
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;

Line 6406: WHEN FND_API.G_EXC_ERROR 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
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

Line 6422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6418: p_count => x_msg_count,
6419: p_data => x_msg_data
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

Line 6507: WHEN FND_API.G_EXC_ERROR 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
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;

Line 6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6517: p_count => x_msg_count,
6518: p_data => x_msg_data
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;

Line 6560: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6556: /*** added new signature bug#3192512**/
6557:
6558: FUNCTION get_last_amendment_date (
6559: p_api_version IN NUMBER
6560: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6561:
6562: ,x_return_status OUT NOCOPY VARCHAR2
6563: ,x_msg_data OUT NOCOPY VARCHAR2
6564: ,x_msg_count OUT NOCOPY NUMBER

Line 7226: WHEN FND_API.G_EXC_ERROR THEN

7222: x_return_status := l_return_status;
7223: px_qa_result_tbl := l_qa_result_tbl;
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:

Line 7234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7230:
7231: x_return_status := G_RET_STS_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:

Line 7403: WHEN FND_API.G_EXC_ERROR THEN

7399: x_return_status := l_return_status;
7400: px_qa_result_tbl := l_qa_result_tbl;
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:

Line 7411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7407:
7408: x_return_status := G_RET_STS_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:

Line 7565: WHEN FND_API.G_EXC_ERROR THEN

7561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'leaving check_internal_contacts_valid without error');
7563: END IF;
7564: EXCEPTION
7565: WHEN FND_API.G_EXC_ERROR THEN
7566: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7567: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving check_internal_contacts_valid with G_EXC_ERROR');
7568: END IF;
7569:

Line 7573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7569:
7570: x_return_status := G_RET_STS_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:

Line 7709: WHEN FND_API.G_EXC_ERROR THEN

7705: x_return_status := l_return_status;
7706: px_qa_result_tbl := l_qa_result_tbl;
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:

Line 7717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7713:
7714: x_return_status := G_RET_STS_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:

Line 8081: WHEN FND_API.G_EXC_ERROR THEN

8077: x_return_status := l_return_status;
8078: px_qa_result_tbl := l_qa_result_tbl;
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;

Line 8087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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
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:

Line 8183: WHEN FND_API.G_EXC_ERROR THEN

8179: x_return_status := l_return_status;
8180: px_qa_result_tbl := l_qa_result_tbl;
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:

Line 8191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8187:
8188: x_return_status := G_RET_STS_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:

Line 8658: RAISE FND_API.G_EXC_ERROR;

8654: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',l_qa_code);
8655:
8656: l_doc_type_class := getDocTypeClass(p_bus_doctype => del_rec.business_document_type);
8657: If (l_doc_type_class IS NULL) then
8658: RAISE FND_API.G_EXC_ERROR;
8659: End If;
8660: l_del_type_int_flag := getDelTypeIntFlag(p_document_type_class => l_doc_type_class
8661: ,p_deliverable_type => del_rec.deliverable_type);
8662: If (l_del_type_int_flag IS NULL) then

Line 8663: RAISE FND_API.G_EXC_ERROR;

8659: End If;
8660: l_del_type_int_flag := getDelTypeIntFlag(p_document_type_class => l_doc_type_class
8661: ,p_deliverable_type => del_rec.deliverable_type);
8662: If (l_del_type_int_flag IS NULL) then
8663: RAISE FND_API.G_EXC_ERROR;
8664: End If;
8665:
8666: If (l_doc_type_class = 'REPOSITORY'
8667: AND l_del_type_int_flag = 'N'

Line 8694: WHEN FND_API.G_EXC_ERROR THEN

8690: px_qa_result_tbl := l_qa_result_tbl;
8691:
8692:
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;

Line 8702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8698: END IF;
8699: x_return_status := G_RET_STS_ERROR;
8700:
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;

Line 8738: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

8734: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8735: */
8736: PROCEDURE validate_deliverable_for_qa (
8737: p_api_version IN NUMBER,
8738: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8739: p_doc_type IN VARCHAR2,
8740: p_doc_id IN NUMBER,
8741: p_mode IN VARCHAR2,
8742: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,

Line 8850: RAISE FND_API.G_EXC_ERROR;

8846: x_return_status);
8847: IF p_doc_id = NULL THEN
8848: Okc_Api.Set_Message(G_APP_NAME
8849: ,'OKC_DEL_NO_PARAMS');
8850: RAISE FND_API.G_EXC_ERROR;
8851: END IF;
8852: IF p_doc_type = NULL THEN
8853: Okc_Api.Set_Message(G_APP_NAME
8854: ,'OKC_DEL_NO_PARAMS');

Line 8855: RAISE FND_API.G_EXC_ERROR;

8851: END IF;
8852: IF p_doc_type = NULL THEN
8853: Okc_Api.Set_Message(G_APP_NAME
8854: ,'OKC_DEL_NO_PARAMS');
8855: RAISE FND_API.G_EXC_ERROR;
8856: END IF;
8857: IF p_mode = NULL THEN
8858: Okc_Api.Set_Message(G_APP_NAME
8859: ,'OKC_DEL_NO_PARAMS');

Line 8860: RAISE FND_API.G_EXC_ERROR;

8856: END IF;
8857: IF p_mode = NULL THEN
8858: Okc_Api.Set_Message(G_APP_NAME
8859: ,'OKC_DEL_NO_PARAMS');
8860: RAISE FND_API.G_EXC_ERROR;
8861: END IF;
8862:
8863:
8864:

Line 8872: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8868: RAISE OKC_API.G_EXCEPTION_ERROR;
8869: END IF;
8870:
8871: -- Initialize message list if p_init_msg_list is set to TRUE.
8872: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8873: FND_MSG_PUB.initialize;
8874: END IF;
8875:
8876: --initialize l_qa_result_tbl

Line 9118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9114: p_severity => l_amendments_severity,
9115: px_qa_result_tbl => l_qa_result_tbl,
9116: x_return_status => l_return_status);
9117: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9119: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9120: RAISE FND_API.G_EXC_ERROR ;
9121: END IF;
9122:

Line 9120: RAISE FND_API.G_EXC_ERROR ;

9116: x_return_status => l_return_status);
9117: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9119: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9120: RAISE FND_API.G_EXC_ERROR ;
9121: END IF;
9122:
9123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking amendments');

Line 9137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9133: p_severity => l_notifications_severity,
9134: px_qa_result_tbl => l_qa_result_tbl,
9135: x_return_status => l_return_status);
9136: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9138: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9139: RAISE FND_API.G_EXC_ERROR ;
9140: END IF;
9141:

Line 9139: RAISE FND_API.G_EXC_ERROR ;

9135: x_return_status => l_return_status);
9136: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9138: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9139: RAISE FND_API.G_EXC_ERROR ;
9140: END IF;
9141:
9142: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking notifications');

Line 9156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9152: p_severity => l_int_contact_severity,
9153: px_qa_result_tbl => l_qa_result_tbl,
9154: x_return_status => l_return_status);
9155: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9157: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9158: RAISE FND_API.G_EXC_ERROR ;
9159: END IF;
9160:

Line 9158: RAISE FND_API.G_EXC_ERROR ;

9154: x_return_status => l_return_status);
9155: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9157: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9158: RAISE FND_API.G_EXC_ERROR ;
9159: END IF;
9160:
9161: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking internal contacts');

Line 9177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9173: p_severity => l_int_contact_valid_severity,
9174: px_qa_result_tbl => l_qa_result_tbl,
9175: x_return_status => l_return_status);
9176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9178: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9179: RAISE FND_API.G_EXC_ERROR ;
9180: END IF;
9181:

Line 9179: RAISE FND_API.G_EXC_ERROR ;

9175: x_return_status => l_return_status);
9176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9178: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9179: RAISE FND_API.G_EXC_ERROR ;
9180: END IF;
9181:
9182: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9183: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking internal contacts valid');

Line 9200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9196: px_qa_result_tbl => l_qa_result_tbl,
9197: x_return_status => l_return_status);
9198:
9199: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9201: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9202: RAISE FND_API.G_EXC_ERROR ;
9203: END IF;
9204:

Line 9202: RAISE FND_API.G_EXC_ERROR ;

9198:
9199: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9201: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9202: RAISE FND_API.G_EXC_ERROR ;
9203: END IF;
9204:
9205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module

Line 9222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9218: p_severity =>l_ext_contact_severity,
9219: px_qa_result_tbl => l_qa_result_tbl,
9220: x_return_status => l_return_status);
9221: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9223: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9224: RAISE FND_API.G_EXC_ERROR ;
9225: END IF;
9226: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9224: RAISE FND_API.G_EXC_ERROR ;

9220: x_return_status => l_return_status);
9221: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9223: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9224: RAISE FND_API.G_EXC_ERROR ;
9225: END IF;
9226: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9227: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking external contacts');
9228: END IF;

Line 9241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9237: p_bus_doc_date_events_tbl => p_bus_doc_date_events_tbl,
9238: px_qa_result_tbl => l_qa_result_tbl,
9239: x_return_status => l_return_status);
9240: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9242: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9243: RAISE FND_API.G_EXC_ERROR ;
9244: END IF;
9245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9243: RAISE FND_API.G_EXC_ERROR ;

9239: x_return_status => l_return_status);
9240: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9242: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9243: RAISE FND_API.G_EXC_ERROR ;
9244: END IF;
9245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking due dates');
9247: END IF;

Line 9298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9294: px_qa_result_tbl => l_qa_result_tbl,
9295: x_return_status => l_return_status);
9296:
9297: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9299: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9300: RAISE FND_API.G_EXC_ERROR ;
9301: END IF;
9302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 9300: RAISE FND_API.G_EXC_ERROR ;

9296:
9297: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
9298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9299: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
9300: RAISE FND_API.G_EXC_ERROR ;
9301: END IF;
9302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished checking variable usage');
9304: END IF;

Line 9368: WHEN FND_API.G_EXC_ERROR 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
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;

Line 9392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9388: p_count => x_msg_count,
9389: p_data => x_msg_data
9390: );
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;

Line 9451: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

9447:
9448:
9449: PROCEDURE delete_del_status_hist_attach(
9450: p_api_version IN NUMBER,
9451: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9452: p_deliverable_id IN NUMBER,
9453: p_bus_doc_id IN NUMBER,
9454: p_bus_doc_version IN NUMBER,
9455: p_bus_doc_type IN VARCHAR2,

Line 9504: WHEN FND_API.G_EXC_ERROR 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
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:

Line 9515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9511: p_count => x_msg_count,
9512: p_data => x_msg_data
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:

Line 9731: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

9727: /*** added new signature bug#3192512**/
9728:
9729: FUNCTION deliverables_exist(
9730: p_api_version IN NUMBER,
9731: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9732: x_return_status OUT NOCOPY VARCHAR2,
9733: x_msg_data OUT NOCOPY VARCHAR2,
9734: x_msg_count OUT NOCOPY NUMBER,
9735: p_doctype IN VARCHAR2,

Line 9866: WHEN FND_API.G_EXC_ERROR 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
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;

Line 9876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9872: p_count => x_msg_count,
9873: p_data => x_msg_data
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;

Line 10012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

10008: /*** added new signature bug#3192512**/
10009:
10010: FUNCTION deliverables_amended(
10011: p_api_version IN NUMBER,
10012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10013:
10014: x_return_status OUT NOCOPY VARCHAR2,
10015: x_msg_data OUT NOCOPY VARCHAR2,
10016: x_msg_count OUT NOCOPY NUMBER,

Line 10276: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

10272: ***/
10273:
10274: PROCEDURE copy_response_deliverables (
10275: p_api_version IN NUMBER,
10276: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
10277: p_source_doc_id IN NUMBER,
10278: p_source_doc_type IN VARCHAR2,
10279: p_target_doc_id IN NUMBER,
10280: p_target_doc_type IN VARCHAR2,

Line 10860: WHEN FND_API.G_EXC_ERROR THEN

10856: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10857: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,':leaving ');
10858: END IF;
10859: EXCEPTION
10860: WHEN FND_API.G_EXC_ERROR THEN
10861: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10862: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR: '||
10863: substr(sqlerrm,1,200));
10864: END IF;

Line 10880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10876: p_count => x_msg_count,
10877: p_data => x_msg_data
10878: );
10879:
10880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10881: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10882: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name
10883: ,'leaving with G_EXC_UNEXPECTED_ERROR :'||substr(sqlerrm,1,200));
10884: END IF;

Line 10983: WHEN FND_API.G_EXC_ERROR THEN

10979: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: leaving ');
10980: END IF;
10981: x_return_status := l_return_status;
10982: EXCEPTION
10983: WHEN FND_API.G_EXC_ERROR THEN
10984: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10985: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
10986: END IF;
10987: x_return_status := G_RET_STS_ERROR;

Line 10993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10989: p_count => x_msg_count,
10990: p_data => x_msg_data
10991: );
10992:
10993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10994: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10995: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
10996: END IF;
10997: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 11032: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

11028: to the variable.
11029: ***/
11030: FUNCTION deliverable_amendment_exists (
11031: p_api_version IN NUMBER,
11032: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
11033: p_bus_doc_type IN VARCHAR2,
11034: p_bus_doc_id IN NUMBER,
11035: p_variable_code IN VARCHAR2,
11036: x_msg_data OUT NOCOPY VARCHAR2,

Line 11075: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

11071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside the API');
11072: END IF;
11073:
11074: -- Standard call to check for call compatibility.
11075: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11077: END IF;
11078:
11079: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11072: END IF;
11073:
11074: -- Standard call to check for call compatibility.
11075: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11077: END IF;
11078:
11079: -- Initialize message list if p_init_msg_list is set to TRUE.
11080: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 11080: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11077: END IF;
11078:
11079: -- Initialize message list if p_init_msg_list is set to TRUE.
11080: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11081: FND_MSG_PUB.initialize;
11082: END IF;
11083:
11084: -- Initialize API return status to success

Line 11232: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

11228: -- bug#4075168 New API for Template Revision
11229: -- bug#4083525 New param p_copy_deliverables
11230: PROCEDURE CopyDelForTemplateRevision(
11231: p_api_version IN NUMBER,
11232: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
11233: p_source_doc_id IN NUMBER,
11234: p_source_doc_type IN VARCHAR2,
11235: p_target_doc_id IN NUMBER,
11236: p_target_doc_type IN VARCHAR2,

Line 11679: -- Default = FND_API.G_FALSE

11675: --Pre-reqs : None.
11676: --Parameters :
11677: --IN : p_api_version IN NUMBER Required
11678: -- : p_init_msg_list IN VARCHAR2 Optional
11679: -- Default = FND_API.G_FALSE
11680: -- : p_commit IN VARCHAR2 Optional
11681: -- Default = FND_API.G_FALSE
11682: -- : p_bus_doc_id IN NUMBER Required
11683: -- Contract ID of the contract to be deleted

Line 11681: -- Default = FND_API.G_FALSE

11677: --IN : p_api_version IN NUMBER Required
11678: -- : p_init_msg_list IN VARCHAR2 Optional
11679: -- Default = FND_API.G_FALSE
11680: -- : p_commit IN VARCHAR2 Optional
11681: -- Default = FND_API.G_FALSE
11682: -- : p_bus_doc_id IN NUMBER Required
11683: -- Contract ID of the contract to be deleted
11684: -- : p_bus_doc_type IN VARCHAR2 Required
11685: -- Type of the contract to be deleted

Line 11704: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

11700: --Note :
11701: -- End of comments
11702: PROCEDURE deleteDeliverables(
11703: p_api_version IN NUMBER,
11704: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
11705: p_commit IN VARCHAR2:=FND_API.G_FALSE,
11706: p_bus_doc_id IN NUMBER,
11707: p_bus_doc_type IN VARCHAR2,
11708: p_bus_doc_version IN NUMBER,

Line 11705: p_commit IN VARCHAR2:=FND_API.G_FALSE,

11701: -- End of comments
11702: PROCEDURE deleteDeliverables(
11703: p_api_version IN NUMBER,
11704: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
11705: p_commit IN VARCHAR2:=FND_API.G_FALSE,
11706: p_bus_doc_id IN NUMBER,
11707: p_bus_doc_type IN VARCHAR2,
11708: p_bus_doc_version IN NUMBER,
11709: p_prev_del_active IN VARCHAR2 := 'N',

Line 11848: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

11844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'p_revert_dels: '|| p_revert_dels);
11845: END IF;
11846:
11847: -- Standard call to check for call compatibility.
11848: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
11849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11850: END IF;
11851:
11852: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 11849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11845: END IF;
11846:
11847: -- Standard call to check for call compatibility.
11848: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
11849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11850: END IF;
11851:
11852: -- Initialize message list if p_init_msg_list is set to TRUE.
11853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 11853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11850: END IF;
11851:
11852: -- Initialize message list if p_init_msg_list is set to TRUE.
11853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11854: FND_MSG_PUB.initialize;
11855: END IF;
11856:
11857: -- If the flag p_revert_dels is "N" then this API is called to delete

Line 11867: p_init_msg_list => FND_API.G_FALSE,

11863: 'Deleting deliverables with document version equal to -99');
11864: END IF;
11865:
11866: delete_deliverables(p_api_version => 1.0,
11867: p_init_msg_list => FND_API.G_FALSE,
11868: p_doc_id => p_bus_doc_id,
11869: p_doc_type => p_bus_doc_type,
11870: p_doc_version => -99,
11871: x_return_status => x_return_status,

Line 11902: p_init_msg_list => FND_API.G_FALSE,

11898: 'Deleting deliverables with document version equal to -99');
11899: END IF;
11900:
11901: delete_deliverables(p_api_version => 1.0,
11902: p_init_msg_list => FND_API.G_FALSE,
11903: p_doc_id => p_bus_doc_id,
11904: p_doc_type => p_bus_doc_type,
11905: p_doc_version => -99,
11906: x_return_status => x_return_status,

Line 12223: p_init_msg_list => FND_API.G_FALSE,

12219: 'Deleting deliverables with document version equal to' || to_char(p_bus_doc_version - 1));
12220: END IF;
12221:
12222: delete_deliverables(p_api_version => 1.0,
12223: p_init_msg_list => FND_API.G_FALSE,
12224: p_doc_id => p_bus_doc_id,
12225: p_doc_type => p_bus_doc_type,
12226: p_doc_version => p_bus_doc_version - 1,
12227: x_return_status => x_return_status,