eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_API

Line 409: Okc_Api.Set_Message(G_APP_NAME,

405: WHEN OTHERS THEN
406: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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;

Line 459: Okc_Api.Set_Message(G_APP_NAME,

455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
456: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);
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;

Line 620: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

616: delRecTab delRecTabType;
617: delInsTab delRecTabType;
618: delNewTab delRecTabType;
619: l_api_name CONSTANT VARCHAR2(30) :='copy_del_for_amendment';
620: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
621: l_deliverable_id NUMBER;
622: l_from_pk1_value VARCHAR2(100);
623: l_result BOOLEAN;
624: l_copy_attachments VARCHAR2(1);

Line 811: Okc_Api.Set_Message(G_APP_NAME

807: END IF;
808:
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

Line 829: Okc_Api.Set_Message(G_APP_NAME

825: END IF;
826:
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

Line 1928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1924: delIdTab delIdTabType;
1925: j PLS_INTEGER := 0;
1926: k PLS_INTEGER := 0;
1927: l_api_name CONSTANT VARCHAR2(30) :='copy_deliverables';
1928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1929: l_deliverable_id NUMBER;
1930: l_from_pk1_value VARCHAR2(100);
1931: l_result BOOLEAN;
1932: l_copy VARCHAR2(1) := 'N';

Line 3113: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

3109: p PLS_INTEGER := 0;
3110: TYPE delIdRecType IS RECORD (del_id NUMBER,orig_del_id NUMBER);
3111: TYPE delIdTabType IS TABLE OF delIdRecType;
3112: delIdTab delIdTabType;
3113: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3114: l_msg_count NUMBER;
3115: l_msg_data VARCHAR2(1000);
3116: l_api_version CONSTANT VARCHAR2(30) := 1.0;
3117: l_recur_parent_id NUMBER;

Line 3660: p_init_msg_list => OKC_API.G_FALSE,

3656: END LOOP;
3657: -- delete the deliverable definition
3658: delete_deliverable (
3659: p_api_version => l_api_version,
3660: p_init_msg_list => OKC_API.G_FALSE,
3661: p_del_id => delRecTab(i).deliverable_id,
3662: x_msg_data => l_msg_data ,
3663: x_msg_count => l_msg_count,
3664: x_return_status => l_return_status);

Line 3666: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3662: x_msg_data => l_msg_data ,
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;

Line 4637: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

4633:
4634: def_rec def_cur%ROWTYPE;
4635: --TYPE delIdTabType IS TABLE OF NUMBER;
4636: --delIdTab delIdTabType;
4637: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
4638: l_api_name CONSTANT VARCHAR2(30) :='clear_amendment_operation';
4639:
4640: BEGIN
4641:

Line 4762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4758: AND business_document_type = p_doc_type
4759: AND manage_yn = 'Y';
4760: TYPE delIdTabType IS TABLE OF NUMBER;
4761: delIdTab delIdTabType;
4762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
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

Line 4840: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

4836: x_return_status OUT NOCOPY VARCHAR2)
4837: IS
4838:
4839: l_api_name CONSTANT VARCHAR2(30) :='create_del_status_history';
4840: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
4841: l_msg_count NUMBER;
4842: l_msg_data VARCHAR2(1000);
4843: l_api_version CONSTANT VARCHAR2(30) := 1.0;
4844: j PLS_INTEGER := 0;

Line 4965: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

4961:
4962: TYPE delStsTabType IS TABLE OF okc_del_status_history%ROWTYPE;
4963: delStsTab delStsTabType;
4964:
4965: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
4966: l_msg_count NUMBER;
4967: l_msg_data VARCHAR2(1000);
4968: l_api_version CONSTANT VARCHAR2(30) := 1.0;
4969: j PLS_INTEGER := 0;

Line 5083: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

5079: delStsTab(j).last_update_date := sysdate;
5080: delStsTab(j).last_update_login := Fnd_Global.Login_Id;
5081: END LOOP;
5082:
5083: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5084: -- BULK UPDATE of status
5085: FORALL i IN delIdTab.FIRST..delIdTab.LAST
5086: UPDATE okc_deliverables
5087: SET

Line 5193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5189: errbuf OUT NOCOPY VARCHAR2,
5190: retcode OUT NOCOPY VARCHAR2)
5191: IS
5192: l_api_name CONSTANT VARCHAR2(30) :='overdue_deliverable_manager';
5193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5194: l_msg_count NUMBER;
5195: l_msg_data VARCHAR2(1000);
5196: l_api_version CONSTANT VARCHAR2(30) := 1.0;
5197: l_init_msg_list VARCHAR2(3) := 'T';

Line 5215: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5211: x_return_status => l_return_status,
5212: x_msg_count => l_msg_count,
5213: x_msg_data => l_msg_data);
5214: --check return status
5215: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5217: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5218: RAISE OKC_API.G_EXCEPTION_ERROR;
5219: END IF;

Line 5216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5212: x_msg_count => l_msg_count,
5213: x_msg_data => l_msg_data);
5214: --check return status
5215: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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

Line 5217: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5213: x_msg_data => l_msg_data);
5214: --check return status
5215: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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');

Line 5218: RAISE OKC_API.G_EXCEPTION_ERROR;

5214: --check return status
5215: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5216: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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;

Line 5228: l_return_status := okc_api.g_ret_sts_error;

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
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');

Line 5284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5280: AND business_document_type <> 'TEMPLATE'
5281: AND deliverable_status IN ('OPEN','REJECTED')
5282: AND actual_due_date < trunc(sysdate); -- bug#3617906 removed trunc on actual due date
5283:
5284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5285: l_msg_count NUMBER;
5286: l_msg_data VARCHAR2(1000);
5287: l_notification_id NUMBER;
5288: j PLS_INTEGER := 0;

Line 5310: l_return_status := OKC_API.START_ACTIVITY(l_api_name

5306: END IF;
5307:
5308: -- call start_activity to create savepoint, check comptability
5309: -- and initialize message list
5310: l_return_status := OKC_API.START_ACTIVITY(l_api_name
5311: ,p_init_msg_list
5312: ,'_PROCESS'
5313: ,x_return_status);
5314:

Line 5316: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5312: ,'_PROCESS'
5313: ,x_return_status);
5314:
5315: -- check if activity started successfully
5316: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5318: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5319: RAISE OKC_API.G_EXCEPTION_ERROR;
5320: END IF;

Line 5317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5313: ,x_return_status);
5314:
5315: -- check if activity started successfully
5316: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5318: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5319: RAISE OKC_API.G_EXCEPTION_ERROR;
5320: END IF;
5321:

Line 5318: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5314:
5315: -- check if activity started successfully
5316: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5318: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5319: RAISE OKC_API.G_EXCEPTION_ERROR;
5320: END IF;
5321:
5322:

Line 5319: RAISE OKC_API.G_EXCEPTION_ERROR;

5315: -- check if activity started successfully
5316: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5318: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5319: RAISE OKC_API.G_EXCEPTION_ERROR;
5320: END IF;
5321:
5322:
5323: OPEN del_cur;

Line 5382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5378: -- sent to person who launched the concurrent request.
5379: l_return_status := 'S';
5380: END IF;
5381: ELSE
5382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5383: END IF;
5384:
5385: END LOOP;
5386:

Line 5405: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

5401: COMMIT;
5402:
5403: END IF;
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;

Line 5475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5471: IS
5472: l_api_name CONSTANT VARCHAR2(30) :='beforedue_deliverable_manager';
5473: l_api_version CONSTANT VARCHAR2(30) := 1.0;
5474: l_init_msg_list VARCHAR2(3) := 'T';
5475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5476: l_msg_count NUMBER;
5477: l_msg_data VARCHAR2(1000);
5478: E_Resource_Busy EXCEPTION;
5479: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);

Line 5496: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5492: x_msg_count => l_msg_count,
5493: x_msg_data => l_msg_data);
5494:
5495: --check return status
5496: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5498: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5499: RAISE OKC_API.G_EXCEPTION_ERROR;
5500: END IF;

Line 5497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5493: x_msg_data => l_msg_data);
5494:
5495: --check return status
5496: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5498: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5499: RAISE OKC_API.G_EXCEPTION_ERROR;
5500: END IF;
5501:

Line 5498: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5494:
5495: --check return status
5496: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5498: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5499: RAISE OKC_API.G_EXCEPTION_ERROR;
5500: END IF;
5501:
5502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5499: RAISE OKC_API.G_EXCEPTION_ERROR;

5495: --check return status
5496: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5498: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
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');

Line 5507: l_return_status := okc_api.g_ret_sts_error;

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

Line 5559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5555: l_api_name CONSTANT VARCHAR2(30) :='beforedue_del_notifier';
5556: l_notification_date DATE;
5557: delRecTab delRecTabType;
5558: delNtfTab delRecTabType;
5559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5560: l_msg_count NUMBER;
5561: l_msg_data VARCHAR2(1000);
5562: l_notification_id NUMBER;
5563: l_deliverable_id NUMBER;

Line 5573: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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
5574: ,p_init_msg_list
5575: ,'_PROCESS'
5576: ,x_return_status
5577: );

Line 5579: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5575: ,'_PROCESS'
5576: ,x_return_status
5577: );
5578: -- check if activity started successfully
5579: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5581: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5582: RAISE OKC_API.G_EXCEPTION_ERROR;
5583: END IF;

Line 5580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5576: ,x_return_status
5577: );
5578: -- check if activity started successfully
5579: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5581: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5582: RAISE OKC_API.G_EXCEPTION_ERROR;
5583: END IF;
5584: ---------------------------------------------------

Line 5581: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5577: );
5578: -- check if activity started successfully
5579: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5581: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5582: RAISE OKC_API.G_EXCEPTION_ERROR;
5583: END IF;
5584: ---------------------------------------------------
5585: FOR del_rec IN del_cur LOOP

Line 5582: RAISE OKC_API.G_EXCEPTION_ERROR;

5578: -- check if activity started successfully
5579: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5581: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5582: RAISE OKC_API.G_EXCEPTION_ERROR;
5583: END IF;
5584: ---------------------------------------------------
5585: FOR del_rec IN del_cur LOOP
5586: k := k+1;

