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.IGI_EXP_AP_TRANS_PKG dependencies on FND_LOG

Line 4: --following variables added for bug 3199481: fnd logging changes: sdixit

1: PACKAGE BODY igi_exp_ap_trans_pkg AS
2: /* $Header: igiexpyb.pls 120.4.12000000.1 2007/09/13 04:25:23 mbremkum ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;

Line 5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY igi_exp_ap_trans_pkg AS
2: /* $Header: igiexpyb.pls 120.4.12000000.1 2007/09/13 04:25:23 mbremkum ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 6: l_state_level number := FND_LOG.LEVEL_STATEMENT;

2: /* $Header: igiexpyb.pls 120.4.12000000.1 2007/09/13 04:25:23 mbremkum ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 8: l_event_level number := FND_LOG.LEVEL_EVENT;

4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:

Line 9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);

Line 10: l_error_level number := FND_LOG.LEVEL_ERROR;

6: l_state_level number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_ap_trans_all%ROWTYPE;

Line 11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number := FND_LOG.LEVEL_EVENT;
9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_ap_trans_all%ROWTYPE;
15: new_references igi_exp_ap_trans_all%ROWTYPE;

Line 71: --bug 3199481 fnd logging changes: sdixit: start block

67: FETCH cur_old_ref_values INTO old_references;
68: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
69: CLOSE cur_old_ref_values;
70: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
71: --bug 3199481 fnd logging changes: sdixit: start block
72: IF (l_error_level >= l_debug_level ) THEN
73: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.set_column_values',FALSE);
74: END IF;
75: --bug 3199481 fnd logging changes: sdixit: end block

Line 73: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.set_column_values',FALSE);

69: CLOSE cur_old_ref_values;
70: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
71: --bug 3199481 fnd logging changes: sdixit: start block
72: IF (l_error_level >= l_debug_level ) THEN
73: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.set_column_values',FALSE);
74: END IF;
75: --bug 3199481 fnd logging changes: sdixit: end block
76:
77: app_exception.raise_exception;

Line 75: --bug 3199481 fnd logging changes: sdixit: end block

71: --bug 3199481 fnd logging changes: sdixit: start block
72: IF (l_error_level >= l_debug_level ) THEN
73: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.set_column_values',FALSE);
74: END IF;
75: --bug 3199481 fnd logging changes: sdixit: end block
76:
77: app_exception.raise_exception;
78: RETURN;
79: END IF;

Line 138: --bug 3199481 fnd logging changes: sdixit: start block

134: ELSIF NOT igi_exp_dus_pkg.get_pk_for_validation (
135: new_references.du_id
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: --bug 3199481 fnd logging changes: sdixit: start block
139: IF (l_error_level >= l_debug_level ) THEN
140: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.check_parent_existance',FALSE);
141: END IF;
142: --bug 3199481 fnd logging changes: sdixit: end block

Line 140: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.check_parent_existance',FALSE);

136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: --bug 3199481 fnd logging changes: sdixit: start block
139: IF (l_error_level >= l_debug_level ) THEN
140: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.check_parent_existance',FALSE);
141: END IF;
142: --bug 3199481 fnd logging changes: sdixit: end block
143:
144: app_exception.raise_exception;

Line 142: --bug 3199481 fnd logging changes: sdixit: end block

138: --bug 3199481 fnd logging changes: sdixit: start block
139: IF (l_error_level >= l_debug_level ) THEN
140: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.check_parent_existance',FALSE);
141: END IF;
142: --bug 3199481 fnd logging changes: sdixit: end block
143:
144: app_exception.raise_exception;
145: END IF;
146:

Line 211: --bug 3199481 fnd logging changes: sdixit: start block

207: FETCH cur_rowid INTO lv_rowid;
208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name('FND' ,'FND-CANNOT DELETE MASTER');
211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.get_fk_igi_exp_dus',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block

Line 213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.get_fk_igi_exp_dus',FALSE);

209: CLOSE cur_rowid;
210: fnd_message.set_name('FND' ,'FND-CANNOT DELETE MASTER');
211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.get_fk_igi_exp_dus',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block
216: app_exception.raise_exception;
217: RETURN;

Line 215: --bug 3199481 fnd logging changes: sdixit: end block

211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.get_fk_igi_exp_dus',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block
216: app_exception.raise_exception;
217: RETURN;
218: END IF;
219: CLOSE cur_rowid;

Line 301: --bug 3199481 fnd logging changes: sdixit: start block

297: new_references.ap_tran_id
298: )
299: ) THEN
300: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
301: --bug 3199481 fnd logging changes: sdixit: start block
302: IF (l_error_level >= l_debug_level ) THEN
303: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg1',FALSE);
304: END IF;
305: --bug 3199481 fnd logging changes: sdixit: end block

Line 303: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg1',FALSE);

299: ) THEN
300: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
301: --bug 3199481 fnd logging changes: sdixit: start block
302: IF (l_error_level >= l_debug_level ) THEN
303: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg1',FALSE);
304: END IF;
305: --bug 3199481 fnd logging changes: sdixit: end block
306:
307: app_exception.raise_exception;

Line 305: --bug 3199481 fnd logging changes: sdixit: end block

301: --bug 3199481 fnd logging changes: sdixit: start block
302: IF (l_error_level >= l_debug_level ) THEN
303: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg1',FALSE);
304: END IF;
305: --bug 3199481 fnd logging changes: sdixit: end block
306:
307: app_exception.raise_exception;
308: END IF;
309: check_parent_existance;

Line 320: --bug 3199481 fnd logging changes: sdixit: start block

316: new_references.ap_tran_id
317: )
318: ) THEN
319: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
320: --bug 3199481 fnd logging changes: sdixit: start block
321: IF (l_error_level >= l_debug_level ) THEN
322: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg2',FALSE);
323: END IF;
324: --bug 3199481 fnd logging changes: sdixit: end block

Line 322: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg2',FALSE);

318: ) THEN
319: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
320: --bug 3199481 fnd logging changes: sdixit: start block
321: IF (l_error_level >= l_debug_level ) THEN
322: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg2',FALSE);
323: END IF;
324: --bug 3199481 fnd logging changes: sdixit: end block
325:
326: app_exception.raise_exception;

Line 324: --bug 3199481 fnd logging changes: sdixit: end block

320: --bug 3199481 fnd logging changes: sdixit: start block
321: IF (l_error_level >= l_debug_level ) THEN
322: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.before_dml.msg2',FALSE);
323: END IF;
324: --bug 3199481 fnd logging changes: sdixit: end block
325:
326: app_exception.raise_exception;
327: END IF;
328: END IF;

Line 391: --bug 3199481 fnd logging changes: sdixit: start block

387: x_last_update_login := -1;
388: END IF;
389: ELSE
390: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
391: --bug 3199481 fnd logging changes: sdixit: start block
392: IF (l_error_level >= l_debug_level ) THEN
393: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.insert_row',FALSE);
394: END IF;
395: --bug 3199481 fnd logging changes: sdixit: end block

Line 393: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.insert_row',FALSE);

389: ELSE
390: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
391: --bug 3199481 fnd logging changes: sdixit: start block
392: IF (l_error_level >= l_debug_level ) THEN
393: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.insert_row',FALSE);
394: END IF;
395: --bug 3199481 fnd logging changes: sdixit: end block
396:
397: app_exception.raise_exception;

Line 395: --bug 3199481 fnd logging changes: sdixit: end block

391: --bug 3199481 fnd logging changes: sdixit: start block
392: IF (l_error_level >= l_debug_level ) THEN
393: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.insert_row',FALSE);
394: END IF;
395: --bug 3199481 fnd logging changes: sdixit: end block
396:
397: app_exception.raise_exception;
398: END IF;
399:

Line 564: --bug 3199481 fnd logging changes: sdixit: start block

560: OPEN c1;
561: FETCH c1 INTO tlinfo;
562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: --bug 3199481 fnd logging changes: sdixit: start block
565: IF (l_error_level >= l_debug_level ) THEN
566: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
567: END IF;
568: --bug 3199481 fnd logging changes: sdixit: end block

Line 566: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);

562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: --bug 3199481 fnd logging changes: sdixit: start block
565: IF (l_error_level >= l_debug_level ) THEN
566: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
567: END IF;
568: --bug 3199481 fnd logging changes: sdixit: end block
569:
570: CLOSE c1;

Line 568: --bug 3199481 fnd logging changes: sdixit: end block

564: --bug 3199481 fnd logging changes: sdixit: start block
565: IF (l_error_level >= l_debug_level ) THEN
566: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
567: END IF;
568: --bug 3199481 fnd logging changes: sdixit: end block
569:
570: CLOSE c1;
571: app_exception.raise_exception;
572: RETURN;

Line 600: --bug 3199481 fnd logging changes: sdixit: start block

596: ) THEN
597: NULL;
598: ELSE
599: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
600: --bug 3199481 fnd logging changes: sdixit: start block
601: IF (l_error_level >= l_debug_level ) THEN
602: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
603: END IF;
604: --bug 3199481 fnd logging changes: sdixit: end block

Line 602: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);

598: ELSE
599: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
600: --bug 3199481 fnd logging changes: sdixit: start block
601: IF (l_error_level >= l_debug_level ) THEN
602: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
603: END IF;
604: --bug 3199481 fnd logging changes: sdixit: end block
605:
606: app_exception.raise_exception;

Line 604: --bug 3199481 fnd logging changes: sdixit: end block

600: --bug 3199481 fnd logging changes: sdixit: start block
601: IF (l_error_level >= l_debug_level ) THEN
602: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.lock_row',FALSE);
603: END IF;
604: --bug 3199481 fnd logging changes: sdixit: end block
605:
606: app_exception.raise_exception;
607: END IF;
608:

Line 667: --bug 3199481 fnd logging changes: sdixit: start block

663: x_last_update_login := -1;
664: END IF;
665: ELSE
666: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
667: --bug 3199481 fnd logging changes: sdixit: start block
668: IF (l_error_level >= l_debug_level ) THEN
669: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.update_row',FALSE);
670: END IF;
671: --bug 3199481 fnd logging changes: sdixit: end block

Line 669: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.update_row',FALSE);

665: ELSE
666: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
667: --bug 3199481 fnd logging changes: sdixit: start block
668: IF (l_error_level >= l_debug_level ) THEN
669: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.update_row',FALSE);
670: END IF;
671: --bug 3199481 fnd logging changes: sdixit: end block
672:
673: app_exception.raise_exception;

Line 671: --bug 3199481 fnd logging changes: sdixit: end block

667: --bug 3199481 fnd logging changes: sdixit: start block
668: IF (l_error_level >= l_debug_level ) THEN
669: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpyb.IGI_EXP_AP_TRANS_PKG.update_row',FALSE);
670: END IF;
671: --bug 3199481 fnd logging changes: sdixit: end block
672:
673: app_exception.raise_exception;
674: END IF;
675: