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.GL_JE_BATCHES_PKG dependencies on GL_JE_BATCHES

Line 1: PACKAGE BODY gl_je_batches_pkg AS

1: PACKAGE BODY gl_je_batches_pkg AS
2: /* $Header: glijebab.pls 120.16.12000000.2 2007/07/25 17:20:31 aktelang ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 16: FROM GL_JE_BATCHES jeb

12: per_type VARCHAR2,
13: row_id VARCHAR2) IS
14: CURSOR chk_duplicates is
15: SELECT 'Duplicate'
16: FROM GL_JE_BATCHES jeb
17: WHERE jeb.name = batch_name
18: AND jeb.default_period_name = period_name
19: AND jeb.chart_of_accounts_id = coa_id
20: AND jeb.period_set_name = cal_name

Line 42: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.check_unique');

38: WHEN app_exceptions.application_exception THEN
39: RAISE;
40: WHEN OTHERS THEN
41: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
42: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.check_unique');
43: RAISE;
44: END check_unique;
45:
46: FUNCTION get_unique_id RETURN NUMBER IS

Line 48: SELECT gl_je_batches_s.NEXTVAL

44: END check_unique;
45:
46: FUNCTION get_unique_id RETURN NUMBER IS
47: CURSOR get_new_id IS
48: SELECT gl_je_batches_s.NEXTVAL
49: FROM dual;
50: new_id number;
51: BEGIN
52: OPEN get_new_id;

Line 61: fnd_message.set_token('SEQUENCE', 'GL_JE_BATCHES_S');

57: return(new_id);
58: ELSE
59: CLOSE get_new_id;
60: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
61: fnd_message.set_token('SEQUENCE', 'GL_JE_BATCHES_S');
62: app_exception.raise_exception;
63: END IF;
64:
65: EXCEPTION

Line 70: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.get_unique_id');

66: WHEN app_exceptions.application_exception THEN
67: RAISE;
68: WHEN OTHERS THEN
69: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
70: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.get_unique_id');
71: RAISE;
72: END get_unique_id;
73:
74:

Line 101: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.has_lines');

97: WHEN app_exceptions.application_exception THEN
98: RAISE;
99: WHEN OTHERS THEN
100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
101: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.has_lines');
102: RAISE;
103: END has_lines;
104:
105:

Line 136: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_approval');

132: WHEN app_exceptions.application_exception THEN
133: RAISE;
134: WHEN OTHERS THEN
135: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
136: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_approval');
137: RAISE;
138: END needs_approval;
139:
140: FUNCTION needs_tax(batch_id NUMBER) RETURN BOOLEAN IS

Line 168: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_tax');

164: WHEN app_exceptions.application_exception THEN
165: RAISE;
166: WHEN OTHERS THEN
167: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
168: fnd_message.set_token('PROCEDURE', 'gl_je_batches_pkg.needs_tax');
169: RAISE;
170: END needs_tax;
171:
172:

Line 290: CURSOR C IS SELECT rowid FROM GL_JE_BATCHES

286: X_Last_Updated_By NUMBER,
287: X_Last_Update_Login NUMBER
288: ) IS
289:
290: CURSOR C IS SELECT rowid FROM GL_JE_BATCHES
291: WHERE je_batch_id = X_Je_Batch_Id;
292:
293: has_je VARCHAR2(1);
294: BEGIN

Line 317: INSERT INTO GL_JE_BATCHES(

313: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
314: app_exception.raise_exception;
315: END IF;
316:
317: INSERT INTO GL_JE_BATCHES(
318: je_batch_id,
319: name,
320: chart_of_accounts_id,
321: period_set_name,

Line 416: FROM GL_JE_BATCHES

412: X_Verify_Request_Completed VARCHAR2
413: ) IS
414: CURSOR C IS
415: SELECT *
416: FROM GL_JE_BATCHES
417: WHERE rowid = X_Rowid
418: FOR UPDATE of Je_Batch_Id NOWAIT;
419: Recinfo C%ROWTYPE;
420: dev_request_phase VARCHAR2(30);

Line 598: FROM gl_je_batches

594: -- refetch the approval status
595: IF (Update_Approval_Stat_Flag = 'Y') THEN
596: SELECT approval_status_code
597: INTO X_Approval_Status_Code
598: FROM gl_je_batches
599: WHERE rowid = X_RowId;
600:
601: -- If a journal has been deleted, we may need to reset the
602: -- approval required flag. Check.

Line 609: IF (gl_je_batches_pkg.needs_approval(X_Je_Batch_Id)) THEN

605: -- posted or approved, but check anyway.
606: IF ( (X_status <> 'P')
607: AND (X_Approval_Status_Code <> 'A')
608: ) THEN
609: IF (gl_je_batches_pkg.needs_approval(X_Je_Batch_Id)) THEN
610: IF (X_Approval_Status_Code = 'Z') THEN
611: X_Approval_Status_Code := 'R';
612: END IF;
613: ELSE

Line 631: UPDATE GL_JE_BATCHES

627:
628: -- To prevent conflicts where the same user is updating multiple headers
629: -- from the same batch, only update the status verified if you are
630: -- updating it to 'N'.
631: UPDATE GL_JE_BATCHES
632: SET
633: je_batch_id = X_Je_Batch_Id,
634: name = X_Name,
635: chart_of_accounts_id = X_Chart_of_Accounts_id,

Line 739: CURSOR C IS SELECT rowid FROM GL_JE_BATCHES

735: X_Global_Attribute18 VARCHAR2,
736: X_Global_Attribute19 VARCHAR2,
737: X_Global_Attribute20 VARCHAR2
738: ) IS
739: CURSOR C IS SELECT rowid FROM GL_JE_BATCHES
740:
741: WHERE je_batch_id = X_Je_Batch_Id;
742: has_je VARCHAR2(1);
743: BEGIN

Line 766: INSERT INTO GL_JE_BATCHES(

762: fnd_message.set_name('SQLGL', 'GL_JE_BATCH_W_NO_JOURNALS');
763: app_exception.raise_exception;
764: END IF;
765:
766: INSERT INTO GL_JE_BATCHES(
767: je_batch_id,
768: last_update_date,
769: last_updated_by,
770: name,

Line 984: FROM GL_JE_BATCHES

980: X_Global_Attribute20 VARCHAR2
981: ) IS
982: CURSOR C IS
983: SELECT *
984: FROM GL_JE_BATCHES
985: WHERE rowid = X_Rowid
986: FOR UPDATE of Je_Batch_Id NOWAIT;
987: Recinfo C%ROWTYPE;
988: dev_request_phase VARCHAR2(30);

Line 1326: FROM gl_je_batches

1322: -- refetch the approval status
1323: IF (Update_Approval_Stat_Flag = 'Y') THEN
1324: SELECT approval_status_code
1325: INTO X_Approval_Status_Code
1326: FROM gl_je_batches
1327: WHERE rowid = X_RowId;
1328:
1329: -- If a journal has been deleted, we may need to reset the
1330: -- approval required flag. Check.

Line 1337: IF (gl_je_batches_pkg.needs_approval(X_Je_Batch_Id)) THEN

1333: -- posted or approved, but check anyway.
1334: IF ( (X_status <> 'P')
1335: AND (X_Approval_Status_Code <> 'A')
1336: ) THEN
1337: IF (gl_je_batches_pkg.needs_approval(X_Je_Batch_Id)) THEN
1338: IF (X_Approval_Status_Code = 'Z') THEN
1339: X_Approval_Status_Code := 'R';
1340: END IF;
1341: ELSE

Line 1347: UPDATE GL_JE_BATCHES

1343: END IF;
1344: END IF;
1345: END IF;
1346:
1347: UPDATE GL_JE_BATCHES
1348: SET
1349:
1350: je_batch_id = X_Je_Batch_Id,
1351: last_update_date = X_Last_Update_Date,

Line 1435: FROM gl_je_batches

1431: status,
1432: request_id
1433: INTO bc_status, approval_status,
1434: batch_status, request_id
1435: FROM gl_je_batches
1436: WHERE rowid = X_Rowid;
1437:
1438: -- Check if we are in the process of reserving funds for
1439: -- this batch

Line 1499: DELETE FROM GL_JE_BATCHES

1495: -- Delete the journals
1496: gl_je_headers_pkg.delete_headers(Je_Batch_Id);
1497:
1498: -- Delete the batches
1499: DELETE FROM GL_JE_BATCHES
1500: WHERE rowid = X_Rowid;
1501:
1502: EXCEPTION
1503: WHEN NO_DATA_FOUND THEN

Line 1507: END gl_je_batches_pkg;

1503: WHEN NO_DATA_FOUND THEN
1504: null;
1505: END Delete_Row;
1506:
1507: END gl_je_batches_pkg;