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 ZPB_LOG

Line 56: zpb_log.WRITE(l_api_name ,'Starting execution ');

52:
53:
54: BEGIN
55:
56: zpb_log.WRITE(l_api_name ,'Starting execution ');
57:
58: l_expired_user_exists := FALSE;
59:
60: FOR l_dist_pending_row_rec IN dist_pending_csr

Line 79: zpb_log.WRITE_STATEMENT(l_api_name ,'Submit Conc Request for user=' || l_user_id ||' Buss Area= ' || l_business_area_id );

75:
76: IF (l_SID is NULL OR l_SID = 0) THEN
77: --We know that user's AW is now available for distribution
78: --Submit a concurrent request
79: zpb_log.WRITE_STATEMENT(l_api_name ,'Submit Conc Request for user=' || l_user_id ||' Buss Area= ' || l_business_area_id );
80: --
81: BEGIN
82: SELECT fugp.responsibility_id
83: INTO l_resp_id

Line 99: zpb_log.WRITE_STATEMENT(l_api_name ,'Conc Request id for user =' || l_req_id);

95: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB',
96: 'ZPB_DC_DATA_DISTRIB_REQ', NULL, NULL, FALSE,
97: l_user_id,l_business_area_id);
98:
99: zpb_log.WRITE_STATEMENT(l_api_name ,'Conc Request id for user =' || l_req_id);
100: COMMIT;
101:
102: EXCEPTION
103: WHEN NO_DATA_FOUND

Line 106: zpb_log.WRITE_TO_CONCMGR_LOG_TR('ZPB_DC_EXPIRED_USER',

102: EXCEPTION
103: WHEN NO_DATA_FOUND
104: THEN
105: l_expired_user_exists := TRUE;
106: zpb_log.WRITE_TO_CONCMGR_LOG_TR('ZPB_DC_EXPIRED_USER',
107: 'USER_NAME',
108: ZPB_WF_NTF.ID_to_FNDUser(l_user_id));
109: END;
110:

Line 116: zpb_log.WRITE_STATEMENT(l_api_name ,'Return Status=' || l_return_status);

112:
113:
114: END LOOP;
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;

Line 117: zpb_log.WRITE(l_api_name ,'Execution end');

113:
114: END LOOP;
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;

Line 211: zpb_log.WRITE(l_api_name ,'Starting execution ');

207: AND business_area_id = p_business_area_id;
208:
209:
210: BEGIN
211: zpb_log.WRITE(l_api_name ,'Starting execution ');
212: zpb_log.WRITE_STATEMENT(l_api_name ,'Processing for user=' || p_user_id ||' Buss Area= ' || p_business_area_id );
213:
214: --Check if any other user has attached the user's AW r/w
215: zpb_personal_aw.personal_aw_rw_scan(p_user => TO_CHAR(p_user_id),

Line 212: zpb_log.WRITE_STATEMENT(l_api_name ,'Processing for user=' || p_user_id ||' Buss Area= ' || p_business_area_id );

208:
209:
210: BEGIN
211: zpb_log.WRITE(l_api_name ,'Starting execution ');
212: zpb_log.WRITE_STATEMENT(l_api_name ,'Processing for user=' || p_user_id ||' Buss Area= ' || p_business_area_id );
213:
214: --Check if any other user has attached the user's AW r/w
215: zpb_personal_aw.personal_aw_rw_scan(p_user => TO_CHAR(p_user_id),
216: p_business_area => p_business_area_id,

Line 229: zpb_log.WRITE_STATEMENT(l_api_name ,'User AW available');

225:
226: IF (l_SID is NULL OR l_SID = 0) THEN
227: --We know that user's AW is now available for distribution
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,

Line 260: zpb_log.WRITE_STATEMENT(l_api_name ,'Start up return status =' || l_return_status);

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
263: raise FND_API.G_EXC_ERROR;
264: END IF;

Line 261: zpb_log.WRITE_STATEMENT(l_api_name ,'Executed Startup');

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
263: raise FND_API.G_EXC_ERROR;
264: END IF;
265:

Line 281: zpb_log.WRITE_STATEMENT(l_api_name ,'Users currency profile =' || l_currency_profile_option);

277: COMMIT;
278:
279: --Get the currency profile option for the user
280: l_currency_profile_option := FND_PROFILE.VALUE_SPECIFIC('ZPB_DEF_CURR_VIEW',p_user_id);
281: zpb_log.WRITE_STATEMENT(l_api_name ,'Users currency profile =' || l_currency_profile_option);
282:
283: --For each row that has distribution pending for this user do a distribute
284:
285: FOR l_dist_pending_row_rec IN dist_pending_csr

Line 338: zpb_log.WRITE_STATEMENT(l_api_name ,'Create Structure Command =' || l_command);

334: ',' || '''' || l_copy_target_data_flag || '''' ||
335: ',' || '''' || 'S' || '''' ||
336: ',' || '''' || l_currency_view || '''' ||
337: ')';
338: zpb_log.WRITE_STATEMENT(l_api_name ,'Create Structure Command =' || l_command);
339: zpb_aw.EXECUTE(l_command);
340: zpb_log.WRITE_STATEMENT(l_api_name ,'Structure Created');
341: END IF;
342:

Line 340: zpb_log.WRITE_STATEMENT(l_api_name ,'Structure Created');

336: ',' || '''' || l_currency_view || '''' ||
337: ')';
338: zpb_log.WRITE_STATEMENT(l_api_name ,'Create Structure Command =' || l_command);
339: zpb_aw.EXECUTE(l_command);
340: zpb_log.WRITE_STATEMENT(l_api_name ,'Structure Created');
341: END IF;
342:
343: --Do data distribution
344: l_command := 'call dc.distribute(' || '''' || l_template_id || '''' ||

Line 352: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Data Command =' || l_command);

348: ',' || '''' || l_copy_target_data_flag || '''' ||
349: ',' || '''' || 'D' || '''' ||
350: ',' || '''' || l_currency_view || '''' ||
351: ')';
352: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Data Command =' || l_command);
353: zpb_aw.EXECUTE(l_command);
354: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Distributed');
355:
356: l_command := 'call sv.exe.dcsolve('''||l_template_id||''' '''||

Line 354: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Distributed');

350: ',' || '''' || l_currency_view || '''' ||
351: ')';
352: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Data Command =' || l_command);
353: zpb_aw.EXECUTE(l_command);
354: zpb_log.WRITE_STATEMENT(l_api_name ,'Distribute Distributed');
355:
356: l_command := 'call sv.exe.dcsolve('''||l_template_id||''' '''||
357: l_dist_pending_row_rec.ac_instance_id||''' '''||
358: l_dist_pending_row_rec.generate_template_task_id||''')';

Line 360: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalc Command =' || l_command);

356: l_command := 'call sv.exe.dcsolve('''||l_template_id||''' '''||
357: l_dist_pending_row_rec.ac_instance_id||''' '''||
358: l_dist_pending_row_rec.generate_template_task_id||''')';
359:
360: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalc Command =' || l_command);
361: zpb_aw.EXECUTE(l_command);
362: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalculated');
363:
364: --Commit data to AW

Line 362: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalculated');

358: l_dist_pending_row_rec.generate_template_task_id||''')';
359:
360: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalc Command =' || l_command);
361: zpb_aw.EXECUTE(l_command);
362: zpb_log.WRITE_STATEMENT(l_api_name ,'Recalculated');
363:
364: --Commit data to AW
365: l_command := 'call pa.commit()';
366: zpb_aw.EXECUTE(l_command);

Line 367: zpb_log.WRITE_STATEMENT(l_api_name ,'Data Committed');

363:
364: --Commit data to AW
365: l_command := 'call pa.commit()';
366: zpb_aw.EXECUTE(l_command);
367: zpb_log.WRITE_STATEMENT(l_api_name ,'Data Committed');
368:
369: --Update ZPB_DC_OBJECTS with the currency
370: IF (l_currency_flag = 'Y') THEN
371: UPDATE zpb_dc_objects

Line 410: zpb_log.WRITE(l_api_name ,'Execution end');

406: WHERE user_id = p_user_id
407: AND business_area_id = p_business_area_id;
408:
409: END IF;
410: zpb_log.WRITE(l_api_name ,'Execution end');
411: retcode := '0';
412: COMMIT;
413: RETURN;
414: