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 FND_API

Line 18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

14:
15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

16: -- GLOBAL CONSTANTS
17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

17: ------------------------------------------------------------------------------
18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: ---------------------------------------------------------------------------

Line 22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

18: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
19: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: ---------------------------------------------------------------------------
26: -- START: Helper Procedures and Functions

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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
72: RAISE FND_API.G_EXC_ERROR ;
73: END IF;
74: END IF;

Line 72: RAISE FND_API.G_EXC_ERROR ;

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
72: RAISE FND_API.G_EXC_ERROR ;
73: END IF;
74: END IF;
75:
76: EXCEPTION

Line 77: WHEN FND_API.G_EXC_ERROR THEN

73: END IF;
74: END IF;
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
80: END IF;
81: x_return_status := G_RET_STS_ERROR;

Line 87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

83: p_count => x_msg_count,
84: p_data => x_msg_data
85: );
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
90: END IF;
91: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 189: RAISE FND_API.G_EXC_ERROR;

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:
192: /**
193: * Helper method to return 'Y' if recurring deliverable definition already

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

305: END IF;
306:
307: -- check status
308: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
310: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
311: RAISE FND_API.G_EXC_ERROR ;
312: END IF;
313:

Line 311: RAISE FND_API.G_EXC_ERROR ;

307: -- check status
308: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
310: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
311: RAISE FND_API.G_EXC_ERROR ;
312: END IF;
313:
314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'601: Recurr Dates Count'||l_recurring_dates.count);

Line 682: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

678: x_msg_count,
679: x_msg_data,
680: x_errorcode
681: );
682: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;
685: END LOOP;
686:

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: x_msg_data,
680: x_errorcode
681: );
682: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;
685: END LOOP;
686:
687: ------------------------------------------------------------------------

Line 709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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 ;
710: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
711: RAISE FND_API.G_EXC_ERROR ;
712: END IF;
713: END IF;

Line 711: RAISE FND_API.G_EXC_ERROR ;

707:
708: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
710: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
711: RAISE FND_API.G_EXC_ERROR ;
712: END IF;
713: END IF;
714:
715: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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 ;
736: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
737: RAISE FND_API.G_EXC_ERROR ;
738: END IF;
739: END IF;

Line 737: RAISE FND_API.G_EXC_ERROR ;

733:
734: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
736: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
737: RAISE FND_API.G_EXC_ERROR ;
738: END IF;
739: END IF;
740:
741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 758: RAISE FND_API.G_EXC_ERROR;

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:
761: /**
762: * Helper method to return proper number value for the day of week.

Line 809: RAISE FND_API.G_EXC_ERROR;

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;
812:
813: ---------------------------------------------------------------------------

Line 856: RAISE FND_API.G_EXC_ERROR;

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
859: Okc_Api.Set_Message(G_APP_NAME
860: ,'OKC_DEL_NO_PARAMS');

Line 861: 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
864: Okc_Api.Set_Message(G_APP_NAME
865: ,'OKC_DEL_NO_PARAMS');

Line 866: 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
869: Okc_Api.Set_Message(G_APP_NAME
870: ,'OKC_DEL_NO_PARAMS');

Line 871: 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
874: Okc_Api.Set_Message(G_APP_NAME
875: ,'OKC_DEL_NO_PARAMS');

Line 876: 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:
879: -- Standard Start of API savepoint
880: SAVEPOINT g_activate_del_GRP;

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

879: -- Standard Start of API savepoint
880: SAVEPOINT g_activate_del_GRP;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:
887: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

880: SAVEPOINT g_activate_del_GRP;
881:
882: -- Standard call to check for call compatibility.
883: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:
887: -- Initialize message list if p_init_msg_list is set to TRUE.
888: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 888: IF FND_API.to_Boolean( p_init_msg_list ) THEN

884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;
886:
887: -- Initialize message list if p_init_msg_list is set to TRUE.
888: IF FND_API.to_Boolean( p_init_msg_list ) THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891:
892: -- Initialize API return status to success

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889: FND_MSG_PUB.initialize;
890: END IF;
891:
892: -- Initialize API return status to success
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: --- check if sync flag is TRUE
896: IF FND_API.To_Boolean( p_sync_flag ) THEN
897:

Line 896: IF FND_API.To_Boolean( p_sync_flag ) THEN

892: -- Initialize API return status to success
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: --- check if sync flag is TRUE
896: IF FND_API.To_Boolean( p_sync_flag ) THEN
897:
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;

Line 917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

913: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701: Finished resolveDeliverables'||x_return_status);
914: END IF;
915:
916: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
918: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
919: RAISE FND_API.G_EXC_ERROR ;
920: END IF;
921:

Line 919: RAISE FND_API.G_EXC_ERROR ;

915:
916: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
918: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
919: RAISE FND_API.G_EXC_ERROR ;
920: END IF;
921:
922: END IF;
923:

Line 943: p_sync_recurr_instances_flag => FND_API.G_TRUE);

939: x_msg_data => x_msg_data,
940: x_msg_count => x_msg_count,
941: x_return_status => x_return_status,
942: p_sync_flag => p_sync_flag,
943: p_sync_recurr_instances_flag => FND_API.G_TRUE);
944:
945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
946: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Finished resolveDeliverables'||x_return_status);
947: END IF;

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

946: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Finished resolveDeliverables'||x_return_status);
947: END IF;
948:
949: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
951: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
952: RAISE FND_API.G_EXC_ERROR ;
953: END IF;
954:

Line 952: RAISE FND_API.G_EXC_ERROR ;

948:
949: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
951: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
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');

Line 981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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 ;
982: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
983: RAISE FND_API.G_EXC_ERROR ;
984: END IF;
985:

Line 983: RAISE FND_API.G_EXC_ERROR ;

979:
980: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
982: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
983: RAISE FND_API.G_EXC_ERROR ;
984: END IF;
985:
986: IF FND_API.To_Boolean( p_commit ) THEN
987: COMMIT WORK;

Line 986: IF FND_API.To_Boolean( p_commit ) THEN

982: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
983: RAISE FND_API.G_EXC_ERROR ;
984: END IF;
985:
986: IF FND_API.To_Boolean( p_commit ) THEN
987: COMMIT WORK;
988: END IF;
989:
990: -- Standard call to get message count and if count is 1, get message info.

Line 998: WHEN FND_API.G_EXC_ERROR THEN

994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: Leaving activateDeliverables');
995: END IF;
996:
997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN
999: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1200: Leaving activateDeliverables Unexpected ERROR');
1001: END IF;
1002: ROLLBACK TO g_activate_del_GRP;

Line 1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1002: ROLLBACK TO g_activate_del_GRP;
1003: x_return_status := G_RET_STS_ERROR ;
1004: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1300: Leaving activateDeliverables Unexpected ERROR');
1009: END IF;
1010: ROLLBACK TO g_activate_del_GRP;

Line 1057: RAISE FND_API.G_EXC_ERROR;

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;
1060:
1061: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1089: RAISE FND_API.G_EXC_ERROR;

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:
1092: END IF;
1093:

Line 1115: RAISE FND_API.G_EXC_ERROR;

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:
1118: END IF;
1119: END LOOP;

Line 1240: l_sync_flag := FND_API.G_FALSE;

1236: -- initialize
1237: del_count := 0;
1238: j := 0;
1239: k := 0;
1240: l_sync_flag := FND_API.G_FALSE;
1241:
1242: -- start procedure
1243: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);

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

1247: -- Standard Start of API savepoint
1248: SAVEPOINT g_resolve_del_GRP;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1248: SAVEPOINT g_resolve_del_GRP;
1249:
1250: -- Standard call to check for call compatibility.
1251: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: -- Initialize API return status to success

Line 1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1264: l_sync_flag := FND_API.G_TRUE;
1265: ELSE

Line 1263: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN

1259:
1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1264: l_sync_flag := FND_API.G_TRUE;
1265: ELSE
1266: l_sync_flag := p_sync_flag;
1267: END IF;

Line 1264: l_sync_flag := FND_API.G_TRUE;

1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1264: l_sync_flag := FND_API.G_TRUE;
1265: ELSE
1266: l_sync_flag := p_sync_flag;
1267: END IF;
1268:

Line 1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1412: x_msg_data => x_msg_data,
1413: x_msg_count => x_msg_count,
1414: x_return_status => x_return_status);
1415: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1417: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1418: RAISE FND_API.G_EXC_ERROR ;
1419: END IF;
1420:

Line 1418: RAISE FND_API.G_EXC_ERROR ;

1414: x_return_status => x_return_status);
1415: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1417: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1418: RAISE FND_API.G_EXC_ERROR ;
1419: END IF;
1420:
1421: END IF; -- fixed due date is 'Yes'
1422:

Line 1446: RAISE FND_API.G_EXC_ERROR;

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:
1449: -- by default this is N
1450: generate_new_instances_yn := 'N';

Line 1472: IF FND_API.To_Boolean( l_sync_flag ) THEN

1468: END IF;
1469:
1470: -- fix Bug 3574466: If sync flag is true, generate only the
1471: -- delta instances.
1472: IF FND_API.To_Boolean( l_sync_flag ) THEN
1473:
1474: --- ASSUMPTION: In this case only end date can change
1475: --- get old start date
1476: l_recurr_start_date := delRecTab(i).start_event_date;

Line 1498: RAISE FND_API.G_EXC_ERROR;

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: */
1501:
1502: --- resolve relative end date

