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.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on FND_API

Line 535: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),

531: attribute12 = NVL(cur_row.attribute12,attribute12),
532: attribute13 = NVL(cur_row.attribute13,attribute13),
533: attribute14 = NVL(cur_row.attribute14,attribute14),
534: attribute15 = NVL(cur_row.attribute15,attribute15),
535: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
536: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
537: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, cur_row.replacement_group_num),
538: firm_flag = NVL(cur_row.firm_flag, firm_flag),
539: setup_id = NVL(cur_row.setup_id, setup_id),

Line 536: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),

532: attribute13 = NVL(cur_row.attribute13,attribute13),
533: attribute14 = NVL(cur_row.attribute14,attribute14),
534: attribute15 = NVL(cur_row.attribute15,attribute15),
535: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
536: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
537: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, cur_row.replacement_group_num),
538: firm_flag = NVL(cur_row.firm_flag, firm_flag),
539: setup_id = NVL(cur_row.setup_id, setup_id),
540: group_sequence_id = NVL(cur_row.group_sequence_id, group_sequence_id),

Line 537: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, cur_row.replacement_group_num),

533: attribute14 = NVL(cur_row.attribute14,attribute14),
534: attribute15 = NVL(cur_row.attribute15,attribute15),
535: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
536: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
537: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, cur_row.replacement_group_num),
538: firm_flag = NVL(cur_row.firm_flag, firm_flag),
539: setup_id = NVL(cur_row.setup_id, setup_id),
540: group_sequence_id = NVL(cur_row.group_sequence_id, group_sequence_id),
541: group_sequence_number = NVL(cur_row.group_sequence_number, group_sequence_number),

Line 1000: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),

996: attribute12 = NVL(cur_row.attribute12,attribute12),
997: attribute13 = NVL(cur_row.attribute13,attribute13),
998: attribute14 = NVL(cur_row.attribute14,attribute14),
999: attribute15 = NVL(cur_row.attribute15,attribute15),
1000: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
1001: substitute_group_num = cur_row.substitute_group_num,
1002: replacement_group_num = cur_row.replacement_group_num
1003: WHERE wip_entity_id = p_wip_entity_id
1004: AND organization_id = p_organization_id

Line 1276: x_return_status := fnd_api.g_ret_sts_success;

1272: x_return_status VARCHAR(1);
1273: x_msg_data VARCHAR(2000);
1274: l_dummy VARCHAR(1);
1275: BEGIN
1276: x_return_status := fnd_api.g_ret_sts_success;
1277:
1278: begin
1279: FOR cur_row IN req_info(p_group_id,
1280: p_wip_entity_id,

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

1292: p_wip_entity_type => wip_constants.discrete,
1293: x_return_status => x_return_status,
1294: x_msg_data => x_msg_data);
1295:
1296: if (x_return_status <> fnd_api.g_ret_sts_success) then
1297: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1298: end if;
1299:
1300: END LOOP;

Line 1297: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1293: x_return_status => x_return_status,
1294: x_msg_data => x_msg_data);
1295:
1296: if (x_return_status <> fnd_api.g_ret_sts_success) then
1297: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1298: end if;
1299:
1300: END LOOP;
1301: exception

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

1531: p_new_component_qty => cur_row.required_quantity,
1532: p_inventory_item_id => cur_row.inventory_item_id_old,
1533: x_return_status => x_return_status,
1534: x_msg_data => x_msg_data);
1535: if (x_return_status <> fnd_api.g_ret_sts_success) then
1536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1537: end if;
1538:
1539: elsif ( (l_wip_supply_type <> cur_row.wip_supply_type or

Line 1536: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1532: p_inventory_item_id => cur_row.inventory_item_id_old,
1533: x_return_status => x_return_status,
1534: x_msg_data => x_msg_data);
1535: if (x_return_status <> fnd_api.g_ret_sts_success) then
1536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1537: end if;
1538:
1539: elsif ( (l_wip_supply_type <> cur_row.wip_supply_type or
1540: l_supply_subinventory <> cur_row.supply_subinventory or

Line 1585: /* LBM Project: if user wants to change the basis_type to null (item basis), he needs to insert fnd_api.g_miss_num into interface table. This should be in the interface user guide */

1581: quantity_per_assembly),
1582: component_yield_factor = NVL(cur_row.component_yield_factor,
1583: component_yield_factor),/*Component Yield Enhancement(Bug 4369064)*/
1584:
1585: /* LBM Project: if user wants to change the basis_type to null (item basis), he needs to insert fnd_api.g_miss_num into interface table. This should be in the interface user guide */
1586: /* Bug 5468646 - update component basis */
1587: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),
1588: last_update_date = sysdate,/*BUG 6721823*/
1589: last_updated_by = cur_row.last_updated_by,

Line 1587: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),

