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.

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 2293: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

2289: -- p_organization_id => p_organization_id,
2290: -- p_date => trunc(nvl(p_release_date, sysdate)) );
2291: --if(p_error_code <> 0) then
2292: -- p_error_code := -1;
2293: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2294: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2295: -- p_err_msg := fnd_message.get;
2296: -- return;
2297: --end if;

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

2290: -- p_date => trunc(nvl(p_release_date, sysdate)) );
2291: --if(p_error_code <> 0) then
2292: -- p_error_code := -1;
2293: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2294: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2295: -- p_err_msg := fnd_message.get;
2296: -- return;
2297: --end if;
2298: -- ED: bugfix 3299811

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

2291: --if(p_error_code <> 0) then
2292: -- p_error_code := -1;
2293: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2294: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2295: -- p_err_msg := fnd_message.get;
2296: -- return;
2297: --end if;
2298: -- ED: bugfix 3299811
2299:

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

2389:
2390: --if SQL%NOTFOUND then -- bug 3571360
2391: if l_cnt <= 0 then -- bug 3571360
2392: p_error_code := -1;
2393: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2394: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2395: p_err_msg := fnd_message.get;
2396: end if;
2397:

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

2390: --if SQL%NOTFOUND then -- bug 3571360
2391: if l_cnt <= 0 then -- bug 3571360
2392: p_error_code := -1;
2393: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2394: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2395: p_err_msg := fnd_message.get;
2396: end if;
2397:
2398: exception

Line 2395: p_err_msg := fnd_message.get;

2391: if l_cnt <= 0 then -- bug 3571360
2392: p_error_code := -1;
2393: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
2394: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
2395: p_err_msg := fnd_message.get;
2396: end if;
2397:
2398: exception
2399: when others then

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

2428: BEGIN
2429:
2430: v_wlji_process_status(v_index) := 3;
2431: v_wlji_err_code(v_index) := -1;
2432: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2433: fnd_message.set_token('FLD_NAME', p_fld);
2434: x_err_msg := fnd_message.get;
2435: v_wlji_err_msg(v_index) := x_err_msg;
2436: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);

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

2429:
2430: v_wlji_process_status(v_index) := 3;
2431: v_wlji_err_code(v_index) := -1;
2432: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2433: fnd_message.set_token('FLD_NAME', p_fld);
2434: x_err_msg := fnd_message.get;
2435: v_wlji_err_msg(v_index) := x_err_msg;
2436: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);
2437: fnd_file.new_line(fnd_file.log, 3);

Line 2434: x_err_msg := fnd_message.get;

2430: v_wlji_process_status(v_index) := 3;
2431: v_wlji_err_code(v_index) := -1;
2432: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2433: fnd_message.set_token('FLD_NAME', p_fld);
2434: x_err_msg := fnd_message.get;
2435: v_wlji_err_msg(v_index) := x_err_msg;
2436: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg||' '||aux_string);
2437: fnd_file.new_line(fnd_file.log, 3);
2438:

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

2462:
2463: BEGIN
2464: v_wlji_process_status(v_index) := 3; --ERROR
2465: v_wlji_err_code(v_index) := -1;
2466: fnd_message.set_name(p_product, p_message_name);
2467: x_err_msg := fnd_message.get;
2468: v_wlji_err_msg(v_index) := x_err_msg;
2469: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg);
2470: fnd_file.new_line(fnd_file.log, 3);

Line 2467: x_err_msg := fnd_message.get;

2463: BEGIN
2464: v_wlji_process_status(v_index) := 3; --ERROR
2465: v_wlji_err_code(v_index) := -1;
2466: fnd_message.set_name(p_product, p_message_name);
2467: x_err_msg := fnd_message.get;
2468: v_wlji_err_msg(v_index) := x_err_msg;
2469: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| stmt_number||' '||x_err_msg);
2470: fnd_file.new_line(fnd_file.log, 3);
2471:

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

4374: -- P_ORGANIZATION_ID => v_wlji_org(v_index)
4375: -- );
4376:
4377: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4378: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4379: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4380: -- l_err_msg := fnd_message.get;
4381: -- l_error_code := -1;
4382: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);

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

4375: -- );
4376:
4377: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4378: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4379: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4380: -- l_err_msg := fnd_message.get;
4381: -- l_error_code := -1;
4382: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4383: -- l_error_code := -1;

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

4376:
4377: --IF (l_return_value > 0 OR l_return_value <> 0) THEN
4378: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
4379: -- FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
4380: -- l_err_msg := fnd_message.get;
4381: -- l_error_code := -1;
4382: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4383: -- l_error_code := -1;
4384: -- GOTO skip_job_id_valid;

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

4666: -- this is to be called only for job creation.
4667: if v_wlji_load_type(v_index) = 5 then
4668: if RTRIM(v_wlji_description(v_index)) is NULL then
4669: l_date_text := fnd_date.date_to_charDT(sysdate) ;
4670: fnd_message.set_name('WIP','WIP_MLD_DESC');
4671: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4672: v_wlji_description(v_index) := FND_Message.get;
4673: else
4674: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));

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

4667: if v_wlji_load_type(v_index) = 5 then
4668: if RTRIM(v_wlji_description(v_index)) is NULL then
4669: l_date_text := fnd_date.date_to_charDT(sysdate) ;
4670: fnd_message.set_name('WIP','WIP_MLD_DESC');
4671: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4672: v_wlji_description(v_index) := FND_Message.get;
4673: else
4674: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));
4675: end if;

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

4668: if RTRIM(v_wlji_description(v_index)) is NULL then
4669: l_date_text := fnd_date.date_to_charDT(sysdate) ;
4670: fnd_message.set_name('WIP','WIP_MLD_DESC');
4671: fnd_message.set_token('LOAD_DATE', l_date_text, false) ;
4672: v_wlji_description(v_index) := FND_Message.get;
4673: else
4674: v_wlji_description(v_index) := RTRIM(v_wlji_description(v_index));
4675: end if;
4676:

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

4810: and NVL(mmtt2.locator_id, -9999) = NVL(v_wsli(v_wlji_source_line_id(v_index)).locator_id, -9999)
4811: );
4812: end if;
4813: If l_dummy <> 0 then
4814: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4815: FND_MESSAGE.SET_TOKEN('TABLE',
4816: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4817: ||'Table: mtl_transaction_lots_temp ');
4818: l_err_msg := fnd_message.get;

Line 4815: FND_MESSAGE.SET_TOKEN('TABLE',

4811: );
4812: end if;
4813: If l_dummy <> 0 then
4814: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4815: FND_MESSAGE.SET_TOKEN('TABLE',
4816: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4817: ||'Table: mtl_transaction_lots_temp ');
4818: l_err_msg := fnd_message.get;
4819: l_error_code := -1;

Line 4818: l_err_msg := fnd_message.get;

4814: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4815: FND_MESSAGE.SET_TOKEN('TABLE',
4816: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4817: ||'Table: mtl_transaction_lots_temp ');
4818: l_err_msg := fnd_message.get;
4819: l_error_code := -1;
4820: HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4821: END IF;
4822:

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

4931: exception
4932: -- BA: BUGFIX 2380517
4933: when no_data_found then
4934: l_error_code := -1;
4935: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
4936: l_err_msg := fnd_message.get;
4937: handle_error(l_error_code, l_err_msg, l_stmt_num);
4938: --EA: BUGFIX 2380517
4939:

Line 4936: l_err_msg := fnd_message.get;

4932: -- BA: BUGFIX 2380517
4933: when no_data_found then
4934: l_error_code := -1;
4935: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
4936: l_err_msg := fnd_message.get;
4937: handle_error(l_error_code, l_err_msg, l_stmt_num);
4938: --EA: BUGFIX 2380517
4939:
4940: when others then

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

5191: exception
5192: -- BA: BUGFIX 2380517
5193: when no_data_found then
5194: l_error_code := -1;
5195: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
5196: l_err_msg := fnd_message.get;
5197: handle_error(l_error_code, l_err_msg, l_stmt_num);
5198: --EA: BUGFIX 2380517
5199: when others then

Line 5196: l_err_msg := fnd_message.get;

5192: -- BA: BUGFIX 2380517
5193: when no_data_found then
5194: l_error_code := -1;
5195: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
5196: l_err_msg := fnd_message.get;
5197: handle_error(l_error_code, l_err_msg, l_stmt_num);
5198: --EA: BUGFIX 2380517
5199: when others then
5200: l_error_code := -1;

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

5235: v_wlji_routing_revision_date(v_index),
5236: l_error_code,
5237: l_err_msg) = 1)
5238: then
5239: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
5240: l_err_msg := fnd_message.get;
5241: l_warning_count := l_warning_count + 1;
5242: handle_warning(p_err_msg => l_err_msg,
5243: p_header_id => v_wlji_header_id(v_index),

Line 5240: l_err_msg := fnd_message.get;

5236: l_error_code,
5237: l_err_msg) = 1)
5238: then
5239: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
5240: l_err_msg := fnd_message.get;
5241: l_warning_count := l_warning_count + 1;
5242: handle_warning(p_err_msg => l_err_msg,
5243: p_header_id => v_wlji_header_id(v_index),
5244: p_request_id => v_wlji_request_id(v_index),

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

6331: -- and trunc(nvl(v_wlji_date_released(v_index),sysdate)) between PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
6332: -- and period_close_date is NULL;
6333: --exception
6334: -- when NO_DATA_FOUND then
6335: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
6336: -- l_err_msg := fnd_message.get;
6337: -- l_error_code := -1;
6338: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
6339: -- GOTO skip_resched_validations;

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

6332: -- and period_close_date is NULL;
6333: --exception
6334: -- when NO_DATA_FOUND then
6335: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
6336: -- l_err_msg := fnd_message.get;
6337: -- l_error_code := -1;
6338: -- HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
6339: -- GOTO skip_resched_validations;
6340: -- when others then

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

6379: v_wlji_wip_entity_id(v_index),
6380: null,
6381: v_wlji_org(v_index),
6382: null, 5) then
6383: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
6384: l_err_msg := fnd_message.get;
6385: l_warning_count := l_warning_count + 1;
6386: handle_warning(p_err_msg => l_err_msg,
6387: p_header_id => v_wlji_header_id(v_index),

Line 6384: l_err_msg := fnd_message.get;

6380: null,
6381: v_wlji_org(v_index),
6382: null, 5) then
6383: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
6384: l_err_msg := fnd_message.get;
6385: l_warning_count := l_warning_count + 1;
6386: handle_warning(p_err_msg => l_err_msg,
6387: p_header_id => v_wlji_header_id(v_index),
6388: p_request_id => v_wlji_request_id(v_index),

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

6422:
6423: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6424: v_wlji_process_status(v_index) := 3; --ERROR
6425: v_wlji_err_code(v_index) := -1;
6426: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6427: fnd_message.set_token('CC', l_temp_cc);
6428: v_wlji_err_msg(v_index) := fnd_message.get;
6429: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6430: fnd_file.new_line(fnd_file.log, 3);

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

6423: if p_est_scrap_account is null or p_est_scrap_var_account is null then
6424: v_wlji_process_status(v_index) := 3; --ERROR
6425: v_wlji_err_code(v_index) := -1;
6426: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6427: fnd_message.set_token('CC', l_temp_cc);
6428: v_wlji_err_msg(v_index) := fnd_message.get;
6429: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6430: fnd_file.new_line(fnd_file.log, 3);
6431: l_error_code := -1;

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

6424: v_wlji_process_status(v_index) := 3; --ERROR
6425: v_wlji_err_code(v_index) := -1;
6426: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6427: fnd_message.set_token('CC', l_temp_cc);
6428: v_wlji_err_msg(v_index) := fnd_message.get;
6429: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6430: fnd_file.new_line(fnd_file.log, 3);
6431: l_error_code := -1;
6432: GOTO skip_resched_validations;

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

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

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

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

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

6435: v_wlji_process_status(v_index) := 3; --ERROR
6436: v_wlji_err_code(v_index) := -1;
6437: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
6438: fnd_message.set_token('CC', l_temp_cc);
6439: v_wlji_err_msg(v_index) := fnd_message.get;
6440: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' ' ||v_wlji_err_msg(v_index));
6441: fnd_file.new_line(fnd_file.log, 3);
6442: l_error_code := -1;
6443: GOTO skip_resched_validations;

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

6968:
6969: if l_scrap_account10 is null or l_est_scrap_abs_account10 is null then
6970: v_wlji_process_status(v_index) := 3; --ERROR
6971: v_wlji_err_code(v_index) := -1;
6972: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6973: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6974: v_wlji_err_msg(v_index) := fnd_message.get;
6975: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6976: fnd_file.new_line(fnd_file.log, 3);

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

6969: if l_scrap_account10 is null or l_est_scrap_abs_account10 is null then
6970: v_wlji_process_status(v_index) := 3; --ERROR
6971: v_wlji_err_code(v_index) := -1;
6972: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6973: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6974: v_wlji_err_msg(v_index) := fnd_message.get;
6975: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6976: fnd_file.new_line(fnd_file.log, 3);
6977: l_error_code := -1;

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

6970: v_wlji_process_status(v_index) := 3; --ERROR
6971: v_wlji_err_code(v_index) := -1;
6972: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
6973: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
6974: v_wlji_err_msg(v_index) := fnd_message.get;
6975: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
6976: fnd_file.new_line(fnd_file.log, 3);
6977: l_error_code := -1;
6978: l_error_count := l_error_count + 1;

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

7003:
7004: if l_scrap_account9999 is null or l_est_scrap_abs_account9999 is null then
7005: v_wlji_process_status(v_index) := 3; --ERROR
7006: v_wlji_err_code(v_index) := -1;
7007: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7008: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7009: v_wlji_err_msg(v_index) := fnd_message.get;
7010: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7011: fnd_file.new_line(fnd_file.log, 3);

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

7004: if l_scrap_account9999 is null or l_est_scrap_abs_account9999 is null then
7005: v_wlji_process_status(v_index) := 3; --ERROR
7006: v_wlji_err_code(v_index) := -1;
7007: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7008: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7009: v_wlji_err_msg(v_index) := fnd_message.get;
7010: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7011: fnd_file.new_line(fnd_file.log, 3);
7012: l_error_code := -1;

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

7005: v_wlji_process_status(v_index) := 3; --ERROR
7006: v_wlji_err_code(v_index) := -1;
7007: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
7008: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
7009: v_wlji_err_msg(v_index) := fnd_message.get;
7010: fnd_file.put_line(fnd_file.log, 'stmt_num: '|| l_stmt_num ||' '||v_wlji_err_msg(v_index));
7011: fnd_file.new_line(fnd_file.log, 3);
7012: l_error_code := -1;
7013: l_error_count := l_error_count + 1;

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

7055: if wip_osp.po_req_exists ( v_wlji_wip_entity_id(v_index),
7056: null,
7057: v_wlji_org(v_index),
7058: null, 5) then
7059: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
7060: l_err_msg := fnd_message.get;
7061: l_warning_count := l_warning_count + 1;
7062: handle_warning( p_err_msg => l_err_msg,
7063: p_header_id => v_wlji_header_id(v_index),

Line 7060: l_err_msg := fnd_message.get;

7056: null,
7057: v_wlji_org(v_index),
7058: null, 5) then
7059: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
7060: l_err_msg := fnd_message.get;
7061: l_warning_count := l_warning_count + 1;
7062: handle_warning( p_err_msg => l_err_msg,
7063: p_header_id => v_wlji_header_id(v_index),
7064: p_request_id => v_wlji_request_id(v_index),

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

7118: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
7119:
7120: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
7121: l_error_code := -1;
7122: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7123:
7124: select meaning
7125: into translated_meaning
7126: from mfg_lookups

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

7127: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7128: and lookup_code = 7
7129: and upper(enabled_flag) = 'Y';
7130:
7131: fnd_message.set_token('STATUS',translated_meaning);
7132: l_error_msg := fnd_message.get;
7133: handle_error(l_error_code, l_error_msg, l_stmt_num);
7134: l_error_count := l_error_count + 1;
7135: GOTO skip_other_steps;

Line 7132: l_error_msg := fnd_message.get;

7128: and lookup_code = 7
7129: and upper(enabled_flag) = 'Y';
7130:
7131: fnd_message.set_token('STATUS',translated_meaning);
7132: l_error_msg := fnd_message.get;
7133: handle_error(l_error_code, l_error_msg, l_stmt_num);
7134: l_error_count := l_error_count + 1;
7135: GOTO skip_other_steps;
7136: end if;

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

7546: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
7547:
7548: if ( l_returnStatus <> fnd_api.g_ret_sts_success ) then
7549: l_error_code := -1;
7550: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7551: select meaning
7552: into translated_meaning
7553: from mfg_lookups
7554: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'

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

7554: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7555: and lookup_code = 7
7556: and upper(enabled_flag) = 'Y';
7557:
7558: fnd_message.set_token('STATUS',translated_meaning);
7559: l_error_msg := fnd_message.get;
7560: handle_error(l_error_code, l_error_msg, l_stmt_num);
7561: l_error_count := l_error_count + 1;
7562: end if;

Line 7559: l_error_msg := fnd_message.get;

7555: and lookup_code = 7
7556: and upper(enabled_flag) = 'Y';
7557:
7558: fnd_message.set_token('STATUS',translated_meaning);
7559: l_error_msg := fnd_message.get;
7560: handle_error(l_error_code, l_error_msg, l_stmt_num);
7561: l_error_count := l_error_count + 1;
7562: end if;
7563: