DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on FND_PROFILE

Line 927: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');

923: l_first_serial_txn_id NUMBER;
924:
925: BEGIN
926:
927: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
928:
929: IF (g_debug = 'Y') THEN
930: fnd_file.put_line(fnd_file.log, 'Parameters to Create_JobCopies are :');
931: fnd_file.put_line(fnd_file.log, ' p_wip_entity_id ='||p_wip_entity_id );

Line 3881: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');

3877: e_proc_error EXCEPTION;
3878:
3879: BEGIN
3880:
3881: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
3882:
3883: IF (g_debug = 'Y') THEN
3884: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
3885: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );

Line 4901: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN

4897: -- to inside create_jobcopies.
4898:
4899: l_stmt_num := 40;
4900:
4901: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
4902: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4903: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
4904: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
4905: raise e_upg_error;

Line 4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN

4902: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4903: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
4904: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
4905: raise e_upg_error;
4906: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
4907: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
4908: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
4909: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
4910: ELSE

Line 5199: l_ret_val := fnd_profile.save('WSM_CREATE_LBJ_COPY_ROUTING', '1', 'SITE');

5195: 'Please correct the problem and run Refresh Open Jobs Copies for the above '||l_err_ctr||' jobs. ');
5196:
5197: l_stmt_num := 150;
5198:
5199: l_ret_val := fnd_profile.save('WSM_CREATE_LBJ_COPY_ROUTING', '1', 'SITE');
5200:
5201: fnd_file.put_line(fnd_file.log, 'Set the profile "WSM: Create Lot Based Jobs Copy Routing" to YES. '||
5202: 'Upgrade successful. ');
5203: