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_FMP_MR_APPROVAL_PVT dependencies on FND_MESSAGE

Line 71: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

67: FETCH GetMrHeaderDet into l_mr_rec;
68:
69: IF GetMrHeaderDet%NOTFOUND
70: THEN
71: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
72: l_subject := fnd_message.get;
73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

Line 72: l_subject := fnd_message.get;

68:
69: IF GetMrHeaderDet%NOTFOUND
70: THEN
71: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
72: l_subject := fnd_message.get;
73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

Line 74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

70: THEN
71: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
72: l_subject := fnd_message.get;
73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
77: l_subject := fnd_message.get;
78: End if;

Line 75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

71: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
72: l_subject := fnd_message.get;
73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
77: l_subject := fnd_message.get;
78: End if;
79: CLOSE GetMrHeaderDet;

Line 76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

72: l_subject := fnd_message.get;
73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
77: l_subject := fnd_message.get;
78: End if;
79: CLOSE GetMrHeaderDet;
80:

Line 77: l_subject := fnd_message.get;

73: else
74: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
75: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
76: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
77: l_subject := fnd_message.get;
78: End if;
79: CLOSE GetMrHeaderDet;
80:
81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');

77: l_subject := fnd_message.get;
78: End if;
79: CLOSE GetMrHeaderDet;
80:
81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');
82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
84: l_subject := fnd_message.get;
85:

Line 82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

