DBA Data[Home] [Help]

APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

7: ---------------------------------------------------------------------------
8: -- Global VARIABLES
9: ---------------------------------------------------------------------------
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_MANAGE_DELIVERABLES_GRP';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: g_module CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
13: G_ENTITY_NAME CONSTANT VARCHAR2(40) := 'OKC_DELIVERABLES';
14:
15: ------------------------------------------------------------------------------

Line 187: Okc_Api.Set_Message(G_APP_NAME,

183: WHEN OTHERS THEN
184: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
186: END IF;
187: Okc_Api.Set_Message(G_APP_NAME,
188: 'OKC_DEL_ERR_CHK_INSTS_STS');
189: RAISE FND_API.G_EXC_ERROR;
190: END;
191:

Line 756: Okc_Api.Set_Message(G_APP_NAME,

752: WHEN OTHERS THEN
753: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
755: END IF;
756: Okc_Api.Set_Message(G_APP_NAME,
757: 'OKC_DEL_ERR_GEN_INSTS');
758: RAISE FND_API.G_EXC_ERROR;
759: END; -- generate_del_instances
760:

Line 807: Okc_Api.Set_Message(G_APP_NAME,

803: WHEN OTHERS THEN
804: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
806: END IF;
807: Okc_Api.Set_Message(G_APP_NAME,
808: 'OKC_DEL_ERR_EVT_DTLS');
809: RAISE FND_API.G_EXC_ERROR;
810:
811: END;

Line 854: Okc_Api.Set_Message(G_APP_NAME

850: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Bus dod event date'||p_event_date);
851: END IF;
852:
853: IF p_bus_doc_id = NULL THEN
854: Okc_Api.Set_Message(G_APP_NAME
855: ,'OKC_DEL_NO_PARAMS');
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858: IF p_bus_doc_type = NULL THEN

Line 859: Okc_Api.Set_Message(G_APP_NAME

855: ,'OKC_DEL_NO_PARAMS');
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858: IF p_bus_doc_type = NULL THEN
859: Okc_Api.Set_Message(G_APP_NAME
860: ,'OKC_DEL_NO_PARAMS');
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863: IF p_bus_doc_version = NULL THEN

Line 864: Okc_Api.Set_Message(G_APP_NAME

860: ,'OKC_DEL_NO_PARAMS');
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863: IF p_bus_doc_version = NULL THEN
864: Okc_Api.Set_Message(G_APP_NAME
865: ,'OKC_DEL_NO_PARAMS');
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868: IF p_event_code = NULL THEN

Line 869: Okc_Api.Set_Message(G_APP_NAME

865: ,'OKC_DEL_NO_PARAMS');
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868: IF p_event_code = NULL THEN
869: Okc_Api.Set_Message(G_APP_NAME
870: ,'OKC_DEL_NO_PARAMS');
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: IF p_event_date = NULL THEN

Line 874: Okc_Api.Set_Message(G_APP_NAME

870: ,'OKC_DEL_NO_PARAMS');
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: IF p_event_date = NULL THEN
874: Okc_Api.Set_Message(G_APP_NAME
875: ,'OKC_DEL_NO_PARAMS');
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:

Line 1055: Okc_Api.Set_Message(G_APP_NAME,

1051: END IF;
1052:
1053: IF p_event_id is NULL OR p_event_UOM is NULL OR p_event_duration is NULL THEN
1054:
1055: Okc_Api.Set_Message(G_APP_NAME,
1056: 'OKC_DEL_NOT_RSLV_EVTS');
1057: RAISE FND_API.G_EXC_ERROR;
1058:
1059: END IF;

Line 1087: Okc_Api.Set_Message(G_APP_NAME,

1083: p_duration => p_event_duration,
1084: p_before_after => l_del_before_after);
1085:
1086: IF l_actual_date is NULL THEN
1087: Okc_Api.Set_Message(G_APP_NAME,
1088: 'OKC_DEL_DT_NOT_RSLVD');
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:

Line 1113: Okc_Api.Set_Message(G_APP_NAME,

1109: p_timeunit => p_event_UOM,
1110: p_duration => p_event_duration,
1111: p_before_after => l_del_before_after);
1112: /* IF l_actual_date is NULL THEN
1113: Okc_Api.Set_Message(G_APP_NAME,
1114: 'OKC_DEL_DT_NOT_RSLVD');
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF; */
1117:

Line 1444: Okc_Api.Set_Message(G_APP_NAME,

1440: END IF;
1441:
1442: -- unexpected error
1443: IF l_has_instances_yn is null THEN
1444: Okc_Api.Set_Message(G_APP_NAME,
1445: 'OKC_DEL_ERR_GET_INSTS');
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF;
1448:

Line 1496: Okc_Api.Set_Message(G_APP_NAME,

1492: -- to resolve relative end date check if due dates table is
1493: -- not empty
1494: /*--Commenting out as part of fix for bug 4030982--
1495: IF p_bus_doc_date_events_tbl.count = 0 THEN
1496: Okc_Api.Set_Message(G_APP_NAME,
1497: 'OKC_DEL_ERR_DTS_EMPY');
1498: RAISE FND_API.G_EXC_ERROR;
1499: END IF;
1500: */

Line 1528: Okc_Api.Set_Message(G_APP_NAME,

1524: END IF; --- End Date is Evaluated
1525:
1526: -- By this time l_recurr_end_date should not be NULL
1527: IF l_recurr_end_date is NULL THEN
1528: Okc_Api.Set_Message(G_APP_NAME,
1529: 'OKC_DEL_END_DT_NOT_FOUND');
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:

Line 1771: Okc_Api.Set_Message(G_APP_NAME,

1767: l_recurr_start_date := delRecTab(i).fixed_start_date;
1768:
1769: -- By this time l_recurr_start_date should not be NULL
1770: IF l_recurr_start_date is NULL THEN
1771: Okc_Api.Set_Message(G_APP_NAME,
1772: 'OKC_DEL_ST_DT_NOT_FOUND');
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775: END IF; --- Start date resolved

Line 1818: Okc_Api.Set_Message(G_APP_NAME,

1814:
1815: END IF; --- get the end date
1816:
1817: IF l_recurr_end_date is NULL THEN
1818: Okc_Api.Set_Message(G_APP_NAME,
1819: 'OKC_DEL_END_DT_NOT_FOUND');
1820: RAISE FND_API.G_EXC_ERROR;
1821: END IF;
1822:

Line 1836: Okc_Api.Set_Message(G_APP_NAME,

1832: -- if both frequency values ar null
1833: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL
1834: AND Nvl(delRecTab(i).repeating_frequency_uom,'ABC') <> 'DAY'
1835: ) THEN
1836: Okc_Api.Set_Message(G_APP_NAME,
1837: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
1838: RAISE FND_API.G_EXC_ERROR;
1839: END IF;
1840:

Line 2485: Okc_Api.Set_Message(G_APP_NAME,

2481: END IF;
2482:
2483: --- raise exception if END is NULL
2484: IF l_recurr_end_date is NULL THEN
2485: Okc_Api.Set_Message(G_APP_NAME,
2486: 'OKC_DEL_END_DT_NOT_FOUND');
2487: RAISE FND_API.G_EXC_ERROR;
2488: END IF;
2489:

Line 2500: Okc_Api.Set_Message(G_APP_NAME,

2496:
2497: -- if both frequency values ar null
2498: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL
2499: AND Nvl(delRecTab(i).repeating_frequency_uom,'ABC') <> 'DAY') THEN
2500: Okc_Api.Set_Message(G_APP_NAME,
2501: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:

Line 2578: Okc_Api.Set_Message(G_APP_NAME,

2574: END IF;
2575:
2576: --- raise exception if END is NULL
2577: /* IF l_recurr_end_date is NULL THEN
2578: Okc_Api.Set_Message(G_APP_NAME,
2579: 'OKC_DEL_END_DT_NOT_FOUND');
2580: RAISE FND_API.G_EXC_ERROR;
2581: END IF; */
2582:

Line 2665: Okc_Api.Set_Message(G_APP_NAME,

2661:
2662: -- if both frequency values ar null
2663: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL
2664: AND Nvl(delRecTab(i).repeating_frequency_uom,'ABC') <> 'DAY') THEN
2665: Okc_Api.Set_Message(G_APP_NAME,
2666: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;
2669:

Line 4116: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_bus_doc_type);

4112: */
4113:
4114:
4115: if ('COMPLETED' = del_rec.deliverable_status) THEN
4116: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_bus_doc_type);
4117: elsif ('CANCELLED' = del_rec.deliverable_status) THEN
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_bus_doc_type);
4119: elsif ('OPEN' = del_rec.deliverable_status) THEN
4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);

Line 4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_bus_doc_type);

4114:
4115: if ('COMPLETED' = del_rec.deliverable_status) THEN
4116: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_bus_doc_type);
4117: elsif ('CANCELLED' = del_rec.deliverable_status) THEN
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_bus_doc_type);
4119: elsif ('OPEN' = del_rec.deliverable_status) THEN
4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);
4121: elsif ('FAILED_TO_PERFORM' = del_rec.deliverable_status) THEN
4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);

Line 4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);

4116: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_COMPLETE_NTF_SUBJECT',p_bus_doc_type);
4117: elsif ('CANCELLED' = del_rec.deliverable_status) THEN
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_bus_doc_type);
4119: elsif ('OPEN' = del_rec.deliverable_status) THEN
4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);
4121: elsif ('FAILED_TO_PERFORM' = del_rec.deliverable_status) THEN
4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);
4123: elsif ('REJECTED' = del_rec.deliverable_status ) THEN
4124: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_bus_doc_type);

Line 4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);

