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_ITEM_BULKLOAD_PKG dependencies on EGO_ITEM_BULKLOAD_PKG

Line 1: PACKAGE BODY EGO_ITEM_BULKLOAD_PKG AS

1: PACKAGE BODY EGO_ITEM_BULKLOAD_PKG AS
2: /* $Header: EGOIBLKB.pls 120.90.12010000.3 2009/01/05 13:13:02 snandana ship $ */
3:
4:
5: ------------------------------

Line 308: ,buff => 'EGO_ITEM_BULKLOAD_PKG: '||p_msg);

304:
305: BEGIN
306: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
307: FND_FILE.put_line(which => FND_FILE.LOG
308: ,buff => 'EGO_ITEM_BULKLOAD_PKG: '||p_msg);
309:
310: END IF;
311: -- NOTE: No need to check for profile now, as Error_Handler checks
312: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.

Line 332: ,buff => 'EGO_ITEM_BULKLOAD_PKG: '||p_msg);

328: BEGIN
329:
330: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
331: FND_FILE.put_line(which => FND_FILE.LOG
332: ,buff => 'EGO_ITEM_BULKLOAD_PKG: '||p_msg);
333: END IF;
334:
335: EXCEPTION
336: WHEN OTHERS THEN

Line 1075: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

1071:
1072: PROCEDURE load_item_interface
1073: (
1074: p_resultfmt_usage_id IN NUMBER,
1075: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
1076: p_set_process_id IN NUMBER,
1077: x_set_process_id OUT NOCOPY NUMBER,
1078: x_errbuff OUT NOCOPY VARCHAR2,
1079: x_retcode OUT NOCOPY VARCHAR2

Line 1233: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN

1229:
1230: l_prod_col_name := c_item_base_attr_intf_rec.attribute_code;
1231: l_intf_col_name := c_item_base_attr_intf_rec.intf_column_name;
1232:
1233: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN
1234: OPEN c_bom_comp_col_exists(l_prod_col_name);
1235: FETCH c_bom_comp_col_exists INTO l_exists;
1236: IF c_bom_comp_col_exists%FOUND THEN
1237: l_bom_col_exists := TRUE;

Line 1258: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND

1254: -- If the Caller Identifer is G_BOM and the column exists in
1255: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1256: -- name from BOM_COMPONENT_COLUMNS.
1257: --------------------------------------------------------------------
1258: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1259: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1260: THEN
1261: SELECT BOM_INTF_COLUMN_NAME INTO l_bom_prod_col_name
1262: FROM BOM_COMPONENT_COLUMNS

Line 1277: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR

1273: -- If the Caller Identifer is G_BOM, and the column exists in
1274: -- BOM_COMPONENT_COLUMNS, then save the column info.
1275: --------------------------------------------------------------------
1276: IF (
1277: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1278: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1279: l_bom_col_exists = TRUE
1280: )
1281: ) THEN

Line 1278: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND

1274: -- BOM_COMPONENT_COLUMNS, then save the column info.
1275: --------------------------------------------------------------------
1276: IF (
1277: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1278: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1279: l_bom_col_exists = TRUE
1280: )
1281: ) THEN
1282: --------------------------------------------------------------------

Line 1350: END IF; --end: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)...

1346: Write_Debug('l_prod_col_name_tbl('||i||') : '||l_prod_col_name_tbl(i));
1347: Write_Debug('l_intf_col_name_tbl('||i||') : '||l_intf_col_name_tbl(i));
1348: i := i+1;
1349: END IF; --end: IF (l_prod_col_name = G_ITEM_NUMBER) THEN
1350: END IF; --end: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)...
1351: END LOOP;--end: FOR c_item_base_attr_intf_rec..
1352:
1353:
1354: l_value_to_id_col_exists := FALSE;

Line 2561: l_dyn_sql := l_dyn_sql || ' AND EGO_ITEM_BULKLOAD_PKG.get_desc_gen_method(MSIV.ITEM_CATALOG_GROUP_ID) = :FUNCTION_GEN ';

2557: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2558: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2559: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK1_VALUE = MSIV.INVENTORY_ITEM_ID ';
2560: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK2_VALUE = MSIV.ORGANIZATION_ID ';
2561: l_dyn_sql := l_dyn_sql || ' AND EGO_ITEM_BULKLOAD_PKG.get_desc_gen_method(MSIV.ITEM_CATALOG_GROUP_ID) = :FUNCTION_GEN ';
2562: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2563: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> MSIV.DESCRIPTION';
2564: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK1_VALUE IS NOT NULL';
2565: l_dyn_sql := l_dyn_sql || ' AND UPPER(EBI.TRANSACTION_TYPE) IN (:UPD, :SYNC)';

Line 2742: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

2738:
2739: PROCEDURE preprocess_item_interface
2740: (
2741: p_resultfmt_usage_id IN NUMBER,
2742: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
2743: p_set_process_id IN NUMBER,
2744: x_errbuff IN OUT NOCOPY VARCHAR2,
2745: x_retcode IN OUT NOCOPY VARCHAR2
2746: ) IS

Line 3110: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

3106: ----------------------------------------------------------
3107: PROCEDURE Setup_item_interface
3108: (
3109: p_resultfmt_usage_id IN NUMBER,
3110: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
3111: p_set_process_id IN NUMBER,
3112: x_set_process_id OUT NOCOPY NUMBER,
3113: x_errbuff OUT NOCOPY VARCHAR2,
3114: x_retcode OUT NOCOPY VARCHAR2

Line 3277: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

3273:
3274: PROCEDURE load_item_revs_interface
3275: (
3276: p_resultfmt_usage_id IN NUMBER,
3277: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
3278: p_data_level IN VARCHAR2,
3279: p_set_process_id IN NUMBER,
3280: x_set_process_id OUT NOCOPY NUMBER,
3281: x_errbuff OUT NOCOPY VARCHAR2,

Line 3429: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN

3425:
3426: --------------------------------------------------------------------
3427: -- If the Caller Identifer is G_ITEM, then save the column info.
3428: --------------------------------------------------------------------
3429: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN
3430:
3431: --------------------------------------------------------------------
3432: -- Store the Item Number column name in the Generic Interface
3433: --------------------------------------------------------------------

Line 3489: END IF; --IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)

3485: l_intf_col_name_tbl(i) := l_intf_col_name;
3486:
3487: END IF; --IF (l_prod_col_name = G_ITEM_NUMBER) THEN
3488:
3489: END IF; --IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)
3490: Write_Debug('^^l_prod_col_name_tbl('||i||') : '||l_prod_col_name_tbl(i));
3491: Write_Debug('^^l_intf_col_name_tbl('||i||') : '||l_intf_col_name_tbl(i));
3492: i := i+1;
3493:

Line 4041: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

4037: ----------------------------------------------------------
4038: PROCEDURE preprocess_itemrev_interface
4039: (
4040: p_resultfmt_usage_id IN NUMBER,
4041: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
4042: p_set_process_id IN NUMBER,
4043: x_errbuff IN OUT NOCOPY VARCHAR2,
4044: x_retcode IN OUT NOCOPY VARCHAR2
4045: ) IS

Line 4108: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

4104: ----------------------------------------------------------
4105: PROCEDURE Setup_itemrev_interface
4106: (
4107: p_resultfmt_usage_id IN NUMBER,
4108: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
4109: p_data_level IN VARCHAR2,
4110: p_set_process_id IN NUMBER,
4111: x_set_process_id OUT NOCOPY NUMBER,
4112: x_errbuff OUT NOCOPY VARCHAR2,

Line 6007: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

6003: p_resultfmt_usage_id IN NUMBER,
6004: p_user_id IN NUMBER,
6005: p_conc_request_id IN NUMBER,
6006: p_language_code IN VARCHAR2,
6007: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6008: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6009: x_errbuff OUT NOCOPY VARCHAR2,
6010: x_retcode OUT NOCOPY VARCHAR2,
6011: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

Line 6096: Developer_Debug('Completely Reformatted EGO_ITEM_BULKLOAD_PKG with Error Handler Changes');

6092: -- Open Error Handler Debug Session.
6093: -----------------------------------------------------
6094: Open_Debug_Session;
6095:
6096: Developer_Debug('Completely Reformatted EGO_ITEM_BULKLOAD_PKG with Error Handler Changes');
6097:
6098: Developer_Debug('After Open_Debug_Session');
6099: SetGobals();
6100: G_LANGUAGE_CODE := p_language_code;

Line 6157: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN

6153: -- 1. Item 2. Item Revision. --
6154: -- Hence need to call appropriate populate interface table procedure. --
6155: -- --
6156: -------------------------------------------------------------------------------
6157: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN
6158:
6159: OPEN c_resultfmt_info(p_resultfmt_usage_id);
6160: FETCH c_resultfmt_info INTO l_data_level, l_catalog_group_id;
6161: Developer_Debug('Result Format Data Level =>'||l_data_level);

Line 6259: EGO_ITEM_BULKLOAD_PKG.load_intersections_interface

6255: -------------------------------------------------------------------
6256: -- End: Fix for Bug# 3403455. (PPEDDAMA) --
6257: -- Setup Item Rev Interface only if Revision Base attrs exist. --
6258: -------------------------------------------------------------------
6259: EGO_ITEM_BULKLOAD_PKG.load_intersections_interface
6260: (
6261: p_resultfmt_usage_id =>p_resultfmt_usage_id,
6262: p_set_process_id =>p_data_set_id,
6263: x_set_process_id =>l_msii_set_process_id,

Line 6267: write_debug('Done with EGO_ITEM_BULKLOAD_PKG.load_intersections_interface ---x_retcode-'||x_retcode);

6263: x_set_process_id =>l_msii_set_process_id,
6264: x_errbuff =>x_errbuff,
6265: x_retcode =>x_retcode
6266: );
6267: write_debug('Done with EGO_ITEM_BULKLOAD_PKG.load_intersections_interface ---x_retcode-'||x_retcode);
6268: --ELSE --G_ITEM_REV_DATA_LEVEL
6269: /*
6270: ---------------------------------------------------------------------------------
6271: -- Now that Revisions show up as a part of Item Search Results,

Line 6292: ELSIF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN

6288: END IF; --end: IF c_resultfmt_info%FOUND THEN
6289:
6290: CLOSE c_resultfmt_info;
6291:
6292: ELSIF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN
6293:
6294: --------------------------------------------------------------
6295: -- BOM called the Bulkload code, hence setup Item and Item
6296: -- Revision Interface tables appropriately.

Line 6350: END IF;--IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)

6346: -- This ELSE condition should never be reached.
6347: --------------------------------------------------------------
6348: Developer_Debug('INVALID CALLER IDENTIFIER : '|| p_caller_identifier);
6349:
6350: END IF;--IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)
6351:
6352: --R12
6353: ----------------------------------------------------------------
6354: -- Call for User Attributes Bulk Processing, to load the

Line 7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');

7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7230: ,p_count => x_msg_count

Line 7768: END EGO_ITEM_BULKLOAD_PKG;

7764:
7765:
7766:
7767:
7768: END EGO_ITEM_BULKLOAD_PKG;