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 CE_TRANSACTION_CODES

Line 1: PACKAGE BODY CE_TRANSACTION_CODES_PKG as

1: PACKAGE BODY CE_TRANSACTION_CODES_PKG as
2: /* $Header: cetrxcdb.pls 120.4.12010000.2 2009/07/31 09:34:48 vnetan ship $ */
3: --
4: -- Package
5: -- ce_transaction_codes_pkg

Line 5: -- ce_transaction_codes_pkg

1: PACKAGE BODY CE_TRANSACTION_CODES_PKG as
2: /* $Header: cetrxcdb.pls 120.4.12010000.2 2009/07/31 09:34:48 vnetan ship $ */
3: --
4: -- Package
5: -- ce_transaction_codes_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for ce_transaction_codes
8: -- History
9: -- 00-00-94 Dean McCarthy Created

Line 7: -- To contain validation and insertion routines for ce_transaction_codes

3: --
4: -- Package
5: -- ce_transaction_codes_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for ce_transaction_codes
8: -- History
9: -- 00-00-94 Dean McCarthy Created
10:
11: FUNCTION body_revision RETURN VARCHAR2 IS

Line 25: -- Inserts a row into ce_transaction_codes

21: --
22: -- Procedure
23: -- Insert_Row
24: -- Purpose
25: -- Inserts a row into ce_transaction_codes
26: -- History
27: -- 00-00-94 Dean McCarthy Created
28: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
29: -- Arguments

Line 30: -- all the columns of the table CE_TRANSACTION_CODES

