DBA Data[Home] [Help]

APPS.IGI_EXP_AP_TRANS_PKG dependencies on IGI_EXP_AP_TRANS_PKG

Line 1: PACKAGE BODY igi_exp_ap_trans_pkg AS

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;

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 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 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 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 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 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 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 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 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 868: END igi_exp_ap_trans_pkg;

864:
865: END delete_row;
866:
867:
868: END igi_exp_ap_trans_pkg;