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.

[Home] [Help]

APPS.WSMPLBJI dependencies on FND_MESSAGE

Line 353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

349: from mtl_parameters
350: where organization_code = l_org_code;
351: exception
352: when others then
353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
354: fnd_message.set_token('FLD_NAME', 'Organization Code');
355: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
356: return -1;
357: end;

Line 354: fnd_message.set_token('FLD_NAME', 'Organization Code');

350: where organization_code = l_org_code;
351: exception
352: when others then
353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
354: fnd_message.set_token('FLD_NAME', 'Organization Code');
355: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
356: return -1;
357: end;
358: end if;

Line 355: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);

351: exception
352: when others then
353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
354: fnd_message.set_token('FLD_NAME', 'Organization Code');
355: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
356: return -1;
357: end;
358: end if;
359:

Line 375: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

371: and TRUNC(SYSDATE) <= NVL(ORG.DATE_TO, SYSDATE+1)
372: and WSM.ORGANIZATION_ID = l_org_id;
373: exception
374: when others then
375: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
376: fnd_message.set_token('FLD_NAME', 'Organization ID');
377: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
378: return -1;
379: end;

Line 376: fnd_message.set_token('FLD_NAME', 'Organization ID');

372: and WSM.ORGANIZATION_ID = l_org_id;
373: exception
374: when others then
375: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
376: fnd_message.set_token('FLD_NAME', 'Organization ID');
377: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
378: return -1;
379: end;
380:

Line 377: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);

373: exception
374: when others then
375: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
376: fnd_message.set_token('FLD_NAME', 'Organization ID');
377: fnd_file.put_line(fnd_file.log, 'get_one_org_id: ' || fnd_message.get);
378: return -1;
379: end;
380:
381: return l_org_id;

Line 729: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');

725: p_sequence_id_type => 'O',
726: p_routing_rev_date => p_routing_revision_date,
727: x_err_code => l_error_code,
728: x_err_msg => l_error_msg) then
729: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
730: p_error_code := -1;
731: p_error_msg := fnd_message.get;
732: return;
733: end if;

Line 731: p_error_msg := fnd_message.get;

727: x_err_code => l_error_code,
728: x_err_msg => l_error_msg) then
729: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
730: p_error_code := -1;
731: p_error_msg := fnd_message.get;
732: return;
733: end if;
734: --osp end
735:

Line 967: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

963: err_msg => l_error_msg,
964: p_org_id => p_org,
965: p_job_type => p_job_type) = 1
966: and (l_est_scrap_account is null or l_est_scrap_var_account is null) then
967: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
968: fnd_message.set_token('CC',p_class_code);
969: p_error_code := -1;
970: p_error_msg := fnd_message.get;
971: return;

Line 968: fnd_message.set_token('CC',p_class_code);

964: p_org_id => p_org,
965: p_job_type => p_job_type) = 1
966: and (l_est_scrap_account is null or l_est_scrap_var_account is null) then
967: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
968: fnd_message.set_token('CC',p_class_code);
969: p_error_code := -1;
970: p_error_msg := fnd_message.get;
971: return;
972: end if;

Line 970: p_error_msg := fnd_message.get;

966: and (l_est_scrap_account is null or l_est_scrap_var_account is null) then
967: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
968: fnd_message.set_token('CC',p_class_code);
969: p_error_code := -1;
970: p_error_msg := fnd_message.get;
971: return;
972: end if;
973:
974:

Line 1231: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

1227: p_replenish_quantity => p_start_quantity);
1228:
1229: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
1230: p_error_code := -1;
1231: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
1232: select meaning
1233: into translated_meaning
1234: from mfg_lookups
1235: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'

Line 1238: fnd_message.set_token('STATUS',translated_meaning);

1234: from mfg_lookups
1235: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
1236: and lookup_code = 5
1237: and upper(enabled_flag) = 'Y';
1238: fnd_message.set_token('STATUS',translated_meaning);
1239: p_error_msg := fnd_message.get;
1240: return;
1241: end if;
1242: end if;

Line 1239: p_error_msg := fnd_message.get;

1235: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
1236: and lookup_code = 5
1237: and upper(enabled_flag) = 'Y';
1238: fnd_message.set_token('STATUS',translated_meaning);
1239: p_error_msg := fnd_message.get;
1240: return;
1241: end if;
1242: end if;
1243:

Line 2079: fnd_message.set_name('WSM', 'WSM_NO_SCRAP_ACC');

2075: fnd_file.put_line(fnd_file.log,p_error_msg);
2076: end if;
2077:
2078: WHEN no_dept_error THEN
2079: fnd_message.set_name('WSM', 'WSM_NO_SCRAP_ACC');
2080: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
2081: p_error_msg := fnd_message.get;
2082: p_error_code := -1;
2083:

Line 2080: fnd_message.set_token('DEPT_ID',to_char(l_department_id));

2076: end if;
2077:
2078: WHEN no_dept_error THEN
2079: fnd_message.set_name('WSM', 'WSM_NO_SCRAP_ACC');
2080: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
2081: p_error_msg := fnd_message.get;
2082: p_error_code := -1;
2083:
2084: when others then

Line 2081: p_error_msg := fnd_message.get;

2077:
2078: WHEN no_dept_error THEN
2079: fnd_message.set_name('WSM', 'WSM_NO_SCRAP_ACC');
2080: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
2081: p_error_msg := fnd_message.get;
2082: p_error_code := -1;
2083:
2084: when others then
2085: p_error_code := SQLCODE;

Line 2299: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

2295: -- p_organization_id => p_organization_id,
2296: -- p_date => trunc(nvl(p_release_date, sysdate)) );
2297: --if(p_error_code <> 0) then
2298: -- p_error_code := -1;
2299: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2300: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2301: -- p_err_msg := fnd_message.get;
2302: -- return;
2303: --end if;

Line 2300: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');

2296: -- p_date => trunc(nvl(p_release_date, sysdate)) );
2297: --if(p_error_code <> 0) then
2298: -- p_error_code := -1;
2299: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2300: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2301: -- p_err_msg := fnd_message.get;
2302: -- return;
2303: --end if;
2304: -- ED: bugfix 3299811

Line 2301: -- p_err_msg := fnd_message.get;

2297: --if(p_error_code <> 0) then
2298: -- p_error_code := -1;
2299: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2300: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2301: -- p_err_msg := fnd_message.get;
2302: -- return;
2303: --end if;
2304: -- ED: bugfix 3299811
2305:

Line 2399: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

2395:
2396: --if SQL%NOTFOUND then -- bug 3571360
2397: if l_cnt <= 0 then -- bug 3571360
2398: p_error_code := -1;
2399: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2400: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2401: p_err_msg := fnd_message.get;
2402: end if;
2403:

Line 2400: fnd_message.set_token('FLD_NAME','Wip Accounting Period');

2396: --if SQL%NOTFOUND then -- bug 3571360
2397: if l_cnt <= 0 then -- bug 3571360
2398: p_error_code := -1;
2399: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2400: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2401: p_err_msg := fnd_message.get;
2402: end if;
2403:
2404: exception

Line 2401: p_err_msg := fnd_message.get;

2397: if l_cnt <= 0 then -- bug 3571360
2398: p_error_code := -1;
2399: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2400: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2401: p_err_msg := fnd_message.get;
2402: end if;
2403:
2404: exception
2405: when others then

Line 2438: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2434: BEGIN
2435:
2436: v_wlji_process_status(v_index) := 3;
2437: v_wlji_err_code(v_index) := -1;
2438: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2439: fnd_message.set_token('FLD_NAME', p_fld);
2440: x_err_msg := fnd_message.get;
2441: v_wlji_err_msg(v_index) := x_err_msg;
2442: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);

Line 2439: fnd_message.set_token('FLD_NAME', p_fld);

2435:
2436: v_wlji_process_status(v_index) := 3;
2437: v_wlji_err_code(v_index) := -1;
2438: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2439: fnd_message.set_token('FLD_NAME', p_fld);
2440: x_err_msg := fnd_message.get;
2441: v_wlji_err_msg(v_index) := x_err_msg;
2442: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);
2443: fnd_file.new_line(fnd_file.log, 3);

Line 2440: x_err_msg := fnd_message.get;

2436: v_wlji_process_status(v_index) := 3;
2437: v_wlji_err_code(v_index) := -1;
2438: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2439: fnd_message.set_token('FLD_NAME', p_fld);
2440: x_err_msg := fnd_message.get;
2441: v_wlji_err_msg(v_index) := x_err_msg;
2442: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);
2443: fnd_file.new_line(fnd_file.log, 3);
2444:

Line 2472: fnd_message.set_name(p_product, p_message_name);

2468:
2469: BEGIN
2470: v_wlji_process_status(v_index) := 3; --ERROR
2471: v_wlji_err_code(v_index) := -1;
2472: fnd_message.set_name(p_product, p_message_name);
2473: x_err_msg := fnd_message.get;
2474: v_wlji_err_msg(v_index) := x_err_msg;
2475: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg);
2476: fnd_file.new_line(fnd_file.log, 3);

Line 2473: x_err_msg := fnd_message.get;

2469: BEGIN
2470: v_wlji_process_status(v_index) := 3; --ERROR
2471: v_wlji_err_code(v_index) := -1;
2472: fnd_message.set_name(p_product, p_message_name);
2473: x_err_msg := fnd_message.get;
2474: v_wlji_err_msg(v_index) := x_err_msg;
2475: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg);
2476: fnd_file.new_line(fnd_file.log, 3);
2477:

Line 4384: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

4380: -- P_ORGANIZATION_ID => v_wlji_org(v_index)
4381: -- );
4382:
4383: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4384: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4385: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4386: -- l_err_msg := fnd_message.get;
4387: -- l_error_code := -1;
4388: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);

Line 4385: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');

4381: -- );
4382:
4383: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4384: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4385: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4386: -- l_err_msg := fnd_message.get;
4387: -- l_error_code := -1;
4388: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4389: -- l_error_code := -1;

Line 4386: -- l_err_msg := fnd_message.get;

4382:
4383: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4384: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4385: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4386: -- l_err_msg := fnd_message.get;
4387: -- l_error_code := -1;
4388: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4389: -- l_error_code := -1;
4390: -- GOTO skip_job_id_valid;

Line 4676: fnd_message.set_name('WIP','WIP_MLD_DESC');

4672: -- this is to be called only for job creation.
4673: if v_wlji_load_type(v_index) = 5 then
4674: if RTRIM(v_wlji_description(v_index)) is NULL then
4675: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1) ;
4676: fnd_message.set_name('WIP','WIP_MLD_DESC');
4677: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4678: v_wlji_description(v_index) := FND_Message.get;
4679: else
4680: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));

Line 4677: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;

4673: if v_wlji_load_type(v_index) = 5 then
4674: if RTRIM(v_wlji_description(v_index)) is NULL then
4675: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1) ;
4676: fnd_message.set_name('WIP','WIP_MLD_DESC');
4677: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4678: v_wlji_description(v_index) := FND_Message.get;
4679: else
4680: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));
4681: end if;

Line 4678: v_wlji_description(v_index) := FND_Message.get;

4674: if RTRIM(v_wlji_description(v_index)) is NULL then
4675: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1) ;
4676: fnd_message.set_name('WIP','WIP_MLD_DESC');
4677: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4678: v_wlji_description(v_index) := FND_Message.get;
4679: else
4680: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));
4681: end if;
4682:

Line 4820: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

4816: and NVL(mmtt2.locator_id, -9999) = NVL(v_wsli(v_wlji_source_line_id(v_index)).locator_id, -9999)
4817: );
4818: end if;
4819: If l_dummy <> 0 then
4820: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4821: FND_MESSAGE.SET_TOKEN('TABLE',
4822: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4823: ||'Table: mtl_transaction_lots_temp ');
4824: l_err_msg := fnd_message.get;

Line 4821: FND_MESSAGE.SET_TOKEN('TABLE',

4817: );
4818: end if;
4819: If l_dummy <> 0 then
4820: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4821: FND_MESSAGE.SET_TOKEN('TABLE',
4822: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4823: ||'Table: mtl_transaction_lots_temp ');
4824: l_err_msg := fnd_message.get;
4825: l_error_code := -1;

Line 4824: l_err_msg := fnd_message.get;

4820: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4821: FND_MESSAGE.SET_TOKEN('TABLE',
4822: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4823: ||'Table: mtl_transaction_lots_temp ');
4824: l_err_msg := fnd_message.get;
4825: l_error_code := -1;
4826: HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4827: END IF;
4828:

Line 4941: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');

4937: exception
4938: -- BA: BUGFIX 2380517
4939: when no_data_found then
4940: l_error_code := -1;
4941: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
4942: l_err_msg := fnd_message.get;
4943: handle_error(l_error_code, l_err_msg, l_stmt_num);
4944: --EA: BUGFIX 2380517
4945:

Line 4942: l_err_msg := fnd_message.get;

4938: -- BA: BUGFIX 2380517
4939: when no_data_found then
4940: l_error_code := -1;
4941: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
4942: l_err_msg := fnd_message.get;
4943: handle_error(l_error_code, l_err_msg, l_stmt_num);
4944: --EA: BUGFIX 2380517
4945:
4946: when others then

Line 5201: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');

5197: exception
5198: -- BA: BUGFIX 2380517
5199: when no_data_found then
5200: l_error_code := -1;
5201: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
5202: l_err_msg := fnd_message.get;
5203: handle_error(l_error_code, l_err_msg, l_stmt_num);
5204: --EA: BUGFIX 2380517
5205: when others then

Line 5202: l_err_msg := fnd_message.get;

5198: -- BA: BUGFIX 2380517
5199: when no_data_found then
5200: l_error_code := -1;
5201: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
5202: l_err_msg := fnd_message.get;
5203: handle_error(l_error_code, l_err_msg, l_stmt_num);
5204: --EA: BUGFIX 2380517
5205: when others then
5206: l_error_code := -1;

Line 5245: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');

