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.102.12020000.5 2013/01/17 04:22:44 lanhuang 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 1112: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

1108:
1109: PROCEDURE load_item_interface
1110: (
1111: p_resultfmt_usage_id IN NUMBER,
1112: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
1113: p_set_process_id IN NUMBER,
1114: x_set_process_id OUT NOCOPY NUMBER,
1115: x_errbuff OUT NOCOPY VARCHAR2,
1116: x_retcode OUT NOCOPY VARCHAR2

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

1271:
1272: l_prod_col_name := c_item_base_attr_intf_rec.attribute_code;
1273: l_intf_col_name := c_item_base_attr_intf_rec.intf_column_name;
1274:
1275: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN
1276: OPEN c_bom_comp_col_exists(l_prod_col_name);
1277: FETCH c_bom_comp_col_exists INTO l_exists;
1278: IF c_bom_comp_col_exists%FOUND THEN
1279: l_bom_col_exists := TRUE;

Line 1300: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND

1296: -- If the Caller Identifer is G_BOM and the column exists in
1297: -- BOM_COMPONENT_COLUMNS then fetch the Correct prod column
1298: -- name from BOM_COMPONENT_COLUMNS.
1299: --------------------------------------------------------------------
1300: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1301: l_bom_col_exists = TRUE AND l_prod_col_name <> G_ITEM_NUMBER)
1302: THEN
1303: SELECT BOM_INTF_COLUMN_NAME INTO l_bom_prod_col_name
1304: FROM BOM_COMPONENT_COLUMNS

Line 1319: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR

1315: -- If the Caller Identifer is G_BOM, and the column exists in
1316: -- BOM_COMPONENT_COLUMNS, then save the column info.
1317: --------------------------------------------------------------------
1318: IF (
1319: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1320: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1321: l_bom_col_exists = TRUE
1322: )
1323: ) THEN

Line 1320: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND

1316: -- BOM_COMPONENT_COLUMNS, then save the column info.
1317: --------------------------------------------------------------------
1318: IF (
1319: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) OR
1320: (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM AND
1321: l_bom_col_exists = TRUE
1322: )
1323: ) THEN
1324: --------------------------------------------------------------------

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

1388: Write_Debug('l_prod_col_name_tbl('||i||') : '||l_prod_col_name_tbl(i));
1389: Write_Debug('l_intf_col_name_tbl('||i||') : '||l_intf_col_name_tbl(i));
1390: i := i+1;
1391: END IF; --end: IF (l_prod_col_name = G_ITEM_NUMBER) THEN
1392: END IF; --end: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)...
1393: END LOOP;--end: FOR c_item_base_attr_intf_rec..
1394:
1395:
1396: l_value_to_id_col_exists := FALSE;

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

2642: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
2643: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
2644: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK1_VALUE = MSIV.INVENTORY_ITEM_ID ';
2645: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK2_VALUE = MSIV.ORGANIZATION_ID ';
2646: l_dyn_sql := l_dyn_sql || ' AND EGO_ITEM_BULKLOAD_PKG.get_desc_gen_method(MSIV.ITEM_CATALOG_GROUP_ID) = :FUNCTION_GEN ';
2647: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' IS NOT NULL';
2648: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_intf_col_name_tbl(i)||' <> MSIV.DESCRIPTION';
2649: l_dyn_sql := l_dyn_sql || ' AND EBI.INSTANCE_PK1_VALUE IS NOT NULL';
2650: l_dyn_sql := l_dyn_sql || ' AND UPPER(EBI.TRANSACTION_TYPE) IN (:UPD, :SYNC)';

Line 2827: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

2823:
2824: PROCEDURE preprocess_item_interface
2825: (
2826: p_resultfmt_usage_id IN NUMBER,
2827: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
2828: p_set_process_id IN NUMBER,
2829: x_errbuff IN OUT NOCOPY VARCHAR2,
2830: x_retcode IN OUT NOCOPY VARCHAR2
2831: ) IS

Line 3195: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

3191: ----------------------------------------------------------
3192: PROCEDURE Setup_item_interface
3193: (
3194: p_resultfmt_usage_id IN NUMBER,
3195: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
3196: p_set_process_id IN NUMBER,
3197: x_set_process_id OUT NOCOPY NUMBER,
3198: x_errbuff OUT NOCOPY VARCHAR2,
3199: x_retcode OUT NOCOPY VARCHAR2

Line 3362: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

3358:
3359: PROCEDURE load_item_revs_interface
3360: (
3361: p_resultfmt_usage_id IN NUMBER,
3362: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
3363: p_data_level IN VARCHAR2,
3364: p_set_process_id IN NUMBER,
3365: x_set_process_id OUT NOCOPY NUMBER,
3366: x_errbuff OUT NOCOPY VARCHAR2,

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

3510:
3511: --------------------------------------------------------------------
3512: -- If the Caller Identifer is G_ITEM, then save the column info.
3513: --------------------------------------------------------------------
3514: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN
3515:
3516: --------------------------------------------------------------------
3517: -- Store the Item Number column name in the Generic Interface
3518: --------------------------------------------------------------------

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

3570: l_intf_col_name_tbl(i) := l_intf_col_name;
3571:
3572: END IF; --IF (l_prod_col_name = G_ITEM_NUMBER) THEN
3573:
3574: END IF; --IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)
3575: Write_Debug('^^l_prod_col_name_tbl('||i||') : '||l_prod_col_name_tbl(i));
3576: Write_Debug('^^l_intf_col_name_tbl('||i||') : '||l_intf_col_name_tbl(i));
3577: i := i+1;
3578:

Line 4126: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

4122: ----------------------------------------------------------
4123: PROCEDURE preprocess_itemrev_interface
4124: (
4125: p_resultfmt_usage_id IN NUMBER,
4126: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
4127: p_set_process_id IN NUMBER,
4128: x_errbuff IN OUT NOCOPY VARCHAR2,
4129: x_retcode IN OUT NOCOPY VARCHAR2
4130: ) IS

Line 4193: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

4189: ----------------------------------------------------------
4190: PROCEDURE Setup_itemrev_interface
4191: (
4192: p_resultfmt_usage_id IN NUMBER,
4193: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
4194: p_data_level IN VARCHAR2,
4195: p_set_process_id IN NUMBER,
4196: x_set_process_id OUT NOCOPY NUMBER,
4197: x_errbuff OUT NOCOPY VARCHAR2,

Line 6160: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,

6156: p_resultfmt_usage_id IN NUMBER,
6157: p_user_id IN NUMBER,
6158: p_conc_request_id IN NUMBER,
6159: p_language_code IN VARCHAR2,
6160: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6161: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6162: x_errbuff OUT NOCOPY VARCHAR2,
6163: x_retcode OUT NOCOPY VARCHAR2,
6164: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

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

6245: -- Open Error Handler Debug Session.
6246: -----------------------------------------------------
6247: Open_Debug_Session;
6248:
6249: Developer_Debug('Completely Reformatted EGO_ITEM_BULKLOAD_PKG with Error Handler Changes');
6250:
6251: Developer_Debug('After Open_Debug_Session');
6252: SetGobals();
6253: G_LANGUAGE_CODE := p_language_code;

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

6306: -- 1. Item 2. Item Revision. --
6307: -- Hence need to call appropriate populate interface table procedure. --
6308: -- --
6309: -------------------------------------------------------------------------------
6310: IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM) THEN
6311:
6312: OPEN c_resultfmt_info(p_resultfmt_usage_id);
6313: FETCH c_resultfmt_info INTO l_data_level, l_catalog_group_id;
6314: Developer_Debug('Result Format Data Level =>'||l_data_level);

Line 6412: EGO_ITEM_BULKLOAD_PKG.load_intersections_interface

6408: -------------------------------------------------------------------
6409: -- End: Fix for Bug# 3403455. (PPEDDAMA) --
6410: -- Setup Item Rev Interface only if Revision Base attrs exist. --
6411: -------------------------------------------------------------------
6412: EGO_ITEM_BULKLOAD_PKG.load_intersections_interface
6413: (
6414: p_resultfmt_usage_id =>p_resultfmt_usage_id,
6415: p_set_process_id =>p_data_set_id,
6416: x_set_process_id =>l_msii_set_process_id,

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

6416: x_set_process_id =>l_msii_set_process_id,
6417: x_errbuff =>x_errbuff,
6418: x_retcode =>x_retcode
6419: );
6420: write_debug('Done with EGO_ITEM_BULKLOAD_PKG.load_intersections_interface ---x_retcode-'||x_retcode);
6421: --ELSE --G_ITEM_REV_DATA_LEVEL
6422: /*
6423: ---------------------------------------------------------------------------------
6424: -- Now that Revisions show up as a part of Item Search Results,

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

6441: END IF; --end: IF c_resultfmt_info%FOUND THEN
6442:
6443: CLOSE c_resultfmt_info;
6444:
6445: ELSIF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_BOM) THEN
6446:
6447: --------------------------------------------------------------
6448: -- BOM called the Bulkload code, hence setup Item and Item
6449: -- Revision Interface tables appropriately.

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

6499: -- This ELSE condition should never be reached.
6500: --------------------------------------------------------------
6501: Developer_Debug('INVALID CALLER IDENTIFIER : '|| p_caller_identifier);
6502:
6503: END IF;--IF (p_caller_identifier = EGO_ITEM_BULKLOAD_PKG.G_ITEM)
6504:
6505: --R12
6506: ----------------------------------------------------------------
6507: -- Call for User Attributes Bulk Processing, to load the

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

7375: EXCEPTION
7376: WHEN OTHERS THEN
7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7383: ,p_count => x_msg_count

Line 7921: END EGO_ITEM_BULKLOAD_PKG;

7917:
7918:
7919:
7920:
7921: END EGO_ITEM_BULKLOAD_PKG;