78: End if;
79: CLOSE GetMrHeaderDet;
80:
81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');
82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
84: l_subject := fnd_message.get;
85:
86: wf_engine.setitemattrtext(

Line 83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

79: CLOSE GetMrHeaderDet;
80:
81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');
82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
84: l_subject := fnd_message.get;
85:
86: wf_engine.setitemattrtext(
87: itemtype => itemtype

Line 84: l_subject := fnd_message.get;

80:
81: fnd_message.set_name('AHL','AHL_FMP_MR_NTF_FORWARD_SUBJECT');
82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
84: l_subject := fnd_message.get;
85:
86: wf_engine.setitemattrtext(
87: itemtype => itemtype
88: ,itemkey => itemkey

Line 94: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVAL_SUBJECT');

90: ,avalue => l_subject
91: );
92: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
93: THEN
94: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVAL_SUBJECT');
95: ELSE
96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRTRM_SUBJECT');
97: END IF;
98:

Line 96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRTRM_SUBJECT');

92: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
93: THEN
94: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVAL_SUBJECT');
95: ELSE
96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRTRM_SUBJECT');
97: END IF;
98:
99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

Line 99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

95: ELSE
96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRTRM_SUBJECT');
97: END IF;
98:
99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
101: l_subject := fnd_message.get;
102:
103: wf_engine.setitemattrtext(

Line 100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRTRM_SUBJECT');
97: END IF;
98:
99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
101: l_subject := fnd_message.get;
102:
103: wf_engine.setitemattrtext(
104: itemtype => itemtype

Line 101: l_subject := fnd_message.get;

97: END IF;
98:
99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
101: l_subject := fnd_message.get;
102:
103: wf_engine.setitemattrtext(
104: itemtype => itemtype
105: ,itemkey => itemkey

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

107: ,avalue => l_subject
108: );
109: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
110: THEN
111: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECT_SUBJECT');
112: ELSE
113: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECTR_SUBJECT');
114: END IF;
115:

Line 113: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECTR_SUBJECT');

109: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
110: THEN
111: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECT_SUBJECT');
112: ELSE
113: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECTR_SUBJECT');
114: END IF;
115:
116:
117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

Line 117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

113: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REJECTR_SUBJECT');
114: END IF;
115:
116:
117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
118: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
119: l_subject := fnd_message.get;
120:
121: wf_engine.setitemattrtext(

Line 118: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

114: END IF;
115:
116:
117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
118: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
119: l_subject := fnd_message.get;
120:
121: wf_engine.setitemattrtext(
122: itemtype => itemtype

Line 119: l_subject := fnd_message.get;

115:
116:
117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
118: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
119: l_subject := fnd_message.get;
120:
121: wf_engine.setitemattrtext(
122: itemtype => itemtype
123: ,itemkey => itemkey

Line 130: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVED_SUBJECT');

126: );
127:
128: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
129: THEN
130: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVED_SUBJECT');
131: ELSE
132: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_SUBJECT');
133: END IF;
134:

Line 132: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_SUBJECT');

128: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
129: THEN
130: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPRVED_SUBJECT');
131: ELSE
132: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_SUBJECT');
133: END IF;
134:
135: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

Line 135: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

131: ELSE
132: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_SUBJECT');
133: END IF;
134:
135: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
137: l_subject := fnd_message.get;
138:
139:

Line 136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

132: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_SUBJECT');
133: END IF;
134:
135: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
137: l_subject := fnd_message.get;
138:
139:
140: wf_engine.setitemattrtext(

Line 137: l_subject := fnd_message.get;

133: END IF;
134:
135: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
137: l_subject := fnd_message.get;
138:
139:
140: wf_engine.setitemattrtext(
141: itemtype => itemtype

Line 148: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINAL_SUBJECT');

144: ,avalue => l_subject
145: );
146: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
147: THEN
148: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINAL_SUBJECT');
149: else
150: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINALTR_SUBJECT');
151: end if;
152:

Line 150: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINALTR_SUBJECT');

146: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
147: THEN
148: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINAL_SUBJECT');
149: else
150: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINALTR_SUBJECT');
151: end if;
152:
153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

Line 153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

149: else
150: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINALTR_SUBJECT');
151: end if;
152:
153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
155: l_subject := fnd_message.get;
156:
157: wf_engine.setitemattrtext(

Line 154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

150: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FINALTR_SUBJECT');
151: end if;
152:
153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
155: l_subject := fnd_message.get;
156:
157: wf_engine.setitemattrtext(
158: itemtype => itemtype

Line 155: l_subject := fnd_message.get;

151: end if;
152:
153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
155: l_subject := fnd_message.get;
156:
157: wf_engine.setitemattrtext(
158: itemtype => itemtype
159: ,itemkey => itemkey

Line 165: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMIND_SUBJECT');

161: ,avalue => l_subject
162: );
163: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
164: THEN
165: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMIND_SUBJECT');
166: ELSE
167: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMINDT_SUBJECT');
168: END IF;
169:

Line 167: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMINDT_SUBJECT');

163: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
164: THEN
165: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMIND_SUBJECT');
166: ELSE
167: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMINDT_SUBJECT');
168: END IF;
169:
170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

Line 170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

166: ELSE
167: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMINDT_SUBJECT');
168: END IF;
169:
170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext(

Line 171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

167: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_REMINDT_SUBJECT');
168: END IF;
169:
170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext(
175: itemtype => itemtype

Line 172: l_subject := fnd_message.get;

168: END IF;
169:
170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext(
175: itemtype => itemtype
176: ,itemkey => itemkey

Line 179: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_ERROR_SUBJECT');

175: itemtype => itemtype
176: ,itemkey => itemkey
177: ,aname => 'REMIND_SUBJECT'
178: ,avalue => l_subject);
179: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
182: l_subject := fnd_message.get;
183:

Line 180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);

176: ,itemkey => itemkey
177: ,aname => 'REMIND_SUBJECT'
178: ,avalue => l_subject);
179: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext(

Line 181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);

177: ,aname => 'REMIND_SUBJECT'
178: ,avalue => l_subject);
179: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext(
185: itemtype => itemtype

Line 182: l_subject := fnd_message.get;

178: ,avalue => l_subject);
179: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext(
185: itemtype => itemtype
186: ,itemkey => itemkey

Line 378: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

374: FETCH GetMrHeaderDet into l_mr_header_rec;
375:
376: IF GetMrHeaderDet%NOTFOUND
377: THEN
378: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);

375:
376: IF GetMrHeaderDet%NOTFOUND
377: THEN
378: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 380: l_body := fnd_message.get;

376: IF GetMrHeaderDet%NOTFOUND
377: THEN
378: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);

Line 382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

378: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
385: l_body := fnd_message.get;
386: l_subject:= fnd_message.get;

Line 383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

379: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
385: l_body := fnd_message.get;
386: l_subject:= fnd_message.get;
387: END IF;

Line 384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);

380: l_body := fnd_message.get;
381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
385: l_body := fnd_message.get;
386: l_subject:= fnd_message.get;
387: END IF;
388: CLOSE GetMrHeaderDet;

Line 385: l_body := fnd_message.get;

381: ELSE
382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
385: l_body := fnd_message.get;
386: l_subject:= fnd_message.get;
387: END IF;
388: CLOSE GetMrHeaderDet;
389:

Line 386: l_subject:= fnd_message.get;

382: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
383: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
384: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
385: l_body := fnd_message.get;
386: l_subject:= fnd_message.get;
387: END IF;
388: CLOSE GetMrHeaderDet;
389:
390: /*--------------------------------------------------------------------------

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

388: CLOSE GetMrHeaderDet;
389:
390: /*--------------------------------------------------------------------------
391: -- Query approval object table for any detail information of this object
392: -- that will be used to replace tokens defined in FND Messages.
393: -- Here to simplify, we are using hard-coded messages.
394: ----------------------------------------------------------------------------*/
395:
396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');

Line 396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');

392: -- that will be used to replace tokens defined in FND Messages.
393: -- Here to simplify, we are using hard-coded messages.
394: ----------------------------------------------------------------------------*/
395:
396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');
397: fnd_message.set_token('APPROVER',l_approver);
398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);
399: l_body := l_body||fnd_message.get;
400: l_subject:= fnd_message.get||'-'||l_body;

Line 397: fnd_message.set_token('APPROVER',l_approver);

393: -- Here to simplify, we are using hard-coded messages.
394: ----------------------------------------------------------------------------*/
395:
396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');
397: fnd_message.set_token('APPROVER',l_approver);
398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);
399: l_body := l_body||fnd_message.get;
400: l_subject:= fnd_message.get||'-'||l_body;
401: document := document || l_body;

Line 398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);

394: ----------------------------------------------------------------------------*/
395:
396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');
397: fnd_message.set_token('APPROVER',l_approver);
398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);
399: l_body := l_body||fnd_message.get;
400: l_subject:= fnd_message.get||'-'||l_body;
401: document := document || l_body;
402:

Line 399: l_body := l_body||fnd_message.get;

395:
396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');
397: fnd_message.set_token('APPROVER',l_approver);
398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);
399: l_body := l_body||fnd_message.get;
400: l_subject:= fnd_message.get||'-'||l_body;
401: document := document || l_body;
402:
403: IF G_DEBUG='Y' THEN

Line 400: l_subject:= fnd_message.get||'-'||l_body;

396: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FORWARD_FYI_BODY');
397: fnd_message.set_token('APPROVER',l_approver);
398: -- fnd_message.set_token('l_approver',l_mr_header_rec.TITLE, false);
399: l_body := l_body||fnd_message.get;
400: l_subject:= fnd_message.get||'-'||l_body;
401: document := document || l_body;
402:
403: IF G_DEBUG='Y' THEN
404: AHL_DEBUG_PUB.disable_debug;

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

495: );
496:
497: /*--------------------------------------------------------------------------
498: -- Query approval object table for any detail information of this object
499: -- that will be used to replace tokens defined in FND Messages.
500: -- Here to simplify, we are using hard-coded messages.
501: ----------------------------------------------------------------------------*/
502: OPEN GetMrHeaderDet(l_object_id);
503: FETCH GetMrHeaderDet into l_mr_header_rec;

