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

APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on 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: /* Bug 10048345 */
259: CURSOR find_if_deliverable_exists(ACTUAL_DUE_DATE_passed IN DATE , RECURRING_DEL_PARENT_ID_passed IN NUMBER) IS
260: SELECT deliverable_id,ACTUAL_DUE_DATE,RECURRING_DEL_PARENT_ID FROM OKC_DELIVERABLES DEL

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: /* Bug 10048345 */
259: CURSOR find_if_deliverable_exists(ACTUAL_DUE_DATE_passed IN DATE , RECURRING_DEL_PARENT_ID_passed IN NUMBER) IS
260: SELECT deliverable_id,ACTUAL_DUE_DATE,RECURRING_DEL_PARENT_ID FROM OKC_DELIVERABLES DEL
261: WHERE DEL.RECURRING_DEL_PARENT_ID= RECURRING_DEL_PARENT_ID_passed

Line 291: OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates(

287: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'501: Calling getRecurringDates');
289: END IF;
290: --- Calculate recurring instances
291: OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates(
292: p_api_version => l_api_version,
293: p_init_msg_list => G_FALSE,
294: p_start_date => p_recurr_start_date,
295: p_end_date => p_recurr_end_date,

Line 366: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(

362: delRecord.deliverable_id;
363:
364: -- copy attachments from the definition, if any
365: -- check if attachments exists
366: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(
367: p_entity_name => G_ENTITY_NAME,
368: p_pk1_value => delRecord.deliverable_id ) THEN
369:
370: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 674: okc_deliverable_process_pvt.copy_deliverable_udas(

670: delInstanceRecTab(i).estimated_price,
671: delInstanceRecTab(i).uda_template_id,
672: delInstanceRecTab(i).schedule_type
673: );
674: okc_deliverable_process_pvt.copy_deliverable_udas(
675: delInstanceRecTab(i).orig_system_reference_id1,
676: delInstanceRecTab(i).DELIVERABLE_ID,
677: x_return_status,
678: x_msg_count,

Line 696: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(

692: END IF;
693:
694: IF delStsTab.count > 0 THEN
695: --- set status history record to INACTIVE for each deliverable instance
696: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(
697: p_api_version => l_api_version,
698: p_init_msg_list => G_FALSE,
699: p_del_st_hist_tab => delStsTab,
700: x_msg_data => l_msg_data,

Line 705: 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);

701: x_msg_count => l_msg_count,
702: x_return_status => l_return_status);
703:
704: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
705: 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);
706: END IF;
707:
708: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 722: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(

718:
719: -- insert status histiry records for OPEN status
720: IF delStsTab1.count > 0 THEN
721: --- set status history record to OPEN for each deliverable instance
722: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(
723: p_api_version => l_api_version,
724: p_init_msg_list => G_FALSE,
725: p_del_st_hist_tab => delStsTab1,
726: x_msg_data => l_msg_data,

Line 731: 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);

727: x_msg_count => l_msg_count,
728: x_return_status => l_return_status);
729:
730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: 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);
732: END IF;
733:
734: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 902: OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables(

898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Calling '||'syncDeliverables');
900: END IF;
901: --- call deliverables process PVT to sync the deliverables for given version
902: OKC_DELIVERABLE_PROCESS_PVT.sync_deliverables(
903: p_api_version => l_api_version,
904: p_init_msg_list => G_FALSE,
905: p_current_docid => p_bus_doc_id,
906: p_current_doctype => p_bus_doc_type,

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

952: RAISE FND_API.G_EXC_ERROR ;
953: END IF;
954:
955: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
956: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'900: Calling '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
957: END IF;
958:
959: --- call change_deliverable_status, to change deliverable status from
960: --- INACTIVE to 'OPEN'

Line 961: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

957: END IF;
958:
959: --- call change_deliverable_status, to change deliverable status from
960: --- INACTIVE to 'OPEN'
961: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
962: p_api_version => l_api_version,
963: p_init_msg_list => G_FALSE,
964: p_doc_id => p_bus_doc_id,
965: p_doc_version => p_bus_doc_version,

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

973: x_msg_count => x_msg_count,
974: x_return_status => x_return_status);
975:
976: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status'||x_return_status);
978: END IF;
979:
980: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1080: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(

1076:
1077: IF (p_event_code is not NULL AND p_event_code = l_del_event_name) THEN
1078: --- Calculate actual date
1079: l_actual_date :=
1080: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(
1081: p_start_date => p_event_date,
1082: p_timeunit => p_event_UOM,
1083: p_duration => p_event_duration,
1084: p_before_after => l_del_before_after);

Line 1107: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(

1103: END IF;
1104:
1105: --- Calculate actual date
1106: l_actual_date :=
1107: OKC_DELIVERABLE_PROCESS_PVT.get_actual_date(
1108: p_start_date => p_bus_doc_date_events_tbl(k).event_date,
1109: p_timeunit => p_event_UOM,
1110: p_duration => p_event_duration,
1111: p_before_after => l_del_before_after);

Line 1197: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1193: AND business_document_version = p_bus_doc_version
1194: AND recurring_del_parent_id = p_del_id;
1195:
1196: -- for storage of bulk Fetch
1197: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1198:
1199: -- for storage recurrign instances
1200: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1201:

Line 1200: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

1196: -- for storage of bulk Fetch
1197: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1198:
1199: -- for storage recurrign instances
1200: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
1201:
1202: TYPE DelIdList IS TABLE OF NUMBER
1203: INDEX BY BINARY_INTEGER;
1204: deliverableIds DelIdList;

Line 1230: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;

1226:
1227: l_new_status OKC_DELIVERABLES.deliverable_status%TYPE;
1228:
1229: --- for deliverable ids
1230: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
1231:
1232: generate_new_instances_yn VARCHAR2(1);
1233: l_sync_flag VARCHAR2(1);
1234: BEGIN

Line 1550: 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);

1546: FETCH get_del_ids_cur BULK COLLECT INTO delIds;
1547: CLOSE get_del_ids_cur;
1548:
1549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: 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);
1551: 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);
1552: END IF;
1553:
1554: -- if there are any deliverable instances to be deleted

Line 1551: 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);

1547: CLOSE get_del_ids_cur;
1548:
1549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: 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);
1551: 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);
1552: END IF;
1553:
1554: -- if there are any deliverable instances to be deleted
1555: IF delIds.count > 0 THEN

Line 1556: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

1552: END IF;
1553:
1554: -- if there are any deliverable instances to be deleted
1555: IF delIds.count > 0 THEN
1556: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1557: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1558: p_api_version => l_api_version,
1559: p_init_msg_list => G_FALSE,
1560: p_doc_id => p_bus_doc_id,

Line 1557: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

1553:
1554: -- if there are any deliverable instances to be deleted
1555: IF delIds.count > 0 THEN
1556: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1557: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1558: p_api_version => l_api_version,
1559: p_init_msg_list => G_FALSE,
1560: p_doc_id => p_bus_doc_id,
1561: p_doc_type => p_bus_doc_type,

Line 1575: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '

1571: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1572: ' Finished delete_del_instances for count '||delIds.count);
1573: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1574: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1575: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances '
1576: ||x_return_status);
1577: END IF;
1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1695: ' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '

1691:
1692: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1694: ,'1081: Recurring Definition = '||delRecTab(i).deliverable_id||
1695: ' Calling OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '
1696: ||delIds.count);
1697: END IF;
1698:
1699: -- if there are any deliverable instances to be deleted

Line 1701: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

1697: END IF;
1698:
1699: -- if there are any deliverable instances to be deleted
1700: IF delIds.count > 0 THEN
1701: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1702: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1703: p_api_version => l_api_version,
1704: p_init_msg_list => G_FALSE,
1705: p_doc_id => p_bus_doc_id,

Line 1702: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

1698:
1699: -- if there are any deliverable instances to be deleted
1700: IF delIds.count > 0 THEN
1701: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
1702: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
1703: p_api_version => l_api_version,
1704: p_init_msg_list => G_FALSE,
1705: p_doc_id => p_bus_doc_id,
1706: p_doc_type => p_bus_doc_type,

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

1719:
1720: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name
1722: ,'108: Recurring Definition = '||delRecTab(i).deliverable_id||
1723: ' Finished OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances for count '||delIds.count);
1724: END IF;
1725: END IF;
1726: -- set the flag to generate new instances
1727: generate_new_instances_yn := 'Y';

Line 2073: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;

2069: AND recurring_del_parent_id = p_del_id
2070: AND TRUNC(actual_due_date) > TRUNC(p_actual_date);
2071:
2072: --- for deliverable ids
2073: delIds OKC_DELIVERABLE_PROCESS_PVT.delIdTabType;
2074:
2075: TYPE DelIdList IS TABLE OF NUMBER
2076: INDEX BY BINARY_INTEGER;
2077: deliverableIds DelIdList;

Line 2094: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

2090: l_api_name CONSTANT VARCHAR2(30) := 'updateDeliverables';
2091: l_api_version CONSTANT VARCHAR2(30) := 1;
2092:
2093: -- for storage of bulk Fetch
2094: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2095:
2096: -- for storage recurrign instances
2097: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2098:

Line 2097: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;

2093: -- for storage of bulk Fetch
2094: delRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2095:
2096: -- for storage recurrign instances
2097: delInstanceRecTab OKC_DELIVERABLE_PROCESS_PVT.delRecTabType;
2098:
2099: l_del_event_name OKC_BUS_DOC_EVENTS_B.business_event_code%TYPE;
2100: l_del_before_after OKC_BUS_DOC_EVENTS_B.before_after%TYPE;
2101: l_actual_date DATE;

Line 2405: 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');

2401: FETCH get_del_ids_cur1 BULK COLLECT INTO delIds;
2402: CLOSE get_del_ids_cur1;
2403:
2404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2405: 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');
2406: END IF;
2407:
2408: IF delIds.count > 0 THEN
2409: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

Line 2409: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

2405: 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');
2406: END IF;
2407:
2408: IF delIds.count > 0 THEN
2409: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2410: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2411: p_api_version => l_api_version,
2412: p_init_msg_list => G_FALSE,
2413: p_doc_id => p_bus_doc_id,

Line 2410: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

2406: END IF;
2407:
2408: IF delIds.count > 0 THEN
2409: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2410: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2411: p_api_version => l_api_version,
2412: p_init_msg_list => G_FALSE,
2413: p_doc_id => p_bus_doc_id,
2414: p_doc_type => p_bus_doc_type,

Line 2423: 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);

2419: x_msg_count => x_msg_count,
2420: x_return_status => x_return_status);
2421:
2422: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2423: 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);
2424: END IF;
2425: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2427: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 2603: 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');

2599: FETCH get_del_ids_cur2 BULK COLLECT INTO delIds;
2600: CLOSE get_del_ids_cur2;
2601:
2602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2603: 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');
2604: END IF;
2605:
2606: IF delIds.count > 0 THEN
2607: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

Line 2607: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT

2603: 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');
2604: END IF;
2605:
2606: IF delIds.count > 0 THEN
2607: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2608: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2609: p_api_version => l_api_version,
2610: p_init_msg_list => G_FALSE,
2611: p_doc_id => p_bus_doc_id,

Line 2608: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(

2604: END IF;
2605:
2606: IF delIds.count > 0 THEN
2607: --- call delete_del_instances or OKC_DELIVERABLE_PROCESS_PVT
2608: OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances(
2609: p_api_version => l_api_version,
2610: p_init_msg_list => G_FALSE,
2611: p_doc_id => p_bus_doc_id,
2612: p_doc_type => p_bus_doc_type,

Line 2621: 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);

2617: x_msg_count => x_msg_count,
2618: x_return_status => x_return_status);
2619:
2620: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2621: 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);
2622: END IF;
2623: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2625: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 2935: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

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

Line 3054: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

3050: END IF;
3051:
3052: --- call change_deliverable_status, to change deliverable status
3053: --- to CANCELLED
3054: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
3055: p_api_version => l_api_version,
3056: p_init_msg_list => G_FALSE,
3057: p_doc_id => p_bus_doc_id,
3058: p_doc_version => p_bus_doc_version,

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

3112: -- Initialize API return status to success
3113: x_return_status := FND_API.G_RET_STS_SUCCESS;
3114:
3115: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3116: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
3117: END IF;
3118:
3119: --- call change_deliverable_status, to change deliverable status from
3120: --- INACTIVE to 'OPEN'

Line 3121: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

3117: END IF;
3118:
3119: --- call change_deliverable_status, to change deliverable status from
3120: --- INACTIVE to 'OPEN'
3121: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
3122: p_api_version => l_api_version,
3123: p_init_msg_list => G_FALSE,
3124: p_doc_id => p_bus_doc_id,
3125: p_doc_version => p_bus_doc_version,

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

3133: x_msg_count => x_msg_count,
3134: x_return_status => x_return_status);
3135:
3136: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3137: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
3138: END IF;
3139:
3140: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

3435: x_return_status := FND_API.G_RET_STS_SUCCESS;
3436:
3437: -- start procedure
3438: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3439: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables');
3440: END IF;
3441:
3442: --- call change_deliverable_status, to change deliverable status
3443: --- to CANCELLED

Line 3444: OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables(

3440: END IF;
3441:
3442: --- call change_deliverable_status, to change deliverable status
3443: --- to CANCELLED
3444: OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables(
3445: p_api_version => l_api_version,
3446: p_init_msg_list => G_FALSE,
3447: p_doc_id => p_bus_doc_id,
3448: p_doc_version => p_bus_doc_version,

Line 4016: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;

4012: deliverable_status <> 'INACTIVE'));
4013:
4014:
4015: del_rec del_cursor%ROWTYPE;
4016: delStsTab OKC_DELIVERABLE_PROCESS_PVT.delHistTabType;
4017:
4018: cursor status_notes_cur IS
4019: select
4020: deliverable.deliverable_status,

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

4150:
4151: begin
4152: --bulk create status history records
4153: if k > 0 then
4154: OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history(p_api_version => 1.0,
4155: p_init_msg_list => FND_API.G_FALSE,
4156: p_del_st_hist_tab => delStsTab,
4157: x_msg_data => x_msg_data,
4158: x_msg_count => x_msg_count,

Line 4165: 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);

4161:
4162: exception
4163: when others then
4164: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4165: 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);
4166:
4167: END IF;
4168: raise;
4169: end;

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

4593: -- Initialize API return status to success
4594: x_return_status := FND_API.G_RET_STS_SUCCESS;
4595:
4596: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4597: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
4598: END IF;
4599:
4600: --- call change_deliverable_status, to change deliverable status from
4601: --- INACTIVE to 'OPEN'

Line 4602: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(

4598: END IF;
4599:
4600: --- call change_deliverable_status, to change deliverable status from
4601: --- INACTIVE to 'OPEN'
4602: OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status(
4603: p_api_version => l_api_version,
4604: p_init_msg_list => G_FALSE,
4605: p_doc_id => p_bus_doc_id,
4606: p_doc_version => p_bus_doc_version,

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

4614: x_msg_count => x_msg_count,
4615: x_return_status => x_return_status);
4616:
4617: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4618: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
4619: END IF;
4620:
4621: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;