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.CE_SYSTEM_PARAMETERS1_PKG dependencies on CE_SYSTEM_PARAMETERS

Line 1: PACKAGE BODY CE_SYSTEM_PARAMETERS1_PKG as

1: PACKAGE BODY CE_SYSTEM_PARAMETERS1_PKG as
2: /* $Header: cesysp1b.pls 120.8 2008/01/23 13:21:45 kbabu ship $ */
3: FUNCTION body_revision RETURN VARCHAR2 IS
4: BEGIN
5:

Line 87: FROM CE_SYSTEM_PARAMETERS s,

83: X_AUTHORIZATION_BAT,
84: X_BSC_EXCHANGE_DATE_TYPE,
85: X_BAT_EXCHANGE_DATE_TYPE,
86: X_legal_entity_id
87: FROM CE_SYSTEM_PARAMETERS s,
88: GL_SETS_OF_BOOKS g,
89: GL_DAILY_CONVERSION_TYPES ct
90: WHERE s.legal_entity_id = X_legal_entity_id
91: and s.set_of_books_id = g.set_of_books_id

Line 98: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS NO_DATA_FOUND');

94:
95: END IF;
96: EXCEPTION
97: WHEN NO_DATA_FOUND THEN
98: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS NO_DATA_FOUND');
99: null;
100: WHEN TOO_MANY_ROWS THEN
101: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS TOO_MANY_ROWS');
102: null;

Line 101: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS TOO_MANY_ROWS');

97: WHEN NO_DATA_FOUND THEN
98: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS NO_DATA_FOUND');
99: null;
100: WHEN TOO_MANY_ROWS THEN
101: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS TOO_MANY_ROWS');
102: null;
103: WHEN OTHERS THEN
104: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS');
105: RAISE;

Line 104: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS');

100: WHEN TOO_MANY_ROWS THEN
101: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS TOO_MANY_ROWS');
102: null;
103: WHEN OTHERS THEN
104: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.SELECT_COLUMNS');
105: RAISE;
106: END SELECT_COLUMNS;
107:
108: /* ---------------------------------------------------------------------

Line 210: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS NO_DATA_FOUND');

206: WHERE BA.BANK_ACCOUNT_ID = X_BANK_ACCOUNT_ID;
207: END IF;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS NO_DATA_FOUND');
211: null;
212: WHEN TOO_MANY_ROWS THEN
213: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS TOO_MANY_ROWS');
214: null;

Line 213: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS TOO_MANY_ROWS');

209: WHEN NO_DATA_FOUND THEN
210: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS NO_DATA_FOUND');
211: null;
212: WHEN TOO_MANY_ROWS THEN
213: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS TOO_MANY_ROWS');
214: null;
215: WHEN OTHERS THEN
216: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS');
217: RAISE;

Line 216: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS');

212: WHEN TOO_MANY_ROWS THEN
213: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS TOO_MANY_ROWS');
214: null;
215: WHEN OTHERS THEN
216: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BA_SELECT_COLUMNS');
217: RAISE;
218: END Ba_Select_Columns;
219:
220: /* ---------------------------------------------------------------------

Line 255: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS NO_DATA_FOUND');

251: AND BAU.BANK_ACCOUNT_ID = NVL(X_BANK_ACCOUNT_ID, BAU.BANK_ACCOUNT_ID);
252: END IF;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS NO_DATA_FOUND');
256: null;
257: WHEN TOO_MANY_ROWS THEN
258: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS TOO_MANY_ROWS');
259: null;

Line 258: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS TOO_MANY_ROWS');

254: WHEN NO_DATA_FOUND THEN
255: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS NO_DATA_FOUND');
256: null;
257: WHEN TOO_MANY_ROWS THEN
258: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS TOO_MANY_ROWS');
259: null;
260: WHEN OTHERS THEN
261: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS');
262: RAISE;

Line 261: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS');

257: WHEN TOO_MANY_ROWS THEN
258: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS TOO_MANY_ROWS');
259: null;
260: WHEN OTHERS THEN
261: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS');
262: RAISE;
263: END BAU_SELECT_COLUMNS;
264:
265: END CE_SYSTEM_PARAMETERS1_PKG;

Line 265: END CE_SYSTEM_PARAMETERS1_PKG;

261: cep_standard.debug('EXCEPTION: CE_SYSTEM_PARAMETERS1_PKG.BAU_SELECT_COLUMNS');
262: RAISE;
263: END BAU_SELECT_COLUMNS;
264:
265: END CE_SYSTEM_PARAMETERS1_PKG;