Line 507: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

503: FETCH GetMrHeaderDet into l_mr_header_rec;
504:
505: IF GetMrHeaderDet%NOTFOUND
506: THEN
507: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);

504:
505: IF GetMrHeaderDet%NOTFOUND
506: THEN
507: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 509: l_body := fnd_message.get;

505: IF GetMrHeaderDet%NOTFOUND
506: THEN
507: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

Line 511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

507: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
514: l_body := fnd_message.get;
515: l_subject:= fnd_message.get;

Line 512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

508: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
514: l_body := fnd_message.get;
515: l_subject:= fnd_message.get;
516: END IF;

Line 513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

509: l_body := fnd_message.get;
510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
514: l_body := fnd_message.get;
515: l_subject:= fnd_message.get;
516: END IF;
517: CLOSE GetMrHeaderDet;

Line 514: l_body := fnd_message.get;

510: ELSE
511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
514: l_body := fnd_message.get;
515: l_subject:= fnd_message.get;
516: END IF;
517: CLOSE GetMrHeaderDet;
518:

Line 515: l_subject:= fnd_message.get;

511: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
512: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
513: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
514: l_body := fnd_message.get;
515: l_subject:= fnd_message.get;
516: END IF;
517: CLOSE GetMrHeaderDet;
518:
519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');

Line 519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');

515: l_subject:= fnd_message.get;
516: END IF;
517: CLOSE GetMrHeaderDet;
518:
519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');
520: fnd_message.set_token('APPROVER',l_approver);
521: l_body :=l_body||'.'||fnd_message.get;
522: l_subject :=l_body||fnd_message.get;
523: document := document || l_body;

Line 520: fnd_message.set_token('APPROVER',l_approver);

516: END IF;
517: CLOSE GetMrHeaderDet;
518:
519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');
520: fnd_message.set_token('APPROVER',l_approver);
521: l_body :=l_body||'.'||fnd_message.get;
522: l_subject :=l_body||fnd_message.get;
523: document := document || l_body;
524: IF G_DEBUG='Y' THEN

Line 521: l_body :=l_body||'.'||fnd_message.get;

517: CLOSE GetMrHeaderDet;
518:
519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');
520: fnd_message.set_token('APPROVER',l_approver);
521: l_body :=l_body||'.'||fnd_message.get;
522: l_subject :=l_body||fnd_message.get;
523: document := document || l_body;
524: IF G_DEBUG='Y' THEN
525: AHL_DEBUG_PUB.disable_debug;

Line 522: l_subject :=l_body||fnd_message.get;

518:
519: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_APPRVED_FYI_BODY');
520: fnd_message.set_token('APPROVER',l_approver);
521: l_body :=l_body||'.'||fnd_message.get;
522: l_subject :=l_body||fnd_message.get;
523: document := document || l_body;
524: IF G_DEBUG='Y' THEN
525: AHL_DEBUG_PUB.disable_debug;
526: END IF;

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

615:
616:
617: /*--------------------------------------------------------------------------
618: -- Query approval object table for any detail information of this object
619: -- that will be used to replace tokens defined in FND Messages.
620: -- Here to simplify, we are using hard-coded messages.
621: ----------------------------------------------------------------------------*/
622:
623: OPEN GetMrHeaderDet(l_object_id);

Line 628: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

624: FETCH GetMrHeaderDet into l_mr_header_rec;
625:
626: IF GetMrHeaderDet%NOTFOUND
627: THEN
628: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);

625:
626: IF GetMrHeaderDet%NOTFOUND
627: THEN
628: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 630: l_body := fnd_message.get;

626: IF GetMrHeaderDet%NOTFOUND
627: THEN
628: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

Line 632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

628: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
635: l_body := fnd_message.get;
636: l_subject:= fnd_message.get;

Line 633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

629: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
635: l_body := fnd_message.get;
636: l_subject:= fnd_message.get;
637: END IF;

Line 634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

630: l_body := fnd_message.get;
631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
635: l_body := fnd_message.get;
636: l_subject:= fnd_message.get;
637: END IF;
638: CLOSE GetMrHeaderDet;

Line 635: l_body := fnd_message.get;

631: ELSE
632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
635: l_body := fnd_message.get;
636: l_subject:= fnd_message.get;
637: END IF;
638: CLOSE GetMrHeaderDet;
639:

Line 636: l_subject:= fnd_message.get;

632: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
633: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
634: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
635: l_body := fnd_message.get;
636: l_subject:= fnd_message.get;
637: END IF;
638: CLOSE GetMrHeaderDet;
639:
640: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FINAL_APPROVAL');

Line 640: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FINAL_APPROVAL');

636: l_subject:= fnd_message.get;
637: END IF;
638: CLOSE GetMrHeaderDet;
639:
640: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FINAL_APPROVAL');
641: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
642: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
643:
644:

Line 641: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

637: END IF;
638: CLOSE GetMrHeaderDet;
639:
640: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FINAL_APPROVAL');
641: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
642: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
643:
644:
645:

Line 642: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

638: CLOSE GetMrHeaderDet;
639:
640: fnd_message.set_name('AHL', 'AHL_FMP_MRNTF_FINAL_APPROVAL');
641: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
642: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
643:
644:
645:
646: l_body :=l_body||'.'|| fnd_message.get;

Line 646: l_body :=l_body||'.'|| fnd_message.get;

642: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
643:
644:
645:
646: l_body :=l_body||'.'|| fnd_message.get;
647:
648: document := document || l_body;
649: IF G_DEBUG='Y' THEN
650: AHL_DEBUG_PUB.disable_debug;

Line 749: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

745: FETCH GetMrHeaderDet into l_mr_header_rec;
746:
747: IF GetMrHeaderDet%NOTFOUND
748: THEN
749: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);

746:
747: IF GetMrHeaderDet%NOTFOUND
748: THEN
749: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 751: l_body := fnd_message.get;

747: IF GetMrHeaderDet%NOTFOUND
748: THEN
749: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);

Line 753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

749: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);
756: l_body := fnd_message.get;
757: l_subject:= fnd_message.get;

Line 754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

750: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);
756: l_body := fnd_message.get;
757: l_subject:= fnd_message.get;
758: END IF;

Line 755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);

751: l_body := fnd_message.get;
752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);
756: l_body := fnd_message.get;
757: l_subject:= fnd_message.get;
758: END IF;
759: CLOSE GetMrHeaderDet;

Line 756: l_body := fnd_message.get;

752: ELSE
753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);
756: l_body := fnd_message.get;
757: l_subject:= fnd_message.get;
758: END IF;
759: CLOSE GetMrHeaderDet;
760:

Line 757: l_subject:= fnd_message.get;

753: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
754: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
755: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER,false);
756: l_body := fnd_message.get;
757: l_subject:= fnd_message.get;
758: END IF;
759: CLOSE GetMrHeaderDet;
760:
761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');

Line 761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');

757: l_subject:= fnd_message.get;
758: END IF;
759: CLOSE GetMrHeaderDet;
760:
761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');
762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;

Line 762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);

758: END IF;
759: CLOSE GetMrHeaderDet;
760:
761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');
762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;
766:

Line 763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);

759: CLOSE GetMrHeaderDet;
760:
761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');
762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;
766:
767:

Line 764: fnd_message.set_token('APPROVER',l_approver);

760:
761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');
762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;
766:
767:
768: l_body := l_body||fnd_message.get;

Line 765: l_body := fnd_message.get;

761: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVAL_REJECT');
762: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
763: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;
766:
767:
768: l_body := l_body||fnd_message.get;
769: l_subject:= l_body||fnd_message.get;

Line 768: l_body := l_body||fnd_message.get;

764: fnd_message.set_token('APPROVER',l_approver);
765: l_body := fnd_message.get;
766:
767:
768: l_body := l_body||fnd_message.get;
769: l_subject:= l_body||fnd_message.get;
770:
771: document := document || l_body;
772: IF G_DEBUG='Y' THEN

Line 769: l_subject:= l_body||fnd_message.get;

765: l_body := fnd_message.get;
766:
767:
768: l_body := l_body||fnd_message.get;
769: l_subject:= l_body||fnd_message.get;
770:
771: document := document || l_body;
772: IF G_DEBUG='Y' THEN
773: AHL_DEBUG_PUB.disable_debug;

Line 883: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

879: FETCH GetMrHeaderDet into l_mr_header_rec;
880:
881: IF GetMrHeaderDet%NOTFOUND
882: THEN
883: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);

880:
881: IF GetMrHeaderDet%NOTFOUND
882: THEN
883: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);

Line 885: l_body := fnd_message.get;

881: IF GetMrHeaderDet%NOTFOUND
882: THEN
883: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);

Line 887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

883: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;

Line 888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);

884: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID);
885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;
892: END IF;

Line 889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);

885: l_body := fnd_message.get;
886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;
892: END IF;
893: CLOSE GetMrHeaderDet;

Line 890: l_body := fnd_message.get;

886: ELSE
887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;
892: END IF;
893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');

Line 891: l_subject:= fnd_message.get;

887: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
888: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE);
889: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.VERSION_NUMBER);
890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;
892: END IF;
893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');
895: fnd_message.set_token('REQUESTER',l_requester);

Line 894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');

890: l_body := fnd_message.get;
891: l_subject:= fnd_message.get;
892: END IF;
893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');
895: fnd_message.set_token('REQUESTER',l_requester);
896: fnd_message.set_token('REQUESTER_NOTE',l_requester_note);
897: l_body :=l_body||fnd_message.get;
898: document := document || l_body;

Line 895: fnd_message.set_token('REQUESTER',l_requester);

891: l_subject:= fnd_message.get;
892: END IF;
893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');
895: fnd_message.set_token('REQUESTER',l_requester);
896: fnd_message.set_token('REQUESTER_NOTE',l_requester_note);
897: l_body :=l_body||fnd_message.get;
898: document := document || l_body;
899:

