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

Line 1284: l_ret_code := FND_API.G_TRUE;

1280: IS
1281: l_trade_unit_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
1282: l_ret_code VARCHAR2(100);
1283: BEGIN
1284: l_ret_code := FND_API.G_TRUE;
1285:
1286: SELECT TRADE_ITEM_DESCRIPTOR
1287: INTO l_trade_unit_desc
1288: FROM MTL_SYSTEM_ITEMS_B

Line 1293: l_ret_code := FND_API.G_FALSE;

1289: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1290: AND ORGANIZATION_ID = p_org_id;
1291:
1292: IF NVL(l_trade_unit_desc,'BASE_UNIT_OR_EACH') <> 'BASE_UNIT_OR_EACH' THEN
1293: l_ret_code := FND_API.G_FALSE;
1294: END IF;
1295: RETURN(l_ret_code);
1296: EXCEPTION
1297: WHEN NO_DATA_FOUND THEN

Line 1298: RETURN(FND_API.G_TRUE);

1294: END IF;
1295: RETURN(l_ret_code);
1296: EXCEPTION
1297: WHEN NO_DATA_FOUND THEN
1298: RETURN(FND_API.G_TRUE);
1299: WHEN OTHERS THEN
1300: RETURN (FND_API.G_FALSE);
1301: END Validate_Unit_Wt_Uom;
1302:

Line 1300: RETURN (FND_API.G_FALSE);

1296: EXCEPTION
1297: WHEN NO_DATA_FOUND THEN
1298: RETURN(FND_API.G_TRUE);
1299: WHEN OTHERS THEN
1300: RETURN (FND_API.G_FALSE);
1301: END Validate_Unit_Wt_Uom;
1302:
1303: --------------------------------
1304: /**

Line 1326: p_commit VARCHAR2 := FND_API.G_FALSE,

1322: */
1323: PROCEDURE PROCESS_ATTRIBUTE_UPDATES (p_inventory_item_id NUMBER,
1324: p_organization_id NUMBER,
1325: p_attribute_names EGO_VARCHAR_TBL_TYPE,
1326: p_commit VARCHAR2 := FND_API.G_FALSE,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2) AS
1330:

Line 1552: IF p_commit = FND_API.G_TRUE THEN

1548: END IF; -- IF other attrs got updated
1549: END IF; -- IF registration attrs got updated
1550:
1551: -- achampan: removed rollup call
1552: IF p_commit = FND_API.G_TRUE THEN
1553: write_debug_log('Commiting...');
1554: COMMIT;
1555: END IF;
1556:

Line 1581: p_commit VARCHAR2 := FND_API.G_FALSE,

1577: PROCEDURE PROCESS_EXTN_ATTRIBUTE_UPDATES (p_inventory_item_id NUMBER,
1578: p_organization_id NUMBER,
1579: p_attribute_names EGO_VARCHAR_TBL_TYPE,
1580: p_attr_group_name VARCHAR2,
1581: p_commit VARCHAR2 := FND_API.G_FALSE,
1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_count OUT NOCOPY NUMBER,
1584: x_msg_data OUT NOCOPY VARCHAR2) AS
1585: x_error_message VARCHAR2(2000);

Line 1724: IF p_commit = FND_API.G_TRUE THEN

1720: AND T.LANGUAGE = L.LANGUAGE_CODE);
1721: END;
1722: END LOOP; --FOR i IN c_customers(l_gtin) LOOP
1723:
1724: IF p_commit = FND_API.G_TRUE THEN
1725: write_debug_log('Commiting...');
1726: COMMIT;
1727: END IF;
1728:

Line 2090: p_commit => FND_API.G_FALSE,

2086: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
2087: p_inventory_item_id => i.inventory_item_id,
2088: p_organization_id => i.organization_id,
2089: p_attribute_names => l_attribute_names,
2090: p_commit => FND_API.G_FALSE,
2091: x_return_status => l_return_status,
2092: x_msg_count => l_msg_count,
2093: x_msg_data => l_msg_text);
2094:

Line 2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2092: x_msg_count => l_msg_count,
2093: x_msg_data => l_msg_text);
2094:
2095: write_debug_log('After calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ... return_status, error = '||l_return_status||' , '||l_msg_text);
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
2098: SET process_flag = 3
2099: WHERE rowid = i.rowid;
2100:

Line 2131: p_commit VARCHAR2 := FND_API.G_FALSE,

