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.8.12010000.2 2008/09/08 12:07:32 vsingava ship $ */
3:
4: ITEMS_POP CONSTANT INTEGER:=1;
5: ITEM_TYPES_POP CONSTANT INTEGER:=2;

Line 110: 'CZ_POPULATORS_PKG',

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

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

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

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

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

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

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

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

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

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

852:
853: IF ps_node_already_exists AND exists_in_t_names THEN
854:
855: -- Need to update the previous entry
856: LOG_REPORT('CZ_POPULATORS_PKG.preview','Updating previous entry');
857: UPDATE CZ_IMP_PS_NODES
858: SET PROPERTY_BACKPTR = var_property_ptr,ITEM_TYPE_BACKPTR = var_item_type_ptr,INTL_TEXT_ID = var_new_text_id,
859: ITEM_ID = var_item_id,USER_STR03 = var_key,FSK_PSNODE_3_EXT = var_fk_key,
860: PRIMARY_UOM_CODE = var_primary_uom_code,

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

865: PARENT_ID = var_ps_node_id AND NAME = var_name;
866: -- Implies we encountered the new node later to old node or another new node
867: ELSE
868: 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
869: LOG_REPORT('CZ_POPULATORS_PKG.preview','Skipping entry :'||var_name);
870: RAISE SKIP_IT;
871: ELSE
872: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
873: -- Need to INSERT

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

872: -- We reach here, when import_table_existence_flag is alone FALSE. May be inserting the new one or the old one
873: -- Need to INSERT
874: t_names(t_names.Count+1):=var_name;
875: var_tree_seq:=var_tree_seq+1;
876: LOG_REPORT('CZ_POPULATORS_PKG.preview','Inserting entry :'||var_name);
877:
878: INSERT INTO CZ_IMP_PS_NODES
879: (RUN_ID,
880: PS_NODE_ID,

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

968: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
969: DBMS_SQL.CLOSE_CURSOR(var_cursor);
970: END IF;
971: p_err:=mRUN_ID;
972: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
973: WHEN WRONG_SQL THEN
974: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
975: DBMS_SQL.CLOSE_CURSOR(var_cursor);
976: END IF;

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

974: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
975: DBMS_SQL.CLOSE_CURSOR(var_cursor);
976: END IF;
977: p_err:=mRUN_ID;
978: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
979: WHEN OTHERS THEN
980: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
981: DBMS_SQL.CLOSE_CURSOR(var_cursor);
982: END IF;

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

980: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
981: DBMS_SQL.CLOSE_CURSOR(var_cursor);
982: END IF;
983: p_err:=mRUN_ID;
984: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);
985: END Preview_unsec;
986:
987: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
988: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

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

1147: mXFR_PROJECT_GROUP);
1148:
1149: IF var_failed>0 THEN
1150: p_err:=mRUN_ID;
1151: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Populator failed ...');
1152: END IF;
1153: RAISE STOP_IT;
1154: END IF;
1155:

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

1327: WHEN STOP_IT THEN
1328: NULL;
1329: WHEN OTHERS THEN
1330: p_err:=mRUN_ID;
1331: LOG_REPORT('CZ_POPULATORS_PKG.Execute','Execute populator "'||var_pop_name||'" failed : '||SQLERRM);
1332: END Execute_unsec;
1333:
1334: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1335: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 1475: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',

1471:
1472: EXCEPTION
1473: WHEN MODEL_DOES_NOT_EXIST THEN
1474: p_err:=mRUN_ID;
1475: LOG_REPORT('CZ_POPULATORS_PKG.Repopulate',
1476: 'Model with model_id='||TO_CHAR(p_model_id)||' does not exist.');
1477: END Repopulate_unsec;
1478:
1479: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1571: END CZ_POPULATORS_PKG;

1567: mALWAYS_REGENERATE := 'N';
1568: END;
1569:
1570:
1571: END CZ_POPULATORS_PKG;