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.

[Home] [Help]

APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_DELIVERABLE_PROCESS_PVT

Line 57: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(

53:
54: IF l_del_row_count = 0 THEN
55:
56: -- create status history record
57: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(
58: p_api_version => l_api_version,
59: p_init_msg_list => G_FALSE,
60: p_del_id => p_deliverable_id,
61: p_deliverable_status => p_deliverable_status,

Line 67: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||x_return_status);

63: x_msg_count => x_msg_count,
64: x_return_status => x_return_status);
65:
66: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||x_return_status);
68: END IF;
69: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
71: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 236: l_recurring_dates OKC_DELIVERABLE_PROCESS_PVT.recurring_dates_tab_type;

232: p_change_status_to IN VARCHAR2)
233: IS
234:
235: --- for recurring dates
236: l_recurring_dates OKC_DELIVERABLE_PROCESS_PVT.recurring_dates_tab_type;
237: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
238:
239: l_api_version CONSTANT VARCHAR2(30) := 1;
240: l_api_name CONSTANT VARCHAR2(30) := 'generate_del_instances';

Line 237: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

233: IS
234:
235: --- for recurring dates
236: l_recurring_dates OKC_DELIVERABLE_PROCESS_PVT.recurring_dates_tab_type;
237: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
238:
239: l_api_version CONSTANT VARCHAR2(30) := 1;
240: l_api_name CONSTANT VARCHAR2(30) := 'generate_del_instances';
241:

Line 256: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;

252: TYPE DelIdList IS TABLE OF NUMBER
253: INDEX BY BINARY_INTEGER;
254: deliverableIds DelIdList;
255:
256: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
257: delStsTab1 OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
258:
259: BEGIN
260:

Line 257: delStsTab1 OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;

253: INDEX BY BINARY_INTEGER;
254: deliverableIds DelIdList;
255:
256: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
257: delStsTab1 OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
258:
259: BEGIN
260:
261: -- initialize

Line 280: OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates(

276: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
277: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'501: Calling getRecurringDates');
278: END IF;
279: --- Calculate recurring instances
280: OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates(
281: p_api_version => l_api_version,
282: p_init_msg_list => G_FALSE,
283: p_start_date => p_recurr_start_date,
284: p_end_date => p_recurr_end_date,

Line 346: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(

342: delRecord.deliverable_id;
343:
344: -- copy attachments from the definition, if any
345: -- check if attachments exists
346: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(
347: p_entity_name => G_ENTITY_NAME,
348: p_pk1_value => delRecord.deliverable_id ) THEN
349:
350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 622: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(

618: END IF;
619:
620: IF delStsTab.count > 0 THEN
621: --- set status history record to INACTIVE for each deliverable instance
622: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(
623: p_api_version => l_api_version,
624: p_init_msg_list => G_FALSE,
625: p_del_st_hist_tab => delStsTab,
626: x_msg_data => l_msg_data,

Line 631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);

627: x_msg_count => l_msg_count,
628: x_return_status => l_return_status);
629:
630: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);
632: END IF;
633:
634: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 648: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(

644:
645: -- insert status histiry records for OPEN status
646: IF delStsTab1.count > 0 THEN
647: --- set status history record to OPEN for each deliverable instance
648: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(
649: p_api_version => l_api_version,
650: p_init_msg_list => G_FALSE,
651: p_del_st_hist_tab => delStsTab1,
652: x_msg_data => l_msg_data,

Line 657: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);

653: x_msg_count => l_msg_count,
654: x_return_status => l_return_status);
655:
656: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);
658: END IF;
659:
660: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 828: OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables(

824: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Calling '||'syncDeliverables');
826: END IF;
827: --- call deliverables process PVT to sync the deliverables for given version
828: OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables(
829: p_api_version => l_api_version,
830: p_init_msg_list => G_FALSE,
831: p_current_docid => p_bus_doc_id,
832: p_current_doctype => p_bus_doc_type,

Line 882: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'900: Calling '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');

878: RAISE FND_API.G_EXC_ERROR ;
879: END IF;
880:
881: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'900: Calling '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
883: END IF;
884:
885: --- call change_deliverable_status, to change deliverable status from
886: --- INACTIVE to 'OPEN'

Line 887: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

883: END IF;
884:
885: --- call change_deliverable_status, to change deliverable status from
886: --- INACTIVE to 'OPEN'
887: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
888: p_api_version => l_api_version,
889: p_init_msg_list => G_FALSE,
890: p_doc_id => p_bus_doc_id,
891: p_doc_version => p_bus_doc_version,

Line 903: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status'||x_return_status);

899: x_msg_count => x_msg_count,
900: x_return_status => x_return_status);
901:
902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
903: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status'||x_return_status);
904: END IF;
905:
906: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1006: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(

1002:
1003: IF (p_event_code is not NULL AND p_event_code = l_del_event_name) THEN
1004: --- Calculate actual date
1005: l_actual_date :=
1006: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(
1007: p_start_date => p_event_date,
1008: p_timeunit => p_event_UOM,
1009: p_duration => p_event_duration,
1010: p_before_after => l_del_before_after);

Line 1033: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(

1029: END IF;
1030:
1031: --- Calculate actual date
1032: l_actual_date :=
1033: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(
1034: p_start_date => p_bus_doc_date_events_tbl(k).event_date,
1035: p_timeunit => p_event_UOM,
1036: p_duration => p_event_duration,
1037: p_before_after => l_del_before_after);

Line 1121: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1117: AND business_document_version = p_bus_doc_version
1118: AND recurring_del_parent_id = p_del_id;
1119:
1120: -- for storage of bulk Fetch
1121: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1122:
1123: -- for storage recurrign instances
1124: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1125:

Line 1124: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1120: -- for storage of bulk Fetch
1121: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1122:
1123: -- for storage recurrign instances
1124: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1125:
1126: TYPE DelIdList IS TABLE OF NUMBER
1127: INDEX BY BINARY_INTEGER;
1128: deliverableIds DelIdList;

Line 1154: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;

1150:
1151: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
1152:
1153: --- for deliverable ids
1154: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
1155:
1156: generate_new_instances_yn VARCHAR2(1);
1157: l_sync_flag VARCHAR2(1);
1158: BEGIN

Line 1459: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);

1455: FETCH get_del_ids_cur BULK COLLECT INTO delIds;
1456: CLOSE get_del_ids_cur;
1457:
1458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1459: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);
1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '||x_return_status);
1461: END IF;
1462:
1463: -- if there are any deliverable instances to be deleted

Line 1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '||x_return_status);

1456: CLOSE get_del_ids_cur;
1457:
1458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1459: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);
1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '||x_return_status);
1461: END IF;
1462:
1463: -- if there are any deliverable instances to be deleted
1464: IF delIds.count > 0 THEN

Line 1465: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

1461: END IF;
1462:
1463: -- if there are any deliverable instances to be deleted
1464: IF delIds.count > 0 THEN
1465: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1466: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1467: p_api_version => l_api_version,
1468: p_init_msg_list => G_FALSE,
1469: p_doc_id => p_bus_doc_id,

Line 1466: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

1462:
1463: -- if there are any deliverable instances to be deleted
1464: IF delIds.count > 0 THEN
1465: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1466: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1467: p_api_version => l_api_version,
1468: p_init_msg_list => G_FALSE,
1469: p_doc_id => p_bus_doc_id,
1470: p_doc_type => p_bus_doc_type,

Line 1484: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '

1480: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1481: ' Finished delete_del_instances for count '||delIds.count);
1482: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1483: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1484: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '
1485: ||x_return_status);
1486: END IF;
1487:
1488: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1594: ' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '

1590:
1591: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1593: ,'1081: Recurring Definition = '||delRecTab(i).deliverable_id||
1594: ' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '
1595: ||delIds.count);
1596: END IF;
1597:
1598: -- if there are any deliverable instances to be deleted

Line 1600: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

1596: END IF;
1597:
1598: -- if there are any deliverable instances to be deleted
1599: IF delIds.count > 0 THEN
1600: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1601: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1602: p_api_version => l_api_version,
1603: p_init_msg_list => G_FALSE,
1604: p_doc_id => p_bus_doc_id,

