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.AHL_UMP_UNPLANNED_PVT dependencies on FND_API

Line 26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

22:
23: PROCEDURE Create_Unit_Effectivity
24: (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 27: p_commit IN VARCHAR2 := FND_API.G_FALSE,

23: PROCEDURE Create_Unit_Effectivity
24: (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,

Line 28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

24: (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_mr_header_id IN NUMBER,

Line 156: x_return_status:=FND_API.G_RET_STS_SUCCESS;

152:
153: SAVEPOINT sp_create_unit_effectivity;
154:
155: -- Initialize return status to success initially
156: x_return_status:=FND_API.G_RET_STS_SUCCESS;
157:
158: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
159: THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 158: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

154:
155: -- Initialize return status to success initially
156: x_return_status:=FND_API.G_RET_STS_SUCCESS;
157:
158: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
159: THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

156: x_return_status:=FND_API.G_RET_STS_SUCCESS;
157:
158: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
159: THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162:
163: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
164: AHL_UTIL_PKG.Get_Appln_Usage

Line 171: IF (l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

167: x_return_status => l_return_status
168: );
169:
170: l_msg_count := FND_MSG_PUB.COUNT_MSG;
171: IF (l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS)
172: THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:

Line 173: RAISE FND_API.G_EXC_ERROR;

169:
170: l_msg_count := FND_MSG_PUB.COUNT_MSG;
171: IF (l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS)
172: THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL ) THEN
177: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );

Line 183: IF (p_init_msg_list = FND_API.G_TRUE) THEN

179: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_return_status: ' || l_return_status);
180: END IF;
181:
182:
183: IF (p_init_msg_list = FND_API.G_TRUE) THEN
184: FND_MSG_PUB.Initialize;
185: END IF;
186:
187: -- API body starts here

Line 191: p_mr_header_id IS NULL OR p_mr_header_id = FND_API.G_MISS_NUM OR

187: -- API body starts here
188: -- If (p_mr_header_id is null or p_instance_id is null), then display error
189: IF
190: (
191: p_mr_header_id IS NULL OR p_mr_header_id = FND_API.G_MISS_NUM OR
192: p_instance_id IS NULL OR p_instance_id = FND_API.G_MISS_NUM
193: )
194: THEN
195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

Line 192: p_instance_id IS NULL OR p_instance_id = FND_API.G_MISS_NUM

188: -- If (p_mr_header_id is null or p_instance_id is null), then display error
189: IF
190: (
191: p_mr_header_id IS NULL OR p_mr_header_id = FND_API.G_MISS_NUM OR
192: p_instance_id IS NULL OR p_instance_id = FND_API.G_MISS_NUM
193: )
194: THEN
195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);

Line 206: RAISE FND_API.G_EXC_ERROR;

202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
203: 'Invalid Procedure Call'
204: );
205: END IF;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208:
209: -- validate the mr header id
210: OPEN check_mr_exists (p_mr_header_id);

Line 225: RAISE FND_API.G_EXC_ERROR;

221: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
222: 'MR is not found'
223: );
224: END IF;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: CLOSE check_mr_exists;
228:
229: -- validate the instance id

Line 245: RAISE FND_API.G_EXC_ERROR;

241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
242: 'Instance Number is invalid'
243: );
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: CLOSE check_instance_exists;
248:
249: --Set the return status to an error and raise an error message if the application code returned is not AHL

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: CLOSE check_instance_exists;
248:
249: --Set the return status to an error and raise an error message if the application code returned is not AHL
250: IF (l_appln_code <> 'AHL') THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
253: FND_MSG_PUB.add;
254: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
255: fnd_log.string

Line 262: RAISE FND_API.G_EXC_ERROR;

258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
259: 'Application Usage Mode is not defined or is invalid'
260: );
261: END IF;
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: --pdoki added for ER 9583373
266: OPEN Chk_UE_Init_Due (p_mr_header_id, p_instance_id);

Line 279: RAISE FND_API.G_EXC_ERROR;

275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
277: FND_MSG_PUB.ADD;
278: CLOSE Chk_UE_Init_Due;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: CLOSE Chk_UE_Init_Due;
282:
283:

Line 301: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )

297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data);
299:
300: x_msg_count := FND_MSG_PUB.count_msg;
301: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
302: THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:

Line 303: RAISE FND_API.G_EXC_ERROR;

299:
300: x_msg_count := FND_MSG_PUB.count_msg;
301: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
302: THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
307: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');

Line 318: RAISE FND_API.G_EXC_ERROR;

314: THEN
315: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
316: FND_MSG_PUB.ADD;
317: CLOSE Get_all_appl_mrs;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320:
321: CLOSE Get_all_appl_mrs;
322:

Line 338: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )

334: p_components_flag => 'N', -- get applicability for only this instance.
335: x_applicable_mr_tbl => l_applicable_mr_tbl);
336:
337: x_msg_count := FND_MSG_PUB.count_msg;
338: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
339: THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

Line 340: RAISE FND_API.G_EXC_ERROR;

336:
337: x_msg_count := FND_MSG_PUB.count_msg;
338: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
339: THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
344: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_PVT.GET_APPLICABLE_MRS to validate MR-Instance applicability' );

Line 362: RAISE FND_API.G_EXC_ERROR;

358:
359: IF (l_mr_applicable_flag = false) THEN
360: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF; -- MR applicable
364:
365: l_all_appl_mrs.csi_item_instance_id := p_instance_id;
366: l_all_appl_mrs.mr_header_id := p_mr_header_id;

Line 472: RAISE FND_API.G_EXC_ERROR;

468:
469: x_msg_count := FND_MSG_PUB.count_msg;
470: IF x_msg_count > 0
471: THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
476: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );

Line 501: RAISE FND_API.G_EXC_ERROR;

497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
499: FND_MSG_PUB.ADD;
500: CLOSE Chk_UE_Init_Due;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: CLOSE Chk_UE_Init_Due;
504:
505: /*

Line 673: RAISE FND_API.G_EXC_ERROR;

669: -- Check Error Message stack.
670: x_msg_count := FND_MSG_PUB.count_msg;
671: IF x_msg_count > 0
672: THEN
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;
675:
676:
677: EXCEPTION

Line 678: WHEN FND_API.G_EXC_ERROR THEN

674: END IF;
675:
676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: Rollback to sp_create_unit_effectivity;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
682: fnd_log.string

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: Rollback to sp_create_unit_effectivity;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
682: fnd_log.string
683: (
684: G_DEBUG_ERROR,

Line 693: p_encoded => FND_API.G_FALSE

689: FND_MSG_PUB.count_and_get
690: (
691: p_count => x_msg_count,
692: p_data => x_msg_data,
693: p_encoded => FND_API.G_FALSE
694: );
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: Rollback to sp_create_unit_effectivity;

Line 696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

692: p_data => x_msg_data,
693: p_encoded => FND_API.G_FALSE
694: );
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: Rollback to sp_create_unit_effectivity;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
700: fnd_log.string

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: );
695:
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: Rollback to sp_create_unit_effectivity;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
700: fnd_log.string
701: (
702: G_DEBUG_ERROR,

Line 711: p_encoded => FND_API.G_FALSE

707: FND_MSG_PUB.count_and_get
708: (
709: p_count => x_msg_count,
710: p_data => x_msg_data,
711: p_encoded => FND_API.G_FALSE
712: );
713:
714: WHEN OTHERS THEN
715: Rollback to sp_create_unit_effectivity;

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

712: );
713:
714: WHEN OTHERS THEN
715: Rollback to sp_create_unit_effectivity;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
718: THEN
719: FND_MSG_PUB.add_exc_msg
720: (

Line 738: p_encoded => FND_API.G_FALSE

734: FND_MSG_PUB.count_and_get
735: (
736: p_count => x_msg_count,
737: p_data => x_msg_data,
738: p_encoded => FND_API.G_FALSE
739: );
740: END Create_Unit_Effectivity;
741:
742:

Line 746: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

742:
743: PROCEDURE Delete_Unit_Effectivity
744: (
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
747: p_commit IN VARCHAR2 := FND_API.G_FALSE,
748: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,

Line 747: p_commit IN VARCHAR2 := FND_API.G_FALSE,

743: PROCEDURE Delete_Unit_Effectivity
744: (
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
747: p_commit IN VARCHAR2 := FND_API.G_FALSE,
748: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,

Line 748: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

744: (
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
747: p_commit IN VARCHAR2 := FND_API.G_FALSE,
748: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_unit_effectivity_id IN NUMBER

Line 804: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

800: BEGIN
801:
802: SAVEPOINT sp_delete_unit_effectivity;
803: -- Standard call to check for call compatibility
804: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
805: THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: SAVEPOINT sp_delete_unit_effectivity;
803: -- Standard call to check for call compatibility
804: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
805: THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809: -- Log API entry point
810: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)

Line 822: x_return_status := FND_API.G_RET_STS_SUCCESS;

818: END IF;
819:
820: -- API body starts here
821: -- Initialize API return status to success
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823:
824: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
825: AHL_UTIL_PKG.Get_Appln_Usage
826: (

Line 834: RAISE FND_API.G_EXC_ERROR;

830:
831: l_msg_count := FND_MSG_PUB.COUNT_MSG;
832: IF (l_msg_count > 0)
833: THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836:
837: -- if the UE Id passed is a middle node then get the Top Node UE Id.
838: OPEN GetOrigUeId ( p_unit_effectivity_id );

Line 860: RAISE FND_API.G_EXC_ERROR;

856: IF (l_originator_ue_id IS NULL)
857: THEN
858: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: ELSE
862: -- validate the existance of the Unit Effectivity Id
863: OPEN GetStatusCode (p_unit_effectivity_id);
864: FETCH GetStatusCode INTO l_get_status_code,l_object_type;

Line 869: RAISE FND_API.G_EXC_ERROR;

865: IF (GetStatusCode%NOTFOUND) THEN
866: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
867: FND_MSG_PUB.ADD;
868: CLOSE GetStatusCode;
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
871: AND l_object_type = 'SR')THEN
872: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
873: FND_MSG_PUB.ADD;

Line 896: RAISE FND_API.G_EXC_ERROR;

892: THEN
893: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_STATUS_NULL'); -- mesg reused
894: FND_MSG_PUB.ADD;
895: CLOSE GetStatusCode;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: CLOSE GetStatusCode;
899: IF ( l_get_status_code IS NULL OR l_get_status_code IN ('EXCEPTION') )
900: THEN

Line 917: RAISE FND_API.G_EXC_ERROR;

913: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
914: 'Cannot delete UE'
915: );
916: END IF;
917: RAISE FND_API.G_EXC_ERROR;
918:
919: END IF;
920:
921: END LOOP;

Line 963: RAISE FND_API.G_EXC_ERROR;

959: -- Check Error Message stack.
960: x_msg_count := FND_MSG_PUB.count_msg;
961: IF x_msg_count > 0
962: THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: -- Standard call to get message count and if count is 1, get message info
967: FND_MSG_PUB.count_and_get

Line 971: p_encoded => FND_API.G_FALSE

967: FND_MSG_PUB.count_and_get
968: (
969: p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE
972: );
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN

Line 975: WHEN FND_API.G_EXC_ERROR THEN

971: p_encoded => FND_API.G_FALSE
972: );
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN
976: Rollback to sp_delete_unit_effectivity;
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
979: fnd_log.string

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_ERROR THEN
976: Rollback to sp_delete_unit_effectivity;
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
979: fnd_log.string
980: (
981: G_DEBUG_ERROR,

Line 990: p_encoded => FND_API.G_FALSE

986: FND_MSG_PUB.count_and_get
987: (
988: p_count => x_msg_count,
989: p_data => x_msg_data,
990: p_encoded => FND_API.G_FALSE
991: );
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: Rollback to sp_delete_unit_effectivity;

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: p_data => x_msg_data,
990: p_encoded => FND_API.G_FALSE
991: );
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: Rollback to sp_delete_unit_effectivity;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
997: fnd_log.string

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

991: );
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: Rollback to sp_delete_unit_effectivity;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
997: fnd_log.string
998: (
999: G_DEBUG_ERROR,

Line 1008: p_encoded => FND_API.G_FALSE

1004: FND_MSG_PUB.count_and_get
1005: (
1006: p_count => x_msg_count,
1007: p_data => x_msg_data,
1008: p_encoded => FND_API.G_FALSE
1009: );
1010:
1011: WHEN OTHERS THEN
1012: Rollback to sp_delete_unit_effectivity;

Line 1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1009: );
1010:
1011: WHEN OTHERS THEN
1012: Rollback to sp_delete_unit_effectivity;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: FND_MSG_PUB.add_exc_msg
1017: (

Line 1035: p_encoded => FND_API.G_FALSE

1031: FND_MSG_PUB.count_and_get
1032: (
1033: p_count => x_msg_count,
1034: p_data => x_msg_data,
1035: p_encoded => FND_API.G_FALSE
1036: );
1037: End Delete_Unit_Effectivity;
1038:
1039: End AHL_UMP_UNPLANNED_PVT;