2127: */
2128: PROCEDURE UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id NUMBER,
2129: p_organization_id NUMBER,
2130: p_update_reg VARCHAR2 := 'N',
2131: p_commit VARCHAR2 := FND_API.G_FALSE,
2132: x_return_status OUT NOCOPY VARCHAR2,
2133: x_msg_count OUT NOCOPY NUMBER,
2134: x_msg_data OUT NOCOPY VARCHAR2)
2135: IS

Line 2150: IF p_commit = FND_API.G_TRUE THEN

2146: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2147: AND ORGANIZATION_ID = p_organization_id;
2148: END IF;
2149:
2150: IF p_commit = FND_API.G_TRUE THEN
2151: COMMIT;
2152: END IF;
2153:
2154: x_return_status := 'S';

Line 2217: l_null_str_value := FND_API.G_MISS_CHAR;

2213: l_propagate_sh_temps := FALSE;
2214: l_propagate_top_gtin := FALSE;
2215: l_propagate_unit_weight := FALSE;
2216:
2217: l_null_str_value := FND_API.G_MISS_CHAR;
2218: l_null_num_value := FND_API.G_MISS_NUM;
2219: l_null_date_value := FND_API.G_MISS_DATE;
2220:
2221: l_item_id := p_pk_column_name_value_pairs(p_pk_column_name_value_pairs.FIRST).VALUE;

Line 2218: l_null_num_value := FND_API.G_MISS_NUM;

2214: l_propagate_top_gtin := FALSE;
2215: l_propagate_unit_weight := FALSE;
2216:
2217: l_null_str_value := FND_API.G_MISS_CHAR;
2218: l_null_num_value := FND_API.G_MISS_NUM;
2219: l_null_date_value := FND_API.G_MISS_DATE;
2220:
2221: l_item_id := p_pk_column_name_value_pairs(p_pk_column_name_value_pairs.FIRST).VALUE;
2222: l_organization_id := p_pk_column_name_value_pairs(p_pk_column_name_value_pairs.FIRST+1).VALUE;

Line 2219: l_null_date_value := FND_API.G_MISS_DATE;

2215: l_propagate_unit_weight := FALSE;
2216:
2217: l_null_str_value := FND_API.G_MISS_CHAR;
2218: l_null_num_value := FND_API.G_MISS_NUM;
2219: l_null_date_value := FND_API.G_MISS_DATE;
2220:
2221: l_item_id := p_pk_column_name_value_pairs(p_pk_column_name_value_pairs.FIRST).VALUE;
2222: l_organization_id := p_pk_column_name_value_pairs(p_pk_column_name_value_pairs.FIRST+1).VALUE;
2223:

Line 2485: x_return_status := FND_API.G_RET_STS_SUCCESS;

2481: l_found_attr BOOLEAN := FALSE;
2482:
2483: BEGIN
2484:
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;
2486: l_api_name := 'Update_Attribute';
2487:
2488: write_debug_log(l_api_name||': starting for '||p_inventory_item_id||'-'||p_organization_id);
2489:

Line 2587: , p_bulkload_flag => FND_API.G_TRUE

2583: , p_data_level_name_value_pairs => Bom_Rollup_Pub.g_data_level_name_value_pairs
2584: , p_attr_name_value_pairs => l_attr_new_values
2585: -- this is very important, because otherwise, updates would trigger rollups, creating an infinite loop
2586: , p_debug_level => p_debug_level
2587: , p_bulkload_flag => FND_API.G_TRUE
2588: , x_return_status => x_return_status
2589: , x_errorcode => x_errorcode
2590: , x_msg_count => x_msg_count
2591: , x_msg_data => x_msg_data

Line 2714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2710:
2711: IF NOT l_found_attr THEN
2712:
2713: -- add more descriptive error
2714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2715: x_msg_data := SQLERRM;
2716: x_msg_count := 1;
2717:
2718: END IF;

Line 2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2728: WHEN OTHERS THEN
2729:
2730: write_debug_log(l_api_name||': failed: '||sqlerrm);
2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

Line 2739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2735: FND_MESSAGE.Set_Token('PKG_NAME', g_pkg_name);
2736: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2737: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2738: FND_MSG_PUB.Add;
2739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2740: ,p_count => x_msg_count
2741: ,p_data => x_msg_data);
2742:
2743: END Update_Attribute;

Line 2841: x_return_status := FND_API.G_RET_STS_SUCCESS;

2837: )
2838: IS
2839: l_gtin_dml_str VARCHAR2(2000);
2840: BEGIN
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: -- for now just update
2844: l_gtin_dml_str := 'UPDATE ego_item_gtn_attrs_b SET ';
2845: l_gtin_dml_str := l_gtin_dml_str || 'TOP_GTIN = ''' || p_top_gtin_flag || '''';