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.CZ_POPULATORS_PKG dependencies on CZ_POPULATORS_PKG

Line 1: PACKAGE BODY CZ_POPULATORS_PKG AS

1: PACKAGE BODY CZ_POPULATORS_PKG AS
2: /* $Header: czpopb.pls 120.10.12020000.2 2012/08/17 15:27:12 smanna ship $ */
3:
4: ITEMS_POP CONSTANT INTEGER:=1;
5: ITEM_TYPES_POP CONSTANT INTEGER:=2;

Line 113: 'CZ_POPULATORS_PKG',

109: (p_run_id,
110: SYSDATE,
111: USER,
112: 1,
113: 'CZ_POPULATORS_PKG',
114: 11276,
115: fnd_msg_pub.GET(i,fnd_api.g_false),
116: mCOUNTER);
117: COMMIT;

Line 198: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);

194: l_msg_index := 1;
195: WHILE l_msg_count > 0
196: LOOP
197: l_msg_data := fnd_msg_pub.get(l_msg_index,fnd_api.g_false);
198: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);
199: l_msg_index := l_msg_index + 1;
200: l_msg_count := l_msg_count - 1;
201: END LOOP;
202: FND_MSG_PUB.initialize;

Line 425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');

421:
422: EXCEPTION
423: WHEN DELETED_EXPRESSION THEN
424: p_err:=mRUN_ID;
425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');
426: WHEN WRONG_SQL THEN
427: p_err:=mRUN_ID;
428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
429: WHEN OTHERS THEN

Line 428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);

424: p_err:=mRUN_ID;
425: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : definition was deleted.');
426: WHEN WRONG_SQL THEN
427: p_err:=mRUN_ID;
428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
429: WHEN OTHERS THEN
430: p_err:=mRUN_ID;
431: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);
432: END Regenerate_unsec;

Line 431: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);

427: p_err:=mRUN_ID;
428: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" -wrong SQL query is used : '||SQLERRM);
429: WHEN OTHERS THEN
430: p_err:=mRUN_ID;
431: LOG_REPORT('CZ_POPULATORS_PKG.Regenerate','Regenerate populator "'||var_pop_name||'" : '||SQLERRM);
432: END Regenerate_unsec;
433:
434: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
435: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 862: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');

858:
859: IF ps_node_already_exists AND exists_in_t_names THEN
860:
861: -- Need to update the previous entry
862: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');
863: UPDATE CZ_IMP_PS_NODES
864: SET PROPERTY_BACKPTR = var_property_ptr,ITEM_TYPE_BACKPTR = var_item_type_ptr,INTL_TEXT_ID = var_new_text_id,
865: ITEM_ID = var_item_id,USER_STR03 = var_key,FSK_PSNODE_3_EXT = var_fk_key,
866: PRIMARY_UOM_CODE = var_primary_uom_code,

Line 875: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);

871: PARENT_ID = var_ps_node_id AND NAME = var_name;
872: -- Implies we encountered the new node later to old node or another new node
873: ELSE
874: IF(NOT ps_node_already_exists) AND exists_in_t_names THEN-- Implies we encountered the new node later to old node or another new node
875: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);
876: RAISE SKIP_IT;
877: ELSE
878: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
879: -- Need to INSERT

Line 882: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);

878: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
879: -- Need to INSERT
880: t_names(t_names.Count+1):=var_name;
881: var_tree_seq:=var_tree_seq+1;
882: --LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);
883:
884: --Bug8584377
885: IF (NOT ps_node_already_exists) THEN
886: var_new_text_id := get_Next_Seq_Id(mINTL_TEXT_SEQUENCE);

Line 983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);

979: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
980: DBMS_SQL.CLOSE_CURSOR(var_cursor);
981: END IF;
982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
984: WHEN WRONG_SQL THEN
985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;

Line 989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);

985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;
988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
990: WHEN OTHERS THEN
991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;

Line 995: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);

991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;
994: p_err:=mRUN_ID;
995: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);
996: END Preview_unsec;
997:
998: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
999: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1165: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');

1161: mXFR_PROJECT_GROUP);
1162:
1163: IF var_failed>0 THEN
1164: p_err:=mRUN_ID;
1165: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');
1166: END IF;
1167: RAISE STOP_IT;
1168: END IF;
1169:

Line 1357: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);

1353: WHEN STOP_IT THEN
1354: NULL;
1355: WHEN OTHERS THEN
1356: p_err:=mRUN_ID;
1357: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);
1358: END Execute_unsec;
1359:
1360: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1361: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1501: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',

1497:
1498: EXCEPTION
1499: WHEN MODEL_DOES_NOT_EXIST THEN
1500: p_err:=mRUN_ID;
1501: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',
1502: 'Model with model_id='||TO_CHAR(p_model_id)||' does not exist.');
1503: END Repopulate_unsec;
1504:
1505: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1597: END CZ_POPULATORS_PKG;

1593: mALWAYS_REGENERATE := 'N';
1594: END;
1595:
1596:
1597: END CZ_POPULATORS_PKG;