Line 1530: RAISE FND_API.G_EXC_ERROR;

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:
1533: --- check if new date is less then old date
1534: --- delete instances where actual date is equal to or

Line 1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1576: ||x_return_status);
1577: END IF;
1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1582: RAISE FND_API.G_EXC_ERROR ;
1583: END IF;
1584:

Line 1582: RAISE FND_API.G_EXC_ERROR ;

1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1582: RAISE FND_API.G_EXC_ERROR ;
1583: END IF;
1584:
1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

Line 1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1711: x_msg_count => x_msg_count,
1712: x_return_status => x_return_status);
1713:
1714: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1716: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1717: RAISE FND_API.G_EXC_ERROR ;
1718: END IF;
1719:

Line 1717: RAISE FND_API.G_EXC_ERROR ;

1713:
1714: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1716: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1717: RAISE FND_API.G_EXC_ERROR ;
1718: END IF;
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

Line 1773: RAISE FND_API.G_EXC_ERROR;

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
1776:
1777: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1820: RAISE FND_API.G_EXC_ERROR;

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:
1823: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1824: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Get Recurring Frequency ');

Line 1838: RAISE FND_API.G_EXC_ERROR;

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:
1841: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Generate Instances ');

Line 1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1888: x_msg_data => x_msg_data,
1889: x_msg_count => x_msg_count,
1890: x_return_status => x_return_status);
1891: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1893: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1894: RAISE FND_API.G_EXC_ERROR ;
1895: END IF;
1896:

Line 1894: RAISE FND_API.G_EXC_ERROR ;

1890: x_return_status => x_return_status);
1891: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1893: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1894: RAISE FND_API.G_EXC_ERROR ;
1895: END IF;
1896:
1897:
1898: --- resolve relative end date

Line 1952: IF FND_API.To_Boolean( p_commit ) THEN

1948: IF del_cur %ISOPEN THEN
1949: CLOSE del_cur ;
1950: END IF;
1951:
1952: IF FND_API.To_Boolean( p_commit ) THEN
1953: COMMIT WORK;
1954: END IF;
1955:
1956: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1962: WHEN FND_API.G_EXC_ERROR THEN

1958: END IF;
1959:
1960: EXCEPTION
1961:
1962: WHEN FND_API.G_EXC_ERROR THEN
1963: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1964: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving resolveDeliverables Unexpected ERROR');
1965: END IF;
1966: IF del_cur %ISOPEN THEN

Line 1977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1973: ROLLBACK TO g_resolve_del_GRP;
1974: x_return_status := G_RET_STS_ERROR ;
1975: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1976:
1977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1978: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1979: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving resolveDeliverables Unexpected ERROR');
1980: END IF;
1981: IF del_cur %ISOPEN THEN

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

2125: -- Standard Start of API savepoint
2126: SAVEPOINT g_update_del_GRP;
2127:
2128: -- Standard call to check for call compatibility.
2129: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: END IF;
2132:
2133: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2126: SAVEPOINT g_update_del_GRP;
2127:
2128: -- Standard call to check for call compatibility.
2129: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: END IF;
2132:
2133: -- Initialize message list if p_init_msg_list is set to TRUE.
2134: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2134: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2131: END IF;
2132:
2133: -- Initialize message list if p_init_msg_list is set to TRUE.
2134: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2135: FND_MSG_PUB.initialize;
2136: END IF;
2137:
2138: -- Initialize API return status to success

Line 2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

2135: FND_MSG_PUB.initialize;
2136: END IF;
2137:
2138: -- Initialize API return status to success
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: --- open deliverables cursor and populate records of table
2142: FOR del_rec IN del_cur LOOP
2143: k := k+1;

Line 2426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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
2428: RAISE FND_API.G_EXC_ERROR ;
2429: END IF;
2430: END IF; -- end delIds > 0

Line 2428: RAISE FND_API.G_EXC_ERROR ;

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
2428: RAISE FND_API.G_EXC_ERROR ;
2429: END IF;
2430: END IF; -- end delIds > 0
2431: --- re-resolve the deliverable
2432: --- you have the start date.

Line 2487: RAISE FND_API.G_EXC_ERROR;

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:
2490:
2491: --- get the repeat frequency and create new instances

Line 2502: RAISE FND_API.G_EXC_ERROR;

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:
2505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'116: Recurring Deliverable = '||delRecTab(i).deliverable_id||' Calling generated instances');

Line 2580: RAISE FND_API.G_EXC_ERROR;

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:
2583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'121a: new end date = '||l_recurr_end_date||' Old end date '||delRecTab(i).end_event_date);

Line 2624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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
2626: RAISE FND_API.G_EXC_ERROR ;
2627: END IF;
2628:

Line 2626: RAISE FND_API.G_EXC_ERROR ;

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
2626: RAISE FND_API.G_EXC_ERROR ;
2627: END IF;
2628:
2629: END IF;
2630: --- increment the count

Line 2667: RAISE FND_API.G_EXC_ERROR;

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:
2670: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2671: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'126: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Calling generate_del_instances');

Line 2733: IF FND_API.To_Boolean( p_commit ) THEN

2729: IF del_cur %ISOPEN THEN
2730: CLOSE del_cur ;
2731: END IF;
2732:
2733: IF FND_API.To_Boolean( p_commit ) THEN
2734: COMMIT WORK;
2735: END IF;
2736:
2737: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2743: WHEN FND_API.G_EXC_ERROR THEN

2739: END IF;
2740:
2741: EXCEPTION
2742:
2743: WHEN FND_API.G_EXC_ERROR THEN
2744: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2745: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateDeliverables Unexpected ERROR');
2746: END IF;
2747: IF del_cur %ISOPEN THEN

Line 2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2757: ROLLBACK TO g_update_del_GRP;
2758: x_return_status := G_RET_STS_ERROR ;
2759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2760:
2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2762: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2763: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');
2764: END IF;
2765: IF del_cur %ISOPEN THEN

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

2827: -- Standard Start of API savepoint
2828: SAVEPOINT g_enable_del_ntf_GRP;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END IF;
2834:
2835: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2828: SAVEPOINT g_enable_del_ntf_GRP;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END IF;
2834:
2835: -- Initialize message list if p_init_msg_list is set to TRUE.
2836: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2836: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END IF;
2834:
2835: -- Initialize message list if p_init_msg_list is set to TRUE.
2836: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2837: FND_MSG_PUB.initialize;
2838: END IF;
2839:
2840: -- Initialize API return status to success

Line 2841: x_return_status := FND_API.G_RET_STS_SUCCESS;

2837: FND_MSG_PUB.initialize;
2838: END IF;
2839:
2840: -- Initialize API return status to success
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'
2844: WHERE business_document_id = p_bus_doc_id
2845: AND business_document_type = p_bus_doc_type

Line 2848: IF FND_API.To_Boolean( p_commit ) THEN

2844: WHERE business_document_id = p_bus_doc_id
2845: AND business_document_type = p_bus_doc_type
2846: AND business_document_version = p_bus_doc_version;
2847:
2848: IF FND_API.To_Boolean( p_commit ) THEN
2849: COMMIT WORK;
2850: END IF;
2851:
2852: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2858: WHEN FND_API.G_EXC_ERROR THEN

2854: END IF;
2855:
2856: EXCEPTION
2857:
2858: WHEN FND_API.G_EXC_ERROR THEN
2859: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2860: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving enableNotifications Unexpected ERROR');
2861: END IF;
2862: ROLLBACK TO g_enable_del_ntf_GRP;

Line 2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2862: ROLLBACK TO g_enable_del_ntf_GRP;
2863: x_return_status := G_RET_STS_ERROR ;
2864: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2868: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving enableNotifications Unexpected ERROR');
2869: END IF;
2870: ROLLBACK TO g_enable_del_ntf_GRP;

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

2912: -- Standard Start of API savepoint
2913: SAVEPOINT g_cancel_del_GRP;
2914:
2915: -- Standard call to check for call compatibility.
2916: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END IF;
2919:
2920: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2913: SAVEPOINT g_cancel_del_GRP;
2914:
2915: -- Standard call to check for call compatibility.
2916: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END IF;
2919:
2920: -- Initialize message list if p_init_msg_list is set to TRUE.
2921: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2921: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END IF;
2919:
2920: -- Initialize message list if p_init_msg_list is set to TRUE.
2921: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2922: FND_MSG_PUB.initialize;
2923: END IF;
2924:
2925: -- Initialize API return status to success

Line 2926: x_return_status := FND_API.G_RET_STS_SUCCESS;

2922: FND_MSG_PUB.initialize;
2923: END IF;
2924:
2925: -- Initialize API return status to success
2926: x_return_status := FND_API.G_RET_STS_SUCCESS;
2927:
2928: -- start procedure
2929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'change_deliverable_status');

Line 2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished change_deliverable_status' ||x_return_status);
2952: END IF;
2953:
2954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2956: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2957: RAISE FND_API.G_EXC_ERROR ;
2958: END IF;
2959:

Line 2957: RAISE FND_API.G_EXC_ERROR ;

2953:
2954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2956: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2957: RAISE FND_API.G_EXC_ERROR ;
2958: END IF;
2959:
2960:
2961: IF FND_API.To_Boolean( p_commit ) THEN

Line 2961: IF FND_API.To_Boolean( p_commit ) THEN

2957: RAISE FND_API.G_EXC_ERROR ;
2958: END IF;
2959:
2960:
2961: IF FND_API.To_Boolean( p_commit ) THEN
2962: COMMIT WORK;
2963: END IF;
2964:
2965: -- Standard call to get message count and if count is 1, get message info.

Line 2974: WHEN FND_API.G_EXC_ERROR THEN

2970: END IF;
2971:
2972: EXCEPTION
2973:
2974: WHEN FND_API.G_EXC_ERROR THEN
2975: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2976: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
2977: END IF;
2978: ROLLBACK TO g_cancel_del_GRP;

Line 2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2978: ROLLBACK TO g_cancel_del_GRP;
2979: x_return_status := G_RET_STS_ERROR ;
2980: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2981:
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2983: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2984: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
2985: END IF;
2986: ROLLBACK TO g_cancel_del_GRP;

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

3031: -- Standard Start of API savepoint
3032: SAVEPOINT g_cancel2_del_GRP;
3033:
3034: -- Standard call to check for call compatibility.
3035: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037: END IF;
3038:
3039: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3032: SAVEPOINT g_cancel2_del_GRP;
3033:
3034: -- Standard call to check for call compatibility.
3035: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037: END IF;
3038:
3039: -- Initialize message list if p_init_msg_list is set to TRUE.
3040: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3040: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037: END IF;
3038:
3039: -- Initialize message list if p_init_msg_list is set to TRUE.
3040: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3041: FND_MSG_PUB.initialize;
3042: END IF;
3043:
3044: -- Initialize API return status to success

Line 3045: x_return_status := FND_API.G_RET_STS_SUCCESS;

3041: FND_MSG_PUB.initialize;
3042: END IF;
3043:
3044: -- Initialize API return status to success
3045: x_return_status := FND_API.G_RET_STS_SUCCESS;
3046:
3047: -- start procedure
3048: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3049: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'change_deliverable_status');

Line 3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3070: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished change_deliverable_status' ||x_return_status);
3071: END IF;
3072:
3073: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3075: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3076: RAISE FND_API.G_EXC_ERROR ;
3077: END IF;
3078:

Line 3076: RAISE FND_API.G_EXC_ERROR ;

3072:
3073: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3075: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3076: RAISE FND_API.G_EXC_ERROR ;
3077: END IF;
3078:
3079: -- Initialize API return status to success
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3080: x_return_status := FND_API.G_RET_STS_SUCCESS;

3076: RAISE FND_API.G_EXC_ERROR ;
3077: END IF;
3078:
3079: -- Initialize API return status to success
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;
3081:
3082: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3083: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'resolveDeliverables');
3084: END IF;

Line 3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished resolveDeliverables' ||x_return_status);
3104: END IF;
3105:
3106: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3108: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3109: RAISE FND_API.G_EXC_ERROR ;
3110: END IF;
3111:

Line 3109: RAISE FND_API.G_EXC_ERROR ;

3105:
3106: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3108: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3109: RAISE FND_API.G_EXC_ERROR ;
3110: END IF;
3111:
3112: -- Initialize API return status to success
3113: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3113: x_return_status := FND_API.G_RET_STS_SUCCESS;

3109: RAISE FND_API.G_EXC_ERROR ;
3110: END IF;
3111:
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;

Line 3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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 ;
3142: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3143: RAISE FND_API.G_EXC_ERROR ;
3144: END IF;
3145:

Line 3143: RAISE FND_API.G_EXC_ERROR ;

3139:
3140: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3142: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3143: RAISE FND_API.G_EXC_ERROR ;
3144: END IF;
3145:
3146: IF FND_API.To_Boolean( p_commit ) THEN
3147: COMMIT WORK;

Line 3146: IF FND_API.To_Boolean( p_commit ) THEN

3142: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3143: RAISE FND_API.G_EXC_ERROR ;
3144: END IF;
3145:
3146: IF FND_API.To_Boolean( p_commit ) THEN
3147: COMMIT WORK;
3148: END IF;
3149:
3150: -- Standard call to get message count and if count is 1, get message info.

Line 3159: WHEN FND_API.G_EXC_ERROR THEN

3155: END IF;
3156:
3157: EXCEPTION
3158:
3159: WHEN FND_API.G_EXC_ERROR THEN
3160: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3161: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
3162: END IF;
3163: ROLLBACK TO g_cancel2_del_GRP;

Line 3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3163: ROLLBACK TO g_cancel2_del_GRP;
3164: x_return_status := G_RET_STS_ERROR ;
3165: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168:
3169: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3170: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
3171: END IF;

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