Line 5749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5745: -- sent to person who launched the concurrent request.
5746: l_return_status := 'S';
5747: END IF;
5748: ELSE
5749: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5750: END IF;
5751: END IF; -- call to notifier
5752: END LOOP;
5753: END IF;

Line 5773: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

5769: IF del_cur %ISOPEN THEN
5770: CLOSE del_cur ;
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

Line 5834: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5830: IS
5831: l_api_name CONSTANT VARCHAR2(30) :='escalation_deliverable_manager';
5832: l_api_version CONSTANT VARCHAR2(30) := 1.0;
5833: l_init_msg_list VARCHAR2(3) := 'T';
5834: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5835: l_msg_count NUMBER;
5836: l_msg_data VARCHAR2(1000);
5837: E_Resource_Busy EXCEPTION;
5838: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);

Line 5855: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5851: x_msg_count => l_msg_count,
5852: x_msg_data => l_msg_data);
5853:
5854: --check return status
5855: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5857: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5858: RAISE OKC_API.G_EXCEPTION_ERROR;
5859: END IF;

Line 5856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5852: x_msg_data => l_msg_data);
5853:
5854: --check return status
5855: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5857: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5858: RAISE OKC_API.G_EXCEPTION_ERROR;
5859: END IF;
5860:

Line 5857: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5853:
5854: --check return status
5855: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5857: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5858: RAISE OKC_API.G_EXCEPTION_ERROR;
5859: END IF;
5860:
5861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5858: RAISE OKC_API.G_EXCEPTION_ERROR;

5854: --check return status
5855: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5857: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
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');

Line 5866: l_return_status := okc_api.g_ret_sts_error;

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

Line 5919: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5915: -- OR actual_due_date = sysdate); bug#3722423
5916: l_notification_date DATE;
5917: delRecTab delRecTabType;
5918: delNtfTab delRecTabType;
5919: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5920: l_msg_count NUMBER;
5921: l_msg_data VARCHAR2(1000);
5922: l_notification_id NUMBER;
5923: l_deliverable_id NUMBER;

Line 5933: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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
5934: ,p_init_msg_list
5935: ,'_PROCESS'
5936: ,x_return_status
5937: );

Line 5939: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

5935: ,'_PROCESS'
5936: ,x_return_status
5937: );
5938: -- check if activity started successfully
5939: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5941: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5942: RAISE OKC_API.G_EXCEPTION_ERROR;
5943: END IF;

Line 5940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5936: ,x_return_status
5937: );
5938: -- check if activity started successfully
5939: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5941: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5942: RAISE OKC_API.G_EXCEPTION_ERROR;
5943: END IF;
5944: ---------------------------------------------------

Line 5941: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

5937: );
5938: -- check if activity started successfully
5939: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5941: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5942: RAISE OKC_API.G_EXCEPTION_ERROR;
5943: END IF;
5944: ---------------------------------------------------
5945: FOR del_rec IN del_cur LOOP

Line 5942: RAISE OKC_API.G_EXCEPTION_ERROR;

5938: -- check if activity started successfully
5939: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
5940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5941: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
5942: RAISE OKC_API.G_EXCEPTION_ERROR;
5943: END IF;
5944: ---------------------------------------------------
5945: FOR del_rec IN del_cur LOOP
5946: k := k+1;

Line 6105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6101: -- sent to person who launched the concurrent request.
6102: l_return_status := 'S';
6103: END IF;
6104: ELSE
6105: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6106: END IF;
6107: END IF; -- call to notifier
6108: END LOOP;
6109: END IF;

Line 6129: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

6125: IF del_cur %ISOPEN THEN
6126: CLOSE del_cur ;
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:

Line 6187: l_result VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

6183: )
6184: IS
6185: l_api_name CONSTANT VARCHAR2(30) :='delete_attachments';
6186: l_att_exists BOOLEAN;
6187: l_result VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6188:
6189: CURSOR att_cur IS
6190: SELECT att.attached_document_id
6191: ,doc.datatype_id

Line 6261: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

6257: x_msg_count OUT NOCOPY NUMBER,
6258: x_return_status OUT NOCOPY VARCHAR2)
6259: IS
6260: l_api_name CONSTANT VARCHAR2(30) :='purge_doc_deliverables';
6261: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
6262: l_msg_count NUMBER;
6263: l_msg_data VARCHAR2(1000);
6264: l_api_version CONSTANT VARCHAR2(30) := 1.0;
6265: l_deliverable_id NUMBER;

Line 6279: p_init_msg_list => OKC_API.G_FALSE,

6275: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Business document Type:'||p_doc_table(i).doc_type);
6276: END IF;
6277: delete_deliverables (
6278: p_api_version => l_api_version,
6279: p_init_msg_list => OKC_API.G_FALSE,
6280: p_doc_id => p_doc_table(i).doc_id,
6281: p_doc_type => p_doc_table(i).doc_type,
6282: x_msg_data => l_msg_data,
6283: x_msg_count => l_msg_count,

Line 6356: l_result VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

6352: WHERE business_document_id = p_doc_id
6353: AND business_document_type = p_doc_type
6354: AND business_document_version = p_doc_version;
6355:
6356: l_result VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6357: l_api_name VARCHAR2(30) :='delete_deliverables';
6358: TYPE delIdTabType IS TABLE OF NUMBER;
6359: delIdTab delIdTabType;
6360: BEGIN

Line 6482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

6478: AND business_document_type = 'TEMPLATE';
6479: TYPE delIdRecTabType IS TABLE OF NUMBER;
6480: delIdTab delIdRecTabType;
6481: l_api_name CONSTANT VARCHAR2(30) :='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');

Line 6605: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6601: BEGIN
6602:
6603:
6604: -- Initialize API return status to success
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');

Line 6702: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

6698:
6699: l_end_date date := NULL;
6700: l_timeunit varchar2(30);
6701: l_duration number := 0;
6702: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6703: l_api_name CONSTANT VARCHAR2(30) :='get_actual_date';
6704:
6705: begin
6706: --- check if time unit and duration values are set

Line 6816: x_return_status := OKC_API.G_RET_STS_SUCCESS;

6812:
6813: --- Calculate the end date
6814: l_date := p_start_date + l_daynum_offset;
6815: if TRUNC(l_date) > TRUNC(p_end_date) then
6816: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6817: return;
6818: end if;
6819:
6820: -- initialize the count to add into table of records

Line 6884: x_return_status := OKC_API.G_RET_STS_ERROR;

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,
6887: p_data => x_msg_data
6888: );

Line 7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

7130: * This procedure checks if there is any error related to a given
7131: * deliverable's notification details
7132: * @modifies px_qa_result_tbl table of records that contains validation
7133: * errors and warnings
7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7135: * OKC_API.G_RET_STS_ERROR if failes
7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 7135: * OKC_API.G_RET_STS_ERROR if failes

7131: * deliverable's notification details
7132: * @modifies px_qa_result_tbl table of records that contains validation
7133: * errors and warnings
7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7135: * OKC_API.G_RET_STS_ERROR if failes
7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7139: */

Line 7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

7132: * @modifies px_qa_result_tbl table of records that contains validation
7133: * errors and warnings
7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7135: * OKC_API.G_RET_STS_ERROR if failes
7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7139: */
7140: PROCEDURE check_notifications (

Line 7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

7133: * errors and warnings
7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7135: * OKC_API.G_RET_STS_ERROR if failes
7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7139: */
7140: PROCEDURE check_notifications (
7141: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

7134: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7135: * OKC_API.G_RET_STS_ERROR if failes
7136: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7137: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7138: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7139: */
7140: PROCEDURE check_notifications (
7141: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7142: p_severity IN VARCHAR2,

Line 7149: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7145: ) IS
7146:
7147: l_api_version CONSTANT NUMBER := 1;
7148: l_api_name CONSTANT VARCHAR2(30) := 'check_notifications';
7149: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7150: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7151: l_index PLS_INTEGER := 0;
7152: l_start PLS_INTEGER := 0;
7153: l_message_txt VARCHAR2(2000);

Line 7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

7256: * This procedure checks if there is any error related to a given
7257: * deliverable's internal contacts
7258: * @modifies px_qa_result_tbl table of records that contains validation
7259: * errors and warnings
7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7261: * OKC_API.G_RET_STS_ERROR if failes
7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 7261: * OKC_API.G_RET_STS_ERROR if failes

7257: * deliverable's internal contacts
7258: * @modifies px_qa_result_tbl table of records that contains validation
7259: * errors and warnings
7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7261: * OKC_API.G_RET_STS_ERROR if failes
7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7265: */

Line 7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

7258: * @modifies px_qa_result_tbl table of records that contains validation
7259: * errors and warnings
7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7261: * OKC_API.G_RET_STS_ERROR if failes
7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7265: */
7266: PROCEDURE check_internal_contacts (

Line 7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

7259: * errors and warnings
7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7261: * OKC_API.G_RET_STS_ERROR if failes
7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7265: */
7266: PROCEDURE check_internal_contacts (
7267: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

7260: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7261: * OKC_API.G_RET_STS_ERROR if failes
7262: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7263: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7264: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7265: */
7266: PROCEDURE check_internal_contacts (
7267: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7268: p_severity IN VARCHAR2,

Line 7275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7271: ) IS
7272:
7273: l_api_version CONSTANT NUMBER := 1;
7274: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts';
7275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7276: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7277: l_index PLS_INTEGER := 0;
7278: l_start PLS_INTEGER := 0;
7279: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

7434: * This procedure checks if there is any error related to a given
7435: * deliverable's internal contacts
7436: * @modifies px_qa_result_tbl table of records that contains validation
7437: * errors and warnings
7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7439: * OKC_API.G_RET_STS_ERROR if failes
7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 7439: * OKC_API.G_RET_STS_ERROR if failes

7435: * deliverable's internal contacts
7436: * @modifies px_qa_result_tbl table of records that contains validation
7437: * errors and warnings
7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7439: * OKC_API.G_RET_STS_ERROR if failes
7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7443: */

Line 7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

7436: * @modifies px_qa_result_tbl table of records that contains validation
7437: * errors and warnings
7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7439: * OKC_API.G_RET_STS_ERROR if failes
7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7443: */
7444: PROCEDURE check_internal_contacts_valid (

Line 7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

7437: * errors and warnings
7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7439: * OKC_API.G_RET_STS_ERROR if failes
7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7443: */
7444: PROCEDURE check_internal_contacts_valid (
7445: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

7438: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7439: * OKC_API.G_RET_STS_ERROR if failes
7440: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7441: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7442: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7443: */
7444: PROCEDURE check_internal_contacts_valid (
7445: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7446: p_severity IN VARCHAR2,

Line 7453: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7449: ) IS
7450:
7451: l_api_version CONSTANT NUMBER := 1;
7452: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts_valid';
7453: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7454: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7455: l_index PLS_INTEGER := 0;
7456: l_start PLS_INTEGER := 0;
7457: l_message_txt VARCHAR2(2000);

Line 7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

7599: * This procedure checks if there is any error related to a given
7600: * deliverable's external contacts
7601: * @modifies px_qa_result_tbl table of records that contains validation
7602: * errors and warnings
7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7604: * OKC_API.G_RET_STS_ERROR if failes
7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 7604: * OKC_API.G_RET_STS_ERROR if failes

7600: * deliverable's external contacts
7601: * @modifies px_qa_result_tbl table of records that contains validation
7602: * errors and warnings
7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7604: * OKC_API.G_RET_STS_ERROR if failes
7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7608: */

Line 7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

7601: * @modifies px_qa_result_tbl table of records that contains validation
7602: * errors and warnings
7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7604: * OKC_API.G_RET_STS_ERROR if failes
7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7608: */
7609: PROCEDURE check_external_contacts (

Line 7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

7602: * errors and warnings
7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7604: * OKC_API.G_RET_STS_ERROR if failes
7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7608: */
7609: PROCEDURE check_external_contacts (
7610: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

7603: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7604: * OKC_API.G_RET_STS_ERROR if failes
7605: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7606: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7607: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7608: */
7609: PROCEDURE check_external_contacts (
7610: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7611: p_severity IN VARCHAR2,

Line 7618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7614: ) IS
7615:
7616: l_api_version CONSTANT NUMBER := 1;
7617: l_api_name CONSTANT VARCHAR2(30) := 'check_external_contacts';
7618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7619: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7620: l_index PLS_INTEGER := 0;
7621: l_start PLS_INTEGER := 0;
7622: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

7739: * This procedure checks if there is any error related to a given
7740: * deliverable's due date details
7741: * @modifies px_qa_result_tbl table of records that contains validation
7742: * errors and warnings
7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7744: * OKC_API.G_RET_STS_ERROR if failes
7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 7744: * OKC_API.G_RET_STS_ERROR if failes

7740: * deliverable's due date details
7741: * @modifies px_qa_result_tbl table of records that contains validation
7742: * errors and warnings
7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7744: * OKC_API.G_RET_STS_ERROR if failes
7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7748: */

Line 7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

7741: * @modifies px_qa_result_tbl table of records that contains validation
7742: * errors and warnings
7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7744: * OKC_API.G_RET_STS_ERROR if failes
7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7748: */
7749: PROCEDURE check_due_dates (

Line 7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

7742: * errors and warnings
7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7744: * OKC_API.G_RET_STS_ERROR if failes
7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7748: */
7749: PROCEDURE check_due_dates (
7750: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

7743: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
7744: * OKC_API.G_RET_STS_ERROR if failes
7745: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
7746: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
7747: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
7748: */
7749: PROCEDURE check_due_dates (
7750: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7751: p_severity IN VARCHAR2,

Line 7759: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

7755: ) IS
7756:
7757: l_api_version CONSTANT NUMBER := 1;
7758: l_api_name CONSTANT VARCHAR2(30) := 'check_due_dates';
7759: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7760: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7761: l_index PLS_INTEGER := 0;
7762: l_start PLS_INTEGER := 0;
7763: l_message_txt VARCHAR2(2000);

Line 7829: --l_qa_status := OKC_API.G_RET_STS_ERROR;

7825: OKC_TERMS_UTIL_PVT.get_message(p_app_name => G_OKC,
7826: p_msg_name => 'OKC_DEL_REQUIRED_S');
7827:
7828: -- set return status for calling API to know, that there's a QA message
7829: --l_qa_status := OKC_API.G_RET_STS_ERROR;
7830: END IF;
7831: ELSE
7832:
7833: --06-FEB-2004 pnayani -- Fix for bug 3369934 Resetting due date attributes during copy

Line 8023: --l_qa_status := OKC_API.G_RET_STS_ERROR;

8019: p_token1 => 'EVT_DATE_NAME',
8020: p_token1_value => qaMessages(1) );
8021:
8022: -- set return status for calling API to know, that there's a QA message
8023: --l_qa_status := OKC_API.G_RET_STS_ERROR;
8024:
8025: END IF; -- if one date is missing
8026:
8027: -- if two dates are missing

Line 8055: --l_qa_status := OKC_API.G_RET_STS_ERROR;

8051: p_token2 => 'EVT_DATE_NAME2',
8052: p_token2_value => qaMessages(2) );
8053:
8054: -- set return status for calling API to know, that there's a QA message
8055: --l_qa_status := OKC_API.G_RET_STS_ERROR;
8056:
8057: END IF; -- if two dates are missing
8058: END IF; -- if dates table of records is not empty
8059: END IF; --- if deliverables is not fixed due date

Line 8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

8108: * This procedure checks if there is any error related to a given
8109: * deliverable's amendments
8110: * @modifies px_qa_result_tbl table of records that contains validation
8111: * errors and warnings
8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8113: * OKC_API.G_RET_STS_ERROR if failes
8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 8113: * OKC_API.G_RET_STS_ERROR if failes

8109: * deliverable's amendments
8110: * @modifies px_qa_result_tbl table of records that contains validation
8111: * errors and warnings
8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8113: * OKC_API.G_RET_STS_ERROR if failes
8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8117: */

Line 8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

8110: * @modifies px_qa_result_tbl table of records that contains validation
8111: * errors and warnings
8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8113: * OKC_API.G_RET_STS_ERROR if failes
8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8117: */
8118: PROCEDURE check_amendments (

Line 8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

8111: * errors and warnings
8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8113: * OKC_API.G_RET_STS_ERROR if failes
8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8117: */
8118: PROCEDURE check_amendments (
8119: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

8112: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8113: * OKC_API.G_RET_STS_ERROR if failes
8114: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8115: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8116: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8117: */
8118: PROCEDURE check_amendments (
8119: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8120: p_severity IN VARCHAR2,

Line 8127: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

8123: ) IS
8124:
8125: l_api_version CONSTANT NUMBER := 1;
8126: l_api_name CONSTANT VARCHAR2(30) := 'check_amendments';
8127: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8128: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8129: l_index PLS_INTEGER := 0;
8130: l_start PLS_INTEGER := 0;
8131: l_message_txt VARCHAR2(2000);

Line 8278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

8274: x_return_status OUT NOCOPY VARCHAR2) IS
8275:
8276: l_api_version CONSTANT NUMBER := 1;
8277: l_api_name CONSTANT VARCHAR2(30) := 'check_deliverables_var_usage';
8278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8279: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8280: l_index PLS_INTEGER := 0;
8281: l_start PLS_INTEGER := 0;
8282: l_message_txt VARCHAR2(2000);

Line 8604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

8600:
8601: IF response_doc_type_cur%ISOPEN THEN
8602: CLOSE response_doc_type_cur;
8603: END IF;
8604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8605:
8606:
8607: End check_deliverables_var_usage;
8608:

Line 8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

8611: This API will be invoked by validate_deliverables_for_qa routine during QA check on a
8612: Deliverable. This check should only fire for Deliverables on a document where document_class
8613: is 'REPOSITORY'. This check should not fire for Deliverable types whose INTERNAL_FLAG = 'Y'
8614: * @modifies px_qa_result_tbl table of records that contains validation errors and warnings
8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8616: * OKC_API.G_RET_STS_ERROR if fails
8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error
8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

Line 8616: * OKC_API.G_RET_STS_ERROR if fails

8612: Deliverable. This check should only fire for Deliverables on a document where document_class
8613: is 'REPOSITORY'. This check should not fire for Deliverable types whose INTERNAL_FLAG = 'Y'
8614: * @modifies px_qa_result_tbl table of records that contains validation errors and warnings
8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8616: * OKC_API.G_RET_STS_ERROR if fails
8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error
8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8620: ***********************/

Line 8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error

8613: is 'REPOSITORY'. This check should not fire for Deliverable types whose INTERNAL_FLAG = 'Y'
8614: * @modifies px_qa_result_tbl table of records that contains validation errors and warnings
8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8616: * OKC_API.G_RET_STS_ERROR if fails
8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error
8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8620: ***********************/
8621: PROCEDURE check_external_party_exists (

Line 8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found

8614: * @modifies px_qa_result_tbl table of records that contains validation errors and warnings
8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8616: * OKC_API.G_RET_STS_ERROR if fails
8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error
8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8620: ***********************/
8621: PROCEDURE check_external_party_exists (
8622: del_rec IN OKC_DELIVERABLES%ROWTYPE,

Line 8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found

8615: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8616: * OKC_API.G_RET_STS_ERROR if fails
8617: * OKC_API.G_RET_STS_UNEXP_ERROR if unexpected error
8618: * x_qa_status OKC_API.G_RET_STS_SUCCESS if no error/warning is found
8619: * OKC_API.G_RET_STS_ERROR if at least one error/warning is found
8620: ***********************/
8621: PROCEDURE check_external_party_exists (
8622: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8623: p_severity IN VARCHAR2,

Line 8630: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

8626: ) IS
8627:
8628: l_api_version CONSTANT NUMBER := 1;
8629: l_api_name CONSTANT VARCHAR2(30) := 'check_external_party_exists';
8630: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8631: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8632: l_index PLS_INTEGER := 0;
8633: l_start PLS_INTEGER := 0;
8634:

Line 8732: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds

8728: * p_doc_type not null
8729: * p_doc_id not null
8730: * @modifies p_qa_result_tbl table of records that contains validation
8731: * errors and warnings
8732: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8733: * OKC_API.G_RET_STS_ERROR if failes
8734: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8735: */
8736: PROCEDURE validate_deliverable_for_qa (

Line 8733: * OKC_API.G_RET_STS_ERROR if failes

8729: * p_doc_id not null
8730: * @modifies p_qa_result_tbl table of records that contains validation
8731: * errors and warnings
8732: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8733: * OKC_API.G_RET_STS_ERROR if failes
8734: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error
8735: */
8736: PROCEDURE validate_deliverable_for_qa (
8737: p_api_version IN NUMBER,

Line 8734: * OKC_API.G_RET_STS_UNEXP_ERROR is unexpected error

8730: * @modifies p_qa_result_tbl table of records that contains validation
8731: * errors and warnings
8732: * @returns x_return_status OKC_API.G_RET_STS_SUCCESS if succeeds
8733: * OKC_API.G_RET_STS_ERROR if failes
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,

Line 8755: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

8751: l_api_name CONSTANT VARCHAR2(30) := 'validate_deliverable';
8752: l_qa_severity_warning CONSTANT VARCHAR2(1) := 'W';
8753: l_qa_severity_error CONSTANT VARCHAR2(1) := 'E';
8754:
8755: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8756: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8757:
8758: l_start PLS_INTEGER := 0;
8759: l_end PLS_INTEGER := 0;

Line 8762: l_qa_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

8758: l_start PLS_INTEGER := 0;
8759: l_end PLS_INTEGER := 0;
8760: del_cur del_cur_type;
8761: del_rec okc_deliverables%ROWTYPE;
8762: l_qa_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8763:
8764: -- l_due_date_msg VARCHAR2(2000) := '';
8765: l_check_int_contact VARCHAR2(19) := 'CHECK_BUYER_CONTACT';
8766: l_check_ext_contact VARCHAR2(22) := 'CHECK_SUPPLIER_CONTACT';

Line 8843: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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,
8844: p_init_msg_list,
8845: '_PVT',
8846: x_return_status);
8847: IF p_doc_id = NULL THEN

Line 8848: Okc_Api.Set_Message(G_APP_NAME

8844: p_init_msg_list,
8845: '_PVT',
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

Line 8853: 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');
8855: RAISE FND_API.G_EXC_ERROR;
8856: END IF;
8857: IF p_mode = NULL THEN

Line 8858: 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');
8860: RAISE FND_API.G_EXC_ERROR;
8861: END IF;
8862:

Line 8865: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

8861: END IF;
8862:
8863:
8864:
8865: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
8868: RAISE OKC_API.G_EXCEPTION_ERROR;
8869: END IF;

Line 8866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

8862:
8863:
8864:
8865: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
8868: RAISE OKC_API.G_EXCEPTION_ERROR;
8869: END IF;
8870:

Line 8867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

8863:
8864:
8865: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) 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.

Line 8868: RAISE OKC_API.G_EXCEPTION_ERROR;

8864:
8865: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
8866: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) 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

Line 9463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

9459: IS
9460:
9461: l_api_version CONSTANT NUMBER := 1;
9462: l_api_name CONSTANT VARCHAR2(30) := 'validate_deliverable';
9463: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
9464:
9465:
9466:
9467: BEGIN

Line 9474: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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,
9475: p_init_msg_list,
9476: '_PVT',
9477: x_return_status);
9478:

Line 9480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

9476: '_PVT',
9477: x_return_status);
9478:
9479:
9480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
9483: RAISE OKC_API.G_EXCEPTION_ERROR;
9484: END IF;

Line 9481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

9477: x_return_status);
9478:
9479:
9480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
9483: RAISE OKC_API.G_EXCEPTION_ERROR;
9484: END IF;
9485:

Line 9482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

9478:
9479:
9480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
9483: RAISE OKC_API.G_EXCEPTION_ERROR;
9484: END IF;
9485:
9486:

Line 9483: RAISE OKC_API.G_EXCEPTION_ERROR;

9479:
9480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
9481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
9482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
9483: RAISE OKC_API.G_EXCEPTION_ERROR;
9484: END IF;
9485:
9486:
9487:

Line 9642: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

9638: x_msg_count OUT NOCOPY NUMBER,
9639: x_return_status OUT NOCOPY VARCHAR2)
9640: IS
9641: l_del_id NUMBER;
9642: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
9643: l_result VARCHAR2(1);
9644: l_api_name CONSTANT VARCHAR2(30) :='delete_del_instances';
9645:
9646: l_deleteInstances VARCHAR2(1) := 'Y';

Line 9764: x_return_status := OKC_API.G_RET_STS_SUCCESS;

9760:
9761: BEGIN
9762:
9763: -- Initialize API return status to success
9764: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9765:
9766: FOR del_rec IN del_cur LOOP
9767: If del_rec.internal_flag = 'Y' then
9768: l_internal := del_rec.deliverable_type;

Line 9839: l_result VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

9835: x_msg_count OUT NOCOPY NUMBER,
9836: x_return_status OUT NOCOPY VARCHAR2)
9837: IS
9838:
9839: l_result VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
9840: l_api_name VARCHAR2(30) :='delete_deliverable';
9841:
9842: BEGIN
9843:

Line 9932: l_result VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

9928: where business_document_type = 'TEMPLATE');
9929:
9930: TYPE delIdTabType IS TABLE OF NUMBER;
9931: delIdTab delIdTabType;
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');

Line 10051: x_return_status := OKC_API.G_RET_STS_SUCCESS;

10047:
10048: BEGIN
10049:
10050: -- Initialize API return status to success
10051: x_return_status := OKC_API.G_RET_STS_SUCCESS;
10052:
10053:
10054: FOR del_rec IN del_cur LOOP
10055: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 10320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

10316: j PLS_INTEGER := 0;
10317: k PLS_INTEGER := 0;
10318: m PLS_INTEGER := 0;
10319: l_api_name CONSTANT VARCHAR2(30) :='copy_response_deliverables';
10320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10321: l_recur_del_parent_id NUMBER;
10322:
10323: BEGIN
10324: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 10937: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

10933: x_return_status OUT NOCOPY VARCHAR2)
10934: IS
10935:
10936: l_api_name CONSTANT VARCHAR2(30) :='create_del_status_history';
10937: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10938: l_msg_count NUMBER;
10939: l_msg_data VARCHAR2(1000);
10940: l_api_version CONSTANT VARCHAR2(30) := 1.0;
10941: j PLS_INTEGER := 0;

Line 11260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

11256: delIdTab delIdTabType;
11257: j PLS_INTEGER := 0;
11258: k PLS_INTEGER := 0;
11259: l_api_name CONSTANT VARCHAR2(30) :='CopyDelForTemplateRevision';
11260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11261: l_deliverable_id NUMBER;
11262: l_from_pk1_value VARCHAR2(100);
11263: l_result BOOLEAN;
11264: l_copy VARCHAR2(1) := 'N';

Line 11831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

11827: prev_vers_del prev_vers_del_tbl;
11828:
11829: l_api_name CONSTANT VARCHAR2(30) :='deleteDeliverables';
11830: l_api_version CONSTANT NUMBER := 1.0;
11831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11832:
11833: l_deliverable_id okc_deliverables.deliverable_id%TYPE;
11834:
11835:

Line 11876: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11872: x_msg_count => x_msg_count,
11873: x_msg_data => x_msg_data);
11874:
11875: -----------------------------------------------------
11876: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11878: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11879: RAISE OKC_API.G_EXCEPTION_ERROR;
11880: END IF;

Line 11877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11873: x_msg_data => x_msg_data);
11874:
11875: -----------------------------------------------------
11876: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11878: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11879: RAISE OKC_API.G_EXCEPTION_ERROR;
11880: END IF;
11881: --------------------------------------------------------

Line 11878: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11874:
11875: -----------------------------------------------------
11876: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11878: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11879: RAISE OKC_API.G_EXCEPTION_ERROR;
11880: END IF;
11881: --------------------------------------------------------
11882:

Line 11879: RAISE OKC_API.G_EXCEPTION_ERROR;

11875: -----------------------------------------------------
11876: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11878: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11879: RAISE OKC_API.G_EXCEPTION_ERROR;
11880: END IF;
11881: --------------------------------------------------------
11882:
11883: ELSE

Line 11911: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

11907: x_msg_count => x_msg_count,
11908: x_msg_data => x_msg_data);
11909:
11910: -----------------------------------------------------
11911: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11913: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11914: RAISE OKC_API.G_EXCEPTION_ERROR;
11915: END IF;

Line 11912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

11908: x_msg_data => x_msg_data);
11909:
11910: -----------------------------------------------------
11911: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11913: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11914: RAISE OKC_API.G_EXCEPTION_ERROR;
11915: END IF;
11916: --------------------------------------------------------