Line 1601: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

1597:
1598: -- if there are any deliverable instances to be deleted
1599: IF delIds.count > 0 THEN
1600: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1601: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1602: p_api_version => l_api_version,
1603: p_init_msg_list => G_FALSE,
1604: p_doc_id => p_bus_doc_id,
1605: p_doc_type => p_bus_doc_type,

Line 1622: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);

1618:
1619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1621: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1622: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);
1623: END IF;
1624: END IF;
1625: -- set the flag to generate new instances
1626: generate_new_instances_yn := 'Y';

Line 1970: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;

1966: AND recurring_del_parent_id = p_del_id
1967: AND TRUNC(actual_due_date) > TRUNC(p_actual_date);
1968:
1969: --- for deliverable ids
1970: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
1971:
1972: TYPE DelIdList IS TABLE OF NUMBER
1973: INDEX BY BINARY_INTEGER;
1974: deliverableIds DelIdList;

Line 1991: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1987: l_api_name CONSTANT VARCHAR2(30) := 'updateDeliverables';
1988: l_api_version CONSTANT VARCHAR2(30) := 1;
1989:
1990: -- for storage of bulk Fetch
1991: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1992:
1993: -- for storage recurrign instances
1994: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1995:

Line 1994: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1990: -- for storage of bulk Fetch
1991: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1992:
1993: -- for storage recurrign instances
1994: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1995:
1996: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
1997: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
1998: l_actual_date DATE;

Line 2288: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'111: Recurring Deliverable = '||delRecTab(i).deliverable_id||' instances to be Deleted Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');

2284: FETCH get_del_ids_cur1 BULK COLLECT INTO delIds;
2285: CLOSE get_del_ids_cur1;
2286:
2287: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2288: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'111: Recurring Deliverable = '||delRecTab(i).deliverable_id||' instances to be Deleted Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
2289: END IF;
2290:
2291: IF delIds.count > 0 THEN
2292: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

Line 2292: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

2288: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'111: Recurring Deliverable = '||delRecTab(i).deliverable_id||' instances to be Deleted Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
2289: END IF;
2290:
2291: IF delIds.count > 0 THEN
2292: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2293: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2294: p_api_version => l_api_version,
2295: p_init_msg_list => G_FALSE,
2296: p_doc_id => p_bus_doc_id,

Line 2293: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

2289: END IF;
2290:
2291: IF delIds.count > 0 THEN
2292: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2293: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2294: p_api_version => l_api_version,
2295: p_init_msg_list => G_FALSE,
2296: p_doc_id => p_bus_doc_id,
2297: p_doc_type => p_bus_doc_type,

Line 2306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'112: Recurring Deliverable = '||delRecTab(i).deliverable_id||' FINISHED OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances'||x_return_status);

2302: x_msg_count => x_msg_count,
2303: x_return_status => x_return_status);
2304:
2305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'112: Recurring Deliverable = '||delRecTab(i).deliverable_id||' FINISHED OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances'||x_return_status);
2307: END IF;
2308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 2485: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'123: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');

2481: FETCH get_del_ids_cur2 BULK COLLECT INTO delIds;
2482: CLOSE get_del_ids_cur2;
2483:
2484: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2485: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'123: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
2486: END IF;
2487:
2488: IF delIds.count > 0 THEN
2489: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

Line 2489: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

2485: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'123: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances');
2486: END IF;
2487:
2488: IF delIds.count > 0 THEN
2489: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2490: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2491: p_api_version => l_api_version,
2492: p_init_msg_list => G_FALSE,
2493: p_doc_id => p_bus_doc_id,

Line 2490: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

2486: END IF;
2487:
2488: IF delIds.count > 0 THEN
2489: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2490: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2491: p_api_version => l_api_version,
2492: p_init_msg_list => G_FALSE,
2493: p_doc_id => p_bus_doc_id,
2494: p_doc_type => p_bus_doc_type,

Line 2503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'124: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances'||x_return_status);

2499: x_msg_count => x_msg_count,
2500: x_return_status => x_return_status);
2501:
2502: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2503: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'124: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances'||x_return_status);
2504: END IF;
2505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 2815: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

2811: END IF;
2812:
2813: --- call change_deliverable_status, to change deliverable status
2814: --- to CANCELLED
2815: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
2816: p_api_version => l_api_version,
2817: p_init_msg_list => G_FALSE,
2818: p_doc_id => p_bus_doc_id,
2819: p_doc_version => p_bus_doc_version,

Line 2934: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

2930: END IF;
2931:
2932: --- call change_deliverable_status, to change deliverable status
2933: --- to CANCELLED
2934: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
2935: p_api_version => l_api_version,
2936: p_init_msg_list => G_FALSE,
2937: p_doc_id => p_bus_doc_id,
2938: p_doc_version => p_bus_doc_version,

Line 2996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');

2992: -- Initialize API return status to success
2993: x_return_status := FND_API.G_RET_STS_SUCCESS;
2994:
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
2997: END IF;
2998:
2999: --- call change_deliverable_status, to change deliverable status from
3000: --- INACTIVE to 'OPEN'

Line 3001: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

2997: END IF;
2998:
2999: --- call change_deliverable_status, to change deliverable status from
3000: --- INACTIVE to 'OPEN'
3001: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
3002: p_api_version => l_api_version,
3003: p_init_msg_list => G_FALSE,
3004: p_doc_id => p_bus_doc_id,
3005: p_doc_version => p_bus_doc_version,

Line 3017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);

3013: x_msg_count => x_msg_count,
3014: x_return_status => x_return_status);
3015:
3016: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
3018: END IF;
3019:
3020: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 3319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables');

3315: x_return_status := FND_API.G_RET_STS_SUCCESS;
3316:
3317: -- start procedure
3318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables');
3320: END IF;
3321:
3322: --- call change_deliverable_status, to change deliverable status
3323: --- to CANCELLED

Line 3324: OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables(

3320: END IF;
3321:
3322: --- call change_deliverable_status, to change deliverable status
3323: --- to CANCELLED
3324: OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables(
3325: p_api_version => l_api_version,
3326: p_init_msg_list => G_FALSE,
3327: p_doc_id => p_bus_doc_id,
3328: p_doc_version => p_bus_doc_version,

Line 3896: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;

3892: deliverable_status <> 'INACTIVE'));
3893:
3894:
3895: del_rec del_cursor%ROWTYPE;
3896: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
3897:
3898: cursor status_notes_cur IS
3899: select
3900: deliverable.deliverable_status,

Line 4009: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(p_api_version => 1.0,

4005:
4006: begin
4007: --bulk create status history records
4008: if k > 0 then
4009: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(p_api_version => 1.0,
4010: p_init_msg_list => FND_API.G_FALSE,
4011: p_del_st_hist_tab => delStsTab,
4012: x_msg_data => x_msg_data,
4013: x_msg_count => x_msg_count,

Line 4020: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving postDelStatusChanges because of EXCEPTION in OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history:'||x_msg_data);

4016:
4017: exception
4018: when others then
4019: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4020: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving postDelStatusChanges because of EXCEPTION in OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history:'||x_msg_data);
4021:
4022: END IF;
4023: raise;
4024: end;

Line 4452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');

4448: -- Initialize API return status to success
4449: x_return_status := FND_API.G_RET_STS_SUCCESS;
4450:
4451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
4453: END IF;
4454:
4455: --- call change_deliverable_status, to change deliverable status from
4456: --- INACTIVE to 'OPEN'

Line 4457: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

4453: END IF;
4454:
4455: --- call change_deliverable_status, to change deliverable status from
4456: --- INACTIVE to 'OPEN'
4457: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
4458: p_api_version => l_api_version,
4459: p_init_msg_list => G_FALSE,
4460: p_doc_id => p_bus_doc_id,
4461: p_doc_version => p_bus_doc_version,

Line 4473: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);

4469: x_msg_count => x_msg_count,
4470: x_return_status => x_return_status);
4471:
4472: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4473: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
4474: END IF;
4475:
4476: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;