DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on FND_MESSAGE

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

644: and upper(phase_code) = 'R'
645: and argument1 = to_char(p_organization_id);
646:
647: if (l_pgm_count > 1) then
648: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
649: fnd_message.set_token('ORG', to_char(l_org_code));
650: x_error_msg := fnd_message.get;
651: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
652: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');

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

645: and argument1 = to_char(p_organization_id);
646:
647: if (l_pgm_count > 1) then
648: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
649: fnd_message.set_token('ORG', to_char(l_org_code));
650: x_error_msg := fnd_message.get;
651: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
652: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');
653: retcode := 2;

Line 650: x_error_msg := fnd_message.get;

646:
647: if (l_pgm_count > 1) then
648: fnd_message.set_name('WIP','WIP_RUNNING_LABOR_PRG');
649: fnd_message.set_token('ORG', to_char(l_org_code));
650: x_error_msg := fnd_message.get;
651: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
652: wip_ws_util.trace_log('Unable to run calculation program for this organization. Please try after some time.');
653: retcode := 2;
654: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',

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

920: l_stmt_num :=120;
921: -- Modified for bug 6972129.
922: if l_time_uom_flag = 2 then
923: if (g_logLevel <= wip_constants.trace_logging) then
924: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
925: fnd_message.set_token('EMP', to_char(employee.person_id));
926: x_error_msg := fnd_message.get;
927: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
928: --l_error_count := l_error_count + 1;

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

921: -- Modified for bug 6972129.
922: if l_time_uom_flag = 2 then
923: if (g_logLevel <= wip_constants.trace_logging) then
924: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
925: fnd_message.set_token('EMP', to_char(employee.person_id));
926: x_error_msg := fnd_message.get;
927: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
928: --l_error_count := l_error_count + 1;
929: end if;

Line 926: x_error_msg := fnd_message.get;

922: if l_time_uom_flag = 2 then
923: if (g_logLevel <= wip_constants.trace_logging) then
924: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
925: fnd_message.set_token('EMP', to_char(employee.person_id));
926: x_error_msg := fnd_message.get;
927: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
928: --l_error_count := l_error_count + 1;
929: end if;
930: is_aah_record_valid := false;

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

1000: l_stmt_num :=180;
1001: -- Modified for bug 6972129.
1002: if l_time_uom_flag = 2 then
1003: if (g_logLevel <= wip_constants.trace_logging) then
1004: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1005: fnd_message.set_token('EMP', to_char(employee.person_id));
1006: x_error_msg := fnd_message.get;
1007: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1008: --l_error_count := l_error_count + 1;

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

1001: -- Modified for bug 6972129.
1002: if l_time_uom_flag = 2 then
1003: if (g_logLevel <= wip_constants.trace_logging) then
1004: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1005: fnd_message.set_token('EMP', to_char(employee.person_id));
1006: x_error_msg := fnd_message.get;
1007: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1008: --l_error_count := l_error_count + 1;
1009: end if;

Line 1006: x_error_msg := fnd_message.get;

1002: if l_time_uom_flag = 2 then
1003: if (g_logLevel <= wip_constants.trace_logging) then
1004: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1005: fnd_message.set_token('EMP', to_char(employee.person_id));
1006: x_error_msg := fnd_message.get;
1007: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1008: --l_error_count := l_error_count + 1;
1009: end if;
1010: is_sah_record_valid :=false;

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

1076: l_stmt_num :=230;
1077: -- Modified for bug 6972129.
1078: if l_time_uom_flag = 2 then
1079: if (g_logLevel <= wip_constants.trace_logging) then
1080: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1081: fnd_message.set_token('EMP', to_char(employee.person_id));
1082: x_error_msg := fnd_message.get;
1083: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1084: --l_error_count := l_error_count + 1;

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

1077: -- Modified for bug 6972129.
1078: if l_time_uom_flag = 2 then
1079: if (g_logLevel <= wip_constants.trace_logging) then
1080: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1081: fnd_message.set_token('EMP', to_char(employee.person_id));
1082: x_error_msg := fnd_message.get;
1083: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1084: --l_error_count := l_error_count + 1;
1085: end if;