1583: component_yield_factor),/*Component Yield Enhancement(Bug 4369064)*/
1584:
1585: /* LBM Project: if user wants to change the basis_type to null (item basis), he needs to insert fnd_api.g_miss_num into interface table. This should be in the interface user guide */
1586: /* Bug 5468646 - update component basis */
1587: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),
1588: last_update_date = sysdate,/*BUG 6721823*/
1589: last_updated_by = cur_row.last_updated_by,
1590: creation_date = cur_row.creation_date,
1591: created_by = cur_row.created_by,

Line 1616: fnd_api.g_miss_char,

1612: 1, --push
1613: decode(cur_row.supply_subinventory,
1614: NULL,
1615: supply_subinventory,
1616: fnd_api.g_miss_char,
1617: NULL,
1618: cur_row.supply_subinventory),
1619: nvl(cur_row.supply_subinventory, supply_subinventory)),
1620: supply_locator_id = decode(nvl(cur_row.wip_supply_type, 4),

Line 1625: fnd_api.g_miss_num,

1621: 1, --push
1622: decode(cur_row.supply_locator_id,
1623: NULL,
1624: supply_locator_id,
1625: fnd_api.g_miss_num,
1626: NULL,
1627: cur_row.supply_locator_id),
1628: nvl(cur_row.supply_locator_id, supply_locator_id)),
1629: mrp_net_flag = NVL(cur_row.mrp_net_flag,

Line 1732: x_return_status := FND_API.G_RET_STS_ERROR;

1728: p_wip_entity_id IS NULL THEN
1729:
1730: x_err_code := SQLCODE;
1731: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: return;
1734: END IF;
1735:
1736: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP

Line 2081: x_return_status := FND_API.G_RET_STS_ERROR;

2077: END LOOP;
2078:
2079: exception
2080: when others then
2081: x_return_status := FND_API.G_RET_STS_ERROR;
2082: x_err_code := SQLCODE;
2083: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2084: return;
2085: end;

Line 2136: x_return_status := FND_API.G_RET_STS_ERROR;

2132: p_wip_entity_id IS NULL THEN
2133:
2134: x_err_code := SQLCODE;
2135: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: return;
2138: END IF;
2139:
2140: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP

Line 2274: x_return_status := FND_API.G_RET_STS_ERROR;

2270: END LOOP;
2271:
2272: exception
2273: when others then
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: x_err_code := SQLCODE;
2276: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2277: return;
2278: end;

Line 2388: x_return_status := FND_API.G_RET_STS_ERROR;

2384: end if;
2385:
2386: Exception
2387: when others then
2388: x_return_status := FND_API.G_RET_STS_ERROR;
2389: x_err_msg := 'ERROR IN WIPJDSTB.VERIFY_OPERATION: ' || SQLERRM;
2390: x_err_code := to_char(SQLCODE);
2391: return;
2392:

Line 2494: x_return_status := FND_API.G_RET_STS_ERROR;

2490: IF p_group_id IS NULL OR p_organization_id IS NULL OR p_wip_entity_id IS NULL
2491: OR p_operation_seq_num IS NULL OR p_resource_seq_num IS NULL THEN
2492: x_err_code := SQLCODE;
2493: x_err_msg := 'Error in wiprustb.pls: Primary key cannot be null!';
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495: return;
2496: END IF;
2497:
2498: /************************************************************************

Line 2569: x_return_status := FND_API.G_RET_STS_ERROR;

2565: exception
2566: When others then
2567: x_err_code := SQLCODE;
2568: x_err_msg := 'Error in wipjdstb: '|| SQLERRM;
2569: x_return_status := FND_API.G_RET_STS_ERROR;
2570: return;
2571: end;
2572:
2573: END Sub_Usage;

Line 2842: x_return_status := FND_API.G_RET_STS_ERROR;

2838: p_wip_entity_id IS NULL THEN
2839:
2840: x_err_code := SQLCODE;
2841: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2842: x_return_status := FND_API.G_RET_STS_ERROR;
2843: return;
2844: END IF;
2845:
2846: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

2850: p_wip_entity_id => p_wip_entity_id,
2851: p_operation_seq_num => null,
2852: p_intraoperation_step_type => null,
2853: x_return_status => x_return_status);
2854: if(x_return_status <> fnd_api.g_ret_sts_success) then
2855: rollback to wipjdstb10;
2856: wip_utilities.get_message_stack(p_msg => x_err_msg);
2857: exit;
2858: end if;

Line 2862: x_return_status := FND_API.G_RET_STS_ERROR;

2858: end if;
2859: end loop;
2860: exception
2861: when others then
2862: x_return_status := FND_API.G_RET_STS_ERROR;
2863: x_err_code := SQLCODE;
2864: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2865:
2866: END Add_Serial_Association;

Line 2903: x_return_status := FND_API.G_RET_STS_ERROR;

2899: p_wip_entity_id IS NULL THEN
2900:
2901: x_err_code := SQLCODE;
2902: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2903: x_return_status := FND_API.G_RET_STS_ERROR;
2904: return;
2905: END IF;
2906:
2907: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

2911: p_wip_entity_id => p_wip_entity_id,
2912: p_operation_seq_num => null,
2913: p_intraoperation_step_type => null,
2914: x_return_status => x_return_status);
2915: if(x_return_status <> fnd_api.g_ret_sts_success) then
2916: rollback to wipjdstb20;
2917: wip_utilities.get_message_stack(p_msg => x_err_msg);
2918: exit;
2919: end if;

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

2924: p_wip_entity_id => null,
2925: p_operation_seq_num => null,
2926: p_intraoperation_step_type => null,
2927: x_return_status => x_return_status);
2928: if(x_return_status <> fnd_api.g_ret_sts_success) then
2929: wip_utilities.get_message_stack(p_msg => x_err_msg);
2930: exit;
2931: end if;
2932:

Line 2937: x_return_status := FND_API.G_RET_STS_ERROR;

2933: end loop;
2934:
2935: exception
2936: when others then
2937: x_return_status := FND_API.G_RET_STS_ERROR;
2938: x_err_code := SQLCODE;
2939: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2940: END Change_Serial_Association;
2941:

Line 2976: x_return_status := FND_API.G_RET_STS_ERROR;

2972: p_wip_entity_id IS NULL THEN
2973:
2974: x_err_code := SQLCODE;
2975: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2976: x_return_status := FND_API.G_RET_STS_ERROR;
2977: return;
2978: END IF;
2979:
2980: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

2984: p_wip_entity_id => null,
2985: p_operation_seq_num => null,
2986: p_intraoperation_step_type => null,
2987: x_return_status => x_return_status);
2988: if(x_return_status <> fnd_api.g_ret_sts_success) then
2989: rollback to wipjdstb30;
2990: wip_utilities.get_message_stack(p_msg => x_err_msg);
2991: exit;
2992: end if;

Line 2996: x_return_status := FND_API.G_RET_STS_ERROR;

2992: end if;
2993: end loop;
2994: exception
2995: when others then
2996: x_return_status := FND_API.G_RET_STS_ERROR;
2997: x_err_code := SQLCODE;
2998: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2999: END Delete_Serial_Association;
3000:

Line 3017: x_return_status := fnd_api.g_ret_sts_success;

3013: l_serialization_start_op NUMBER;
3014: l_load_type NUMBER;
3015:
3016: begin
3017: x_return_status := fnd_api.g_ret_sts_success;
3018:
3019: select default_wip_auto_assoc_sn
3020: into l_defaultSN
3021: from wip_parameters