APPS.IGI_MPP_SETUP_PKG dependencies on IGI_MPP_SETUP

Line 1: PACKAGE BODY IGI_MPP_SETUP_PKG AS

1: PACKAGE BODY IGI_MPP_SETUP_PKG AS
2: -- $Header: igipmsub.pls 115.6 2003/12/01 16:13:17 sdixit ship $
3: --bug 3199481: following variables added for fnd logging changes:sdixit :start
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;

Line 28: FROM igi_mpp_setup

24: ) IS
25:
26: CURSOR c_insert IS
27: SELECT rowid row_id
28: FROM igi_mpp_setup
29: WHERE set_of_books_id = X_set_of_books_id ;
30: BEGIN
31: INSERT INTO IGI_MPP_SETUP
32: ( set_of_books_id

Line 31: INSERT INTO IGI_MPP_SETUP

27: SELECT rowid row_id
28: FROM igi_mpp_setup
29: WHERE set_of_books_id = X_set_of_books_id ;
30: BEGIN
31: INSERT INTO IGI_MPP_SETUP
32: ( set_of_books_id
33: , future_posting_ccid
34: , default_accounting_rule_id
35: , je_category_name

Line 63: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Insert_Row',FALSE);

59: CLOSE c_insert;
60: raise no_data_found;
61: --bug 3199481: fnd logging changes:sdixit :start
62: IF (l_error_level >= l_debug_level ) THEN
63: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Insert_Row',FALSE);
64: END IF;
65: --bug 3199481 fnd logging changes: sdixit: end block
66: END IF;
67: CLOSE c_insert;

Line 81: UPDATE igi_mpp_setup SET

77: , X_last_updated_by in number
78: , X_last_update_login in number
79: ) IS
80: BEGIN
81: UPDATE igi_mpp_setup SET
82: future_posting_ccid = X_future_posting_ccid
83: , default_accounting_rule_id = X_default_accounting_rule_id
84: , je_category_name = X_je_category_name
85: , je_source_name = X_je_source_name

Line 95: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Update_Row',FALSE);

91: IF SQL%NOTFOUND THEN
92: raise no_data_found;
93: --bug 3199481: fnd logging changes:sdixit :start
94: IF (l_error_level >= l_debug_level ) THEN
95: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Update_Row',FALSE);
96: END IF;
97: --bug 3199481 fnd logging changes: sdixit: end block
98: END IF;
99:

Line 113: from igi_mpp_setup

109: ) IS
110:
111: CURSOR c_mpp_Setup IS
112: SELECT *
113: from igi_mpp_setup
114: where rowid = X_rowid
115: for update of set_of_books_id NOWAIT
116: ;
117:

Line 128: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Lock_Row.FORM_RECORD_DELETED',FALSE);

124: close c_mpp_setup;
125: fnd_message.set_name( 'FND', 'FORM_RECORD_DELETED');
126: --bug 3199481: fnd logging changes:sdixit :start
127: IF (l_error_level >= l_debug_level ) THEN
128: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Lock_Row.FORM_RECORD_DELETED',FALSE);
129: END IF;
130: --bug 3199481 fnd logging changes: sdixit: end block
131: app_exception.raise_exception;
132: END IF;

Line 163: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Lock_Row.FORM_RECORD_CHANGED',FALSE);

159: else
160: fnd_message.set_name( 'FND', 'FORM_RECORD_CHANGED');
161: --bug 3199481: fnd logging changes:sdixit :start
162: IF (l_error_level >= l_debug_level ) THEN
163: FND_LOG.MESSAGE (l_error_level , 'igi.pls.igipmsub.IGI_MPP_SETUP_PKG.Lock_Row.FORM_RECORD_CHANGED',FALSE);
164: END IF;
165: --bug 3199481 fnd logging changes: sdixit: end block
166: app_exception.raise_exception;
167: END IF;

Line 171: END IGI_MPP_SETUP_PKG ;

167: END IF;
168: END;
169:
170: -- Enter further code below as specified in the Package spec.
171: END IGI_MPP_SETUP_PKG ;