26: -- History
27: -- 00-00-94 Dean McCarthy Created
28: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
29: -- Arguments
30: -- all the columns of the table CE_TRANSACTION_CODES
31: -- Example
32: -- CE_TRANSACTION_CODES.Insert_Row(....;
33: -- Notes
34: --

Line 32: -- CE_TRANSACTION_CODES.Insert_Row(....;

28: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
29: -- Arguments
30: -- all the columns of the table CE_TRANSACTION_CODES
31: -- Example
32: -- CE_TRANSACTION_CODES.Insert_Row(....;
33: -- Notes
34: --
35: PROCEDURE Insert_Row(
36: X_Rowid IN OUT NOCOPY VARCHAR2,

Line 78: SELECT rowid FROM CE_TRANSACTION_CODES

74: X_request_id NUMBER DEFAULT NULL --8707463: Added
75: ) IS
76:
77: CURSOR C IS
78: SELECT rowid FROM CE_TRANSACTION_CODES
79: WHERE transaction_code_id = X_Transaction_Code_Id;
80:
81: CURSOR C2 IS
82: SELECT ce_transaction_codes_s.nextval

Line 82: SELECT ce_transaction_codes_s.nextval

78: SELECT rowid FROM CE_TRANSACTION_CODES
79: WHERE transaction_code_id = X_Transaction_Code_Id;
80:
81: CURSOR C2 IS
82: SELECT ce_transaction_codes_s.nextval
83: FROM sys.dual;
84:
85: BEGIN
86: cep_standard.debug('>>CE_TRANSACTION_CODES_PKG.Insert_Row');

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 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 97: INSERT INTO CE_TRANSACTION_CODES(

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,
100: trx_code,
101: trx_type,

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 199: -- all the columns of the table CE_TRANSACTION_CODES

195: -- Locks a row into gl_daily_conversion_rates
196: -- History
197: -- 00-00-94 Dean McCarthy Created
198: -- Arguments
199: -- all the columns of the table CE_TRANSACTION_CODES
200: -- Example
201: -- ce_transaction_codes.Lock_Row(....;
202: -- Notes
203: --

Line 201: -- ce_transaction_codes.Lock_Row(....;

197: -- 00-00-94 Dean McCarthy Created
198: -- Arguments
199: -- all the columns of the table CE_TRANSACTION_CODES
200: -- Example
201: -- ce_transaction_codes.Lock_Row(....;
202: -- Notes
203: --
204: PROCEDURE Lock_Row(
205: X_Rowid VARCHAR2,

Line 241: FROM CE_TRANSACTION_CODES

237: X_reconciliation_sequence NUMBER
238: ) IS
239: CURSOR C IS
240: SELECT *
241: FROM CE_TRANSACTION_CODES
242: WHERE rowid = X_Rowid
243: FOR UPDATE of Transaction_Code_Id NOWAIT;
244:
245: Recinfo C%ROWTYPE;

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 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 334: -- Updates a row into ce_transaction_codes

330: --
331: -- Procedure
332: -- Update_Row
333: -- Purpose
334: -- Updates a row into ce_transaction_codes
335: -- History
336: -- 00-00-94 Dean McCarthy Created
337: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
338: -- Arguments

Line 339: -- all the columns of the table CE_TRANSACTION_CODES

335: -- History
336: -- 00-00-94 Dean McCarthy Created
337: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
338: -- Arguments
339: -- all the columns of the table CE_TRANSACTION_CODES
340: -- Example
341: -- ce_transaction_codes.Update_Row(....;
342: -- Notes
343: --

Line 341: -- ce_transaction_codes.Update_Row(....;

337: -- 07-20-09 vnetan 8707463: Added REQUEST_ID
338: -- Arguments
339: -- all the columns of the table CE_TRANSACTION_CODES
340: -- Example
341: -- ce_transaction_codes.Update_Row(....;
342: -- Notes
343: --
344: PROCEDURE Update_Row(
345: X_Rowid VARCHAR2,

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 385: UPDATE CE_TRANSACTION_CODES SET

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,
389: trx_type = X_Trx_Type,

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 435: -- Deletes a row from ce_transaction_codes

431: --
432: -- Procedure
433: -- Delete_Row
434: -- Purpose
435: -- Deletes a row from ce_transaction_codes
436: -- History
437: -- 00-00-94 Dean McCarthy Created
438: -- Arguments
439: -- x_rowid Rowid of a row

Line 441: -- ce_transaction_codes.delete_row('ajfdshj');

437: -- 00-00-94 Dean McCarthy Created
438: -- Arguments
439: -- x_rowid Rowid of a row
440: -- Example
441: -- ce_transaction_codes.delete_row('ajfdshj');
442: -- Notes
443: --
444: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
445: BEGIN

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 447: DELETE FROM CE_TRANSACTION_CODES

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
451: cep_standard.debug('NO_DATA_FOUND');

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 481: -- ce_transaction_codes.check_unique_txn_code('ajfdshj', 11, '123.657.99', DEBIT, AP, 1 );

477: -- X_trx_type DEBIT, CREDIT, MISC_DEBIT, MISC_CREDIT, NSF, REJECTED, STOP
478: -- X_RECONCILE_FLAG null, AR, AP, JE, CE, OI
479: -- X_RECONCILIATION_SEQUENCE null, 1,2,3 ...
480: -- Example
481: -- ce_transaction_codes.check_unique_txn_code('ajfdshj', 11, '123.657.99', DEBIT, AP, 1 );
482: -- Notes
483: --
484: PROCEDURE check_unique_txn_code(
485: X_TRX_CODE IN VARCHAR2,

Line 496: FROM ce_transaction_codes tc

492: -- each trx_code cannot be used by more than one trx_type
493: -- check Type, Code
494: CURSOR chk_duplicates is
495: SELECT 'Duplicate'
496: FROM ce_transaction_codes tc
497: WHERE tc.trx_code = X_trx_code
498: AND tc. bank_account_id = X_bank_account_id
499: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id))
500: AND EXISTS(

Line 502: FROM ce_transaction_codes tc2

498: AND tc. bank_account_id = X_bank_account_id
499: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id))
500: AND EXISTS(
501: SELECT 'x'
502: FROM ce_transaction_codes tc2
503: WHERE tc2.trx_code = tc.trx_code
504: AND tc2.bank_account_id = tc.bank_account_id
505: AND tc2.TRX_TYPE <> X_trx_type);
506:

Line 510: FROM ce_transaction_codes tc

506:
507: -- check Code, Priority combiniation
508: CURSOR chk_duplicates2 IS
509: SELECT 'Duplicate'
510: FROM ce_transaction_codes tc
511: WHERE tc.trx_code = X_trx_code
512: AND tc.bank_account_id = X_bank_account_id
513: AND NVL(tc.RECONCILIATION_SEQUENCE,0) = NVL(X_RECONCILIATION_SEQUENCE,0)
514: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id));

Line 520: FROM ce_transaction_codes tc

516:
517: -- check Code, Transaction Source combiniation
518: CURSOR chk_duplicates3 IS
519: SELECT 'Duplicate'
520: FROM ce_transaction_codes tc
521: WHERE tc.trx_code = X_trx_code
522: AND tc. bank_account_id = X_bank_account_id
523: AND NVL(tc.RECONCILE_FLAG, 'X') = NVL(X_RECONCILE_FLAG, 'X')
524: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID( X_Row_id ) );

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 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 584: fnd_message.set_token( 'PROCEDURE','CE_TRANSACTION_CODES_pkg.check_unique_txn_code');

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;
587: END IF;
588: IF ( chk_duplicates2%ISOPEN ) THEN

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 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;

Line 663: fnd_message.set_token( 'FUNCTION','CE_TRANSACTION_CODES_pkg.Is_In_Use');

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;
666: END IF;
667: IF ( chk_arch_stmt_line%ISOPEN ) THEN

Line 673: END CE_TRANSACTION_CODES_PKG;

669: END IF;
670: RAISE;
671: END is_in_use;
672:
673: END CE_TRANSACTION_CODES_PKG;