5241: v_wlji_routing_revision_date(v_index),
5242: l_error_code,
5243: l_err_msg) = 1)
5244: then
5245: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
5246: l_err_msg := fnd_message.get;
5247: l_warning_count := l_warning_count + 1;
5248: handle_warning(p_err_msg => l_err_msg,
5249: p_header_id => v_wlji_header_id(v_index),

Line 5246: l_err_msg := fnd_message.get;

5242: l_error_code,
5243: l_err_msg) = 1)
5244: then
5245: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
5246: l_err_msg := fnd_message.get;
5247: l_warning_count := l_warning_count + 1;
5248: handle_warning(p_err_msg => l_err_msg,
5249: p_header_id => v_wlji_header_id(v_index),
5250: p_request_id => v_wlji_request_id(v_index),

Line 6341: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

6337: -- and trunc(nvl(v_wlji_date_released(v_index),sysdate)) between PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
6338: -- and period_close_date is NULL;
6339: --exception
6340: -- when NO_DATA_FOUND then
6341: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
6342: -- l_err_msg := fnd_message.get;
6343: -- l_error_code := -1;
6344: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
6345: -- GOTO skip_resched_validations;

Line 6342: -- l_err_msg := fnd_message.get;

6338: -- and period_close_date is NULL;
6339: --exception
6340: -- when NO_DATA_FOUND then
6341: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
6342: -- l_err_msg := fnd_message.get;
6343: -- l_error_code := -1;
6344: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
6345: -- GOTO skip_resched_validations;
6346: -- when others then

Line 6389: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');

6385: v_wlji_wip_entity_id(v_index),
6386: null,
6387: v_wlji_org(v_index),
6388: null, 5) then
6389: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
6390: l_err_msg := fnd_message.get;
6391: l_warning_count := l_warning_count + 1;
6392: handle_warning(p_err_msg => l_err_msg,
6393: p_header_id => v_wlji_header_id(v_index),

Line 6390: l_err_msg := fnd_message.get;

6386: null,
6387: v_wlji_org(v_index),
6388: null, 5) then
6389: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
6390: l_err_msg := fnd_message.get;
6391: l_warning_count := l_warning_count + 1;
6392: handle_warning(p_err_msg => l_err_msg,
6393: p_header_id => v_wlji_header_id(v_index),
6394: p_request_id => v_wlji_request_id(v_index),

Line 6432: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

6428:
6429: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6430: v_wlji_process_status(v_index) := 3; --ERROR
6431: v_wlji_err_code(v_index) := -1;
6432: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6433: fnd_message.set_token('CC', l_temp_cc);
6434: v_wlji_err_msg(v_index) := fnd_message.get;
6435: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6436: fnd_file.new_line(fnd_file.log, 3);

Line 6433: fnd_message.set_token('CC', l_temp_cc);

6429: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6430: v_wlji_process_status(v_index) := 3; --ERROR
6431: v_wlji_err_code(v_index) := -1;
6432: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6433: fnd_message.set_token('CC', l_temp_cc);
6434: v_wlji_err_msg(v_index) := fnd_message.get;
6435: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6436: fnd_file.new_line(fnd_file.log, 3);
6437: l_error_code := -1;

Line 6434: v_wlji_err_msg(v_index) := fnd_message.get;

6430: v_wlji_process_status(v_index) := 3; --ERROR
6431: v_wlji_err_code(v_index) := -1;
6432: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6433: fnd_message.set_token('CC', l_temp_cc);
6434: v_wlji_err_msg(v_index) := fnd_message.get;
6435: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6436: fnd_file.new_line(fnd_file.log, 3);
6437: l_error_code := -1;
6438: GOTO skip_resched_validations;

Line 6443: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

6439: end if;
6440: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6441: v_wlji_process_status(v_index) := 3; --ERROR
6442: v_wlji_err_code(v_index) := -1;
6443: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6444: fnd_message.set_token('CC', l_temp_cc);
6445: v_wlji_err_msg(v_index) := fnd_message.get;
6446: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6447: fnd_file.new_line(fnd_file.log, 3);

Line 6444: fnd_message.set_token('CC', l_temp_cc);

6440: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6441: v_wlji_process_status(v_index) := 3; --ERROR
6442: v_wlji_err_code(v_index) := -1;
6443: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6444: fnd_message.set_token('CC', l_temp_cc);
6445: v_wlji_err_msg(v_index) := fnd_message.get;
6446: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6447: fnd_file.new_line(fnd_file.log, 3);
6448: l_error_code := -1;

Line 6445: v_wlji_err_msg(v_index) := fnd_message.get;

6441: v_wlji_process_status(v_index) := 3; --ERROR
6442: v_wlji_err_code(v_index) := -1;
6443: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6444: fnd_message.set_token('CC', l_temp_cc);
6445: v_wlji_err_msg(v_index) := fnd_message.get;
6446: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6447: fnd_file.new_line(fnd_file.log, 3);
6448: l_error_code := -1;
6449: GOTO skip_resched_validations;

Line 6978: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');

6974:
6975: if l_scrap_account10 is null or l_est_scrap_abs_account10 is null then
6976: v_wlji_process_status(v_index) := 3; --ERROR
6977: v_wlji_err_code(v_index) := -1;
6978: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6979: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6980: v_wlji_err_msg(v_index) := fnd_message.get;
6981: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6982: fnd_file.new_line(fnd_file.log, 3);

Line 6979: fnd_message.set_token('DEPT_ID',to_char(l_department_id));

6975: if l_scrap_account10 is null or l_est_scrap_abs_account10 is null then
6976: v_wlji_process_status(v_index) := 3; --ERROR
6977: v_wlji_err_code(v_index) := -1;
6978: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6979: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6980: v_wlji_err_msg(v_index) := fnd_message.get;
6981: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6982: fnd_file.new_line(fnd_file.log, 3);
6983: l_error_code := -1;

Line 6980: v_wlji_err_msg(v_index) := fnd_message.get;

6976: v_wlji_process_status(v_index) := 3; --ERROR
6977: v_wlji_err_code(v_index) := -1;
6978: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6979: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6980: v_wlji_err_msg(v_index) := fnd_message.get;
6981: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6982: fnd_file.new_line(fnd_file.log, 3);
6983: l_error_code := -1;
6984: l_error_count := l_error_count + 1;

Line 7013: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');

7009:
7010: if l_scrap_account9999 is null or l_est_scrap_abs_account9999 is null then
7011: v_wlji_process_status(v_index) := 3; --ERROR
7012: v_wlji_err_code(v_index) := -1;
7013: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7014: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7015: v_wlji_err_msg(v_index) := fnd_message.get;
7016: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7017: fnd_file.new_line(fnd_file.log, 3);

Line 7014: fnd_message.set_token('DEPT_ID',to_char(l_department_id));

7010: if l_scrap_account9999 is null or l_est_scrap_abs_account9999 is null then
7011: v_wlji_process_status(v_index) := 3; --ERROR
7012: v_wlji_err_code(v_index) := -1;
7013: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7014: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7015: v_wlji_err_msg(v_index) := fnd_message.get;
7016: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7017: fnd_file.new_line(fnd_file.log, 3);
7018: l_error_code := -1;

Line 7015: v_wlji_err_msg(v_index) := fnd_message.get;

7011: v_wlji_process_status(v_index) := 3; --ERROR
7012: v_wlji_err_code(v_index) := -1;
7013: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7014: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7015: v_wlji_err_msg(v_index) := fnd_message.get;
7016: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7017: fnd_file.new_line(fnd_file.log, 3);
7018: l_error_code := -1;
7019: l_error_count := l_error_count + 1;

Line 7065: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

7061: if wip_osp.po_req_exists ( v_wlji_wip_entity_id(v_index),
7062: null,
7063: v_wlji_org(v_index),
7064: null, 5) then
7065: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
7066: l_err_msg := fnd_message.get;
7067: l_warning_count := l_warning_count + 1;
7068: handle_warning( p_err_msg => l_err_msg,
7069: p_header_id => v_wlji_header_id(v_index),

Line 7066: l_err_msg := fnd_message.get;

7062: null,
7063: v_wlji_org(v_index),
7064: null, 5) then
7065: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
7066: l_err_msg := fnd_message.get;
7067: l_warning_count := l_warning_count + 1;
7068: handle_warning( p_err_msg => l_err_msg,
7069: p_header_id => v_wlji_header_id(v_index),
7070: p_request_id => v_wlji_request_id(v_index),

Line 7128: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

7124: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
7125:
7126: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
7127: l_error_code := -1;
7128: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7129:
7130: select meaning
7131: into translated_meaning
7132: from mfg_lookups

Line 7137: fnd_message.set_token('STATUS',translated_meaning);

7133: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7134: and lookup_code = 7
7135: and upper(enabled_flag) = 'Y';
7136:
7137: fnd_message.set_token('STATUS',translated_meaning);
7138: l_error_msg := fnd_message.get;
7139: handle_error(l_error_code, l_error_msg, l_stmt_num);
7140: l_error_count := l_error_count + 1;
7141: GOTO skip_other_steps;

Line 7138: l_error_msg := fnd_message.get;

7134: and lookup_code = 7
7135: and upper(enabled_flag) = 'Y';
7136:
7137: fnd_message.set_token('STATUS',translated_meaning);
7138: l_error_msg := fnd_message.get;
7139: handle_error(l_error_code, l_error_msg, l_stmt_num);
7140: l_error_count := l_error_count + 1;
7141: GOTO skip_other_steps;
7142: end if;

Line 7556: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

7552: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
7553:
7554: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
7555: l_error_code := -1;
7556: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7557: select meaning
7558: into translated_meaning
7559: from mfg_lookups
7560: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'

Line 7564: fnd_message.set_token('STATUS',translated_meaning);

7560: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7561: and lookup_code = 7
7562: and upper(enabled_flag) = 'Y';
7563:
7564: fnd_message.set_token('STATUS',translated_meaning);
7565: l_error_msg := fnd_message.get;
7566: handle_error(l_error_code, l_error_msg, l_stmt_num);
7567: l_error_count := l_error_count + 1;
7568: end if;

Line 7565: l_error_msg := fnd_message.get;

7561: and lookup_code = 7
7562: and upper(enabled_flag) = 'Y';
7563:
7564: fnd_message.set_token('STATUS',translated_meaning);
7565: l_error_msg := fnd_message.get;
7566: handle_error(l_error_code, l_error_msg, l_stmt_num);
7567: l_error_count := l_error_count + 1;
7568: end if;
7569: