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_MSG_PUB

Line 56: FND_MSG_PUB.initialize;

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:
59:
60: -- ******************************************************************

Line 65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

61: -- Validate Environment
62: -- ******************************************************************
63: IF FND_GLOBAL.User_Id IS NULL
64: THEN
65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
66: THEN
67: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
68: FND_MSG_PUB.ADD;
69: END IF;

Line 68: FND_MSG_PUB.ADD;

64: THEN
65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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:

Line 74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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
75: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
76: END IF;
77:
78: -- Initialize API return status to SUCCESS

Line 81: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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;
84:
85: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) 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
106: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
107: END IF;
108:
109: l_process_setup_id := NULL;

Line 114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

110: l_object_version_number := 1;
111:
112: x_process_setup_id_tbl := JTF_NUMBER_TABLE();
113:
114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
115: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_process_setup_tbl.count);
116: END IF;
117:
118:

Line 133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

129: l_org_id := l_process_setup_rec.org_id;
130: END IF;
131: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;
132:
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
134: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
135: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);
136: END IF;
137:

Line 176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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);
179: END IF;
180:

Line 201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

197: AND nvl(fl.end_date_active,sysdate) >= sysdate
198: AND fl.enabled_flag= 'Y'
199: AND fl.tag IS NOT NULL;
200:
201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
202: OZF_UTILITY_PVT.debug_message('code table count'||process_code_tbl.count);
203: end if;
204: l_process_setup_rec := p_process_setup_tbl(1);
205: IF (l_process_setup_rec.org_id IS NULL) THEN

Line 216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

212: LOOP
213: flag := true;
214: FOR j IN p_process_setup_tbl.first..p_process_setup_tbl.last
215: LOOP
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
217: OZF_UTILITY_PVT.debug_message('i is '||i);
218: OZF_UTILITY_PVT.debug_message('J'||j);
219: OZF_UTILITY_PVT.debug_message(' for p_process_setup_tbl(j).process_code'||p_process_setup_tbl(j).process_code||'--process_code_tbl(i)'||process_code_tbl(i));
220: end if;

Line 231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

227: exit;
228: end if;
229: END LOOP;
230:
231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
232: OZF_UTILITY_PVT.debug_message('for p_process_setup_tbl(j).process_code'||'--'||process_code_tbl(i));
233: end if;
234: IF (flag = true) THEN
235:

Line 238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

234: IF (flag = true) THEN
235:
236: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;
237:
238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
239: OZF_UTILITY_PVT.debug_message('l_process_setup_id and i '||i||l_process_setup_id);
240: OZF_UTILITY_PVT.debug_message('org_id and i '||i||l_org_id);
241: OZF_UTILITY_PVT.debug_message('l_object_version_number and i '||i||l_object_version_number);
242: OZF_UTILITY_PVT.debug_message('l_process_setup_rec.supp_trade_profile_id and i '||i||l_process_setup_rec.supp_trade_profile_id);

Line 298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

294: COMMIT WORK;
295: END IF;
296:
297: -- Debug Message
298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
299: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
300: END IF;
301:
302: -- Standard call to get message count and if count is 1, get message info.

Line 303: FND_MSG_PUB.Count_And_Get

299: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
300: END IF;
301:
302: -- Standard call to get message count and if count is 1, get message info.
303: FND_MSG_PUB.Count_And_Get
304: (p_count => x_msg_count,
305: p_data => x_msg_data
306: );
307:

Line 313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
317: WHEN FND_API.G_EXC_ERROR THEN

Line 315: FND_MSG_PUB.add;

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;
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;

Line 321: FND_MSG_PUB.Count_And_Get (

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,
324: p_data => x_msg_data
325: );

Line 330: FND_MSG_PUB.Count_And_Get (

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,
333: p_data => x_msg_data
334: );

Line 338: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
342: -- Standard call to get message count and if count=1, get the message

Line 340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 343: FND_MSG_PUB.Count_And_Get (

339: THEN
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: );

Line 431: FND_MSG_PUB.initialize;

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:
434: -- ******************************************************************
435: -- Validate Environment

Line 439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

435: -- Validate Environment
436: -- ******************************************************************
437: IF FND_GLOBAL.User_Id IS NULL
438: THEN
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
440: THEN
441: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
442: FND_MSG_PUB.ADD;
443: END IF;

Line 442: FND_MSG_PUB.ADD;

438: THEN
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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:

Line 448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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
449: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
450: END IF;
451:
452: -- Initialize API return status to SUCCESS

Line 462: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

458: LOOP
459: p_process_setup_rec := p_process_setup_tbl(i);
460: l_process_setup_id := p_process_setup_rec.process_setup_id;
461:
462: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
463: OZF_UTILITY_PVT.debug_message( 'In Update :Process Setup ID' || l_process_setup_id);
464: END IF;
465:
466: -- Check for the existance of the record

Line 501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

497: ,l_process_setup_rec.security_group_id;
498:
499:
500: IF ( csr_process_setup%NOTFOUND) THEN
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
502: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
503: END IF;
504:
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
502: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');
503: END IF;
504:
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;

Line 507: FND_MSG_PUB.add;

503: END IF;
504:
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;

Line 514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

510: END IF;
511: CLOSE csr_process_setup;
512:
513:
514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
515: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_process_setup_rec.object_version_number);
516: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_process_setup_rec.object_version_number);
517: END IF;
518:

Line 522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

518:
519: --- Check the Version Number for Locking
520: IF l_process_setup_rec.object_version_number <> P_process_setup_rec.Object_Version_number
521: THEN
522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
523: OZF_UTILITY_PVT.debug_message( 'dbver' || l_process_setup_rec.object_version_number);
524: OZF_UTILITY_PVT.debug_message( 'reqver' || P_process_setup_rec.object_version_number);
525: END IF;
526:

Line 527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

523: OZF_UTILITY_PVT.debug_message( 'dbver' || l_process_setup_rec.object_version_number);
524: OZF_UTILITY_PVT.debug_message( 'reqver' || P_process_setup_rec.object_version_number);
525: END IF;
526:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
530: FND_MSG_PUB.ADD;
531: END IF;

Line 530: FND_MSG_PUB.ADD;

526:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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:

Line 538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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;
541: -- Invoke validation procedures
542: Validate_process_setup(

Line 566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

562:
563:
564: -- Call Update Table Handler
565: -- Debug Message
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
567: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');
568: END IF;
569: BEGIN
570: OZF_PROCESS_SETUP_PKG.Update_Row(

Line 619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

615: END IF;
616:
617:
618: -- Debug Message
619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
621: END IF;
622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get

Line 623: FND_MSG_PUB.Count_And_Get

619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
621: END IF;
622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count,
625: p_data => x_msg_data
626: );
627: EXCEPTION

Line 632: FND_MSG_PUB.Count_And_Get (

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,
635: p_data => x_msg_data
636: );

Line 641: FND_MSG_PUB.Count_And_Get (

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,
644: p_data => x_msg_data
645: );

Line 649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
653: -- Standard call to get message count and if count=1, get the message

Line 651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 654: FND_MSG_PUB.Count_And_Get (

650: THEN
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: );

Line 696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

692: BEGIN
693: -- Standard Start of API savepoint
694: SAVEPOINT update_process_setup_tbl_pvt;
695:
696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
697: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');
698: END IF;
699:
700: -- Standard call to check for call compatibility.

Line 712: FND_MSG_PUB.initialize;

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:
715: -- ******************************************************************
716: -- Validate Environment

Line 720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

716: -- Validate Environment
717: -- ******************************************************************
718: IF FND_GLOBAL.User_Id IS NULL
719: THEN
720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
723: FND_MSG_PUB.ADD;
724: END IF;

Line 723: FND_MSG_PUB.ADD;

719: THEN
720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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:

Line 729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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
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

Line 741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

737: v_object_version_number := JTF_NUMBER_TABLE();
738:
739: FOR i IN P_process_setup_Tbl.first .. P_process_setup_Tbl.last
740: LOOP
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
742: OZF_UTILITY_PVT.debug_message('i' ||i);
743: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);
744: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).org_id'||P_process_setup_Tbl(i).org_id);
745: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).enabled_flag'||P_process_setup_Tbl(i).enabled_flag);

Line 773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

769:
770:
771:
772: END LOOP;
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
774: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);
775: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);
776: END IF;
777:

Line 824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

820: COMMIT WORK;
821: END IF;
822:
823: -- Debug Message
824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
825: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
826: END IF;
827: -- Standard call to get message count and if count is 1, get message info.
828: FND_MSG_PUB.Count_And_Get

Line 828: FND_MSG_PUB.Count_And_Get

824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
825: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
826: END IF;
827: -- Standard call to get message count and if count is 1, get message info.
828: FND_MSG_PUB.Count_And_Get
829: (p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: EXCEPTION

Line 837: FND_MSG_PUB.Count_And_Get (

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,
840: p_data => x_msg_data
841: );

Line 846: FND_MSG_PUB.Count_And_Get (

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,
849: p_data => x_msg_data
850: );

Line 854: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
858: -- Standard call to get message count and if count=1, get the message

Line 856: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 859: FND_MSG_PUB.Count_And_Get (

855: THEN
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: );

Line 907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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;
911: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

913: p_process_setup_rec.supp_trade_profile_id IS NULL
914: THEN
915: l_psi_dummy := 0;
916:
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
918: OZF_UTILITY_PVT.debug_message('Enabled flag ' ||p_process_setup_rec.enabled_flag );
919: OZF_UTILITY_PVT.debug_message('Org ID ' || p_process_setup_rec.org_id );
920: END IF;
921:

Line 928: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

924: INTO l_psi_dummy;
925: CLOSE csr_pro_setup_4org;
926:
927:
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;

Line 946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

942:
943:
944:
945: IF l_psi_dummy > 0 THEN
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;

Line 948: FND_MSG_PUB.add;

944:
945: IF l_psi_dummy > 0 THEN
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;

Line 954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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);
956: END IF;
957: END IF;
958: ELSE -- for update mode

Line 963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

Line 965: FND_MSG_PUB.add;

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;
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;

Line 998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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;
1001:
1002: IF p_process_setup_rec.org_id = FND_API.g_miss_num OR

Line 1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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');
1007: FND_MSG_PUB.add;
1008: END IF;
1009: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1007: FND_MSG_PUB.add;

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');
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

Line 1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

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
1024: OZF_UTILITY_PVT.debug_message('after check_uniq_process_setup ' );
1025: END IF;
1026:
1027:

Line 1072: FND_MSG_PUB.initialize;

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 )
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 );

Line 1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1071: THEN
1072: FND_MSG_PUB.initialize;
1073: END IF;
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:

Line 1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1080: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1081:
1082: FOR i in 1 .. p_process_setup_tbl.count
1083: LOOP
1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1085: OZF_UTILITY_PVT.debug_message('inside the loop p_process_setup_tbl ' );
1086: END IF;
1087: l_process_setup_rec := p_process_setup_tbl(i);
1088:

Line 1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

1085: OZF_UTILITY_PVT.debug_message('inside the loop p_process_setup_tbl ' );
1086: END IF;
1087: l_process_setup_rec := p_process_setup_tbl(i);
1088:
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
1090: OZF_UTILITY_PVT.debug_message('Enabled flag ' || l_process_setup_rec.enabled_flag );
1091: OZF_UTILITY_PVT.debug_message('automatic flag '|| l_process_setup_rec.automatic_flag );
1092: OZF_UTILITY_PVT.debug_message('Process code' || l_process_setup_rec.process_code );
1093: END IF;

Line 1112: FND_MSG_PUB.Count_And_Get

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
1115: );
1116: EXCEPTION

Line 1119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1123: WHEN FND_API.G_EXC_ERROR THEN

Line 1121: FND_MSG_PUB.add;

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;
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;

Line 1127: FND_MSG_PUB.Count_And_Get (

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,
1130: p_data => x_msg_data
1131: );

Line 1136: FND_MSG_PUB.Count_And_Get (

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,
1139: p_data => x_msg_data
1140: );

Line 1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
1148: -- Standard call to get message count and if count=1, get the message

Line 1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 1149: FND_MSG_PUB.Count_And_Get (

1145: THEN
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: );