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 OZF_UTILITY_PVT

Line 75: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 82: OZF_UTILITY_PVT.debug_message( 'No of records to be created'||p_process_setup_tbl.count);

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
86: -- Debug message

Line 87: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

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(
90: p_api_version_number => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,

Line 106: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

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;
110: l_object_version_number := 1;

Line 115: OZF_UTILITY_PVT.debug_message( 'No of rows to be created '|| p_process_setup_tbl.count);

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

Line 134: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_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:
138: BEGIN

Line 135: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);

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:
138: BEGIN
139:

Line 173: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating process setup');

169: p_attribute15 => l_process_setup_rec.attribute15);
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);

Line 177: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - code conversion id' || l_process_setup_id);

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:
181: x_process_setup_id_tbl.extend;

Line 178: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' after insert call - obj version no ' || l_process_setup_rec.Object_Version_Number);

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:
181: x_process_setup_id_tbl.extend;
182: x_process_setup_id_tbl(x_process_setup_id_tbl.count) := l_process_setup_id;

Line 202: OZF_UTILITY_PVT.debug_message('code table count'||process_code_tbl.count);

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
206: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements

Line 217: OZF_UTILITY_PVT.debug_message('i is '||i);

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;
221: if (p_process_setup_tbl(j).process_code = process_code_tbl(i))

Line 218: OZF_UTILITY_PVT.debug_message('J'||j);

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;
221: if (p_process_setup_tbl(j).process_code = process_code_tbl(i))
222: then

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

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;
221: if (p_process_setup_tbl(j).process_code = process_code_tbl(i))
222: then
223: flag := false;

Line 232: OZF_UTILITY_PVT.debug_message('for p_process_setup_tbl(j).process_code'||'--'||process_code_tbl(i));

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:
236: SELECT ozf_process_setup_all_s.nextval INTO l_process_setup_id FROM DUAL;

Line 239: OZF_UTILITY_PVT.debug_message('l_process_setup_id and i '||i||l_process_setup_id);

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));

Line 240: OZF_UTILITY_PVT.debug_message('org_id and i '||i||l_org_id);

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:

Line 241: OZF_UTILITY_PVT.debug_message('l_object_version_number and i '||i||l_object_version_number);

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:
245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);

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

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:
245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
246: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);

Line 243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:
245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
246: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);
247:

Line 245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || 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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:
245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
246: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);
247:
248: END IF;
249:

Line 246: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);

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);
243: OZF_UTILITY_PVT.debug_message('process_code_tbl(i) and i '||i||process_code_tbl(i));
244:
245: OZF_UTILITY_PVT.debug_message( 'l_org_id ' || l_org_id);
246: OZF_UTILITY_PVT.debug_message( 'Process Setup ID '|| l_process_setup_id);
247:
248: END IF;
249:
250: BEGIN

Line 283: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in creating process setup');

279: p_attribute15 => NULL);
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');

Line 287: OZF_UTILITY_PVT.debug_message('flag was false');

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 ;
289: END LOOP;
290: -- RAISE FND_API.G_EXC_ERROR;
291: -- Standard check for p_commit

Line 299: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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.
303: FND_MSG_PUB.Count_And_Get

Line 311: WHEN OZF_UTILITY_PVT.resource_locked THEN

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

Line 449: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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
453: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 463: OZF_UTILITY_PVT.debug_message( 'In Update :Process Setup ID' || l_process_setup_id);

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
467: OPEN csr_process_setup(l_process_setup_id);

Line 502: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'nodata for upd');

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
506: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

Line 515: OZF_UTILITY_PVT.debug_message( 'Pre Object Version Number ' || l_process_setup_rec.object_version_number);

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:
519: --- Check the Version Number for Locking

Line 516: OZF_UTILITY_PVT.debug_message( 'Post Object Version Number' || P_process_setup_rec.object_version_number);

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:
519: --- Check the Version Number for Locking
520: IF l_process_setup_rec.object_version_number <> P_process_setup_rec.Object_Version_number

Line 523: OZF_UTILITY_PVT.debug_message( 'dbver' || l_process_setup_rec.object_version_number);

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:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 524: OZF_UTILITY_PVT.debug_message( 'reqver' || P_process_setup_rec.object_version_number);

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:
527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN

Line 539: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name);

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(
543: p_api_version_number => 1.0,

Line 567: OZF_UTILITY_PVT.debug_message( 'Private API: Calling Update table handler');

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(
571: p_process_setup_id => l_process_setup_id,

Line 602: OZF_UTILITY_PVT.debug_message (SQLERRM ||' Error in updating OZF_PROCESS_SETUP table');

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

Line 620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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
624: (p_count => x_msg_count,

Line 697: OZF_UTILITY_PVT.debug_message('Entered the proc tbl');

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.
701: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 730: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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
734: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 731: OZF_UTILITY_PVT.debug_message('Total Number of records '||P_process_setup_Tbl.count);

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
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735:

Line 742: OZF_UTILITY_PVT.debug_message('i' ||i);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);

Line 743: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);

Line 744: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).org_id'||P_process_setup_Tbl(i).org_id);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);

Line 745: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).enabled_flag'||P_process_setup_Tbl(i).enabled_flag);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);
749: end if;

Line 746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);
749: end if;
750: -- OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);

Line 747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);
749: end if;
750: -- OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);
751: l_process_setup_id := P_process_setup_Tbl(i).process_setup_id;

Line 748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);

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);
746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);
749: end if;
750: -- OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);
751: l_process_setup_id := P_process_setup_Tbl(i).process_setup_id;
752: P_process_setup_Rec := P_process_setup_Tbl(i);

Line 750: -- OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);

746: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).automatic_flag'||P_process_setup_Tbl(i).automatic_flag);
747: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).supp_trade_profile_id'||P_process_setup_Tbl(i).supp_trade_profile_id);
748: OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_code'||P_process_setup_Tbl(i).process_code);
749: end if;
750: -- OZF_UTILITY_PVT.debug_message('P_process_setup_Tbl(i).process_setup_id'||P_process_setup_Tbl(i).process_setup_id);
751: l_process_setup_id := P_process_setup_Tbl(i).process_setup_id;
752: P_process_setup_Rec := P_process_setup_Tbl(i);
753:
754:

Line 774: OZF_UTILITY_PVT.debug_message('No of rows to be created: ' || l_cc_cnt);

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:
778: IF l_cc_cnt > 0 THEN

Line 775: OZF_UTILITY_PVT.debug_message('No of rows to be updated: ' || l_up_cnt);

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:
778: IF l_cc_cnt > 0 THEN
779: --- Call to Create Procedure

Line 825: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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
829: (p_count => x_msg_count,

Line 908: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

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
912: IF p_process_setup_rec.supp_trade_profile_id = FND_API.g_miss_num OR

Line 918: OZF_UTILITY_PVT.debug_message('Enabled flag ' ||p_process_setup_rec.enabled_flag );

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:
922: OPEN csr_pro_setup_4org(p_process_setup_rec.process_code,p_process_setup_rec.org_id);

Line 919: OZF_UTILITY_PVT.debug_message('Org ID ' || p_process_setup_rec.org_id );

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:
922: OPEN csr_pro_setup_4org(p_process_setup_rec.process_code,p_process_setup_rec.org_id);
923: FETCH csr_pro_setup_4org

Line 929: OZF_UTILITY_PVT.debug_message('Duplicate Process setup id' || p_process_setup_rec.process_setup_id );

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

Line 955: OZF_UTILITY_PVT.debug_message('Count of code map for psi ' || l_psi_dummy);

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
959: l_valid_flag := FND_API.g_true;

Line 978: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

974: -- Start of Comments
975: --
976: -- Required Items Check procedure
977: --
978: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
979: -- For create: G_CREATE, for update: G_UPDATE
980: -- End of Comments
981:
982:

Line 999: OZF_UTILITY_PVT.debug_message('in '||l_api_name);

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
1003: p_process_setup_rec.org_id IS NULL

Line 1024: OZF_UTILITY_PVT.debug_message('after check_uniq_process_setup ' );

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:
1028: END check_process_setup_items;

Line 1033: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package

1029: -- Start of Comments
1030: --
1031: -- validation procedures
1032: --
1033: -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
1034: -- For create: G_CREATE, for update: G_UPDATE
1035: -- End of Comments
1036:
1037: PROCEDURE Validate_Process_Setup(

Line 1076: OZF_UTILITY_PVT.debug_message('in '||l_api_name );

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:
1080: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1085: OZF_UTILITY_PVT.debug_message('inside the loop p_process_setup_tbl ' );

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:
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 1090: OZF_UTILITY_PVT.debug_message('Enabled flag ' || l_process_setup_rec.enabled_flag );

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

Line 1091: OZF_UTILITY_PVT.debug_message('automatic flag '|| l_process_setup_rec.automatic_flag );

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;
1094:
1095: check_process_setup_items(

Line 1092: OZF_UTILITY_PVT.debug_message('Process code' || l_process_setup_rec.process_code );

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;
1094:
1095: check_process_setup_items(
1096: p_process_setup_rec => l_process_setup_rec,

Line 1117: WHEN OZF_Utility_PVT.resource_locked THEN

1113: (p_count => x_msg_count,
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;