DBA Data[Home] [Help]

APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_VAL_ASULEB

Line 1: PACKAGE BODY igs_av_val_asuleb AS

1: PACKAGE BODY igs_av_val_asuleb AS
2: /* $Header: IGSAV07B.pls 115.7 2003/12/10 07:40:42 nalkumar ship $ */
3:
4: G_ITEM_TYPE VARCHAR2(300);
5: -- To validate the basis year advanced standing units or levels.

Line 55: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');

51: RETURN TRUE;
52: EXCEPTION
53: WHEN OTHERS THEN
54: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
55: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');
56: App_Exception.Raise_Exception;
57: IGS_GE_MSG_STACK.ADD;
58: END;
59: END advp_val_basis_year;

Line 106: wf_core.context('igs_av_val_asuleb','create_transcript',l_item_type,l_item_key);

102: /* Write the header doc into CLOB variable */
103: WF_NOTIFICATION.WriteToClob(document, l_message);
104: EXCEPTION
105: WHEN OTHERS THEN
106: wf_core.context('igs_av_val_asuleb','create_transcript',l_item_type,l_item_key);
107: RAISE;
108: END create_transcript;
109:
110: PROCEDURE wf_set_role(

Line 177: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_UDTL');

173: IF NVL(l_notification_flag, 'Z') IN ('D', 'DM', 'DN', 'DMN') THEN
174: wf_engine.setitemattrtext(ItemType => itemtype,
175: ItemKey => itemkey,
176: aname => 'P_DEL_UDTL',
177: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_UDTL');
178: wf_engine.setitemattrtext(ItemType => itemtype,
179: ItemKey => itemkey,
180: aname => 'P_DEL_BDTL',
181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');

Line 181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');

177: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_UDTL');
178: wf_engine.setitemattrtext(ItemType => itemtype,
179: ItemKey => itemkey,
180: aname => 'P_DEL_BDTL',
181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');
182: END IF;
183: IF NVL(l_notification_flag, 'Z') IN ('DM', 'MN', 'M', 'DMN') THEN
184: wf_engine.setitemattrtext(ItemType => itemtype,
185: ItemKey => itemkey,

Line 187: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_UDTL');

183: IF NVL(l_notification_flag, 'Z') IN ('DM', 'MN', 'M', 'DMN') THEN
184: wf_engine.setitemattrtext(ItemType => itemtype,
185: ItemKey => itemkey,
186: aname => 'P_MOD_UDTL',
187: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_UDTL');
188: wf_engine.setitemattrtext(ItemType => itemtype,
189: ItemKey => itemkey,
190: aname => 'P_MOD_BDTL',
191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');

Line 191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');

187: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_UDTL');
188: wf_engine.setitemattrtext(ItemType => itemtype,
189: ItemKey => itemkey,
190: aname => 'P_MOD_BDTL',
191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');
192: END IF;
193: IF NVL(l_notification_flag, 'Z') IN ('DMN', 'DN', 'MN', 'N') THEN
194: wf_engine.setitemattrtext(ItemType => itemtype,
195: ItemKey => itemkey,

Line 197: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_NEW_BDTL');

193: IF NVL(l_notification_flag, 'Z') IN ('DMN', 'DN', 'MN', 'N') THEN
194: wf_engine.setitemattrtext(ItemType => itemtype,
195: ItemKey => itemkey,
196: aname => 'P_NEW_BDTL',
197: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_NEW_BDTL');
198:
199: END IF;
200:
201: --

Line 270: wf_core.context('IGS_AV_VAL_ASULEB', 'VALIDATE_TRANSCRIPT',

266: --
267: l_parameter_list_t.delete;
268: EXCEPTION
269: WHEN OTHERS THEN
270: wf_core.context('IGS_AV_VAL_ASULEB', 'VALIDATE_TRANSCRIPT',
271: l_seq_val,l_raise_event);
272: RAISE;
273: END validate_transcript;
274:

Line 727: END igs_av_val_asuleb;

723: ItemKey => p_itemkey,
724: aname => 'P_REC_NEW_BDTL',
725: avalue => l_new_basis_dtls_body);
726: END get_transcript_data;
727: END igs_av_val_asuleb;