Line 1082: x_error_msg := fnd_message.get;

1078: if l_time_uom_flag = 2 then
1079: if (g_logLevel <= wip_constants.trace_logging) then
1080: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1081: fnd_message.set_token('EMP', to_char(employee.person_id));
1082: x_error_msg := fnd_message.get;
1083: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1084: --l_error_count := l_error_count + 1;
1085: end if;
1086: is_dlh_record_valid :=false;

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

1200: l_stmt_num :=310;
1201: -- Modified for bug 6972129.
1202: if l_time_uom_flag = 2 then
1203: if (g_logLevel <= wip_constants.trace_logging) then
1204: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1205: fnd_message.set_token('EMP', to_char(employee.person_id));
1206: x_error_msg := fnd_message.get;
1207: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1208: --l_error_count := l_error_count + 1;

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

1201: -- Modified for bug 6972129.
1202: if l_time_uom_flag = 2 then
1203: if (g_logLevel <= wip_constants.trace_logging) then
1204: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1205: fnd_message.set_token('EMP', to_char(employee.person_id));
1206: x_error_msg := fnd_message.get;
1207: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1208: --l_error_count := l_error_count + 1;
1209: end if;

Line 1206: x_error_msg := fnd_message.get;

1202: if l_time_uom_flag = 2 then
1203: if (g_logLevel <= wip_constants.trace_logging) then
1204: fnd_message.set_name('WIP','WIP_LM_TIME_UOM');
1205: fnd_message.set_token('EMP', to_char(employee.person_id));
1206: x_error_msg := fnd_message.get;
1207: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1208: --l_error_count := l_error_count + 1;
1209: end if;
1210: is_eh_record_valid := false;

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

1210: is_eh_record_valid := false;
1211: end if;
1212: if earned_hrs_rates.basis_type = 2 then
1213: if (g_logLevel <= wip_constants.trace_logging) then
1214: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1215: fnd_message.set_token('EMP', to_char(employee.person_id));
1216: x_error_msg := fnd_message.get;
1217: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1218: --l_error_count := l_error_count + 1;

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

1211: end if;
1212: if earned_hrs_rates.basis_type = 2 then
1213: if (g_logLevel <= wip_constants.trace_logging) then
1214: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1215: fnd_message.set_token('EMP', to_char(employee.person_id));
1216: x_error_msg := fnd_message.get;
1217: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1218: --l_error_count := l_error_count + 1;
1219: end if;

Line 1216: x_error_msg := fnd_message.get;

1212: if earned_hrs_rates.basis_type = 2 then
1213: if (g_logLevel <= wip_constants.trace_logging) then
1214: fnd_message.set_name('WIP','WIP_LM_LOT_BASED_RES');
1215: fnd_message.set_token('EMP', to_char(employee.person_id));
1216: x_error_msg := fnd_message.get;
1217: wip_ws_util.trace_log(l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1218: --l_error_count := l_error_count + 1;
1219: end if;
1220: is_eh_record_valid := false;

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

1472: errbuf := 'Organization parameter cannot be null';
1473: fnd_file.put_line(fnd_file.log,errbuf);
1474: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
1475: when others then
1476: fnd_message.set_name('WIP','WIP_LAB_UNEXPECTED_ERROR');
1477: x_error_msg := fnd_message.get;
1478: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1479: x_error_msg := sqlerrm(sqlcode);
1480: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);

Line 1477: x_error_msg := fnd_message.get;

1473: fnd_file.put_line(fnd_file.log,errbuf);
1474: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
1475: when others then
1476: fnd_message.set_name('WIP','WIP_LAB_UNEXPECTED_ERROR');
1477: x_error_msg := fnd_message.get;
1478: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1479: x_error_msg := sqlerrm(sqlcode);
1480: wip_ws_util.trace_log('Error in '||l_proc_name||'( stmt_num: '||l_stmt_num||') '||x_error_msg);
1481: rollback;