DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on FND_PROFILE

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

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

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

4108: e_proc_error EXCEPTION;
4109:
4110: BEGIN
4111:
4112: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
4113:
4114: IF (g_debug = 'Y') THEN
4115: fnd_file.put_line(fnd_file.log, 'Parameters to Create_RepJobCopies are :\\n');
4116: fnd_file.put_line(fnd_file.log, ' p_rep_wip_entity_id ='||p_rep_wip_entity_id );

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

5128: -- to inside create_jobcopies.
5129:
5130: l_stmt_num := 40;
5131:
5132: IF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 1) THEN
5133: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5134: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
5136: raise e_upg_error;

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

5133: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5134: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is YES.');
5135: fnd_file.put_line(fnd_file.log, 'Oracle Shopfloor Management is already upgraded to create Lot Based Job Copy Routing. Upgrade failed.');
5136: raise e_upg_error;
5137: ELSIF (to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING')) = 2) THEN
5138: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Upgrade_JobCopies('||l_stmt_num||
5139: '): Value of profile "WSM: Create Lot Based Jobs Copy Routing" is NO.');
5140: fnd_file.put_line(fnd_file.log, 'Upgrading Lot Based Jobs to Use Copy Routings ...');
5141: ELSE

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

5426: 'Please correct the problem and run Refresh Open Jobs Copies for the above '||l_err_ctr||' jobs. ');
5427:
5428: l_stmt_num := 150;
5429:
5430: l_ret_val := fnd_profile.save('WSM_CREATE_LBJ_COPY_ROUTING', '1', 'SITE');
5431:
5432: fnd_file.put_line(fnd_file.log, 'Set the profile "WSM: Create Lot Based Jobs Copy Routing" to YES. '||
5433: 'Upgrade successful. ');
5434: