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_APRVTRM_SUBJECT');
97: END IF;
98:

Line 96: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APRVTRM_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_APRVTRM_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_APRVTRM_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_APRVTRM_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('l_approver',l_mr_header_rec.TITLE, false);
398: l_body := l_body||fnd_message.get;
399: l_subject:= fnd_message.get||'-'||l_body;
400: document := document || l_body;

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

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('l_approver',l_mr_header_rec.TITLE, false);
398: l_body := l_body||fnd_message.get;
399: l_subject:= fnd_message.get||'-'||l_body;
400: document := document || l_body;
401:

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

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

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

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

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

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

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

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

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

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

Line 508: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 513: l_body := fnd_message.get;

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

Line 514: l_subject:= fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 629: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 634: l_body := fnd_message.get;

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

Line 635: l_subject:= fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 750: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 755: l_body := fnd_message.get;

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

Line 756: l_subject:= fnd_message.get;

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

Line 760: fnd_message.set_name('AHL', 'AHL_FMP_MR_NTF_APROVAL_REJECT');

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

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

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

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

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

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

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

Line 764: l_body := fnd_message.get;

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

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

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

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

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

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

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

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

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

Line 884: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 889: l_body := fnd_message.get;

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

Line 890: l_subject:= fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1004: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 1009: l_body := fnd_message.get;

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

Line 1010: l_subject:= fnd_message.get;

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

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

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

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

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

Line 1123: l_body := fnd_message.get;

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

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

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

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

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

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

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

Line 1128: l_body := fnd_message.get;

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

Line 1129: l_subject:= fnd_message.get;

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

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

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