3216: -- Standard Start of API savepoint
3217: SAVEPOINT g_update_del_GRP;
3218:
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END IF;
3223:
3224: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3217: SAVEPOINT g_update_del_GRP;
3218:
3219: -- Standard call to check for call compatibility.
3220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END IF;
3223:
3224: -- Initialize message list if p_init_msg_list is set to TRUE.
3225: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3225: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END IF;
3223:
3224: -- Initialize message list if p_init_msg_list is set to TRUE.
3225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3226: FND_MSG_PUB.initialize;
3227: END IF;
3228:
3229: -- Initialize API return status to success

Line 3230: x_return_status := FND_API.G_RET_STS_SUCCESS;

3226: FND_MSG_PUB.initialize;
3227: END IF;
3228:
3229: -- Initialize API return status to success
3230: x_return_status := FND_API.G_RET_STS_SUCCESS;
3231:
3232: UPDATE OKC_DELIVERABLES
3233: set internal_party_contact_id = p_new_buyer_id,
3234: last_updated_by= Fnd_Global.User_Id,

Line 3242: IF FND_API.To_Boolean( p_commit ) THEN

3238: AND business_document_type = p_bus_doc_type
3239: AND business_document_version = p_bus_doc_version
3240: AND internal_party_contact_id = p_original_buyer_id;
3241:
3242: IF FND_API.To_Boolean( p_commit ) THEN
3243: COMMIT WORK;
3244: END IF;
3245:
3246: -- Standard call to get message count and if count is 1, get message info.

Line 3255: WHEN FND_API.G_EXC_ERROR THEN

3251: END IF;
3252:
3253: EXCEPTION
3254:
3255: WHEN FND_API.G_EXC_ERROR THEN
3256: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3257: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateDeliverables Unexpected ERROR');
3258: END IF;
3259: ROLLBACK TO g_update_del_GRP;

Line 3263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3259: ROLLBACK TO g_update_del_GRP;
3260: x_return_status := G_RET_STS_ERROR ;
3261: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3262:
3263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3264: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3265: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');
3266: END IF;
3267: ROLLBACK TO g_update_del_GRP;

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

3319: -- Standard Start of API savepoint
3320: SAVEPOINT g_update2_del_GRP;
3321:
3322: -- Standard call to check for call compatibility.
3323: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3320: SAVEPOINT g_update2_del_GRP;
3321:
3322: -- Standard call to check for call compatibility.
3323: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: -- Initialize message list if p_init_msg_list is set to TRUE.
3328: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3328: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: -- Initialize message list if p_init_msg_list is set to TRUE.
3328: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3329: FND_MSG_PUB.initialize;
3330: END IF;
3331:
3332: -- Initialize API return status to success

Line 3333: x_return_status := FND_API.G_RET_STS_SUCCESS;

3329: FND_MSG_PUB.initialize;
3330: END IF;
3331:
3332: -- Initialize API return status to success
3333: x_return_status := FND_API.G_RET_STS_SUCCESS;
3334:
3335: IF p_bus_docs_tbl.count > 0 THEN
3336: FOR i IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST LOOP
3337: l_bus_doc_ids(i) := p_bus_docs_tbl(i).bus_doc_id;

Line 3354: IF FND_API.To_Boolean( p_commit ) THEN

3350: AND business_document_id = l_bus_doc_ids(j)
3351: AND business_document_type = l_bus_doc_types(j)
3352: AND business_document_version = l_bus_doc_versions(j);
3353:
3354: IF FND_API.To_Boolean( p_commit ) THEN
3355: COMMIT WORK;
3356: END IF;
3357:
3358: -- Standard call to get message count and if count is 1, get message info.

Line 3367: WHEN FND_API.G_EXC_ERROR THEN

3363: END IF;
3364:
3365: EXCEPTION
3366:
3367: WHEN FND_API.G_EXC_ERROR THEN
3368: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3369: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateBuyerDeliverables Unexpected ERROR');
3370: END IF;
3371: ROLLBACK TO g_update2_del_GRP;

Line 3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3372: x_return_status := G_RET_STS_ERROR ;
3373: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3374:
3375:
3376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3377: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3378: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateBuyerDeliverables Unexpected ERROR');
3379: END IF;
3380: ROLLBACK TO g_update2_del_GRP;

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

3421: -- Standard Start of API savepoint
3422: SAVEPOINT g_disable_del_GRP;
3423:
3424: -- Standard call to check for call compatibility.
3425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: END IF;
3428:
3429: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3422: SAVEPOINT g_disable_del_GRP;
3423:
3424: -- Standard call to check for call compatibility.
3425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: END IF;
3428:
3429: -- Initialize message list if p_init_msg_list is set to TRUE.
3430: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3430: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: END IF;
3428:
3429: -- Initialize message list if p_init_msg_list is set to TRUE.
3430: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3431: FND_MSG_PUB.initialize;
3432: END IF;
3433:
3434: -- Initialize API return status to success

Line 3435: x_return_status := FND_API.G_RET_STS_SUCCESS;

3431: FND_MSG_PUB.initialize;
3432: END IF;
3433:
3434: -- Initialize API return status to success
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');

Line 3459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: Finished disable_deliverables' ||x_return_status);
3456: END IF;
3457:
3458: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3460: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3461: RAISE FND_API.G_EXC_ERROR ;
3462: END IF;
3463:

Line 3461: RAISE FND_API.G_EXC_ERROR ;

3457:
3458: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3460: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3461: RAISE FND_API.G_EXC_ERROR ;
3462: END IF;
3463:
3464:
3465: IF FND_API.To_Boolean( p_commit ) THEN

Line 3465: IF FND_API.To_Boolean( p_commit ) THEN

3461: RAISE FND_API.G_EXC_ERROR ;
3462: END IF;
3463:
3464:
3465: IF FND_API.To_Boolean( p_commit ) THEN
3466: COMMIT WORK;
3467: END IF;
3468:
3469: -- Standard call to get message count and if count is 1, get message info.

Line 3478: WHEN FND_API.G_EXC_ERROR THEN

3474: END IF;
3475:
3476: EXCEPTION
3477:
3478: WHEN FND_API.G_EXC_ERROR THEN
3479: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3480: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving disableDeliverables Unexpected ERROR');
3481: END IF;
3482: ROLLBACK TO g_disable_del_GRP;

Line 3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3482: ROLLBACK TO g_disable_del_GRP;
3483: x_return_status := G_RET_STS_ERROR ;
3484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3485:
3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3487: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3488: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving disableDeliverables Unexpected ERROR');
3489: END IF;
3490: ROLLBACK TO g_disable_del_GRP;

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

3536: -- Standard Start of API savepoint
3537: SAVEPOINT g_update_del_GRP;
3538:
3539: -- Standard call to check for call compatibility.
3540: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3542: END IF;
3543:
3544: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3537: SAVEPOINT g_update_del_GRP;
3538:
3539: -- Standard call to check for call compatibility.
3540: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3542: END IF;
3543:
3544: -- Initialize message list if p_init_msg_list is set to TRUE.
3545: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3545: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3542: END IF;
3543:
3544: -- Initialize message list if p_init_msg_list is set to TRUE.
3545: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3546: FND_MSG_PUB.initialize;
3547: END IF;
3548:
3549: -- Initialize API return status to success

Line 3550: x_return_status := FND_API.G_RET_STS_SUCCESS;

3546: FND_MSG_PUB.initialize;
3547: END IF;
3548:
3549: -- Initialize API return status to success
3550: x_return_status := FND_API.G_RET_STS_SUCCESS;
3551:
3552: --bug#4154567 update -99 version aswell
3553: UPDATE OKC_DELIVERABLES
3554: set internal_party_contact_id = p_new_internal_contact_id,

Line 3563: IF FND_API.To_Boolean( p_commit ) THEN

3559: AND business_document_type = p_bus_doc_type
3560: AND business_document_version IN (-99, p_bus_doc_version)
3561: AND internal_party_contact_id = p_original_internal_contact_id;
3562:
3563: IF FND_API.To_Boolean( p_commit ) THEN
3564: COMMIT WORK;
3565: END IF;
3566:
3567: -- Standard call to get message count and if count is 1, get message info.

Line 3576: WHEN FND_API.G_EXC_ERROR THEN

3572: END IF;
3573:
3574: EXCEPTION
3575:
3576: WHEN FND_API.G_EXC_ERROR THEN
3577: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3578: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3579: END IF;
3580: ROLLBACK TO g_update_del_GRP;

Line 3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3580: ROLLBACK TO g_update_del_GRP;
3581: x_return_status := G_RET_STS_ERROR ;
3582: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3583:
3584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3585: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3586: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3587: END IF;
3588: ROLLBACK TO g_update_del_GRP;

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

3641: -- Standard Start of API savepoint
3642: SAVEPOINT g_update2_del_GRP;
3643:
3644: -- Standard call to check for call compatibility.
3645: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3647: END IF;
3648:
3649: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3642: SAVEPOINT g_update2_del_GRP;
3643:
3644: -- Standard call to check for call compatibility.
3645: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3647: END IF;
3648:
3649: -- Initialize message list if p_init_msg_list is set to TRUE.
3650: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3650: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3647: END IF;
3648:
3649: -- Initialize message list if p_init_msg_list is set to TRUE.
3650: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3651: FND_MSG_PUB.initialize;
3652: END IF;
3653:
3654: -- Initialize API return status to success

Line 3655: x_return_status := FND_API.G_RET_STS_SUCCESS;

3651: FND_MSG_PUB.initialize;
3652: END IF;
3653:
3654: -- Initialize API return status to success
3655: x_return_status := FND_API.G_RET_STS_SUCCESS;
3656:
3657: IF p_bus_docs_tbl.count > 0 THEN
3658: FOR i IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST LOOP
3659: l_bus_doc_ids(i) := p_bus_docs_tbl(i).bus_doc_id;

Line 3677: IF FND_API.To_Boolean( p_commit ) THEN

3673: AND business_document_id = l_bus_doc_ids(j)
3674: AND business_document_type = l_bus_doc_types(j)
3675: AND business_document_version IN (l_bus_doc_versions(j),-99);
3676:
3677: IF FND_API.To_Boolean( p_commit ) THEN
3678: COMMIT WORK;
3679: END IF;
3680:
3681: -- Standard call to get message count and if count is 1, get message info.

Line 3690: WHEN FND_API.G_EXC_ERROR THEN

3686: END IF;
3687:
3688: EXCEPTION
3689:
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3692: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3693: END IF;
3694: ROLLBACK TO g_update2_del_GRP;

Line 3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3695: x_return_status := G_RET_STS_ERROR ;
3696: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3697:
3698:
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3701: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3702: END IF;
3703: ROLLBACK TO g_update2_del_GRP;

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

3747: -- Standard Start of API savepoint
3748: SAVEPOINT g_update_del_GRP;
3749:
3750: -- Standard call to check for call compatibility.
3751: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END IF;
3754:
3755: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3748: SAVEPOINT g_update_del_GRP;
3749:
3750: -- Standard call to check for call compatibility.
3751: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END IF;
3754:
3755: -- Initialize message list if p_init_msg_list is set to TRUE.
3756: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3756: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END IF;
3754:
3755: -- Initialize message list if p_init_msg_list is set to TRUE.
3756: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3757: FND_MSG_PUB.initialize;
3758: END IF;
3759:
3760: -- Initialize API return status to success

Line 3761: x_return_status := FND_API.G_RET_STS_SUCCESS;

3757: FND_MSG_PUB.initialize;
3758: END IF;
3759:
3760: -- Initialize API return status to success
3761: x_return_status := FND_API.G_RET_STS_SUCCESS;
3762:
3763: UPDATE OKC_DELIVERABLES
3764: SET external_party_id = p_external_party_id,
3765: external_party_site_id = p_external_party_site_id,

Line 3774: IF FND_API.To_Boolean( p_commit ) THEN

3770: AND business_document_type = p_bus_doc_type
3771: AND business_document_version = -99;
3772:
3773:
3774: IF FND_API.To_Boolean( p_commit ) THEN
3775: COMMIT WORK;
3776: END IF;
3777:
3778: -- Standard call to get message count and if count is 1, get message info.

Line 3787: WHEN FND_API.G_EXC_ERROR THEN

3783: END IF;
3784:
3785: EXCEPTION
3786:
3787: WHEN FND_API.G_EXC_ERROR THEN
3788: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3789: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3790: END IF;
3791: ROLLBACK TO g_update_del_GRP;

Line 3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3791: ROLLBACK TO g_update_del_GRP;
3792: x_return_status := G_RET_STS_ERROR ;
3793: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3794:
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3797: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3798: END IF;
3799: ROLLBACK TO g_update_del_GRP;

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

3865: -- Standard Start of API savepoint
3866: SAVEPOINT g_update_del_GRP;
3867:
3868: -- Standard call to check for call compatibility.
3869: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END IF;
3872:
3873: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3866: SAVEPOINT g_update_del_GRP;
3867:
3868: -- Standard call to check for call compatibility.
3869: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END IF;
3872:
3873: -- Initialize message list if p_init_msg_list is set to TRUE.
3874: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3874: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END IF;
3872:
3873: -- Initialize message list if p_init_msg_list is set to TRUE.
3874: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3875: FND_MSG_PUB.initialize;
3876: END IF;
3877:
3878: -- Initialize API return status to success

Line 3879: x_return_status := FND_API.G_RET_STS_SUCCESS;

3875: FND_MSG_PUB.initialize;
3876: END IF;
3877:
3878: -- Initialize API return status to success
3879: x_return_status := FND_API.G_RET_STS_SUCCESS;
3880:
3881: -- initialize the table with 0 rows
3882: j := 0;
3883: delIdTab.delete;

Line 3917: IF FND_API.To_Boolean( p_commit ) THEN

3913: CLOSE del_cur ;
3914: END IF;
3915:
3916:
3917: IF FND_API.To_Boolean( p_commit ) THEN
3918: COMMIT WORK;
3919: END IF;
3920:
3921:

Line 3928: WHEN FND_API.G_EXC_ERROR THEN

3924: END IF;
3925:
3926: EXCEPTION
3927:
3928: WHEN FND_API.G_EXC_ERROR THEN
3929: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3930: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3931: END IF;
3932: -- close any open cursors

Line 3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3936: ROLLBACK TO g_update_del_GRP;
3937: x_return_status := G_RET_STS_ERROR ;
3938: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3939:
3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3941: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3942: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3943: END IF;
3944: ROLLBACK TO g_update_del_GRP;

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

4051: -- Standard Start of API savepoint
4052: SAVEPOINT g_createHistory_GRP;
4053:
4054: -- Standard call to check for call compatibility.
4055: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4057: END IF;
4058:
4059: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4052: SAVEPOINT g_createHistory_GRP;
4053:
4054: -- Standard call to check for call compatibility.
4055: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4057: END IF;
4058:
4059: -- Initialize message list if p_init_msg_list is set to TRUE.
4060: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4060: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4057: END IF;
4058:
4059: -- Initialize message list if p_init_msg_list is set to TRUE.
4060: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4061: FND_MSG_PUB.initialize;
4062: END IF;
4063:
4064: --loop thru deliverables where only the notes have changed

Line 4155: p_init_msg_list => FND_API.G_FALSE,

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,
4159: x_return_status => x_return_status );

Line 4171: IF FND_API.To_Boolean( p_commit ) THEN

4167: END IF;
4168: raise;
4169: end;
4170:
4171: IF FND_API.To_Boolean( p_commit ) THEN
4172: COMMIT WORK;
4173: END IF;
4174:
4175:

Line 4182: WHEN FND_API.G_EXC_ERROR THEN

4178: END IF;
4179:
4180: EXCEPTION
4181:
4182: WHEN FND_API.G_EXC_ERROR THEN
4183: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4184: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving postDelStatusChanges Unexpected ERROR');
4185: END IF;
4186: ROLLBACK TO g_createHistory_GRP;

Line 4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4186: ROLLBACK TO g_createHistory_GRP;
4187: x_return_status := G_RET_STS_ERROR ;
4188: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4189:
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4192: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving postDelStatusChanges Unexpected ERROR');
4193: END IF;
4194: ROLLBACK TO g_createHistory_GRP;

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

4221: **/
4222:
4223: FUNCTION deliverablesForExtPartyExist(
4224: p_api_version IN NUMBER,
4225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4226: x_return_status OUT NOCOPY VARCHAR2,
4227: x_msg_data OUT NOCOPY VARCHAR2,
4228: x_msg_count OUT NOCOPY NUMBER,
4229:

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

4307: Returns N or Y, if there is unexpected error then it returns NULL.
4308: **/
4309: FUNCTION check_manageable_deliverables(
4310: p_api_version IN NUMBER,
4311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4312: x_return_status OUT NOCOPY VARCHAR2,
4313: x_msg_data OUT NOCOPY VARCHAR2,
4314: x_msg_count OUT NOCOPY NUMBER,
4315:

Line 4389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4385: * within a customer
4386: */
4387: PROCEDURE mergeExtPartyOnDeliverables (
4388: p_api_version IN NUMBER,
4389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4391: p_document_class IN VARCHAR2,
4392: p_from_external_party_id IN NUMBER,
4393: p_from_external_party_site_id IN NUMBER,

Line 4390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4386: */
4387: PROCEDURE mergeExtPartyOnDeliverables (
4388: p_api_version IN NUMBER,
4389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4391: p_document_class IN VARCHAR2,
4392: p_from_external_party_id IN NUMBER,
4393: p_from_external_party_site_id IN NUMBER,
4394: p_to_external_party_id IN NUMBER,

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

4431: -- Standard Start of API savepoint
4432: SAVEPOINT g_update_del_GRP;
4433:
4434: -- Standard call to check for call compatibility.
4435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END IF;
4438:
4439: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4432: SAVEPOINT g_update_del_GRP;
4433:
4434: -- Standard call to check for call compatibility.
4435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END IF;
4438:
4439: -- Initialize message list if p_init_msg_list is set to TRUE.
4440: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4440: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END IF;
4438:
4439: -- Initialize message list if p_init_msg_list is set to TRUE.
4440: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4441: FND_MSG_PUB.initialize;
4442: END IF;
4443:
4444: -- Initialize API return status to success

Line 4445: x_return_status := FND_API.G_RET_STS_SUCCESS;

4441: FND_MSG_PUB.initialize;
4442: END IF;
4443:
4444: -- Initialize API return status to success
4445: x_return_status := FND_API.G_RET_STS_SUCCESS;
4446:
4447: -- initialize the table with 0 rows
4448: j := 0;
4449: delIdTab.delete;

Line 4471: IF FND_API.To_Boolean( p_commit ) THEN

4467: CLOSE del_cur ;
4468: END IF;
4469:
4470:
4471: IF FND_API.To_Boolean( p_commit ) THEN
4472: COMMIT WORK;
4473: END IF;
4474:
4475:

Line 4482: WHEN FND_API.G_EXC_ERROR THEN

4478: END IF;
4479:
4480: EXCEPTION
4481:
4482: WHEN FND_API.G_EXC_ERROR THEN
4483: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4484: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');
4485: END IF;
4486: -- close any open cursors

Line 4494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4490: ROLLBACK TO g_update_del_GRP;
4491: x_return_status := G_RET_STS_ERROR ;
4492: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4493:
4494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4495: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4496: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');
4497: END IF;
4498: ROLLBACK TO g_update_del_GRP;

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

4547: -- Standard Start of API savepoint
4548: SAVEPOINT g_activatecloseout_del_GRP;
4549:
4550: -- Standard call to check for call compatibility.
4551: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;
4554:
4555: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4548: SAVEPOINT g_activatecloseout_del_GRP;
4549:
4550: -- Standard call to check for call compatibility.
4551: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;
4554:
4555: -- Initialize message list if p_init_msg_list is set to TRUE.
4556: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4556: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4553: END IF;
4554:
4555: -- Initialize message list if p_init_msg_list is set to TRUE.
4556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4557: FND_MSG_PUB.initialize;
4558: END IF;
4559:
4560: -- Initialize API return status to success

Line 4561: x_return_status := FND_API.G_RET_STS_SUCCESS;

4557: FND_MSG_PUB.initialize;
4558: END IF;
4559:
4560: -- Initialize API return status to success
4561: x_return_status := FND_API.G_RET_STS_SUCCESS;
4562:
4563: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4564: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling '||'resolveDeliverables');
4565: END IF;

Line 4588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: Finished resolveDeliverables' ||x_return_status);
4585: END IF;
4586:
4587: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4589: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4590: RAISE FND_API.G_EXC_ERROR ;
4591: END IF;
4592:

Line 4590: RAISE FND_API.G_EXC_ERROR ;

4586:
4587: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4589: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4590: RAISE FND_API.G_EXC_ERROR ;
4591: END IF;
4592:
4593: -- Initialize API return status to success
4594: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4594: x_return_status := FND_API.G_RET_STS_SUCCESS;

4590: RAISE FND_API.G_EXC_ERROR ;
4591: END IF;
4592:
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;

Line 4622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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 ;
4623: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4624: RAISE FND_API.G_EXC_ERROR ;
4625: END IF;
4626:

Line 4624: RAISE FND_API.G_EXC_ERROR ;

4620:
4621: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4623: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4624: RAISE FND_API.G_EXC_ERROR ;
4625: END IF;
4626:
4627: IF FND_API.To_Boolean( p_commit ) THEN
4628: COMMIT WORK;

Line 4627: IF FND_API.To_Boolean( p_commit ) THEN

4623: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4624: RAISE FND_API.G_EXC_ERROR ;
4625: END IF;
4626:
4627: IF FND_API.To_Boolean( p_commit ) THEN
4628: COMMIT WORK;
4629: END IF;
4630:
4631: -- Standard call to get message count and if count is 1, get message info.

Line 4640: WHEN FND_API.G_EXC_ERROR THEN

4636: END IF;
4637:
4638: EXCEPTION
4639:
4640: WHEN FND_API.G_EXC_ERROR THEN
4641: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4642: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving activateCloseoutDeliverables Unexpected ERROR');
4643: END IF;
4644: ROLLBACK TO g_activatecloseout_del_GRP;

Line 4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4644: ROLLBACK TO g_activatecloseout_del_GRP;
4645: x_return_status := G_RET_STS_ERROR ;
4646: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4647:
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649:
4650: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4651: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving activateCloseoutDeliverables Unexpected ERROR');
4652: END IF;

Line 4682: -- Default = FND_API.G_FALSE

4678: --Pre-reqs : None.
4679: --Parameters :
4680: --IN : p_api_version IN NUMBER Required
4681: -- : p_init_msg_list IN VARCHAR2 Optional
4682: -- Default = FND_API.G_FALSE
4683: -- : p_bus_doc_id IN NUMBER Required
4684: -- Header ID of the Standard Purchase Order
4685: -- : p_bus_doc_version IN NUMBER Required
4686: -- Version number of the Standard Purchase Order