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_TRANSACTION_CODES_PKG dependencies on STANDARD

Line 86: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Insert_Row');

82: SELECT ce_transaction_codes_s.nextval
83: FROM sys.dual;
84:
85: BEGIN
86: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Insert_Row');
87:
88: cep_standard.debug('open c2 ');
89:
90: OPEN C2;

Line 88: cep_standard.debug('open c2 ');

84:
85: BEGIN
86: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Insert_Row');
87:
88: cep_standard.debug('open c2 ');
89:
90: OPEN C2;
91: FETCH C2 INTO X_transaction_code_id;
92: CLOSE C2;

Line 95: cep_standard.debug('insert into CE_TRANSACTION_CODES begin');

91: FETCH C2 INTO X_transaction_code_id;
92: CLOSE C2;
93:
94:
95: cep_standard.debug('insert into CE_TRANSACTION_CODES begin');
96:
97: INSERT INTO CE_TRANSACTION_CODES(
98: transaction_code_id,
99: bank_account_id,

Line 177: cep_standard.debug('insert into CE_TRANSACTION_CODES end');

173: X_reconciliation_sequence,
174: X_request_id -- 8707463:Added
175: );
176:
177: cep_standard.debug('insert into CE_TRANSACTION_CODES end');
178:
179: OPEN C;
180: FETCH C INTO X_Rowid;
181:

Line 187: cep_standard.debug('<

183: CLOSE C;
184: RAISE NO_DATA_FOUND;
185: END IF;
186: CLOSE C;
187: cep_standard.debug('< 188:
189: END Insert_Row;
190:
191: --

Line 247: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Lock_Row');

243: FOR UPDATE of Transaction_Code_Id NOWAIT;
244:
245: Recinfo C%ROWTYPE;
246: BEGIN
247: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Lock_Row');
248: OPEN C;
249: FETCH C INTO Recinfo;
250:
251: IF (C%NOTFOUND) THEN

Line 320: cep_standard.debug('row locked');

316: OR ((Recinfo.payroll_payment_format_id IS NULL) AND (X_payroll_payment_format_id IS NULL)))
317: AND ((Recinfo.reconciliation_sequence = X_reconciliation_sequence)
318: OR ((Recinfo.reconciliation_sequence IS NULL) AND (X_reconciliation_sequence IS NULL)))
319: ) THEN
320: cep_standard.debug('row locked');
321: RETURN;
322: ELSE
323: cep_standard.debug('form_record_changed');
324: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 323: cep_standard.debug('form_record_changed');

319: ) THEN
320: cep_standard.debug('row locked');
321: RETURN;
322: ELSE
323: cep_standard.debug('form_record_changed');
324: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
325: APP_EXCEPTION.Raise_Exception;
326: END IF;
327: cep_standard.debug('<

Line 327: cep_standard.debug('<

323: cep_standard.debug('form_record_changed');
324: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
325: APP_EXCEPTION.Raise_Exception;
326: END IF;
327: cep_standard.debug('< 328: END Lock_Row;
329:
330: --
331: -- Procedure

Line 384: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.update_Row');

380: X_reconciliation_sequence NUMBER ,
381: X_request_id NUMBER DEFAULT NULL -- 8707463: Added
382: ) IS
383: BEGIN
384: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.update_Row');
385: UPDATE CE_TRANSACTION_CODES SET
386: transaction_code_id = X_Transaction_Code_Id,
387: bank_account_id = X_Bank_Account_Id,
388: trx_code = X_Trx_Code,

Line 425: cep_standard.debug('NO_DATA_FOUND');

421: request_id = X_request_id --8707463: Added
422: WHERE rowid = X_Rowid;
423: --
424: IF (SQL%NOTFOUND) THEN
425: cep_standard.debug('NO_DATA_FOUND');
426: RAISE NO_DATA_FOUND;
427: END IF;
428: cep_standard.debug('< 429: END Update_Row;

Line 428: cep_standard.debug('<

424: IF (SQL%NOTFOUND) THEN
425: cep_standard.debug('NO_DATA_FOUND');
426: RAISE NO_DATA_FOUND;
427: END IF;
428: cep_standard.debug('< 429: END Update_Row;
430:
431: --
432: -- Procedure

Line 446: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.delete_Row');

442: -- Notes
443: --
444: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
445: BEGIN
446: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.delete_Row');
447: DELETE FROM CE_TRANSACTION_CODES
448: WHERE ROWID = X_Rowid;
449: --
450: IF (SQL%NOTFOUND) THEN

Line 451: cep_standard.debug('NO_DATA_FOUND');

447: DELETE FROM CE_TRANSACTION_CODES
448: WHERE ROWID = X_Rowid;
449: --
450: IF (SQL%NOTFOUND) THEN
451: cep_standard.debug('NO_DATA_FOUND');
452: RAISE NO_DATA_FOUND;
453: END IF;
454: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.update_Row');
455: END Delete_Row;

Line 454: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.update_Row');

450: IF (SQL%NOTFOUND) THEN
451: cep_standard.debug('NO_DATA_FOUND');
452: RAISE NO_DATA_FOUND;
453: END IF;
454: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.update_Row');
455: END Delete_Row;
456:
457: --
458: -- Procedure

Line 530: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.check_unique_txn_code');

526:
527: dummy VARCHAR2(100);
528: --
529: BEGIN
530: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.check_unique_txn_code');
531:
532: OPEN chk_duplicates;
533: FETCH chk_duplicates INTO dummy;
534:

Line 536: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE');

532: OPEN chk_duplicates;
533: FETCH chk_duplicates INTO dummy;
534:
535: IF chk_duplicates%FOUND THEN
536: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE');
537: CLOSE chk_duplicates;
538: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE' );
539: app_exception.raise_exception;
540: END IF;

Line 548: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB2');

544: OPEN chk_duplicates2;
545: FETCH chk_duplicates2 INTO dummy;
546:
547: IF chk_duplicates2%FOUND THEN
548: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB2');
549: CLOSE chk_duplicates2;
550: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB2' );
551: app_exception.raise_exception;
552: END IF;

Line 560: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB1');

556: OPEN chk_duplicates3;
557: FETCH chk_duplicates3 INTO dummy;
558:
559: IF chk_duplicates3%FOUND THEN
560: cep_standard.debug( 'Duplicate: CE_DUP_BANK_TRX_CODE_COMB1');
561: CLOSE chk_duplicates3;
562: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB1' );
563: app_exception.raise_exception;
564: END IF;

Line 568: cep_standard.debug('<

564: END IF;
565:
566: CLOSE chk_duplicates3;
567:
568: cep_standard.debug('< 569: EXCEPTION
570: WHEN app_exceptions.application_exception THEN
571: IF ( chk_duplicates%ISOPEN ) THEN
572: CLOSE chk_duplicates;

Line 582: cep_standard.debug('EXCEPTION: CE_TRANSACTION_CODES_PKG.check_unique_txn_code');

578: CLOSE chk_duplicates3;
579: END IF;
580: RAISE;
581: WHEN OTHERS THEN
582: cep_standard.debug('EXCEPTION: CE_TRANSACTION_CODES_PKG.check_unique_txn_code');
583: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
584: fnd_message.set_token( 'PROCEDURE','CE_TRANSACTION_CODES_pkg.check_unique_txn_code');
585: IF ( chk_duplicates%ISOPEN ) THEN
586: CLOSE chk_duplicates;

Line 614: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.is_in_use');

610:
611: dummy VARCHAR2(240);
612:
613: BEGIN
614: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.is_in_use');
615:
616: /*
617: * Check for transaction code in the statement lines.
618: */

Line 623: cep_standard.debug('Used in statement lines');

619: OPEN chk_stmt_line;
620: FETCH chk_stmt_line INTO dummy;
621:
622: IF chk_stmt_line%FOUND THEN
623: cep_standard.debug('Used in statement lines');
624: CLOSE chk_stmt_line;
625: RETURN TRUE;
626: END IF;
627:

Line 639: cep_standard.debug('Used in archvied statement lines');

635:
636: FETCH chk_arch_stmt_line INTO dummy;
637:
638: IF chk_arch_stmt_line%FOUND THEN
639: cep_standard.debug('Used in archvied statement lines');
640: CLOSE chk_arch_stmt_line;
641: RETURN TRUE;
642: END IF;
643:

Line 646: cep_standard.debug('No reference. Return FALSE');

642: END IF;
643:
644: CLOSE chk_arch_stmt_line;
645:
646: cep_standard.debug('No reference. Return FALSE');
647: RETURN FALSE;
648:
649: cep_standard.debug('< 650: EXCEPTION

Line 649: cep_standard.debug('<

645:
646: cep_standard.debug('No reference. Return FALSE');
647: RETURN FALSE;
648:
649: cep_standard.debug('< 650: EXCEPTION
651: WHEN app_exceptions.application_exception THEN
652: cep_standard.debug('EXCEPTION: Application_exception CE_TRANSACTION_CODES_pkg.Is_In_Use');
653: IF ( chk_stmt_line%ISOPEN ) THEN

Line 652: cep_standard.debug('EXCEPTION: Application_exception CE_TRANSACTION_CODES_pkg.Is_In_Use');

648:
649: cep_standard.debug('< 650: EXCEPTION
651: WHEN app_exceptions.application_exception THEN
652: cep_standard.debug('EXCEPTION: Application_exception CE_TRANSACTION_CODES_pkg.Is_In_Use');
653: IF ( chk_stmt_line%ISOPEN ) THEN
654: CLOSE chk_stmt_line;
655: END IF;
656: IF ( chk_arch_stmt_line%ISOPEN ) THEN

Line 661: cep_standard.debug('EXCEPTION: CE_TRANSACTION_CODES_pkg.Is_In_Use');

657: CLOSE chk_arch_stmt_line;
658: END IF;
659: RAISE;
660: WHEN OTHERS THEN
661: cep_standard.debug('EXCEPTION: CE_TRANSACTION_CODES_pkg.Is_In_Use');
662: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
663: fnd_message.set_token( 'FUNCTION','CE_TRANSACTION_CODES_pkg.Is_In_Use');
664: IF ( chk_stmt_line%ISOPEN ) THEN
665: CLOSE chk_stmt_line;