Line 11913: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

11909:
11910: -----------------------------------------------------
11911: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11913: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11914: RAISE OKC_API.G_EXCEPTION_ERROR;
11915: END IF;
11916: --------------------------------------------------------
11917:

Line 11914: RAISE OKC_API.G_EXCEPTION_ERROR;

11910: -----------------------------------------------------
11911: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
11912: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
11913: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
11914: RAISE OKC_API.G_EXCEPTION_ERROR;
11915: END IF;
11916: --------------------------------------------------------
11917:
11918: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 12232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

12228: x_msg_count => x_msg_count,
12229: x_msg_data => x_msg_data);
12230:
12231: -----------------------------------------------------
12232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
12235: RAISE OKC_API.G_EXCEPTION_ERROR;
12236: END IF;

Line 12233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

12229: x_msg_data => x_msg_data);
12230:
12231: -----------------------------------------------------
12232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
12235: RAISE OKC_API.G_EXCEPTION_ERROR;
12236: END IF;
12237: --------------------------------------------------------

Line 12234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

12230:
12231: -----------------------------------------------------
12232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
12235: RAISE OKC_API.G_EXCEPTION_ERROR;
12236: END IF;
12237: --------------------------------------------------------
12238:

Line 12235: RAISE OKC_API.G_EXCEPTION_ERROR;

12231: -----------------------------------------------------
12232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
12235: RAISE OKC_API.G_EXCEPTION_ERROR;
12236: END IF;
12237: --------------------------------------------------------
12238:
12239: END IF; -- End of (p_prev_del_active = 'N')