Line 896: fnd_message.set_token('REQUESTER_NOTE',l_requester_note);

892: END IF;
893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');
895: fnd_message.set_token('REQUESTER',l_requester);
896: fnd_message.set_token('REQUESTER_NOTE',l_requester_note);
897: l_body :=l_body||fnd_message.get;
898: document := document || l_body;
899:
900: IF G_DEBUG='Y' THEN

Line 897: l_body :=l_body||fnd_message.get;

893: CLOSE GetMrHeaderDet;
894: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APPROVER');
895: fnd_message.set_token('REQUESTER',l_requester);
896: fnd_message.set_token('REQUESTER_NOTE',l_requester_note);
897: l_body :=l_body||fnd_message.get;
898: document := document || l_body;
899:
900: IF G_DEBUG='Y' THEN
901: AHL_DEBUG_PUB.disable_debug;

Line 1003: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

999: FETCH GetMrHeaderDet into l_mr_header_rec;
1000:
1001: IF GetMrHeaderDet%NOTFOUND
1002: THEN
1003: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);

1000:
1001: IF GetMrHeaderDet%NOTFOUND
1002: THEN
1003: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 1005: l_body := fnd_message.get;

1001: IF GetMrHeaderDet%NOTFOUND
1002: THEN
1003: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

Line 1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

1003: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
1010: l_body := fnd_message.get;
1011: l_subject:= fnd_message.get;

Line 1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

1004: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
1010: l_body := fnd_message.get;
1011: l_subject:= fnd_message.get;
1012: END IF;

Line 1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);

1005: l_body := fnd_message.get;
1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
1010: l_body := fnd_message.get;
1011: l_subject:= fnd_message.get;
1012: END IF;
1013: CLOSE GetMrHeaderDet;

Line 1010: l_body := fnd_message.get;

1006: ELSE
1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
1010: l_body := fnd_message.get;
1011: l_subject:= fnd_message.get;
1012: END IF;
1013: CLOSE GetMrHeaderDet;
1014:

Line 1011: l_subject:= fnd_message.get;

1007: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1008: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1009: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.version_number);
1010: l_body := fnd_message.get;
1011: l_subject:= fnd_message.get;
1012: END IF;
1013: CLOSE GetMrHeaderDet;
1014:
1015:

Line 1122: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');

1118: FETCH GetMrHeaderDet into l_mr_header_rec;
1119:
1120: IF GetMrHeaderDet%NOTFOUND
1121: THEN
1122: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

Line 1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);

1119:
1120: IF GetMrHeaderDet%NOTFOUND
1121: THEN
1122: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

Line 1124: l_body := fnd_message.get;

1120: IF GetMrHeaderDet%NOTFOUND
1121: THEN
1122: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);

Line 1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');

1122: fnd_message.set_name('AHL', 'AHL_MR_HEADER_ID_INVALID');
1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);
1129: l_body := fnd_message.get;
1130: l_subject:= fnd_message.get;

Line 1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);

1123: fnd_message.set_token('MR_HEADER_ID',l_mr_header_rec.MR_HEADER_ID,false);
1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);
1129: l_body := fnd_message.get;
1130: l_subject:= fnd_message.get;
1131: END IF;

Line 1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);

1124: l_body := fnd_message.get;
1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);
1129: l_body := fnd_message.get;
1130: l_subject:= fnd_message.get;
1131: END IF;
1132: CLOSE GetMrHeaderDet;

Line 1129: l_body := fnd_message.get;

1125: ELSE
1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);
1129: l_body := fnd_message.get;
1130: l_subject:= fnd_message.get;
1131: END IF;
1132: CLOSE GetMrHeaderDet;
1133:

Line 1130: l_subject:= fnd_message.get;

1126: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_FORWARD_SUBJECT');
1127: fnd_message.set_token('TITLE',l_mr_header_rec.TITLE, false);
1128: fnd_message.set_token('VERSION_NUMBER',l_mr_header_rec.MR_HEADER_ID);
1129: l_body := fnd_message.get;
1130: l_subject:= fnd_message.get;
1131: END IF;
1132: CLOSE GetMrHeaderDet;
1133:
1134:

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

1409: and object_Version_number=l_object_version_number;
1410:
1411: if (sql%notfound)
1412: then
1413: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1414: FND_MSG_PUB.Add;
1415:
1416: l_return_status := FND_API.G_RET_STS_ERROR;
1417: return;