DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_API

Line 7390: l_return_status := FND_API.G_RET_STS_SUCCESS;

7386: l_error_code := 0;
7387: l_return_value := 0;
7388: l_error_msg:= NULL;
7389: l_aux_mesg:= NULL;
7390: l_return_status := FND_API.G_RET_STS_SUCCESS;
7391: l_temp_num:= 0;
7392: l_xst:= true;
7393: hash_str := '';
7394: hash_value := 0;

Line 7892: v_wlji_schedule_group_id(v_idx) <> fnd_api.g_miss_num) then

7888: end if;
7889:
7890: -- Start Bug Fix : 6676148
7891: if (v_wlji_schedule_group_id(v_idx) is not NULL and
7892: v_wlji_schedule_group_id(v_idx) <> fnd_api.g_miss_num) then
7893: l_stmt_num := 170.3;
7894: begin
7895: select 1
7896: into l_temp_num

Line 7987: v_wlji_schedule_group_id(v_idx) <> fnd_api.g_miss_num) then

7983: := NVL(v_wlji_schedule_group_id(v_idx), l_cur_schedule_group_id);
7984: end if;
7985:
7986: if (v_wlji_schedule_group_id(v_idx) is not NULL and
7987: v_wlji_schedule_group_id(v_idx) <> fnd_api.g_miss_num) then
7988: l_stmt_num := 170.5;
7989: begin
7990: select 1
7991: into l_temp_num

Line 11249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

11245: NULL,
11246: l_return_status,
11247: l_error_msg);
11248:
11249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
11250: handle_error(l_return_status, l_error_msg, l_stmt_num);
11251: l_error_count := l_error_count + 1;
11252: GOTO abort_this_job;
11253: else

Line 11275: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

11271: x_return_status => l_return_status,
11272: x_msg_count => l_error_count,
11273: x_msg_data => l_error_msg
11274: );
11275: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
11276: handle_error(l_return_status, l_error_msg, l_stmt_num);
11277: l_error_count := l_error_count + 1;
11278: GOTO abort_this_job;
11279: end if;

Line 11296: l_return_status := FND_API.G_RET_STS_ERROR;

11292: x_error_code => l_error_code,
11293: x_error_msg => l_error_msg);
11294:
11295: if l_error_code <> 0 then
11296: l_return_status := FND_API.G_RET_STS_ERROR;
11297: handle_error(l_return_status, l_error_msg, l_stmt_num);
11298: l_error_count := l_error_count + 1;
11299: GOTO abort_this_job;
11300: end if;

Line 11321: if ( l_return_status <> fnd_api.g_ret_sts_success ) then

11317: x_return_status => l_return_status,
11318: p_kanban_card_id => v_wlji_kanban_card_id(v_idx),
11319: p_supply_status => inv_kanban_pvt.g_supply_status_exception);
11320:
11321: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11322: l_error_code := -1;
11323: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11324: l_stmt_num := 960.1;
11325: select meaning

Line 11376: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

11372: x_return_status => l_return_status,
11373: x_msg_count => l_error_count,
11374: x_msg_data => l_error_msg
11375: );
11376: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
11377: handle_error(l_return_status, l_error_msg, l_stmt_num);
11378: l_error_count := l_error_count + 1;
11379: GOTO abort_this_job;
11380: end if;

Line 11451: schedule_group_id = decode(v_wlji_schedule_group_id(v_idx),fnd_api.g_miss_num,null,v_wlji_schedule_group_id(v_idx)) -- Bug : 6676148

11447: -- EA: BUG3272873
11448: est_scrap_account = nvl(l_est_scrap_account, wdj.est_scrap_account),
11449: est_scrap_var_account = nvl(l_est_scrap_var_account, wdj.est_scrap_var_account),
11450: description = nvl(RTRIM(v_wlji_description(v_idx)), wdj.description),
11451: schedule_group_id = decode(v_wlji_schedule_group_id(v_idx),fnd_api.g_miss_num,null,v_wlji_schedule_group_id(v_idx)) -- Bug : 6676148
11452: -- CZHDBG: how about fusd and lucd ???
11453: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx);
11454:
11455: end if; -- update jobs for which status is not cancelled

Line 11550: p_initmsglist => fnd_api.g_true,

11546: l_end_date := v_wlji_lucd(v_idx);
11547: end if;
11548:
11549: wsm_infinite_scheduler_pvt.schedule (
11550: p_initmsglist => fnd_api.g_true,
11551: p_enddebug => fnd_api.g_true,
11552: p_orgID => v_wlji_org_id(v_idx),
11553: p_wipEntityID => v_wlji_wip_entity_id(v_idx),
11554: p_scheduleMode => l_scheduling_mode,

Line 11551: p_enddebug => fnd_api.g_true,

11547: end if;
11548:
11549: wsm_infinite_scheduler_pvt.schedule (
11550: p_initmsglist => fnd_api.g_true,
11551: p_enddebug => fnd_api.g_true,
11552: p_orgID => v_wlji_org_id(v_idx),
11553: p_wipEntityID => v_wlji_wip_entity_id(v_idx),
11554: p_scheduleMode => l_scheduling_mode,
11555: p_startDate => l_start_date,

Line 11562: if(l_returnstatus <> fnd_api.g_ret_sts_success) then

11558: p_resSeqNum => null,
11559: x_returnstatus => l_returnstatus,
11560: x_errorMsg => l_error_msg
11561: );
11562: if(l_returnstatus <> fnd_api.g_ret_sts_success) then
11563: handle_error(-1, l_error_msg, l_stmt_num);
11564: l_error_count := l_error_count + 1;
11565: goto abort_this_job;
11566: end if;

Line 11679: if l_return_status = FND_API.G_RET_STS_SUCCESS then

11675: x_error_msg => l_err_msg
11676: );
11677: l_stmt_num := 995.2;
11678:
11679: if l_return_status = FND_API.G_RET_STS_SUCCESS then
11680: IF (lbji_debug='Y') THEN
11681: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.LBJ_serial_intf_proc returned Success');
11682: END IF;
11683: ELSE

Line 11693: p_encoded => FND_API.G_FALSE

11689: handle_error(-1, l_err_msg, l_stmt_num);
11690: ELSIF (l_msg_count > 1) THEN
11691: FOR i IN 1..l_msg_count LOOP
11692: l_err_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,
11693: p_encoded => FND_API.G_FALSE
11694: );
11695: handle_error(-1, l_err_msg, l_stmt_num);
11696: END LOOP;
11697: ELSE

Line 11946: if ( l_return_status <> fnd_api.g_ret_sts_success ) then

11942: x_return_status => l_return_status,
11943: p_Kanban_Card_Id => v_wlji_kanban_card_id(v_idx),
11944: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
11945:
11946: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11947: l_error_code := -1;
11948: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11949: select meaning
11950: into l_meaning

Line 18538: if(l_status <> fnd_api.g_ret_sts_success) then

18534: x_status => l_status,
18535: x_msg_count => l_msg_count,
18536: x_msg_data => p_error_msg);
18537:
18538: if(l_status <> fnd_api.g_ret_sts_success) then
18539: p_error_code := -1;
18540: p_error_msg := 'Error: WIP_SUB_OP_RESOURCES_PKG.REPLACE_RESOURCES ' || p_error_msg;
18541: raise e_wljdi_common_error;
18542: end if;

Line 19977: if (x_return_status <> fnd_api.g_ret_sts_success) then

19973: p_wip_entity_type => WIP_CONSTANTS.LOTBASED,
19974: x_return_status => x_return_status,
19975: x_msg_data => p_error_msg);
19976:
19977: if (x_return_status <> fnd_api.g_ret_sts_success) then
19978: raise e_wljdi_common_error;
19979: end if;
19980:
19981: ELSIF (l_sub_type=WSM_SUB_ADD) then

Line 21987: if ( l_return_status <> fnd_api.g_ret_sts_success ) then

21983: p_document_header_id => p_wip_entity_id,
21984: p_Document_detail_Id => null,
21985: p_replenish_quantity => p_start_quantity);
21986:
21987: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
21988: select meaning
21989: into l_translated_meaning
21990: from mfg_lookups
21991: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'