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 541: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),

537: attribute12 = NVL(cur_row.attribute12,attribute12),
538: attribute13 = NVL(cur_row.attribute13,attribute13),
539: attribute14 = NVL(cur_row.attribute14,attribute14),
540: attribute15 = NVL(cur_row.attribute15,attribute15),
541: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
542: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
543: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, nvl(cur_row.replacement_group_num,0)),
544: firm_flag = NVL(cur_row.firm_flag, firm_flag),
545: setup_id = NVL(cur_row.setup_id, setup_id),

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

538: attribute13 = NVL(cur_row.attribute13,attribute13),
539: attribute14 = NVL(cur_row.attribute14,attribute14),
540: attribute15 = NVL(cur_row.attribute15,attribute15),
541: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
542: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
543: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, nvl(cur_row.replacement_group_num,0)),
544: firm_flag = NVL(cur_row.firm_flag, firm_flag),
545: setup_id = NVL(cur_row.setup_id, setup_id),
546: group_sequence_id = NVL(cur_row.group_sequence_id, group_sequence_id),

Line 543: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, nvl(cur_row.replacement_group_num,0)),

539: attribute14 = NVL(cur_row.attribute14,attribute14),
540: attribute15 = NVL(cur_row.attribute15,attribute15),
541: schedule_seq_num = decode(cur_row.schedule_seq_num, fnd_api.g_miss_num, null, cur_row.schedule_seq_num),
542: substitute_group_num = decode(cur_row.substitute_group_num, fnd_api.g_miss_num, null, cur_row.substitute_group_num),
543: replacement_group_num = decode(cur_row.replacement_group_num, fnd_api.g_miss_num, null, nvl(cur_row.replacement_group_num,0)),
544: firm_flag = NVL(cur_row.firm_flag, firm_flag),
545: setup_id = NVL(cur_row.setup_id, setup_id),
546: group_sequence_id = NVL(cur_row.group_sequence_id, group_sequence_id),
547: group_sequence_number = NVL(cur_row.group_sequence_number, group_sequence_number),

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

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

Line 1279: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 1300: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1539: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1588: /* 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 */

1584: quantity_per_assembly),
1585: component_yield_factor = NVL(cur_row.component_yield_factor,
1586: component_yield_factor),/*Component Yield Enhancement(Bug 4369064)*/
1587:
1588: /* 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 */
1589: /* Bug 5468646 - update component basis */
1590: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),
1591: last_update_date = sysdate,/*BUG 6721823*/
1592: /*FP BUG 13406111 :BUG 12814417 @Start */

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

1586: component_yield_factor),/*Component Yield Enhancement(Bug 4369064)*/
1587:
1588: /* 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 */
1589: /* Bug 5468646 - update component basis */
1590: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),
1591: last_update_date = sysdate,/*BUG 6721823*/
1592: /*FP BUG 13406111 :BUG 12814417 @Start */
1593: last_updated_by = fnd_global.user_id,
1594: -- creation_date = cur_row.creation_date,

Line 1613: Null them if fnd_api.g_miss_char and g_miss_num are passed

1609: required_quantity = NVL(cur_row.required_quantity,
1610: required_quantity),
1611: /* Bug 4887280 - modify decode statement for supply_subinventory, and supply_locator */
1612: /*Fix for Bug 6860572(FP 6795337): For push components, if null is passed, retain the original subinventory values.
1613: Null them if fnd_api.g_miss_char and g_miss_num are passed
1614: For Pull components do not allow the inventory to be nulled.*/
1615: supply_subinventory = Decode(NVL(cur_row.wip_supply_type, wip_supply_type),
1616: 2, Decode(cur_row.supply_subinventory,
1617: NULL,

Line 1619: fnd_api.g_miss_char,

1615: supply_subinventory = Decode(NVL(cur_row.wip_supply_type, wip_supply_type),
1616: 2, Decode(cur_row.supply_subinventory,
1617: NULL,
1618: supply_subinventory,
1619: fnd_api.g_miss_char,
1620: supply_subinventory,
1621: cur_row.supply_subinventory),
1622: 3, Decode(cur_row.supply_subinventory,
1623: NULL,

Line 1625: fnd_api.g_miss_char,

1621: cur_row.supply_subinventory),
1622: 3, Decode(cur_row.supply_subinventory,
1623: NULL,
1624: supply_subinventory,
1625: fnd_api.g_miss_char,
1626: supply_subinventory,
1627: cur_row.supply_subinventory),
1628: Decode(cur_row.supply_subinventory,
1629: NULL,

Line 1631: fnd_api.g_miss_char,

1627: cur_row.supply_subinventory),
1628: Decode(cur_row.supply_subinventory,
1629: NULL,
1630: supply_subinventory,
1631: fnd_api.g_miss_char,
1632: NULL,
1633: cur_row.supply_subinventory)),
1634:
1635: supply_locator_id = Decode(cur_row.supply_subinventory,

Line 1638: fnd_api.g_miss_char,

1634:
1635: supply_locator_id = Decode(cur_row.supply_subinventory,
1636: NULL,
1637: supply_locator_id,
1638: fnd_api.g_miss_char,
1639: Decode(NVL(cur_row.wip_supply_type, wip_supply_type),
1640: 2, supply_locator_id,
1641: 3, supply_locator_id,
1642: NULL),

Line 1644: fnd_api.g_miss_num,

1640: 2, supply_locator_id,
1641: 3, supply_locator_id,
1642: NULL),
1643: Decode(cur_row.supply_locator_id,
1644: fnd_api.g_miss_num,
1645: NULL,
1646: NULL,
1647: supply_locator_id, --Bug#16064426: Supply_locator_id should be updated to null only when fnd_api.g_miss_num is populated
1648: cur_row.supply_locator_id)),

Line 1647: supply_locator_id, --Bug#16064426: Supply_locator_id should be updated to null only when fnd_api.g_miss_num is populated

1643: Decode(cur_row.supply_locator_id,
1644: fnd_api.g_miss_num,
1645: NULL,
1646: NULL,
1647: supply_locator_id, --Bug#16064426: Supply_locator_id should be updated to null only when fnd_api.g_miss_num is populated
1648: cur_row.supply_locator_id)),
1649:
1650: mrp_net_flag = NVL(cur_row.mrp_net_flag,
1651: mrp_net_flag),

Line 1658: comments = decode(cur_row.comments,fnd_api.g_miss_char,NULL,NVL( cur_row.comments, comments)), --FP of Bug# 14253442-Comments to be nulled out

1654: mps_date_required = NVL(cur_row.mps_date_required,
1655: mps_date_required),
1656: auto_request_material = NVL( cur_row.auto_request_material,
1657: auto_request_material),
1658: comments = decode(cur_row.comments,fnd_api.g_miss_char,NULL,NVL( cur_row.comments, comments)), --FP of Bug# 14253442-Comments to be nulled out
1659: attribute_category = NVL(cur_row.attribute_category,
1660: attribute_category),
1661: attribute1 = NVL(cur_row.attribute1,attribute1),
1662: attribute2 = NVL(cur_row.attribute2,attribute2),

Line 1758: x_return_status := FND_API.G_RET_STS_ERROR;

1754: p_wip_entity_id IS NULL THEN
1755:
1756: x_err_code := SQLCODE;
1757: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
1758: x_return_status := FND_API.G_RET_STS_ERROR;
1759: return;
1760: END IF;
1761:
1762: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP

Line 1846: x_return_status := FND_API.G_RET_STS_ERROR;

1842: and substitution_type = wip_job_details.wip_add;
1843:
1844: x_err_code := SQLCODE;
1845: x_err_msg := fnd_message.get;
1846: x_return_status := FND_API.G_RET_STS_ERROR;
1847: return;
1848: END IF;
1849: END IF;
1850: /* End Bug 9494799 */

Line 1888: x_return_status := FND_API.G_RET_STS_ERROR;

1884: and substitution_type = wip_job_details.wip_add;
1885:
1886: x_err_code := SQLCODE;
1887: x_err_msg := fnd_message.get;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: return;
1890: END IF;
1891: END IF;
1892: /* End for bug 9822688. */

Line 2199: x_return_status := FND_API.G_RET_STS_ERROR;

2195: END LOOP;
2196:
2197: exception
2198: when others then
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: x_err_code := SQLCODE;
2201: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2202: return;
2203: end;

Line 2259: x_return_status := FND_API.G_RET_STS_ERROR;

2255: p_wip_entity_id IS NULL THEN
2256:
2257: x_err_code := SQLCODE;
2258: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2259: x_return_status := FND_API.G_RET_STS_ERROR;
2260: return;
2261: END IF;
2262:
2263: FOR cur_oper IN oper_info(p_group_id,p_wip_entity_id,p_organization_id) LOOP

Line 2399: x_return_status := FND_API.G_RET_STS_ERROR;

2395: END LOOP;
2396:
2397: exception
2398: when others then
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: x_err_code := SQLCODE;
2401: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2402: return;
2403: end;

Line 2514: x_return_status := FND_API.G_RET_STS_ERROR;

2510: end if;
2511:
2512: Exception
2513: when others then
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: x_err_msg := 'ERROR IN WIPJDSTB.VERIFY_OPERATION: ' || SQLERRM;
2516: x_err_code := to_char(SQLCODE);
2517: return;
2518:

Line 2620: x_return_status := FND_API.G_RET_STS_ERROR;

2616: IF p_group_id IS NULL OR p_organization_id IS NULL OR p_wip_entity_id IS NULL
2617: OR p_operation_seq_num IS NULL OR p_resource_seq_num IS NULL THEN
2618: x_err_code := SQLCODE;
2619: x_err_msg := 'Error in wiprustb.pls: Primary key cannot be null!';
2620: x_return_status := FND_API.G_RET_STS_ERROR;
2621: return;
2622: END IF;
2623:
2624: /************************************************************************

Line 2695: x_return_status := FND_API.G_RET_STS_ERROR;

2691: exception
2692: When others then
2693: x_err_code := SQLCODE;
2694: x_err_msg := 'Error in wipjdstb: '|| SQLERRM;
2695: x_return_status := FND_API.G_RET_STS_ERROR;
2696: return;
2697: end;
2698:
2699: END Sub_Usage;

Line 2968: x_return_status := FND_API.G_RET_STS_ERROR;

2964: p_wip_entity_id IS NULL THEN
2965:
2966: x_err_code := SQLCODE;
2967: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
2968: x_return_status := FND_API.G_RET_STS_ERROR;
2969: return;
2970: END IF;
2971:
2972: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

2976: p_wip_entity_id => p_wip_entity_id,
2977: p_operation_seq_num => null,
2978: p_intraoperation_step_type => null,
2979: x_return_status => x_return_status);
2980: if(x_return_status <> fnd_api.g_ret_sts_success) then
2981: rollback to wipjdstb10;
2982: wip_utilities.get_message_stack(p_msg => x_err_msg);
2983: exit;
2984: end if;

Line 2988: x_return_status := FND_API.G_RET_STS_ERROR;

2984: end if;
2985: end loop;
2986: exception
2987: when others then
2988: x_return_status := FND_API.G_RET_STS_ERROR;
2989: x_err_code := SQLCODE;
2990: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
2991:
2992: END Add_Serial_Association;

Line 3029: x_return_status := FND_API.G_RET_STS_ERROR;

3025: p_wip_entity_id IS NULL THEN
3026:
3027: x_err_code := SQLCODE;
3028: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
3029: x_return_status := FND_API.G_RET_STS_ERROR;
3030: return;
3031: END IF;
3032:
3033: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

3037: p_wip_entity_id => p_wip_entity_id,
3038: p_operation_seq_num => null,
3039: p_intraoperation_step_type => null,
3040: x_return_status => x_return_status);
3041: if(x_return_status <> fnd_api.g_ret_sts_success) then
3042: rollback to wipjdstb20;
3043: wip_utilities.get_message_stack(p_msg => x_err_msg);
3044: exit;
3045: end if;

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

3050: p_wip_entity_id => null,
3051: p_operation_seq_num => null,
3052: p_intraoperation_step_type => null,
3053: x_return_status => x_return_status);
3054: if(x_return_status <> fnd_api.g_ret_sts_success) then
3055: wip_utilities.get_message_stack(p_msg => x_err_msg);
3056: exit;
3057: end if;
3058:

Line 3063: x_return_status := FND_API.G_RET_STS_ERROR;

3059: end loop;
3060:
3061: exception
3062: when others then
3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: x_err_code := SQLCODE;
3065: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
3066: END Change_Serial_Association;
3067:

Line 3102: x_return_status := FND_API.G_RET_STS_ERROR;

3098: p_wip_entity_id IS NULL THEN
3099:
3100: x_err_code := SQLCODE;
3101: x_err_msg := 'Error in wipjdstb.pls'|| SQLERRM;
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: return;
3104: END IF;
3105:
3106: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop

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

3110: p_wip_entity_id => null,
3111: p_operation_seq_num => null,
3112: p_intraoperation_step_type => null,
3113: x_return_status => x_return_status);
3114: if(x_return_status <> fnd_api.g_ret_sts_success) then
3115: rollback to wipjdstb30;
3116: wip_utilities.get_message_stack(p_msg => x_err_msg);
3117: exit;
3118: end if;

Line 3122: x_return_status := FND_API.G_RET_STS_ERROR;

3118: end if;
3119: end loop;
3120: exception
3121: when others then
3122: x_return_status := FND_API.G_RET_STS_ERROR;
3123: x_err_code := SQLCODE;
3124: x_err_msg := 'ERROR IN WIPJDSTB : '||SQLERRM;
3125: END Delete_Serial_Association;
3126:

Line 3143: x_return_status := fnd_api.g_ret_sts_success;

3139: l_serialization_start_op NUMBER;
3140: l_load_type NUMBER;
3141:
3142: begin
3143: x_return_status := fnd_api.g_ret_sts_success;
3144:
3145: select default_wip_auto_assoc_sn
3146: into l_defaultSN
3147: from wip_parameters