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.AHL_ITEMCOMP_APPROVAL_PVT dependencies on FND_MESSAGE

Line 102: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

98: FETCH GetItemCompDet into l_item_comp_rec;
99:
100: IF GetItemCompDet%NOTFOUND
101: THEN
102: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE

Line 103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

99:
100: IF GetItemCompDet%NOTFOUND
101: THEN
102: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');

Line 104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

100: IF GetItemCompDet%NOTFOUND
101: THEN
102: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 105: l_subject := fnd_message.get;

101: THEN
102: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');

103: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');

Line 108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

104: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

105: l_subject := fnd_message.get;
106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 110: l_fwd_subject := fnd_message.get;

106: ELSE
107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;

Line 111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');

107: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_SUBJECT');
108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');

Line 112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

108: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

109: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 114: l_appr_subject := fnd_message.get;

110: l_fwd_subject := fnd_message.get;
111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;

Line 115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');

111: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPR_SUBJECT');
112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');

Line 116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

112: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

113: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 118: l_reject_subject := fnd_message.get;

114: l_appr_subject := fnd_message.get;
115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;

Line 119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');

115: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');

Line 120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

116: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

117: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 122: l_approved_subject := fnd_message.get;

118: l_reject_subject := fnd_message.get;
119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;

Line 123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');

119: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPRD_SUBJECT');
120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');

Line 124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

120: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

121: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 126: l_final_subject := fnd_message.get;

122: l_approved_subject := fnd_message.get;
123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;

Line 127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');

123: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FINAL_SUBJECT');
124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');

Line 128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

124: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

Line 129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

125: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 130: l_remind_subject := fnd_message.get;

126: l_final_subject := fnd_message.get;
127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
134: l_error_subject := fnd_message.get;

Line 131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');

127: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND_SUBJECT');
128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
134: l_error_subject := fnd_message.get;
135:

Line 132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

128: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
134: l_error_subject := fnd_message.get;
135:
136:

Line 133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

129: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
134: l_error_subject := fnd_message.get;
135:
136:
137: END IF;

Line 134: l_error_subject := fnd_message.get;

130: l_remind_subject := fnd_message.get;
131: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_SUBJECT');
132: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
133: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
134: l_error_subject := fnd_message.get;
135:
136:
137: END IF;
138: CLOSE GetItemCompDet;

Line 403: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

399: FETCH GetItemCompDet into l_item_comp_rec;
400:
401: IF GetItemCompDet%NOTFOUND
402: THEN
403: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE

Line 404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

400:
401: IF GetItemCompDet%NOTFOUND
402: THEN
403: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');

Line 405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

401: IF GetItemCompDet%NOTFOUND
402: THEN
403: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 406: l_body := fnd_message.get;

402: THEN
403: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
410: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');

404: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
410: fnd_message.set_token('APPR_NAME',l_approver, false);
411: l_body := fnd_message.get;
412: END IF;

Line 409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

405: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
410: fnd_message.set_token('APPR_NAME',l_approver, false);
411: l_body := fnd_message.get;
412: END IF;
413: CLOSE GetItemCompDet;

Line 410: fnd_message.set_token('APPR_NAME',l_approver, false);

406: l_body := fnd_message.get;
407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
410: fnd_message.set_token('APPR_NAME',l_approver, false);
411: l_body := fnd_message.get;
412: END IF;
413: CLOSE GetItemCompDet;
414:

Line 411: l_body := fnd_message.get;

407: ELSE
408: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FWD');
409: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
410: fnd_message.set_token('APPR_NAME',l_approver, false);
411: l_body := fnd_message.get;
412: END IF;
413: CLOSE GetItemCompDet;
414:
415:

Line 418: -- that will be used to replace tokens defined in FND Messages.

414:
415:
416: /*--------------------------------------------------------------------------
417: -- Query approval object table for any detail information of this object
418: -- that will be used to replace tokens defined in FND Messages.
419: -- Here to simplify, we are using hard-coded messages.
420: ----------------------------------------------------------------------------*/
421: document := document || l_body;
422: RETURN;

Line 524: -- that will be used to replace tokens defined in FND Messages.

520: );
521:
522: /*--------------------------------------------------------------------------
523: -- Query approval object table for any detail information of this object
524: -- that will be used to replace tokens defined in FND Messages.
525: -- Here to simplify, we are using hard-coded messages.
526: ----------------------------------------------------------------------------*/
527: OPEN GetItemCompDet(l_object_id);
528: FETCH GetItemCompDet into l_item_comp_rec;

Line 532: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

528: FETCH GetItemCompDet into l_item_comp_rec;
529:
530: IF GetItemCompDet%NOTFOUND
531: THEN
532: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE

Line 533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

529:
530: IF GetItemCompDet%NOTFOUND
531: THEN
532: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');

Line 534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

530: IF GetItemCompDet%NOTFOUND
531: THEN
532: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 535: l_body := fnd_message.get;

531: THEN
532: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
539: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');

533: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
539: fnd_message.set_token('APPR_NAME',l_approver, false);
540: l_body := fnd_message.get;
541: END IF;

Line 538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

534: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
539: fnd_message.set_token('APPR_NAME',l_approver, false);
540: l_body := fnd_message.get;
541: END IF;
542: CLOSE GetItemCompDet;

Line 539: fnd_message.set_token('APPR_NAME',l_approver, false);

535: l_body := fnd_message.get;
536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
539: fnd_message.set_token('APPR_NAME',l_approver, false);
540: l_body := fnd_message.get;
541: END IF;
542: CLOSE GetItemCompDet;
543:

Line 540: l_body := fnd_message.get;

536: ELSE
537: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_APPRVD');
538: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
539: fnd_message.set_token('APPR_NAME',l_approver, false);
540: l_body := fnd_message.get;
541: END IF;
542: CLOSE GetItemCompDet;
543:
544:

Line 677: -- that will be used to replace tokens defined in FND Messages.

673:
674:
675: /*--------------------------------------------------------------------------
676: -- Query approval object table for any detail information of this object
677: -- that will be used to replace tokens defined in FND Messages.
678: -- Here to simplify, we are using hard-coded messages.
679: ----------------------------------------------------------------------------*/
680:
681: OPEN GetItemCompDet(l_object_id);

Line 686: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

682: FETCH GetItemCompDet into l_item_comp_rec;
683:
684: IF GetItemCompDet%NOTFOUND
685: THEN
686: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE

Line 687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

683:
684: IF GetItemCompDet%NOTFOUND
685: THEN
686: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');

Line 688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

684: IF GetItemCompDet%NOTFOUND
685: THEN
686: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 689: l_body := fnd_message.get;

685: THEN
686: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');

687: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
694: l_body := fnd_message.get;
695: END IF;

Line 692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

688: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
694: l_body := fnd_message.get;
695: END IF;
696: CLOSE GetItemCompDet;

Line 693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

689: l_body := fnd_message.get;
690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
694: l_body := fnd_message.get;
695: END IF;
696: CLOSE GetItemCompDet;
697:

Line 694: l_body := fnd_message.get;

690: ELSE
691: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_FINAL');
692: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
693: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
694: l_body := fnd_message.get;
695: END IF;
696: CLOSE GetItemCompDet;
697:
698:

Line 827: -- that will be used to replace tokens defined in FND Messages.

823: );
824:
825: /*--------------------------------------------------------------------------
826: -- Query approval object table for any detail information of this object
827: -- that will be used to replace tokens defined in FND Messages.
828: -- Here to simplify, we are using hard-coded messages.
829: ----------------------------------------------------------------------------*/
830: OPEN GetItemCompDet(l_object_id);
831: FETCH GetItemCompDet into l_item_comp_rec;

Line 835: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

831: FETCH GetItemCompDet into l_item_comp_rec;
832:
833: IF GetItemCompDet%NOTFOUND
834: THEN
835: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE

Line 836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

832:
833: IF GetItemCompDet%NOTFOUND
834: THEN
835: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');

Line 837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

833: IF GetItemCompDet%NOTFOUND
834: THEN
835: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 838: l_body := fnd_message.get;

834: THEN
835: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
842: fnd_message.set_token('APPR_NAME',l_approver, false);

Line 840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');

836: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
842: fnd_message.set_token('APPR_NAME',l_approver, false);
843: l_body := fnd_message.get;
844: END IF;

Line 841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

837: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
842: fnd_message.set_token('APPR_NAME',l_approver, false);
843: l_body := fnd_message.get;
844: END IF;
845: CLOSE GetItemCompDet;

Line 842: fnd_message.set_token('APPR_NAME',l_approver, false);

838: l_body := fnd_message.get;
839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
842: fnd_message.set_token('APPR_NAME',l_approver, false);
843: l_body := fnd_message.get;
844: END IF;
845: CLOSE GetItemCompDet;
846:

Line 843: l_body := fnd_message.get;

839: ELSE
840: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_FWD_FYI_RJCT');
841: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
842: fnd_message.set_token('APPR_NAME',l_approver, false);
843: l_body := fnd_message.get;
844: END IF;
845: CLOSE GetItemCompDet;
846:
847:

Line 982: -- that will be used to replace tokens defined in FND Messages.

978:
979: commit;
980: /*--------------------------------------------------------------------------
981: -- Query approval object table for any detail information of this object
982: -- that will be used to replace tokens defined in FND Messages.
983: -- Here to simplify, we are using hard-coded messages.
984: ----------------------------------------------------------------------------*/
985:
986: OPEN GetItemCompDet(l_object_id);

Line 991: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

987: FETCH GetItemCompDet into l_item_comp_rec;
988:
989: IF GetItemCompDet%NOTFOUND
990: THEN
991: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE

Line 992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

988:
989: IF GetItemCompDet%NOTFOUND
990: THEN
991: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');

Line 993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

989: IF GetItemCompDet%NOTFOUND
990: THEN
991: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 994: l_body := fnd_message.get;

990: THEN
991: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
998: fnd_message.set_token('NOTE',l_requester_note, false);

Line 996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');

992: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
998: fnd_message.set_token('NOTE',l_requester_note, false);
999: l_body := fnd_message.get;
1000: END IF;

Line 997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

993: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
998: fnd_message.set_token('NOTE',l_requester_note, false);
999: l_body := fnd_message.get;
1000: END IF;
1001: CLOSE GetItemCompDet;

Line 998: fnd_message.set_token('NOTE',l_requester_note, false);

994: l_body := fnd_message.get;
995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
998: fnd_message.set_token('NOTE',l_requester_note, false);
999: l_body := fnd_message.get;
1000: END IF;
1001: CLOSE GetItemCompDet;
1002:

Line 999: l_body := fnd_message.get;

995: ELSE
996: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_APPROVAL');
997: fnd_message.set_token('GROUPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
998: fnd_message.set_token('NOTE',l_requester_note, false);
999: l_body := fnd_message.get;
1000: END IF;
1001: CLOSE GetItemCompDet;
1002:
1003:

Line 1139: -- that will be used to replace tokens defined in FND Messages.

1135:
1136:
1137: /*--------------------------------------------------------------------------
1138: -- Query approval object table for any detail information of this object
1139: -- that will be used to replace tokens defined in FND Messages.
1140: -- Here to simplify, we are using hard-coded messages.
1141: ----------------------------------------------------------------------------*/
1142: OPEN GetItemCompDet(l_object_id);
1143: FETCH GetItemCompDet into l_item_comp_rec;

Line 1147: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

1143: FETCH GetItemCompDet into l_item_comp_rec;
1144:
1145: IF GetItemCompDet%NOTFOUND
1146: THEN
1147: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE

Line 1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

1144:
1145: IF GetItemCompDet%NOTFOUND
1146: THEN
1147: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');

Line 1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

1145: IF GetItemCompDet%NOTFOUND
1146: THEN
1147: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 1150: l_body := fnd_message.get;

1146: THEN
1147: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

Line 1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');

1148: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1155: fnd_message.set_token('NOTE ',l_requester_note, false);
1156: l_body := fnd_message.get;

Line 1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

1149: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1155: fnd_message.set_token('NOTE ',l_requester_note, false);
1156: l_body := fnd_message.get;
1157: END IF;

Line 1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

1150: l_body := fnd_message.get;
1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1155: fnd_message.set_token('NOTE ',l_requester_note, false);
1156: l_body := fnd_message.get;
1157: END IF;
1158: CLOSE GetItemCompDet;

Line 1155: fnd_message.set_token('NOTE ',l_requester_note, false);

1151: ELSE
1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1155: fnd_message.set_token('NOTE ',l_requester_note, false);
1156: l_body := fnd_message.get;
1157: END IF;
1158: CLOSE GetItemCompDet;
1159:

Line 1156: l_body := fnd_message.get;

1152: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_REMIND');
1153: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1154: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1155: fnd_message.set_token('NOTE ',l_requester_note, false);
1156: l_body := fnd_message.get;
1157: END IF;
1158: CLOSE GetItemCompDet;
1159:
1160:

Line 1289: -- that will be used to replace tokens defined in FND Messages.

1285: );
1286:
1287: /*--------------------------------------------------------------------------
1288: -- Query approval object table for any detail information of this object
1289: -- that will be used to replace tokens defined in FND Messages.
1290: -- Here to simplify, we are using hard-coded messages.
1291: ----------------------------------------------------------------------------*/
1292:
1293: OPEN GetItemCompDet(l_object_id);

Line 1298: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');

1294: FETCH GetItemCompDet into l_item_comp_rec;
1295:
1296: IF GetItemCompDet%NOTFOUND
1297: THEN
1298: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE

Line 1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);

1295:
1296: IF GetItemCompDet%NOTFOUND
1297: THEN
1298: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');

Line 1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);

1296: IF GetItemCompDet%NOTFOUND
1297: THEN
1298: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

Line 1301: l_body := fnd_message.get;

1297: THEN
1298: fnd_message.set_name('AHL', 'AHL_MC_COMP_ID_INVALID');
1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);

Line 1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');

1299: fnd_message.set_token('COMPNAME',l_item_comp_rec.concatenated_segments ,false);
1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1306: l_body := fnd_message.get;
1307: END IF;

Line 1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);

1300: fnd_message.set_token('COMP_ID',l_item_comp_rec.INVENTORY_ITEM_ID, false);
1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1306: l_body := fnd_message.get;
1307: END IF;
1308: CLOSE GetItemCompDet;

Line 1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);

1301: l_body := fnd_message.get;
1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1306: l_body := fnd_message.get;
1307: END IF;
1308: CLOSE GetItemCompDet;
1309:

Line 1306: l_body := fnd_message.get;

1302: ELSE
1303: fnd_message.set_name('AHL', 'AHL_MC_COMP_NTF_ERROR_ACT');
1304: fnd_message.set_token('COMPNAME',l_item_comp_rec.ITEM_COMPOSITION_ID ,false);
1305: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1306: l_body := fnd_message.get;
1307: END IF;
1308: CLOSE GetItemCompDet;
1309:
1310: document := document || l_body;

Line 1482: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');

1478: END IF;
1479:
1480: if (sql%notfound)
1481: then
1482: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1483: FND_MSG_PUB.Add;
1484: l_return_status := FND_API.G_RET_STS_ERROR;
1485: End if;
1486:

Line 1652: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');

1648:
1649:
1650: if (sql%notfound)
1651: then
1652: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1653: FND_MSG_PUB.Add;
1654:
1655: l_return_status := FND_API.G_RET_STS_ERROR;
1656: return;