4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_CANCEL_NTF_SUBJECT',p_bus_doc_type);
4119: elsif ('OPEN' = del_rec.deliverable_status) THEN
4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);
4121: elsif ('FAILED_TO_PERFORM' = del_rec.deliverable_status) THEN
4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);
4123: elsif ('REJECTED' = del_rec.deliverable_status ) THEN
4124: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_bus_doc_type);
4125: ELSE
4126: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_bus_doc_type);

Line 4124: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_bus_doc_type);

4120: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REOPEN_NTF_SUBJECT',p_bus_doc_type);
4121: elsif ('FAILED_TO_PERFORM' = del_rec.deliverable_status) THEN
4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);
4123: elsif ('REJECTED' = del_rec.deliverable_status ) THEN
4124: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_bus_doc_type);
4125: ELSE
4126: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_bus_doc_type);
4127: end if;
4128:

Line 4126: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_bus_doc_type);

4122: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_FAILED_NTF_SUBJECT',p_bus_doc_type);
4123: elsif ('REJECTED' = del_rec.deliverable_status ) THEN
4124: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_REJECT_NTF_SUBJECT',p_bus_doc_type);
4125: ELSE
4126: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_SUBMIT_NTF_SUBJECT',p_bus_doc_type);
4127: end if;
4128:
4129: l_msg_code := l_resolved_msg_name;
4130:

Line 4255: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4251:
4252: BEGIN
4253:
4254: -- Initialize API return status to success
4255: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4256:
4257:
4258: l_return_value := 'N';
4259:

Line 4337: x_return_status := OKC_API.G_RET_STS_SUCCESS;

4333:
4334: BEGIN
4335:
4336: -- Initialize API return status to success
4337: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4338:
4339:
4340: l_return_value := 'N';
4341: