DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on FND_MESSAGE

Line 622: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');

618: and upper(phase_code) = 'R'
619: and argument1 = to_char(p_organization_id);
620:
621: if (l_pgm_count > 1) then
622: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
623: fnd_message.set_token('ORG', to_char(l_org_code));
624: x_error_msg := fnd_message.get;
625: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
626: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');

Line 623: fnd_message.set_token('ORG', to_char(l_org_code));

619: and argument1 = to_char(p_organization_id);
620:
621: if (l_pgm_count > 1) then
622: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
623: fnd_message.set_token('ORG', to_char(l_org_code));
624: x_error_msg := fnd_message.get;
625: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
626: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');
627: retcode := 2;

Line 624: x_error_msg := fnd_message.get;

620:
621: if (l_pgm_count > 1) then
622: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
623: fnd_message.set_token('ORG', to_char(l_org_code));
624: x_error_msg := fnd_message.get;
625: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
626: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');
627: retcode := 2;
628: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

Line 892: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');

888: l_stmt_num :=120;
889: -- Modified for bug 6972129.
890: if l_time_uom_flag = 2 then
891: if (g_logLevel <= wip_constants.trace_logging) then
892: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
893: fnd_message.set_token('EMP', to_char(employee.person_id));
894: x_error_msg := fnd_message.get;
895: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
896: --l_error_count := l_error_count + 1;

Line 893: fnd_message.set_token('EMP', to_char(employee.person_id));

889: -- Modified for bug 6972129.
890: if l_time_uom_flag = 2 then
891: if (g_logLevel <= wip_constants.trace_logging) then
892: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
893: fnd_message.set_token('EMP', to_char(employee.person_id));
894: x_error_msg := fnd_message.get;
895: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
896: --l_error_count := l_error_count + 1;
897: end if;

Line 894: x_error_msg := fnd_message.get;

890: if l_time_uom_flag = 2 then
891: if (g_logLevel <= wip_constants.trace_logging) then
892: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
893: fnd_message.set_token('EMP', to_char(employee.person_id));
894: x_error_msg := fnd_message.get;
895: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
896: --l_error_count := l_error_count + 1;
897: end if;
898: is_aah_record_valid := false;

Line 966: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');

962: l_stmt_num :=180;
963: -- Modified for bug 6972129.
964: if l_time_uom_flag = 2 then
965: if (g_logLevel <= wip_constants.trace_logging) then
966: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
967: fnd_message.set_token('EMP', to_char(employee.person_id));
968: x_error_msg := fnd_message.get;
969: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
970: --l_error_count := l_error_count + 1;

Line 967: fnd_message.set_token('EMP', to_char(employee.person_id));

963: -- Modified for bug 6972129.
964: if l_time_uom_flag = 2 then
965: if (g_logLevel <= wip_constants.trace_logging) then
966: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
967: fnd_message.set_token('EMP', to_char(employee.person_id));
968: x_error_msg := fnd_message.get;
969: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
970: --l_error_count := l_error_count + 1;
971: end if;

Line 968: x_error_msg := fnd_message.get;

964: if l_time_uom_flag = 2 then
965: if (g_logLevel <= wip_constants.trace_logging) then
966: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
967: fnd_message.set_token('EMP', to_char(employee.person_id));
968: x_error_msg := fnd_message.get;
969: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
970: --l_error_count := l_error_count + 1;
971: end if;
972: is_sah_record_valid :=false;

Line 1035: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');

1031: l_stmt_num :=230;
1032: -- Modified for bug 6972129.
1033: if l_time_uom_flag = 2 then
1034: if (g_logLevel <= wip_constants.trace_logging) then
1035: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1036: fnd_message.set_token('EMP', to_char(employee.person_id));
1037: x_error_msg := fnd_message.get;
1038: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1039: --l_error_count := l_error_count + 1;

Line 1036: fnd_message.set_token('EMP', to_char(employee.person_id));

1032: -- Modified for bug 6972129.
1033: if l_time_uom_flag = 2 then
1034: if (g_logLevel <= wip_constants.trace_logging) then
1035: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1036: fnd_message.set_token('EMP', to_char(employee.person_id));
1037: x_error_msg := fnd_message.get;
1038: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1039: --l_error_count := l_error_count + 1;
1040: end if;

Line 1037: x_error_msg := fnd_message.get;

1033: if l_time_uom_flag = 2 then
1034: if (g_logLevel <= wip_constants.trace_logging) then
1035: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1036: fnd_message.set_token('EMP', to_char(employee.person_id));
1037: x_error_msg := fnd_message.get;
1038: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1039: --l_error_count := l_error_count + 1;
1040: end if;
1041: is_dlh_record_valid :=false;

Line 1112: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');

1108: l_stmt_num :=310;
1109: -- Modified for bug 6972129.
1110: if l_time_uom_flag = 2 then
1111: if (g_logLevel <= wip_constants.trace_logging) then
1112: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1113: fnd_message.set_token('EMP', to_char(employee.person_id));
1114: x_error_msg := fnd_message.get;
1115: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1116: --l_error_count := l_error_count + 1;

Line 1113: fnd_message.set_token('EMP', to_char(employee.person_id));

1109: -- Modified for bug 6972129.
1110: if l_time_uom_flag = 2 then
1111: if (g_logLevel <= wip_constants.trace_logging) then
1112: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1113: fnd_message.set_token('EMP', to_char(employee.person_id));
1114: x_error_msg := fnd_message.get;
1115: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1116: --l_error_count := l_error_count + 1;
1117: end if;

Line 1114: x_error_msg := fnd_message.get;

1110: if l_time_uom_flag = 2 then
1111: if (g_logLevel <= wip_constants.trace_logging) then
1112: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1113: fnd_message.set_token('EMP', to_char(employee.person_id));
1114: x_error_msg := fnd_message.get;
1115: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1116: --l_error_count := l_error_count + 1;
1117: end if;
1118: is_eh_record_valid := false;

Line 1122: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');

1118: is_eh_record_valid := false;
1119: end if;
1120: if earned_hrs_rates.basis_type = 2 then
1121: if (g_logLevel <= wip_constants.trace_logging) then
1122: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1123: fnd_message.set_token('EMP', to_char(employee.person_id));
1124: x_error_msg := fnd_message.get;
1125: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1126: --l_error_count := l_error_count + 1;

Line 1123: fnd_message.set_token('EMP', to_char(employee.person_id));

1119: end if;
1120: if earned_hrs_rates.basis_type = 2 then
1121: if (g_logLevel <= wip_constants.trace_logging) then
1122: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1123: fnd_message.set_token('EMP', to_char(employee.person_id));
1124: x_error_msg := fnd_message.get;
1125: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1126: --l_error_count := l_error_count + 1;
1127: end if;

Line 1124: x_error_msg := fnd_message.get;

1120: if earned_hrs_rates.basis_type = 2 then
1121: if (g_logLevel <= wip_constants.trace_logging) then
1122: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1123: fnd_message.set_token('EMP', to_char(employee.person_id));
1124: x_error_msg := fnd_message.get;
1125: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1126: --l_error_count := l_error_count + 1;
1127: end if;
1128: is_eh_record_valid := false;

Line 1378: fnd_message.set_name('WIP','WIP_LAB_UNEXPECTED_ERROR');

1374: errbuf := 'Organization parameter cannot be null';
1375: fnd_file.put_line(fnd_file.log,errbuf);
1376: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
1377: when others then
1378: fnd_message.set_name('WIP','WIP_LAB_UNEXPECTED_ERROR');
1379: x_error_msg := fnd_message.get;
1380: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1381: x_error_msg := sqlerrm(sqlcode);
1382: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);

Line 1379: x_error_msg := fnd_message.get;

1375: fnd_file.put_line(fnd_file.log,errbuf);
1376: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
1377: when others then
1378: fnd_message.set_name('WIP','WIP_LAB_UNEXPECTED_ERROR');
1379: x_error_msg := fnd_message.get;
1380: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1381: x_error_msg := sqlerrm(sqlcode);
1382: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1383: rollback;