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 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

294: END IF;
295:
296: -- check status
297: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
299: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
300: RAISE FND_API.G_EXC_ERROR ;
301: END IF;
302:

Line 300: RAISE FND_API.G_EXC_ERROR ;

296: -- check status
297: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
299: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
300: RAISE FND_API.G_EXC_ERROR ;
301: END IF;
302:
303: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
304: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'601: Recurr Dates Count'||l_recurring_dates.count);

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);
632: END IF;
633:
634: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
636: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
637: RAISE FND_API.G_EXC_ERROR ;
638: END IF;
639: END IF;

Line 637: RAISE FND_API.G_EXC_ERROR ;

633:
634: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
636: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
637: RAISE FND_API.G_EXC_ERROR ;
638: END IF;
639: END IF;
640:
641: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

657: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701a: Finished OKC_DELIVERABLE_PROCESS_PVT.create_del_status_history'||l_return_status);
658: END IF;
659:
660: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
662: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
663: RAISE FND_API.G_EXC_ERROR ;
664: END IF;
665: END IF;

Line 663: RAISE FND_API.G_EXC_ERROR ;

659:
660: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
662: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
663: RAISE FND_API.G_EXC_ERROR ;
664: END IF;
665: END IF;
666:
667: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 684: RAISE FND_API.G_EXC_ERROR;

680: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
681: END IF;
682: Okc_Api.Set_Message(G_APP_NAME,
683: 'OKC_DEL_ERR_GEN_INSTS');
684: RAISE FND_API.G_EXC_ERROR;
685: END; -- generate_del_instances
686:
687: /**
688: * Helper method to return proper number value for the day of week.

Line 735: RAISE FND_API.G_EXC_ERROR;

731: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
732: END IF;
733: Okc_Api.Set_Message(G_APP_NAME,
734: 'OKC_DEL_ERR_EVT_DTLS');
735: RAISE FND_API.G_EXC_ERROR;
736:
737: END;
738:
739: ---------------------------------------------------------------------------

Line 782: RAISE FND_API.G_EXC_ERROR;

778:
779: IF p_bus_doc_id = NULL THEN
780: Okc_Api.Set_Message(G_APP_NAME
781: ,'OKC_DEL_NO_PARAMS');
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784: IF p_bus_doc_type = NULL THEN
785: Okc_Api.Set_Message(G_APP_NAME
786: ,'OKC_DEL_NO_PARAMS');

Line 787: RAISE FND_API.G_EXC_ERROR;

783: END IF;
784: IF p_bus_doc_type = NULL THEN
785: Okc_Api.Set_Message(G_APP_NAME
786: ,'OKC_DEL_NO_PARAMS');
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;
789: IF p_bus_doc_version = NULL THEN
790: Okc_Api.Set_Message(G_APP_NAME
791: ,'OKC_DEL_NO_PARAMS');

Line 792: RAISE FND_API.G_EXC_ERROR;

788: END IF;
789: IF p_bus_doc_version = NULL THEN
790: Okc_Api.Set_Message(G_APP_NAME
791: ,'OKC_DEL_NO_PARAMS');
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: IF p_event_code = NULL THEN
795: Okc_Api.Set_Message(G_APP_NAME
796: ,'OKC_DEL_NO_PARAMS');

Line 797: RAISE FND_API.G_EXC_ERROR;

793: END IF;
794: IF p_event_code = NULL THEN
795: Okc_Api.Set_Message(G_APP_NAME
796: ,'OKC_DEL_NO_PARAMS');
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;
799: IF p_event_date = NULL THEN
800: Okc_Api.Set_Message(G_APP_NAME
801: ,'OKC_DEL_NO_PARAMS');

Line 802: RAISE FND_API.G_EXC_ERROR;

798: END IF;
799: IF p_event_date = NULL THEN
800: Okc_Api.Set_Message(G_APP_NAME
801: ,'OKC_DEL_NO_PARAMS');
802: RAISE FND_API.G_EXC_ERROR;
803: END IF;
804:
805: -- Standard Start of API savepoint
806: SAVEPOINT g_activate_del_GRP;

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

805: -- Standard Start of API savepoint
806: SAVEPOINT g_activate_del_GRP;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

806: SAVEPOINT g_activate_del_GRP;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: --- check if sync flag is TRUE
822: IF FND_API.To_Boolean( p_sync_flag ) THEN
823:

Line 822: IF FND_API.To_Boolean( p_sync_flag ) THEN

818: -- Initialize API return status to success
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820:
821: --- check if sync flag is TRUE
822: IF FND_API.To_Boolean( p_sync_flag ) THEN
823:
824: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Calling '||'syncDeliverables');
826: END IF;

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

839: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'701: Finished resolveDeliverables'||x_return_status);
840: END IF;
841:
842: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
844: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR ;
846: END IF;
847:

Line 845: RAISE FND_API.G_EXC_ERROR ;

841:
842: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
844: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR ;
846: END IF;
847:
848: END IF;
849:

Line 869: p_sync_recurr_instances_flag => FND_API.G_TRUE);

865: x_msg_data => x_msg_data,
866: x_msg_count => x_msg_count,
867: x_return_status => x_return_status,
868: p_sync_flag => p_sync_flag,
869: p_sync_recurr_instances_flag => FND_API.G_TRUE);
870:
871: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Finished resolveDeliverables'||x_return_status);
873: END IF;

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

872: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'800: Finished resolveDeliverables'||x_return_status);
873: END IF;
874:
875: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
877: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
878: RAISE FND_API.G_EXC_ERROR ;
879: END IF;
880:

Line 878: RAISE FND_API.G_EXC_ERROR ;

874:
875: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
877: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
878: RAISE FND_API.G_EXC_ERROR ;
879: END IF;
880:
881: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'900: Calling '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

903: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status'||x_return_status);
904: END IF;
905:
906: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
908: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
909: RAISE FND_API.G_EXC_ERROR ;
910: END IF;
911:

Line 909: RAISE FND_API.G_EXC_ERROR ;

905:
906: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
908: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
909: RAISE FND_API.G_EXC_ERROR ;
910: END IF;
911:
912: IF FND_API.To_Boolean( p_commit ) THEN
913: COMMIT WORK;

Line 912: IF FND_API.To_Boolean( p_commit ) THEN

908: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
909: RAISE FND_API.G_EXC_ERROR ;
910: END IF;
911:
912: IF FND_API.To_Boolean( p_commit ) THEN
913: COMMIT WORK;
914: END IF;
915:
916: -- Standard call to get message count and if count is 1, get message info.

Line 924: WHEN FND_API.G_EXC_ERROR THEN

920: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: Leaving activateDeliverables');
921: END IF;
922:
923: EXCEPTION
924: WHEN FND_API.G_EXC_ERROR THEN
925: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1200: Leaving activateDeliverables Unexpected ERROR');
927: END IF;
928: ROLLBACK TO g_activate_del_GRP;

Line 932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

928: ROLLBACK TO g_activate_del_GRP;
929: x_return_status := G_RET_STS_ERROR ;
930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1300: Leaving activateDeliverables Unexpected ERROR');
935: END IF;
936: ROLLBACK TO g_activate_del_GRP;

Line 983: RAISE FND_API.G_EXC_ERROR;

979: IF p_event_id is NULL OR p_event_UOM is NULL OR p_event_duration is NULL THEN
980:
981: Okc_Api.Set_Message(G_APP_NAME,
982: 'OKC_DEL_NOT_RSLV_EVTS');
983: RAISE FND_API.G_EXC_ERROR;
984:
985: END IF;
986:
987: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011:
1012: IF l_actual_date is NULL THEN
1013: Okc_Api.Set_Message(G_APP_NAME,
1014: 'OKC_DEL_DT_NOT_RSLVD');
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
1018: END IF;
1019:

Line 1041: RAISE FND_API.G_EXC_ERROR;

1037: p_before_after => l_del_before_after);
1038: /* IF l_actual_date is NULL THEN
1039: Okc_Api.Set_Message(G_APP_NAME,
1040: 'OKC_DEL_DT_NOT_RSLVD');
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF; */
1043:
1044: END IF;
1045: END LOOP;

Line 1164: l_sync_flag := FND_API.G_FALSE;

1160: -- initialize
1161: del_count := 0;
1162: j := 0;
1163: k := 0;
1164: l_sync_flag := FND_API.G_FALSE;
1165:
1166: -- start procedure
1167: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Entered '||G_PKG_NAME ||'.'||l_api_name);

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

1171: -- Standard Start of API savepoint
1172: SAVEPOINT g_resolve_del_GRP;
1173:
1174: -- Standard call to check for call compatibility.
1175: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: SAVEPOINT g_resolve_del_GRP;
1173:
1174: -- Standard call to check for call compatibility.
1175: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.
1180: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1180: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.
1180: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Initialize API return status to success

Line 1185: x_return_status := FND_API.G_RET_STS_SUCCESS;

1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Initialize API return status to success
1185: x_return_status := FND_API.G_RET_STS_SUCCESS;
1186:
1187: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1188: l_sync_flag := FND_API.G_TRUE;
1189: ELSE

Line 1187: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN

1183:
1184: -- Initialize API return status to success
1185: x_return_status := FND_API.G_RET_STS_SUCCESS;
1186:
1187: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1188: l_sync_flag := FND_API.G_TRUE;
1189: ELSE
1190: l_sync_flag := p_sync_flag;
1191: END IF;

Line 1188: l_sync_flag := FND_API.G_TRUE;

1184: -- Initialize API return status to success
1185: x_return_status := FND_API.G_RET_STS_SUCCESS;
1186:
1187: IF FND_API.To_Boolean (p_sync_recurr_instances_flag) THEN
1188: l_sync_flag := FND_API.G_TRUE;
1189: ELSE
1190: l_sync_flag := p_sync_flag;
1191: END IF;
1192:

Line 1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1321: x_msg_data => x_msg_data,
1322: x_msg_count => x_msg_count,
1323: x_return_status => x_return_status);
1324: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1326: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR ;
1328: END IF;
1329:

Line 1327: RAISE FND_API.G_EXC_ERROR ;

1323: x_return_status => x_return_status);
1324: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1326: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR ;
1328: END IF;
1329:
1330: END IF; -- fixed due date is 'Yes'
1331:

Line 1355: RAISE FND_API.G_EXC_ERROR;

1351: -- unexpected error
1352: IF l_has_instances_yn is null THEN
1353: Okc_Api.Set_Message(G_APP_NAME,
1354: 'OKC_DEL_ERR_GET_INSTS');
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;
1357:
1358: -- by default this is N
1359: generate_new_instances_yn := 'N';

Line 1381: IF FND_API.To_Boolean( l_sync_flag ) THEN

1377: END IF;
1378:
1379: -- fix Bug 3574466: If sync flag is true, generate only the
1380: -- delta instances.
1381: IF FND_API.To_Boolean( l_sync_flag ) THEN
1382:
1383: --- ASSUMPTION: In this case only end date can change
1384: --- get old start date
1385: l_recurr_start_date := delRecTab(i).start_event_date;

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: /*--Commenting out as part of fix for bug 4030982--
1404: IF p_bus_doc_date_events_tbl.count = 0 THEN
1405: Okc_Api.Set_Message(G_APP_NAME,
1406: 'OKC_DEL_ERR_DTS_EMPY');
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: */
1410:
1411: --- resolve relative end date

Line 1439: RAISE FND_API.G_EXC_ERROR;

1435: -- By this time l_recurr_end_date should not be NULL
1436: IF l_recurr_end_date is NULL THEN
1437: Okc_Api.Set_Message(G_APP_NAME,
1438: 'OKC_DEL_END_DT_NOT_FOUND');
1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;
1441:
1442: --- check if new date is less then old date
1443: --- delete instances where actual date is equal to or

Line 1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1485: ||x_return_status);
1486: END IF;
1487:
1488: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1490: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1491: RAISE FND_API.G_EXC_ERROR ;
1492: END IF;
1493:

Line 1491: RAISE FND_API.G_EXC_ERROR ;

1487:
1488: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1490: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1491: RAISE FND_API.G_EXC_ERROR ;
1492: END IF;
1493:
1494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

Line 1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1610: x_msg_count => x_msg_count,
1611: x_return_status => x_return_status);
1612:
1613: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1615: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1616: RAISE FND_API.G_EXC_ERROR ;
1617: END IF;
1618:

Line 1616: RAISE FND_API.G_EXC_ERROR ;

1612:
1613: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1615: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1616: RAISE FND_API.G_EXC_ERROR ;
1617: END IF;
1618:
1619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name

Line 1672: RAISE FND_API.G_EXC_ERROR;

1668: -- By this time l_recurr_start_date should not be NULL
1669: IF l_recurr_start_date is NULL THEN
1670: Okc_Api.Set_Message(G_APP_NAME,
1671: 'OKC_DEL_ST_DT_NOT_FOUND');
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674: END IF; --- Start date resolved
1675:
1676: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1719: RAISE FND_API.G_EXC_ERROR;

1715:
1716: IF l_recurr_end_date is NULL THEN
1717: Okc_Api.Set_Message(G_APP_NAME,
1718: 'OKC_DEL_END_DT_NOT_FOUND');
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721:
1722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1723: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Get Recurring Frequency ');

Line 1735: RAISE FND_API.G_EXC_ERROR;

1731: -- if both frequency values ar null
1732: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL) THEN
1733: Okc_Api.Set_Message(G_APP_NAME,
1734: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
1735: RAISE FND_API.G_EXC_ERROR;
1736: END IF;
1737:
1738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'108: Recurring Definition = '||delRecTab(i).deliverable_id||' Generate Instances ');

Line 1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1785: x_msg_data => x_msg_data,
1786: x_msg_count => x_msg_count,
1787: x_return_status => x_return_status);
1788: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1790: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1791: RAISE FND_API.G_EXC_ERROR ;
1792: END IF;
1793:

Line 1791: RAISE FND_API.G_EXC_ERROR ;

1787: x_return_status => x_return_status);
1788: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1790: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1791: RAISE FND_API.G_EXC_ERROR ;
1792: END IF;
1793:
1794:
1795: --- resolve relative end date

Line 1849: IF FND_API.To_Boolean( p_commit ) THEN

1845: IF del_cur %ISOPEN THEN
1846: CLOSE del_cur ;
1847: END IF;
1848:
1849: IF FND_API.To_Boolean( p_commit ) THEN
1850: COMMIT WORK;
1851: END IF;
1852:
1853: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1859: WHEN FND_API.G_EXC_ERROR THEN

1855: END IF;
1856:
1857: EXCEPTION
1858:
1859: WHEN FND_API.G_EXC_ERROR THEN
1860: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving resolveDeliverables Unexpected ERROR');
1862: END IF;
1863: IF del_cur %ISOPEN THEN

Line 1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1870: ROLLBACK TO g_resolve_del_GRP;
1871: x_return_status := G_RET_STS_ERROR ;
1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving resolveDeliverables Unexpected ERROR');
1877: END IF;
1878: IF del_cur %ISOPEN THEN

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

2022: -- Standard Start of API savepoint
2023: SAVEPOINT g_update_del_GRP;
2024:
2025: -- Standard call to check for call compatibility.
2026: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:
2030: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2023: SAVEPOINT g_update_del_GRP;
2024:
2025: -- Standard call to check for call compatibility.
2026: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:
2030: -- Initialize message list if p_init_msg_list is set to TRUE.
2031: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2031: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2028: END IF;
2029:
2030: -- Initialize message list if p_init_msg_list is set to TRUE.
2031: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2035: -- Initialize API return status to success

Line 2036: x_return_status := FND_API.G_RET_STS_SUCCESS;

2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2035: -- Initialize API return status to success
2036: x_return_status := FND_API.G_RET_STS_SUCCESS;
2037:
2038: --- open deliverables cursor and populate records of table
2039: FOR del_rec IN del_cur LOOP
2040: k := k+1;

Line 2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'112: Recurring Deliverable = '||delRecTab(i).deliverable_id||' FINISHED OKC_DELIVERABLE_PROCESS_PVT.delete_del_instances'||x_return_status);
2307: END IF;
2308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2311: RAISE FND_API.G_EXC_ERROR ;
2312: END IF;
2313: END IF; -- end delIds > 0

Line 2311: RAISE FND_API.G_EXC_ERROR ;

2307: END IF;
2308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2311: RAISE FND_API.G_EXC_ERROR ;
2312: END IF;
2313: END IF; -- end delIds > 0
2314: --- re-resolve the deliverable
2315: --- you have the start date.

Line 2370: RAISE FND_API.G_EXC_ERROR;

2366: --- raise exception if END is NULL
2367: IF l_recurr_end_date is NULL THEN
2368: Okc_Api.Set_Message(G_APP_NAME,
2369: 'OKC_DEL_END_DT_NOT_FOUND');
2370: RAISE FND_API.G_EXC_ERROR;
2371: END IF;
2372:
2373:
2374: --- get the repeat frequency and create new instances

Line 2384: RAISE FND_API.G_EXC_ERROR;

2380: -- if both frequency values ar null
2381: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL) THEN
2382: Okc_Api.Set_Message(G_APP_NAME,
2383: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
2384: RAISE FND_API.G_EXC_ERROR;
2385: END IF;
2386:
2387: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'116: Recurring Deliverable = '||delRecTab(i).deliverable_id||' Calling generated instances');

Line 2462: RAISE FND_API.G_EXC_ERROR;

2458: --- raise exception if END is NULL
2459: /* IF l_recurr_end_date is NULL THEN
2460: Okc_Api.Set_Message(G_APP_NAME,
2461: 'OKC_DEL_END_DT_NOT_FOUND');
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF; */
2464:
2465: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2466: 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 2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 2508: RAISE FND_API.G_EXC_ERROR ;

2504: END IF;
2505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2507: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2508: RAISE FND_API.G_EXC_ERROR ;
2509: END IF;
2510:
2511: END IF;
2512: --- increment the count

Line 2547: RAISE FND_API.G_EXC_ERROR;

2543: -- if both frequency values ar null
2544: IF (l_repeat_day_of_month is NULL AND l_repeat_day_of_week is NULL) THEN
2545: Okc_Api.Set_Message(G_APP_NAME,
2546: 'OKC_DEL_RECUR_FRQ_NOT_FOUND');
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549:
2550: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2551: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'126: Recurring Deliverable = '||delRecTab(i).deliverable_id||'Calling generate_del_instances');

Line 2613: IF FND_API.To_Boolean( p_commit ) THEN

2609: IF del_cur %ISOPEN THEN
2610: CLOSE del_cur ;
2611: END IF;
2612:
2613: IF FND_API.To_Boolean( p_commit ) THEN
2614: COMMIT WORK;
2615: END IF;
2616:
2617: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2623: WHEN FND_API.G_EXC_ERROR THEN

2619: END IF;
2620:
2621: EXCEPTION
2622:
2623: WHEN FND_API.G_EXC_ERROR THEN
2624: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2625: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateDeliverables Unexpected ERROR');
2626: END IF;
2627: IF del_cur %ISOPEN THEN

Line 2641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2637: ROLLBACK TO g_update_del_GRP;
2638: x_return_status := G_RET_STS_ERROR ;
2639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2640:
2641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2642: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2643: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');
2644: END IF;
2645: IF del_cur %ISOPEN THEN

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

2707: -- Standard Start of API savepoint
2708: SAVEPOINT g_enable_del_ntf_GRP;
2709:
2710: -- Standard call to check for call compatibility.
2711: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2708: SAVEPOINT g_enable_del_ntf_GRP;
2709:
2710: -- Standard call to check for call compatibility.
2711: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2716: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success

Line 2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722:
2723: UPDATE OKC_DELIVERABLES set DISABLE_NOTIFICATIONS_YN = 'N'
2724: WHERE business_document_id = p_bus_doc_id
2725: AND business_document_type = p_bus_doc_type

Line 2728: IF FND_API.To_Boolean( p_commit ) THEN

2724: WHERE business_document_id = p_bus_doc_id
2725: AND business_document_type = p_bus_doc_type
2726: AND business_document_version = p_bus_doc_version;
2727:
2728: IF FND_API.To_Boolean( p_commit ) THEN
2729: COMMIT WORK;
2730: END IF;
2731:
2732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2738: WHEN FND_API.G_EXC_ERROR THEN

2734: END IF;
2735:
2736: EXCEPTION
2737:
2738: WHEN FND_API.G_EXC_ERROR THEN
2739: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2740: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving enableNotifications Unexpected ERROR');
2741: END IF;
2742: ROLLBACK TO g_enable_del_ntf_GRP;

Line 2746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2742: ROLLBACK TO g_enable_del_ntf_GRP;
2743: x_return_status := G_RET_STS_ERROR ;
2744: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2745:
2746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2747: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving enableNotifications Unexpected ERROR');
2749: END IF;
2750: ROLLBACK TO g_enable_del_ntf_GRP;

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

2792: -- Standard Start of API savepoint
2793: SAVEPOINT g_cancel_del_GRP;
2794:
2795: -- Standard call to check for call compatibility.
2796: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: END IF;
2799:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2793: SAVEPOINT g_cancel_del_GRP;
2794:
2795: -- Standard call to check for call compatibility.
2796: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: END IF;
2799:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.
2801: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2801: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: END IF;
2799:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.
2801: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2802: FND_MSG_PUB.initialize;
2803: END IF;
2804:
2805: -- Initialize API return status to success

Line 2806: x_return_status := FND_API.G_RET_STS_SUCCESS;

2802: FND_MSG_PUB.initialize;
2803: END IF;
2804:
2805: -- Initialize API return status to success
2806: x_return_status := FND_API.G_RET_STS_SUCCESS;
2807:
2808: -- start procedure
2809: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2810: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'change_deliverable_status');

Line 2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished change_deliverable_status' ||x_return_status);
2832: END IF;
2833:
2834: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2836: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2837: RAISE FND_API.G_EXC_ERROR ;
2838: END IF;
2839:

Line 2837: RAISE FND_API.G_EXC_ERROR ;

2833:
2834: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2836: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2837: RAISE FND_API.G_EXC_ERROR ;
2838: END IF;
2839:
2840:
2841: IF FND_API.To_Boolean( p_commit ) THEN

Line 2841: IF FND_API.To_Boolean( p_commit ) THEN

2837: RAISE FND_API.G_EXC_ERROR ;
2838: END IF;
2839:
2840:
2841: IF FND_API.To_Boolean( p_commit ) THEN
2842: COMMIT WORK;
2843: END IF;
2844:
2845: -- Standard call to get message count and if count is 1, get message info.

Line 2854: WHEN FND_API.G_EXC_ERROR THEN

2850: END IF;
2851:
2852: EXCEPTION
2853:
2854: WHEN FND_API.G_EXC_ERROR THEN
2855: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2856: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
2857: END IF;
2858: ROLLBACK TO g_cancel_del_GRP;

Line 2862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2858: ROLLBACK TO g_cancel_del_GRP;
2859: x_return_status := G_RET_STS_ERROR ;
2860: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2861:
2862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2863: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2864: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
2865: END IF;
2866: ROLLBACK TO g_cancel_del_GRP;

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

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

Line 2916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2920: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2925: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 2956: RAISE FND_API.G_EXC_ERROR ;

2952:
2953: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2955: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2956: RAISE FND_API.G_EXC_ERROR ;
2957: END IF;
2958:
2959: -- Initialize API return status to success
2960: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2960: x_return_status := FND_API.G_RET_STS_SUCCESS;

2956: RAISE FND_API.G_EXC_ERROR ;
2957: END IF;
2958:
2959: -- Initialize API return status to success
2960: x_return_status := FND_API.G_RET_STS_SUCCESS;
2961:
2962: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2963: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'resolveDeliverables');
2964: END IF;

Line 2987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2983: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished resolveDeliverables' ||x_return_status);
2984: END IF;
2985:
2986: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2988: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2989: RAISE FND_API.G_EXC_ERROR ;
2990: END IF;
2991:

Line 2989: RAISE FND_API.G_EXC_ERROR ;

2985:
2986: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2988: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2989: RAISE FND_API.G_EXC_ERROR ;
2990: END IF;
2991:
2992: -- Initialize API return status to success
2993: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2993: x_return_status := FND_API.G_RET_STS_SUCCESS;

2989: RAISE FND_API.G_EXC_ERROR ;
2990: END IF;
2991:
2992: -- Initialize API return status to success
2993: x_return_status := FND_API.G_RET_STS_SUCCESS;
2994:
2995: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2996: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
2997: END IF;

Line 3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
3018: END IF;
3019:
3020: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3022: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3023: RAISE FND_API.G_EXC_ERROR ;
3024: END IF;
3025:

Line 3023: RAISE FND_API.G_EXC_ERROR ;

3019:
3020: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3022: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3023: RAISE FND_API.G_EXC_ERROR ;
3024: END IF;
3025:
3026: IF FND_API.To_Boolean( p_commit ) THEN
3027: COMMIT WORK;

Line 3026: IF FND_API.To_Boolean( p_commit ) THEN

3022: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3023: RAISE FND_API.G_EXC_ERROR ;
3024: END IF;
3025:
3026: IF FND_API.To_Boolean( p_commit ) THEN
3027: COMMIT WORK;
3028: END IF;
3029:
3030: -- Standard call to get message count and if count is 1, get message info.

Line 3039: WHEN FND_API.G_EXC_ERROR THEN

3035: END IF;
3036:
3037: EXCEPTION
3038:
3039: WHEN FND_API.G_EXC_ERROR THEN
3040: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3041: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
3042: END IF;
3043: ROLLBACK TO g_cancel2_del_GRP;

Line 3047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3043: ROLLBACK TO g_cancel2_del_GRP;
3044: x_return_status := G_RET_STS_ERROR ;
3045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3046:
3047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3048:
3049: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3050: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
3051: END IF;

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

3096: -- Standard Start of API savepoint
3097: SAVEPOINT g_update_del_GRP;
3098:
3099: -- Standard call to check for call compatibility.
3100: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: END IF;
3103:
3104: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3097: SAVEPOINT g_update_del_GRP;
3098:
3099: -- Standard call to check for call compatibility.
3100: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: END IF;
3103:
3104: -- Initialize message list if p_init_msg_list is set to TRUE.
3105: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3105: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: END IF;
3103:
3104: -- Initialize message list if p_init_msg_list is set to TRUE.
3105: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3106: FND_MSG_PUB.initialize;
3107: END IF;
3108:
3109: -- Initialize API return status to success

Line 3110: x_return_status := FND_API.G_RET_STS_SUCCESS;

3106: FND_MSG_PUB.initialize;
3107: END IF;
3108:
3109: -- Initialize API return status to success
3110: x_return_status := FND_API.G_RET_STS_SUCCESS;
3111:
3112: UPDATE OKC_DELIVERABLES
3113: set internal_party_contact_id = p_new_buyer_id,
3114: last_updated_by= Fnd_Global.User_Id,

Line 3122: IF FND_API.To_Boolean( p_commit ) THEN

3118: AND business_document_type = p_bus_doc_type
3119: AND business_document_version = p_bus_doc_version
3120: AND internal_party_contact_id = p_original_buyer_id;
3121:
3122: IF FND_API.To_Boolean( p_commit ) THEN
3123: COMMIT WORK;
3124: END IF;
3125:
3126: -- Standard call to get message count and if count is 1, get message info.

Line 3135: WHEN FND_API.G_EXC_ERROR THEN

3131: END IF;
3132:
3133: EXCEPTION
3134:
3135: WHEN FND_API.G_EXC_ERROR THEN
3136: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3137: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateDeliverables Unexpected ERROR');
3138: END IF;
3139: ROLLBACK TO g_update_del_GRP;

Line 3143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3139: ROLLBACK TO g_update_del_GRP;
3140: x_return_status := G_RET_STS_ERROR ;
3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3142:
3143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3144: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3145: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');
3146: END IF;
3147: ROLLBACK TO g_update_del_GRP;

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

3199: -- Standard Start of API savepoint
3200: SAVEPOINT g_update2_del_GRP;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206:
3207: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3200: SAVEPOINT g_update2_del_GRP;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206:
3207: -- Initialize message list if p_init_msg_list is set to TRUE.
3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206:
3207: -- Initialize message list if p_init_msg_list is set to TRUE.
3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3209: FND_MSG_PUB.initialize;
3210: END IF;
3211:
3212: -- Initialize API return status to success

Line 3213: x_return_status := FND_API.G_RET_STS_SUCCESS;

3209: FND_MSG_PUB.initialize;
3210: END IF;
3211:
3212: -- Initialize API return status to success
3213: x_return_status := FND_API.G_RET_STS_SUCCESS;
3214:
3215: IF p_bus_docs_tbl.count > 0 THEN
3216: FOR i IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST LOOP
3217: l_bus_doc_ids(i) := p_bus_docs_tbl(i).bus_doc_id;

Line 3234: IF FND_API.To_Boolean( p_commit ) THEN

3230: AND business_document_id = l_bus_doc_ids(j)
3231: AND business_document_type = l_bus_doc_types(j)
3232: AND business_document_version = l_bus_doc_versions(j);
3233:
3234: IF FND_API.To_Boolean( p_commit ) THEN
3235: COMMIT WORK;
3236: END IF;
3237:
3238: -- Standard call to get message count and if count is 1, get message info.

Line 3247: WHEN FND_API.G_EXC_ERROR THEN

3243: END IF;
3244:
3245: EXCEPTION
3246:
3247: WHEN FND_API.G_EXC_ERROR THEN
3248: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3249: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateBuyerDeliverables Unexpected ERROR');
3250: END IF;
3251: ROLLBACK TO g_update2_del_GRP;

Line 3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3252: x_return_status := G_RET_STS_ERROR ;
3253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3254:
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3258: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateBuyerDeliverables Unexpected ERROR');
3259: END IF;
3260: ROLLBACK TO g_update2_del_GRP;

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

3301: -- Standard Start of API savepoint
3302: SAVEPOINT g_disable_del_GRP;
3303:
3304: -- Standard call to check for call compatibility.
3305: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:
3309: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3302: SAVEPOINT g_disable_del_GRP;
3303:
3304: -- Standard call to check for call compatibility.
3305: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:
3309: -- Initialize message list if p_init_msg_list is set to TRUE.
3310: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3310: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:
3309: -- Initialize message list if p_init_msg_list is set to TRUE.
3310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3311: FND_MSG_PUB.initialize;
3312: END IF;
3313:
3314: -- Initialize API return status to success

Line 3315: x_return_status := FND_API.G_RET_STS_SUCCESS;

3311: FND_MSG_PUB.initialize;
3312: END IF;
3313:
3314: -- Initialize API return status to success
3315: x_return_status := FND_API.G_RET_STS_SUCCESS;
3316:
3317: -- start procedure
3318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling OKC_DELIVERABLE_PROCESS_PVT.disable_deliverables');

Line 3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3335: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: Finished disable_deliverables' ||x_return_status);
3336: END IF;
3337:
3338: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:

Line 3341: RAISE FND_API.G_EXC_ERROR ;

3337:
3338: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3340: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:
3344:
3345: IF FND_API.To_Boolean( p_commit ) THEN

Line 3345: IF FND_API.To_Boolean( p_commit ) THEN

3341: RAISE FND_API.G_EXC_ERROR ;
3342: END IF;
3343:
3344:
3345: IF FND_API.To_Boolean( p_commit ) THEN
3346: COMMIT WORK;
3347: END IF;
3348:
3349: -- Standard call to get message count and if count is 1, get message info.

Line 3358: WHEN FND_API.G_EXC_ERROR THEN

3354: END IF;
3355:
3356: EXCEPTION
3357:
3358: WHEN FND_API.G_EXC_ERROR THEN
3359: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3360: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving disableDeliverables Unexpected ERROR');
3361: END IF;
3362: ROLLBACK TO g_disable_del_GRP;

Line 3366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3362: ROLLBACK TO g_disable_del_GRP;
3363: x_return_status := G_RET_STS_ERROR ;
3364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3365:
3366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3367: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving disableDeliverables Unexpected ERROR');
3369: END IF;
3370: ROLLBACK TO g_disable_del_GRP;

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

3416: -- Standard Start of API savepoint
3417: SAVEPOINT g_update_del_GRP;
3418:
3419: -- Standard call to check for call compatibility.
3420: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: END IF;
3423:
3424: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3417: SAVEPOINT g_update_del_GRP;
3418:
3419: -- Standard call to check for call compatibility.
3420: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: END IF;
3423:
3424: -- Initialize message list if p_init_msg_list is set to TRUE.
3425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3422: END IF;
3423:
3424: -- Initialize message list if p_init_msg_list is set to TRUE.
3425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3426: FND_MSG_PUB.initialize;
3427: END IF;
3428:
3429: -- Initialize API return status to success

Line 3430: x_return_status := FND_API.G_RET_STS_SUCCESS;

3426: FND_MSG_PUB.initialize;
3427: END IF;
3428:
3429: -- Initialize API return status to success
3430: x_return_status := FND_API.G_RET_STS_SUCCESS;
3431:
3432: --bug#4154567 update -99 version aswell
3433: UPDATE OKC_DELIVERABLES
3434: set internal_party_contact_id = p_new_internal_contact_id,

Line 3443: IF FND_API.To_Boolean( p_commit ) THEN

3439: AND business_document_type = p_bus_doc_type
3440: AND business_document_version IN (-99, p_bus_doc_version)
3441: AND internal_party_contact_id = p_original_internal_contact_id;
3442:
3443: IF FND_API.To_Boolean( p_commit ) THEN
3444: COMMIT WORK;
3445: END IF;
3446:
3447: -- Standard call to get message count and if count is 1, get message info.

Line 3456: WHEN FND_API.G_EXC_ERROR THEN

3452: END IF;
3453:
3454: EXCEPTION
3455:
3456: WHEN FND_API.G_EXC_ERROR THEN
3457: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3458: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3459: END IF;
3460: ROLLBACK TO g_update_del_GRP;

Line 3464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3460: ROLLBACK TO g_update_del_GRP;
3461: x_return_status := G_RET_STS_ERROR ;
3462: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3463:
3464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3465: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3466: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3467: END IF;
3468: ROLLBACK TO g_update_del_GRP;

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

3521: -- Standard Start of API savepoint
3522: SAVEPOINT g_update2_del_GRP;
3523:
3524: -- Standard call to check for call compatibility.
3525: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3527: END IF;
3528:
3529: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3522: SAVEPOINT g_update2_del_GRP;
3523:
3524: -- Standard call to check for call compatibility.
3525: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3527: END IF;
3528:
3529: -- Initialize message list if p_init_msg_list is set to TRUE.
3530: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3530: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3527: END IF;
3528:
3529: -- Initialize message list if p_init_msg_list is set to TRUE.
3530: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3531: FND_MSG_PUB.initialize;
3532: END IF;
3533:
3534: -- Initialize API return status to success

Line 3535: x_return_status := FND_API.G_RET_STS_SUCCESS;

3531: FND_MSG_PUB.initialize;
3532: END IF;
3533:
3534: -- Initialize API return status to success
3535: x_return_status := FND_API.G_RET_STS_SUCCESS;
3536:
3537: IF p_bus_docs_tbl.count > 0 THEN
3538: FOR i IN p_bus_docs_tbl.FIRST..p_bus_docs_tbl.LAST LOOP
3539: l_bus_doc_ids(i) := p_bus_docs_tbl(i).bus_doc_id;

Line 3557: IF FND_API.To_Boolean( p_commit ) THEN

3553: AND business_document_id = l_bus_doc_ids(j)
3554: AND business_document_type = l_bus_doc_types(j)
3555: AND business_document_version IN (l_bus_doc_versions(j),-99);
3556:
3557: IF FND_API.To_Boolean( p_commit ) THEN
3558: COMMIT WORK;
3559: END IF;
3560:
3561: -- Standard call to get message count and if count is 1, get message info.

Line 3570: WHEN FND_API.G_EXC_ERROR THEN

3566: END IF;
3567:
3568: EXCEPTION
3569:
3570: WHEN FND_API.G_EXC_ERROR THEN
3571: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3572: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3573: END IF;
3574: ROLLBACK TO g_update2_del_GRP;

Line 3579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3575: x_return_status := G_RET_STS_ERROR ;
3576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3577:
3578:
3579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3580: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3581: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3582: END IF;
3583: ROLLBACK TO g_update2_del_GRP;

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

3627: -- Standard Start of API savepoint
3628: SAVEPOINT g_update_del_GRP;
3629:
3630: -- Standard call to check for call compatibility.
3631: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633: END IF;
3634:
3635: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3628: SAVEPOINT g_update_del_GRP;
3629:
3630: -- Standard call to check for call compatibility.
3631: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633: END IF;
3634:
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3636: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633: END IF;
3634:
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3637: FND_MSG_PUB.initialize;
3638: END IF;
3639:
3640: -- Initialize API return status to success

Line 3641: x_return_status := FND_API.G_RET_STS_SUCCESS;

3637: FND_MSG_PUB.initialize;
3638: END IF;
3639:
3640: -- Initialize API return status to success
3641: x_return_status := FND_API.G_RET_STS_SUCCESS;
3642:
3643: UPDATE OKC_DELIVERABLES
3644: SET external_party_id = p_external_party_id,
3645: external_party_site_id = p_external_party_site_id,

Line 3654: IF FND_API.To_Boolean( p_commit ) THEN

3650: AND business_document_type = p_bus_doc_type
3651: AND business_document_version = -99;
3652:
3653:
3654: IF FND_API.To_Boolean( p_commit ) THEN
3655: COMMIT WORK;
3656: END IF;
3657:
3658: -- Standard call to get message count and if count is 1, get message info.

Line 3667: WHEN FND_API.G_EXC_ERROR THEN

3663: END IF;
3664:
3665: EXCEPTION
3666:
3667: WHEN FND_API.G_EXC_ERROR THEN
3668: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3670: END IF;
3671: ROLLBACK TO g_update_del_GRP;

Line 3675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3671: ROLLBACK TO g_update_del_GRP;
3672: x_return_status := G_RET_STS_ERROR ;
3673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3674:
3675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3676: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3677: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3678: END IF;
3679: ROLLBACK TO g_update_del_GRP;

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

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

Line 3750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3754: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 3759: x_return_status := FND_API.G_RET_STS_SUCCESS;

3755: FND_MSG_PUB.initialize;
3756: END IF;
3757:
3758: -- Initialize API return status to success
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760:
3761: -- initialize the table with 0 rows
3762: j := 0;
3763: delIdTab.delete;

Line 3797: IF FND_API.To_Boolean( p_commit ) THEN

3793: CLOSE del_cur ;
3794: END IF;
3795:
3796:
3797: IF FND_API.To_Boolean( p_commit ) THEN
3798: COMMIT WORK;
3799: END IF;
3800:
3801:

Line 3808: WHEN FND_API.G_EXC_ERROR THEN

3804: END IF;
3805:
3806: EXCEPTION
3807:
3808: WHEN FND_API.G_EXC_ERROR THEN
3809: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3810: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3811: END IF;
3812: -- close any open cursors

Line 3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3816: ROLLBACK TO g_update_del_GRP;
3817: x_return_status := G_RET_STS_ERROR ;
3818: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3819:
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3821: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3822: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3823: END IF;
3824: ROLLBACK TO g_update_del_GRP;

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

3927: -- Standard Start of API savepoint
3928: SAVEPOINT g_createHistory_GRP;
3929:
3930: -- Standard call to check for call compatibility.
3931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934:
3935: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3928: SAVEPOINT g_createHistory_GRP;
3929:
3930: -- Standard call to check for call compatibility.
3931: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934:
3935: -- Initialize message list if p_init_msg_list is set to TRUE.
3936: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3936: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934:
3935: -- Initialize message list if p_init_msg_list is set to TRUE.
3936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3937: FND_MSG_PUB.initialize;
3938: END IF;
3939:
3940: --loop thru deliverables where only the notes have changed

Line 4010: p_init_msg_list => FND_API.G_FALSE,

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

Line 4026: IF FND_API.To_Boolean( p_commit ) THEN

4022: END IF;
4023: raise;
4024: end;
4025:
4026: IF FND_API.To_Boolean( p_commit ) THEN
4027: COMMIT WORK;
4028: END IF;
4029:
4030:

Line 4037: WHEN FND_API.G_EXC_ERROR THEN

4033: END IF;
4034:
4035: EXCEPTION
4036:
4037: WHEN FND_API.G_EXC_ERROR THEN
4038: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4039: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving postDelStatusChanges Unexpected ERROR');
4040: END IF;
4041: ROLLBACK TO g_createHistory_GRP;

Line 4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4041: ROLLBACK TO g_createHistory_GRP;
4042: x_return_status := G_RET_STS_ERROR ;
4043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4044:
4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4046: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4047: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving postDelStatusChanges Unexpected ERROR');
4048: END IF;
4049: ROLLBACK TO g_createHistory_GRP;

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

4076: **/
4077:
4078: FUNCTION deliverablesForExtPartyExist(
4079: p_api_version IN NUMBER,
4080: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4081: x_return_status OUT NOCOPY VARCHAR2,
4082: x_msg_data OUT NOCOPY VARCHAR2,
4083: x_msg_count OUT NOCOPY NUMBER,
4084:

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

4162: Returns N or Y, if there is unexpected error then it returns NULL.
4163: **/
4164: FUNCTION check_manageable_deliverables(
4165: p_api_version IN NUMBER,
4166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4167: x_return_status OUT NOCOPY VARCHAR2,
4168: x_msg_data OUT NOCOPY VARCHAR2,
4169: x_msg_count OUT NOCOPY NUMBER,
4170:

Line 4244: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4240: * within a customer
4241: */
4242: PROCEDURE mergeExtPartyOnDeliverables (
4243: p_api_version IN NUMBER,
4244: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4245: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4246: p_document_class IN VARCHAR2,
4247: p_from_external_party_id IN NUMBER,
4248: p_from_external_party_site_id IN NUMBER,

Line 4245: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4241: */
4242: PROCEDURE mergeExtPartyOnDeliverables (
4243: p_api_version IN NUMBER,
4244: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4245: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4246: p_document_class IN VARCHAR2,
4247: p_from_external_party_id IN NUMBER,
4248: p_from_external_party_site_id IN NUMBER,
4249: p_to_external_party_id IN NUMBER,

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

4286: -- Standard Start of API savepoint
4287: SAVEPOINT g_update_del_GRP;
4288:
4289: -- Standard call to check for call compatibility.
4290: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4292: END IF;
4293:
4294: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4287: SAVEPOINT g_update_del_GRP;
4288:
4289: -- Standard call to check for call compatibility.
4290: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4292: END IF;
4293:
4294: -- Initialize message list if p_init_msg_list is set to TRUE.
4295: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4295: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4292: END IF;
4293:
4294: -- Initialize message list if p_init_msg_list is set to TRUE.
4295: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4296: FND_MSG_PUB.initialize;
4297: END IF;
4298:
4299: -- Initialize API return status to success

Line 4300: x_return_status := FND_API.G_RET_STS_SUCCESS;

4296: FND_MSG_PUB.initialize;
4297: END IF;
4298:
4299: -- Initialize API return status to success
4300: x_return_status := FND_API.G_RET_STS_SUCCESS;
4301:
4302: -- initialize the table with 0 rows
4303: j := 0;
4304: delIdTab.delete;

Line 4326: IF FND_API.To_Boolean( p_commit ) THEN

4322: CLOSE del_cur ;
4323: END IF;
4324:
4325:
4326: IF FND_API.To_Boolean( p_commit ) THEN
4327: COMMIT WORK;
4328: END IF;
4329:
4330:

Line 4337: WHEN FND_API.G_EXC_ERROR THEN

4333: END IF;
4334:
4335: EXCEPTION
4336:
4337: WHEN FND_API.G_EXC_ERROR THEN
4338: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4339: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');
4340: END IF;
4341: -- close any open cursors

Line 4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4345: ROLLBACK TO g_update_del_GRP;
4346: x_return_status := G_RET_STS_ERROR ;
4347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4348:
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4351: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');
4352: END IF;
4353: ROLLBACK TO g_update_del_GRP;

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

4402: -- Standard Start of API savepoint
4403: SAVEPOINT g_activatecloseout_del_GRP;
4404:
4405: -- Standard call to check for call compatibility.
4406: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END IF;
4409:
4410: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4403: SAVEPOINT g_activatecloseout_del_GRP;
4404:
4405: -- Standard call to check for call compatibility.
4406: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END IF;
4409:
4410: -- Initialize message list if p_init_msg_list is set to TRUE.
4411: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4411: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END IF;
4409:
4410: -- Initialize message list if p_init_msg_list is set to TRUE.
4411: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4412: FND_MSG_PUB.initialize;
4413: END IF;
4414:
4415: -- Initialize API return status to success

Line 4416: x_return_status := FND_API.G_RET_STS_SUCCESS;

4412: FND_MSG_PUB.initialize;
4413: END IF;
4414:
4415: -- Initialize API return status to success
4416: x_return_status := FND_API.G_RET_STS_SUCCESS;
4417:
4418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'200: Calling '||'resolveDeliverables');
4420: END IF;

Line 4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4439: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'300: Finished resolveDeliverables' ||x_return_status);
4440: END IF;
4441:
4442: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4444: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4445: RAISE FND_API.G_EXC_ERROR ;
4446: END IF;
4447:

Line 4445: RAISE FND_API.G_EXC_ERROR ;

4441:
4442: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4444: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4445: RAISE FND_API.G_EXC_ERROR ;
4446: END IF;
4447:
4448: -- Initialize API return status to success
4449: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4449: x_return_status := FND_API.G_RET_STS_SUCCESS;

4445: RAISE FND_API.G_EXC_ERROR ;
4446: END IF;
4447:
4448: -- Initialize API return status to success
4449: x_return_status := FND_API.G_RET_STS_SUCCESS;
4450:
4451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Entered '||'OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status');
4453: END IF;

Line 4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4473: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'500: Finished OKC_DELIVERABLE_PROCESS_PVT.change_deliverable_status' ||x_return_status);
4474: END IF;
4475:
4476: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4478: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4479: RAISE FND_API.G_EXC_ERROR ;
4480: END IF;
4481:

Line 4479: RAISE FND_API.G_EXC_ERROR ;

4475:
4476: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4478: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4479: RAISE FND_API.G_EXC_ERROR ;
4480: END IF;
4481:
4482: IF FND_API.To_Boolean( p_commit ) THEN
4483: COMMIT WORK;

Line 4482: IF FND_API.To_Boolean( p_commit ) THEN

4478: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4479: RAISE FND_API.G_EXC_ERROR ;
4480: END IF;
4481:
4482: IF FND_API.To_Boolean( p_commit ) THEN
4483: COMMIT WORK;
4484: END IF;
4485:
4486: -- Standard call to get message count and if count is 1, get message info.

Line 4495: WHEN FND_API.G_EXC_ERROR THEN

4491: END IF;
4492:
4493: EXCEPTION
4494:
4495: WHEN FND_API.G_EXC_ERROR THEN
4496: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4497: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving activateCloseoutDeliverables Unexpected ERROR');
4498: END IF;
4499: ROLLBACK TO g_activatecloseout_del_GRP;

Line 4503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4499: ROLLBACK TO g_activatecloseout_del_GRP;
4500: x_return_status := G_RET_STS_ERROR ;
4501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4502:
4503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4504:
4505: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4506: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving activateCloseoutDeliverables Unexpected ERROR');
4507: END IF;

Line 4537: -- Default = FND_API.G_FALSE

4533: --Pre-reqs : None.
4534: --Parameters :
4535: --IN : p_api_version IN NUMBER Required
4536: -- : p_init_msg_list IN VARCHAR2 Optional
4537: -- Default = FND_API.G_FALSE
4538: -- : p_bus_doc_id IN NUMBER Required
4539: -- Header ID of the Standard Purchase Order
4540: -- : p_bus_doc_version IN NUMBER Required
4541: -- Version number of the Standard Purchase Order