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

Line 119: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

115:
116: zpb_log.WRITE_STATEMENT(l_api_name ,'Return Status=' || l_return_status);
117: zpb_log.WRITE(l_api_name ,'Execution end');
118:
119: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
120: raise FND_API.G_EXC_ERROR;
121: END IF;
122:
123:

Line 120: raise FND_API.G_EXC_ERROR;

116: zpb_log.WRITE_STATEMENT(l_api_name ,'Return Status=' || l_return_status);
117: zpb_log.WRITE(l_api_name ,'Execution end');
118:
119: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
120: raise FND_API.G_EXC_ERROR;
121: END IF;
122:
123:
124: IF l_expired_user_exists

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132: RETURN;
133:
134: EXCEPTION
135:
136: WHEN FND_API.G_EXC_ERROR THEN
137: retcode := '2' ;
138: errbuf:=substr(sqlerrm, 1, 255);
139:
140: WHEN OTHERS THEN

Line 232: -- p_init_msg_list => FND_API.G_FALSE,

228: --Do distribution
229: zpb_log.WRITE_STATEMENT(l_api_name ,'User AW available');
230: --Initialise User AW and attach read write
231: --ZPB_AW.INITIALIZE_USER(p_api_version => 1.0,
232: -- p_init_msg_list => FND_API.G_FALSE,
233: -- p_validation_level => p_validation_level,
234: -- x_return_status => x_return_status,
235: -- x_msg_count => x_msg_count,
236: -- x_msg_data => x_msg_data,

Line 239: -- p_attach_readwrite => FND_API.G_TRUE,

235: -- x_msg_count => x_msg_count,
236: -- x_msg_data => x_msg_data,
237: -- p_user => p_user_id,
238: -- p_business_area_id => l_business_area_id,
239: -- p_attach_readwrite => FND_API.G_TRUE,
240: -- p_sync_shared => FND_API.G_TRUE);
241:
242:
243: --Initialize context

Line 240: -- p_sync_shared => FND_API.G_TRUE);

236: -- x_msg_data => x_msg_data,
237: -- p_user => p_user_id,
238: -- p_business_area_id => l_business_area_id,
239: -- p_attach_readwrite => FND_API.G_TRUE,
240: -- p_sync_shared => FND_API.G_TRUE);
241:
242:
243: --Initialize context
244: ZPB_SECURITY_CONTEXT.INITCONTEXT(p_user_id => p_user_id,

Line 251: p_init_msg_list => FND_API.G_FALSE,

247: p_session_id => 1 ,
248: p_business_area_id => p_business_area_id);
249: --Start up user's AW
250: ZPB_PERSONAL_AW.STARTUP(p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_TRUE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,

Line 252: p_commit => FND_API.G_TRUE,

248: p_business_area_id => p_business_area_id);
249: --Start up user's AW
250: ZPB_PERSONAL_AW.STARTUP(p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_TRUE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,
256: x_msg_data => l_msg_data,

Line 253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

249: --Start up user's AW
250: ZPB_PERSONAL_AW.STARTUP(p_api_version => 1.0,
251: p_init_msg_list => FND_API.G_FALSE,
252: p_commit => FND_API.G_TRUE,
253: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,
256: x_msg_data => l_msg_data,
257: p_user => p_user_id,

Line 258: p_read_only => FND_API.G_FALSE);

254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,
256: x_msg_data => l_msg_data,
257: p_user => p_user_id,
258: p_read_only => FND_API.G_FALSE);
259:
260: zpb_log.WRITE_STATEMENT(l_api_name ,'Start up return status =' || l_return_status);
261: zpb_log.WRITE_STATEMENT(l_api_name ,'Executed Startup');
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

258: p_read_only => FND_API.G_FALSE);
259:
260: zpb_log.WRITE_STATEMENT(l_api_name ,'Start up return status =' || l_return_status);
261: zpb_log.WRITE_STATEMENT(l_api_name ,'Executed Startup');
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: raise FND_API.G_EXC_ERROR;
264: END IF;
265:
266: --Update the ZPB_USERS table with the conc req id

Line 263: raise FND_API.G_EXC_ERROR;

259:
260: zpb_log.WRITE_STATEMENT(l_api_name ,'Start up return status =' || l_return_status);
261: zpb_log.WRITE_STATEMENT(l_api_name ,'Executed Startup');
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: raise FND_API.G_EXC_ERROR;
264: END IF;
265:
266: --Update the ZPB_USERS table with the conc req id
267: UPDATE zpb_users

Line 389: p_init_msg_list => FND_API.G_FALSE,

385: --DO the AW clean up
386: --
387: ZPB_AW.clean_workspace (
388: p_api_version => 1.0,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => l_return_status,
392: x_msg_count => l_msg_count,
393: x_msg_data => l_msg_data);

Line 390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

386: --
387: ZPB_AW.clean_workspace (
388: p_api_version => 1.0,
389: p_init_msg_list => FND_API.G_FALSE,
390: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
391: x_return_status => l_return_status,
392: x_msg_count => l_msg_count,
393: x_msg_data => l_msg_data);
394:

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: RETURN;
414:
415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418: retcode := '2' ;
419: errbuf:=substr(sqlerrm, 1, 255);
420:
421: WHEN OTHERS THEN