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

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

14:
15: PROCEDURE create_process_setup
16: (
17: p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,

Line 19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

15: PROCEDURE create_process_setup
16: (
17: p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,

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

16: (
17: p_api_version_number IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_process_setup_tbl IN process_setup_tbl_type,

Line 45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

41: -- Standard Start of API savepoint
42: SAVEPOINT create_process_setup_pvt;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )

Line 54: IF FND_API.to_Boolean( p_init_msg_list )

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:

Line 70: RAISE FND_API.G_EXC_ERROR;

66: THEN
67: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
68: FND_MSG_PUB.ADD;
69: END IF;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72:
73: -- Debug Message
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
76: END IF;
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
82: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_process_setup_tbl.count);
83: END IF;

Line 85: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
82: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_process_setup_tbl.count);
83: END IF;
84:
85: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
86: -- Debug message
87: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
88: -- Invoke validation procedures
89: Validate_Process_Setup(

Line 91: p_init_msg_list => FND_API.G_FALSE,

87: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
88: -- Invoke validation procedures
89: Validate_Process_Setup(
90: p_api_version_number => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_validation_level => p_validation_level,
93: p_validation_mode => JTF_PLSQL_API.G_CREATE,
94: p_process_setup_tbl => p_process_setup_tbl,
95: x_return_status => x_return_status,

Line 100: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

96: x_msg_count => x_msg_count,
97: x_msg_data => x_msg_data);
98: END IF;
99:
100: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103:
104: -- Debug Message

Line 101: RAISE FND_API.G_EXC_ERROR;

97: x_msg_data => x_msg_data);
98: END IF;
99:
100: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103:
104: -- Debug Message
105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 174: RAISE FND_API.G_EXC_ERROR;

170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating process setup');
174: RAISE FND_API.G_EXC_ERROR;
175: END;
176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
177: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_process_setup_id);
178: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_process_setup_rec.Object_Version_Number);

Line 284: RAISE FND_API.G_EXC_ERROR;

280:
281: EXCEPTION
282: WHEN OTHERS THEN
283: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating process setup');
284: RAISE FND_API.G_EXC_ERROR;
285: END;
286: else
287: OZF_UTILITY_PVT.debug_message('flag was false');
288: end if ;

Line 290: -- RAISE FND_API.G_EXC_ERROR;

286: else
287: OZF_UTILITY_PVT.debug_message('flag was false');
288: end if ;
289: END LOOP;
290: -- RAISE FND_API.G_EXC_ERROR;
291: -- Standard check for p_commit
292: IF FND_API.to_Boolean( p_commit )
293: THEN
294: COMMIT WORK;

Line 292: IF FND_API.to_Boolean( p_commit )

288: end if ;
289: END LOOP;
290: -- RAISE FND_API.G_EXC_ERROR;
291: -- Standard check for p_commit
292: IF FND_API.to_Boolean( p_commit )
293: THEN
294: COMMIT WORK;
295: END IF;
296:

Line 312: x_return_status := FND_API.g_ret_sts_error;

308:
309:
310: EXCEPTION
311: WHEN OZF_UTILITY_PVT.resource_locked THEN
312: x_return_status := FND_API.g_ret_sts_error;
313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
314: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
315: FND_MSG_PUB.add;
316: END IF;

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
314: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
315: FND_MSG_PUB.add;
316: END IF;
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO create_process_setup_pvt;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: -- Standard call to get message count and if count=1, get the message
321: FND_MSG_PUB.Count_And_Get (

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

315: FND_MSG_PUB.add;
316: END IF;
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO create_process_setup_pvt;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: -- Standard call to get message count and if count=1, get the message
321: FND_MSG_PUB.Count_And_Get (
322: p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,

Line 322: p_encoded => FND_API.G_FALSE,

318: ROLLBACK TO create_process_setup_pvt;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: -- Standard call to get message count and if count=1, get the message
321: FND_MSG_PUB.Count_And_Get (
322: p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: ROLLBACK TO create_process_setup_pvt;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: -- Standard call to get message count and if count=1, get the message
330: FND_MSG_PUB.Count_And_Get (

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: p_data => x_msg_data
325: );
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: ROLLBACK TO create_process_setup_pvt;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: -- Standard call to get message count and if count=1, get the message
330: FND_MSG_PUB.Count_And_Get (
331: p_encoded => FND_API.G_FALSE,
332: p_count => x_msg_count,

Line 331: p_encoded => FND_API.G_FALSE,

327: ROLLBACK TO create_process_setup_pvt;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: -- Standard call to get message count and if count=1, get the message
330: FND_MSG_PUB.Count_And_Get (
331: p_encoded => FND_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => x_msg_data
334: );
335: WHEN OTHERS THEN

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333: p_data => x_msg_data
334: );
335: WHEN OTHERS THEN
336: ROLLBACK TO create_process_setup_pvt;
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;

Line 344: p_encoded => FND_API.G_FALSE,

340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
341: END IF;
342: -- Standard call to get message count and if count=1, get the message
343: FND_MSG_PUB.Count_And_Get (
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348:

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

351:
352: PROCEDURE Update_process_setup
353: (
354: p_api_version_number IN NUMBER,
355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356: p_commit IN VARCHAR2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,

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

352: PROCEDURE Update_process_setup
353: (
354: p_api_version_number IN NUMBER,
355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356: p_commit IN VARCHAR2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,

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

353: (
354: p_api_version_number IN NUMBER,
355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356: p_commit IN VARCHAR2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: x_return_status OUT NOCOPY VARCHAR2,
359: x_msg_count OUT NOCOPY NUMBER,
360: x_msg_data OUT NOCOPY VARCHAR2,
361: p_process_setup_tbl IN process_setup_tbl_type ,

Line 420: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

416: -- Standard Start of API savepoint
417: SAVEPOINT update_process_setup_pvt;
418:
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
424: THEN

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
424: THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean( p_init_msg_list )

Line 429: IF FND_API.to_Boolean( p_init_msg_list )

425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean( p_init_msg_list )
430: THEN
431: FND_MSG_PUB.initialize;
432: END IF;
433:

Line 444: RAISE FND_API.G_EXC_ERROR;

440: THEN
441: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
442: FND_MSG_PUB.ADD;
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: -- Debug Message
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
450: END IF;
451:
452: -- Initialize API return status to SUCCESS
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454: x_object_version_number := JTF_NUMBER_TABLE();
455:
456:
457: FOR i in 1 .. p_process_setup_tbl.count

Line 509: RAISE FND_API.G_EXC_ERROR;

505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.G_EXC_ERROR;
510: END IF;
511: CLOSE csr_process_setup;
512:
513:

Line 532: RAISE FND_API.G_EXC_ERROR;

528: THEN
529: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
530: FND_MSG_PUB.ADD;
531: END IF;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535:
536: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 536: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535:
536: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
537: -- Debug message
538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
539: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);
540: END IF;

Line 544: p_init_msg_list => FND_API.G_FALSE,

540: END IF;
541: -- Invoke validation procedures
542: Validate_process_setup(
543: p_api_version_number => 1.0,
544: p_init_msg_list => FND_API.G_FALSE,
545: p_validation_level => p_validation_level,
546: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
547: p_process_setup_tbl => p_process_setup_tbl,
548: x_return_status => x_return_status,

Line 553: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

549: x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data);
551: END IF;
552:
553: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557: IF (l_process_setup_rec.org_id IS NULL) THEN

Line 554: RAISE FND_API.G_EXC_ERROR;

550: x_msg_data => x_msg_data);
551: END IF;
552:
553: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557: IF (l_process_setup_rec.org_id IS NULL) THEN
558: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements

Line 603: RAISE FND_API.G_EXC_ERROR;

599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating OZF_PROCESS_SETUP table');
603: RAISE FND_API.G_EXC_ERROR;
604: END;
605: x_object_version_number.EXTEND;
606: x_object_Version_number(x_object_version_number.count) := p_process_setup_rec.Object_Version_Number;
607:

Line 612: IF FND_API.to_Boolean( p_commit )

608: END LOOP;
609: --END IF;
610:
611: -- Standard check for p_commit
612: IF FND_API.to_Boolean( p_commit )
613: THEN
614: COMMIT WORK;
615: END IF;
616:

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: (p_count => x_msg_count,
625: p_data => x_msg_data
626: );
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO update_process_setup_pvt;
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: FND_MSG_PUB.Count_And_Get (

Line 630: x_return_status := FND_API.G_RET_STS_ERROR;

626: );
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO update_process_setup_pvt;
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: FND_MSG_PUB.Count_And_Get (
633: p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,

Line 633: p_encoded => FND_API.G_FALSE,

629: ROLLBACK TO update_process_setup_pvt;
630: x_return_status := FND_API.G_RET_STS_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: FND_MSG_PUB.Count_And_Get (
633: p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
636: );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

633: p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
636: );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: ROLLBACK TO update_process_setup_pvt;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

635: p_data => x_msg_data
636: );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: ROLLBACK TO update_process_setup_pvt;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,

Line 642: p_encoded => FND_API.G_FALSE,

638: ROLLBACK TO update_process_setup_pvt;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data
645: );
646: WHEN OTHERS THEN

Line 648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

644: p_data => x_msg_data
645: );
646: WHEN OTHERS THEN
647: ROLLBACK TO update_process_setup_pvt;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;

Line 655: p_encoded => FND_API.G_FALSE,

651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659:

Line 666: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

662:
663:
664: PROCEDURE Update_Process_Setup_Tbl(
665: P_Api_Version_Number IN NUMBER,
666: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
667: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669: X_Return_Status OUT NOCOPY VARCHAR2,
670: X_Msg_Count OUT NOCOPY NUMBER,

Line 667: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

663:
664: PROCEDURE Update_Process_Setup_Tbl(
665: P_Api_Version_Number IN NUMBER,
666: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
667: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669: X_Return_Status OUT NOCOPY VARCHAR2,
670: X_Msg_Count OUT NOCOPY NUMBER,
671: X_Msg_Data OUT NOCOPY VARCHAR2,

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

664: PROCEDURE Update_Process_Setup_Tbl(
665: P_Api_Version_Number IN NUMBER,
666: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
667: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669: X_Return_Status OUT NOCOPY VARCHAR2,
670: X_Msg_Count OUT NOCOPY NUMBER,
671: X_Msg_Data OUT NOCOPY VARCHAR2,
672: P_process_setup_Tbl IN process_setup_tbl_type

Line 701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

697: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
698: END IF;
699:
700: -- Standard call to check for call compatibility.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
702: p_api_version_number,
703: l_api_name,
704: G_PKG_NAME)
705: THEN

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: p_api_version_number,
703: l_api_name,
704: G_PKG_NAME)
705: THEN
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )

Line 710: IF FND_API.to_Boolean( p_init_msg_list )

706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )
711: THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:

Line 725: RAISE FND_API.G_EXC_ERROR;

721: THEN
722: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
723: FND_MSG_PUB.ADD;
724: END IF;
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- Debug Message
729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 734: x_return_status := FND_API.G_RET_STS_SUCCESS;

730: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
731: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_process_setup_Tbl.count);
732: END IF;
733: -- Initialize API return status to SUCCESS
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: v_process_setup_id := JTF_NUMBER_TABLE();
737: v_object_version_number := JTF_NUMBER_TABLE();
738:

Line 793: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

789: p_process_setup_tbl => l_create_pro_setup_tbl,
790: x_process_setup_id_tbl => v_process_setup_id
791: );
792:
793: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;
797:

Line 794: RAISE FND_API.G_EXC_ERROR;

790: x_process_setup_id_tbl => v_process_setup_id
791: );
792:
793: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;
797:
798: IF l_up_cnt > 0 THEN

Line 812: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

808: p_process_setup_tbl => l_update_pro_setup_tbl,
809: x_object_version_number => v_object_version_number
810: );
811:
812: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815: END IF;
816:

Line 813: RAISE FND_API.G_EXC_ERROR;

809: x_object_version_number => v_object_version_number
810: );
811:
812: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815: END IF;
816:
817: -- Standard check for p_commit

Line 818: IF FND_API.to_Boolean( p_commit )

814: END IF;
815: END IF;
816:
817: -- Standard check for p_commit
818: IF FND_API.to_Boolean( p_commit )
819: THEN
820: COMMIT WORK;
821: END IF;
822:

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829: (p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO update_process_setup_tbl_pvt;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

831: );
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO update_process_setup_tbl_pvt;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,

Line 838: p_encoded => FND_API.G_FALSE,

834: ROLLBACK TO update_process_setup_tbl_pvt;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO update_process_setup_tbl_pvt;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

840: p_data => x_msg_data
841: );
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO update_process_setup_tbl_pvt;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,

Line 847: p_encoded => FND_API.G_FALSE,

843: ROLLBACK TO update_process_setup_tbl_pvt;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: WHEN OTHERS THEN

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: p_data => x_msg_data
850: );
851: WHEN OTHERS THEN
852: ROLLBACK TO update_process_setup_tbl_pvt;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;

Line 860: p_encoded => FND_API.G_FALSE,

856: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;
858: -- Standard call to get message count and if count=1, get the message
859: FND_MSG_PUB.Count_And_Get (
860: p_encoded => FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
863: );
864:

Line 906: x_return_status := FND_API.g_ret_sts_success;

902:
903:
904: BEGIN
905:
906: x_return_status := FND_API.g_ret_sts_success;
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
908: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
909:
910: END IF;

Line 912: IF p_process_setup_rec.supp_trade_profile_id = FND_API.g_miss_num OR

908: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
909:
910: END IF;
911: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
912: IF p_process_setup_rec.supp_trade_profile_id = FND_API.g_miss_num OR
913: p_process_setup_rec.supp_trade_profile_id IS NULL
914: THEN
915: l_psi_dummy := 0;
916:

Line 932: l_valid_flag := FND_API.g_false;

928: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
929: OZF_UTILITY_PVT.debug_message('Duplicate Process setup id' || p_process_setup_rec.process_setup_id );
930: END IF;
931: IF l_psi_dummy > 0 THEN
932: l_valid_flag := FND_API.g_false;
933: END IF;
934: ELSE
935: l_psi_dummy := NULL;
936: OPEN csr_pro_setup_4stp( p_process_setup_rec.supp_trade_profile_id,

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
947: FND_MESSAGE.set_name('OZF', 'OZF_DUPLICATE_PROCESS_SETUP');
948: FND_MSG_PUB.add;
949: END IF;
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: l_valid_flag := FND_API.g_false;
952: END IF;
953:
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 951: l_valid_flag := FND_API.g_false;

947: FND_MESSAGE.set_name('OZF', 'OZF_DUPLICATE_PROCESS_SETUP');
948: FND_MSG_PUB.add;
949: END IF;
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: l_valid_flag := FND_API.g_false;
952: END IF;
953:
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
955: OZF_UTILITY_PVT.debug_message('Count of code map for psi ' || l_psi_dummy);

Line 959: l_valid_flag := FND_API.g_true;

955: OZF_UTILITY_PVT.debug_message('Count of code map for psi ' || l_psi_dummy);
956: END IF;
957: END IF;
958: ELSE -- for update mode
959: l_valid_flag := FND_API.g_true;
960: END IF;
961:
962: IF l_valid_flag = FND_API.g_false THEN
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 962: IF l_valid_flag = FND_API.g_false THEN

958: ELSE -- for update mode
959: l_valid_flag := FND_API.g_true;
960: END IF;
961:
962: IF l_valid_flag = FND_API.g_false THEN
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
964: FND_MESSAGE.set_name('OZF', 'OZF_DUPLICATE_PROCESS_SETUP');
965: FND_MSG_PUB.add;
966: END IF;

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
964: FND_MESSAGE.set_name('OZF', 'OZF_DUPLICATE_PROCESS_SETUP');
965: FND_MSG_PUB.add;
966: END IF;
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970:
971: END Check_Uniq_Process_Setup;

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: FND_MESSAGE.set_name('OZF', 'OZF_DUPLICATE_PROCESS_SETUP');
965: FND_MSG_PUB.add;
966: END IF;
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970:
971: END Check_Uniq_Process_Setup;
972:

Line 996: x_return_status := FND_API.g_ret_sts_success;

992: l_api_version_number CONSTANT NUMBER := 1.0;
993:
994: BEGIN
995:
996: x_return_status := FND_API.g_ret_sts_success;
997:
998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
999: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1000: END IF;

Line 1002: IF p_process_setup_rec.org_id = FND_API.g_miss_num OR

998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
999: OZF_UTILITY_PVT.debug_message('in '||l_api_name);
1000: END IF;
1001:
1002: IF p_process_setup_rec.org_id = FND_API.g_miss_num OR
1003: p_process_setup_rec.org_id IS NULL
1004: THEN
1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1006: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_MISSING');

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1006: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_MISSING');
1007: FND_MSG_PUB.add;
1008: END IF;
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: END IF;
1011: IF x_return_status <> FND_API.g_ret_sts_success THEN
1012: RETURN;
1013: END IF;

Line 1011: IF x_return_status <> FND_API.g_ret_sts_success THEN

1007: FND_MSG_PUB.add;
1008: END IF;
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: END IF;
1011: IF x_return_status <> FND_API.g_ret_sts_success THEN
1012: RETURN;
1013: END IF;
1014:
1015: check_uniq_process_setup( p_process_setup_rec,

Line 1019: IF x_return_status <> FND_API.g_ret_sts_success THEN

1015: check_uniq_process_setup( p_process_setup_rec,
1016: p_validation_mode,
1017: x_return_status
1018: );
1019: IF x_return_status <> FND_API.g_ret_sts_success THEN
1020: RETURN;
1021: END IF;
1022:
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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

1035: -- End of Comments
1036:
1037: PROCEDURE Validate_Process_Setup(
1038: p_api_version_number IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1040: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1041: p_validation_mode IN VARCHAR2,
1042: p_process_setup_tbl IN process_setup_tbl_type,
1043: x_return_status OUT NOCOPY VARCHAR2,

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

1036:
1037: PROCEDURE Validate_Process_Setup(
1038: p_api_version_number IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1040: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1041: p_validation_mode IN VARCHAR2,
1042: p_process_setup_tbl IN process_setup_tbl_type,
1043: x_return_status OUT NOCOPY VARCHAR2,
1044: x_msg_count OUT NOCOPY NUMBER,

Line 1061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1057: -- Standard Start of API savepoint
1058: SAVEPOINT validate_process_setup_pvt;
1059:
1060: -- Standard call to check for call compatibility.
1061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1062: p_api_version_number,
1063: l_api_name,
1064: G_PKG_NAME)
1065: THEN

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: p_api_version_number,
1063: l_api_name,
1064: G_PKG_NAME)
1065: THEN
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068:
1069: -- Initialize message list if p_init_msg_list is set to TRUE.
1070: IF FND_API.to_Boolean( p_init_msg_list )

Line 1070: IF FND_API.to_Boolean( p_init_msg_list )

1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068:
1069: -- Initialize message list if p_init_msg_list is set to TRUE.
1070: IF FND_API.to_Boolean( p_init_msg_list )
1071: THEN
1072: FND_MSG_PUB.initialize;
1073: END IF;
1074: -- Call the Validate Item procedure for the item(field level validations )

Line 1078: x_return_status := FND_API.g_ret_sts_success;

1074: -- Call the Validate Item procedure for the item(field level validations )
1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1076: OZF_UTILITY_PVT.debug_message('in '||l_api_name );
1077: END IF;
1078: x_return_status := FND_API.g_ret_sts_success;
1079:
1080: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1081:
1082: FOR i in 1 .. p_process_setup_tbl.count

Line 1101: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1097: p_validation_mode => p_validation_mode,
1098: x_return_status => x_return_status);
1099:
1100:
1101: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: x_return_status => x_return_status);
1099:
1100:
1101: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END LOOP;

Line 1103: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1099:
1100:
1101: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END LOOP;
1107:

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100:
1101: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END LOOP;
1107:
1108: END IF;

Line 1110: x_return_status := FND_API.G_RET_STS_SUCCESS;

1106: END LOOP;
1107:
1108: END IF;
1109: -- Initialize API return status to SUCCESS
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111: -- Standard call to get message count and if count is 1, get message info.
1112: FND_MSG_PUB.Count_And_Get
1113: (p_count => x_msg_count,
1114: p_data => x_msg_data

Line 1118: x_return_status := FND_API.g_ret_sts_error;

1114: p_data => x_msg_data
1115: );
1116: EXCEPTION
1117: WHEN OZF_Utility_PVT.resource_locked THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1120: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1121: FND_MSG_PUB.add;
1122: END IF;

Line 1123: WHEN FND_API.G_EXC_ERROR THEN

1119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1120: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1121: FND_MSG_PUB.add;
1122: END IF;
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: ROLLBACK TO validate_process_setup_pvt;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR;

1121: FND_MSG_PUB.add;
1122: END IF;
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: ROLLBACK TO validate_process_setup_pvt;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,

Line 1128: p_encoded => FND_API.G_FALSE,

1124: ROLLBACK TO validate_process_setup_pvt;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data
1131: );
1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data
1131: );
1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1133: ROLLBACK TO validate_process_setup_pvt;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: -- Standard call to get message count and if count=1, get the message
1136: FND_MSG_PUB.Count_And_Get (

Line 1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1130: p_data => x_msg_data
1131: );
1132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1133: ROLLBACK TO validate_process_setup_pvt;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: -- Standard call to get message count and if count=1, get the message
1136: FND_MSG_PUB.Count_And_Get (
1137: p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,

Line 1137: p_encoded => FND_API.G_FALSE,

1133: ROLLBACK TO validate_process_setup_pvt;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: -- Standard call to get message count and if count=1, get the message
1136: FND_MSG_PUB.Count_And_Get (
1137: p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141: WHEN OTHERS THEN

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: p_data => x_msg_data
1140: );
1141: WHEN OTHERS THEN
1142: ROLLBACK TO validate_process_setup_pvt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;

Line 1150: p_encoded => FND_API.G_FALSE,

1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1154: