DBA Data[Home] [Help]

APPS.AHL_PC_APPROVAL_PVT dependencies on FND_MESSAGE

Line 76: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

72: OPEN GET_PC_HEADER_DET(l_object_id);
73: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
74: IF GET_PC_HEADER_DET%NOTFOUND
75: THEN
76: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
77: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
78: fnd_message.set_token('NAME', l_pc_header_rec.NAME, false);
79: l_subject := fnd_message.get;
80: END IF;

Line 77: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

73: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
74: IF GET_PC_HEADER_DET%NOTFOUND
75: THEN
76: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
77: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
78: fnd_message.set_token('NAME', l_pc_header_rec.NAME, false);
79: l_subject := fnd_message.get;
80: END IF;
81: CLOSE GET_PC_HEADER_DET;

Line 78: fnd_message.set_token('NAME', l_pc_header_rec.NAME, false);

74: IF GET_PC_HEADER_DET%NOTFOUND
75: THEN
76: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
77: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
78: fnd_message.set_token('NAME', l_pc_header_rec.NAME, false);
79: l_subject := fnd_message.get;
80: END IF;
81: CLOSE GET_PC_HEADER_DET;
82:

Line 79: l_subject := fnd_message.get;

75: THEN
76: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
77: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
78: fnd_message.set_token('NAME', l_pc_header_rec.NAME, false);
79: l_subject := fnd_message.get;
80: END IF;
81: CLOSE GET_PC_HEADER_DET;
82:
83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');

Line 83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');

79: l_subject := fnd_message.get;
80: END IF;
81: CLOSE GET_PC_HEADER_DET;
82:
83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');
84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:

Line 84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

80: END IF;
81: CLOSE GET_PC_HEADER_DET;
82:
83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');
84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:
88: wf_engine.setitemattrtext

Line 85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

81: CLOSE GET_PC_HEADER_DET;
82:
83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');
84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:
88: wf_engine.setitemattrtext
89: (

Line 86: l_subject := fnd_message.get;

82:
83: fnd_message.set_name('AHL', 'AHL_PC_NTF_FORWARD_SUBJECT');
84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:
88: wf_engine.setitemattrtext
89: (
90: itemtype => itemtype

Line 99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');

95: IF G_DEBUG='Y' THEN
96: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);
97: END IF;
98:
99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:

Line 100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

96: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);
97: END IF;
98:
99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:
104: wf_engine.setitemattrtext

Line 101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

97: END IF;
98:
99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:
104: wf_engine.setitemattrtext
105: (

Line 102: l_subject := fnd_message.get;

98:
99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:
104: wf_engine.setitemattrtext
105: (
106: itemtype => itemtype

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

111: IF G_DEBUG='Y' THEN
112: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
113: END IF;
114:
115: fnd_message.set_name('AHL', 'AHL_PC_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:

Line 116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

112: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
113: END IF;
114:
115: fnd_message.set_name('AHL', 'AHL_PC_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:
120: wf_engine.setitemattrtext

Line 117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

113: END IF;
114:
115: fnd_message.set_name('AHL', 'AHL_PC_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:
120: wf_engine.setitemattrtext
121: (

Line 118: l_subject := fnd_message.get;

114:
115: fnd_message.set_name('AHL', 'AHL_PC_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:
120: wf_engine.setitemattrtext
121: (
122: itemtype => itemtype

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

127: IF G_DEBUG='Y' THEN
128: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
129: END IF;
130:
131: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVED_SUBJECT');
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:

Line 132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

128: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
129: END IF;
130:
131: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVED_SUBJECT');
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:
136: wf_engine.setitemattrtext

Line 133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

129: END IF;
130:
131: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVED_SUBJECT');
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:
136: wf_engine.setitemattrtext
137: (

Line 134: l_subject := fnd_message.get;

130:
131: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVED_SUBJECT');
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:
136: wf_engine.setitemattrtext
137: (
138: itemtype => itemtype

Line 147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');

143: IF G_DEBUG='Y' THEN
144: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
145: END IF;
146:
147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:

Line 148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

144: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
145: END IF;
146:
147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:
152: wf_engine.setitemattrtext

Line 149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

145: END IF;
146:
147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:
152: wf_engine.setitemattrtext
153: (

Line 150: l_subject := fnd_message.get;

146:
147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:
152: wf_engine.setitemattrtext
153: (
154: itemtype => itemtype

Line 163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');

159: IF G_DEBUG='Y' THEN
160: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
161: END IF;
162:
163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:

Line 164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

160: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
161: END IF;
162:
163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:
168: wf_engine.setitemattrtext

Line 165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

161: END IF;
162:
163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:
168: wf_engine.setitemattrtext
169: (

Line 166: l_subject := fnd_message.get;

162:
163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:
168: wf_engine.setitemattrtext
169: (
170: itemtype => itemtype

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

175: IF G_DEBUG='Y' THEN
176: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
177: END IF;
178:
179: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
182: l_subject := fnd_message.get;
183:

Line 180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

176: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
177: END IF;
178:
179: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext

Line 181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

177: END IF;
178:
179: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext
185: (

Line 182: l_subject := fnd_message.get;

178:
179: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext
185: (
186: itemtype => itemtype

Line 374: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

370: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
371:
372: IF GET_PC_HEADER_DET%NOTFOUND
373: THEN
374: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE

Line 375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

371:
372: IF GET_PC_HEADER_DET%NOTFOUND
373: THEN
374: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');

Line 376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

372: IF GET_PC_HEADER_DET%NOTFOUND
373: THEN
374: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 377: l_body := fnd_message.get;

373: THEN
374: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

Line 379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');

375: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
382: fnd_message.set_token('APPR_NAME',l_approver, false);
383: l_body := fnd_message.get;

Line 380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

376: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
382: fnd_message.set_token('APPR_NAME',l_approver, false);
383: l_body := fnd_message.get;
384: END IF;

Line 381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

377: l_body := fnd_message.get;
378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
382: fnd_message.set_token('APPR_NAME',l_approver, false);
383: l_body := fnd_message.get;
384: END IF;
385: CLOSE GET_PC_HEADER_DET;

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

378: ELSE
379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
382: fnd_message.set_token('APPR_NAME',l_approver, false);
383: l_body := fnd_message.get;
384: END IF;
385: CLOSE GET_PC_HEADER_DET;
386:

Line 383: l_body := fnd_message.get;

379: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FWD');
380: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
381: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
382: fnd_message.set_token('APPR_NAME',l_approver, false);
383: l_body := fnd_message.get;
384: END IF;
385: CLOSE GET_PC_HEADER_DET;
386:
387: document := document || l_body;

Line 504: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

500: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
501:
502: IF GET_PC_HEADER_DET%NOTFOUND
503: THEN
504: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE

Line 505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

501:
502: IF GET_PC_HEADER_DET%NOTFOUND
503: THEN
504: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');

Line 506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

502: IF GET_PC_HEADER_DET%NOTFOUND
503: THEN
504: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 507: l_body := fnd_message.get;

503: THEN
504: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

Line 509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');

505: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
512: fnd_message.set_token('APPR_NAME',l_approver, false);
513: l_body := fnd_message.get;

Line 510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

506: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
512: fnd_message.set_token('APPR_NAME',l_approver, false);
513: l_body := fnd_message.get;
514: END IF;

Line 511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

507: l_body := fnd_message.get;
508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
512: fnd_message.set_token('APPR_NAME',l_approver, false);
513: l_body := fnd_message.get;
514: END IF;
515: CLOSE GET_PC_HEADER_DET;

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

508: ELSE
509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
512: fnd_message.set_token('APPR_NAME',l_approver, false);
513: l_body := fnd_message.get;
514: END IF;
515: CLOSE GET_PC_HEADER_DET;
516:

Line 513: l_body := fnd_message.get;

509: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_APPRVD');
510: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
511: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
512: fnd_message.set_token('APPR_NAME',l_approver, false);
513: l_body := fnd_message.get;
514: END IF;
515: CLOSE GET_PC_HEADER_DET;
516:
517: document := document || l_body;

Line 624: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

620: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
621:
622: IF GET_PC_HEADER_DET%NOTFOUND
623: THEN
624: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE

Line 625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

621:
622: IF GET_PC_HEADER_DET%NOTFOUND
623: THEN
624: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');

Line 626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

622: IF GET_PC_HEADER_DET%NOTFOUND
623: THEN
624: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 627: l_body := fnd_message.get;

623: THEN
624: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

Line 629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');

625: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
632: l_body := fnd_message.get;
633: END IF;

Line 630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

626: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
632: l_body := fnd_message.get;
633: END IF;
634: CLOSE GET_PC_HEADER_DET;

Line 631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

627: l_body := fnd_message.get;
628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
632: l_body := fnd_message.get;
633: END IF;
634: CLOSE GET_PC_HEADER_DET;
635:

Line 632: l_body := fnd_message.get;

628: ELSE
629: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_FINAL');
630: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
631: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
632: l_body := fnd_message.get;
633: END IF;
634: CLOSE GET_PC_HEADER_DET;
635:
636: document := document || l_body;

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

749: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
750:
751: IF GET_PC_HEADER_DET%NOTFOUND
752: THEN
753: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE

Line 754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

750:
751: IF GET_PC_HEADER_DET%NOTFOUND
752: THEN
753: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');

Line 755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

751: IF GET_PC_HEADER_DET%NOTFOUND
752: THEN
753: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 756: l_body := fnd_message.get;

752: THEN
753: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

Line 758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');

754: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
761: fnd_message.set_token('APPR_NAME',l_approver, false);
762: l_body := fnd_message.get;

Line 759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

755: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
761: fnd_message.set_token('APPR_NAME',l_approver, false);
762: l_body := fnd_message.get;
763: END IF;

Line 760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

756: l_body := fnd_message.get;
757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
761: fnd_message.set_token('APPR_NAME',l_approver, false);
762: l_body := fnd_message.get;
763: END IF;
764: CLOSE GET_PC_HEADER_DET;

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

757: ELSE
758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
761: fnd_message.set_token('APPR_NAME',l_approver, false);
762: l_body := fnd_message.get;
763: END IF;
764: CLOSE GET_PC_HEADER_DET;
765:

Line 762: l_body := fnd_message.get;

758: fnd_message.set_name('AHL', 'AHL_PC_NTF_FWD_FYI_RJCT');
759: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
760: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
761: fnd_message.set_token('APPR_NAME',l_approver, false);
762: l_body := fnd_message.get;
763: END IF;
764: CLOSE GET_PC_HEADER_DET;
765:
766: document := document || l_body;

Line 891: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

887: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
888:
889: IF GET_PC_HEADER_DET%NOTFOUND
890: THEN
891: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE

Line 892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

888:
889: IF GET_PC_HEADER_DET%NOTFOUND
890: THEN
891: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');

Line 893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

889: IF GET_PC_HEADER_DET%NOTFOUND
890: THEN
891: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);

Line 894: l_body := fnd_message.get;

890: THEN
891: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');

892: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);

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

893: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);
901: l_body := fnd_message.get;

Line 898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

894: l_body := fnd_message.get;
895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);
901: l_body := fnd_message.get;
902: END IF;

Line 899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

895: ELSE
896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);
901: l_body := fnd_message.get;
902: END IF;
903: CLOSE GET_PC_HEADER_DET;

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

896: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL');
897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);
901: l_body := fnd_message.get;
902: END IF;
903: CLOSE GET_PC_HEADER_DET;
904:

Line 901: l_body := fnd_message.get;

897: fnd_message.set_token('REQUESTER',l_requester, false);
898: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
899: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
900: fnd_message.set_token('NOTE',l_requester_note, false);
901: l_body := fnd_message.get;
902: END IF;
903: CLOSE GET_PC_HEADER_DET;
904:
905: document := document || l_body;

Line 1029: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

1025: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
1026:
1027: IF GET_PC_HEADER_DET%NOTFOUND
1028: THEN
1029: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE

Line 1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

1026:
1027: IF GET_PC_HEADER_DET%NOTFOUND
1028: THEN
1029: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');

Line 1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

1027: IF GET_PC_HEADER_DET%NOTFOUND
1028: THEN
1029: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);

Line 1032: l_body := fnd_message.get;

1028: THEN
1029: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');

1030: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);

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

1031: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);
1039: l_body := fnd_message.get;

Line 1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

1032: l_body := fnd_message.get;
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);
1039: l_body := fnd_message.get;
1040: END IF;

Line 1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);
1039: l_body := fnd_message.get;
1040: END IF;
1041: CLOSE GET_PC_HEADER_DET;

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

1034: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMINDER');
1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);
1039: l_body := fnd_message.get;
1040: END IF;
1041: CLOSE GET_PC_HEADER_DET;
1042:

Line 1039: l_body := fnd_message.get;

1035: fnd_message.set_token('REQUESTER',l_requester, false);
1036: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1037: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1038: fnd_message.set_token('NOTE',l_requester_note, false);
1039: l_body := fnd_message.get;
1040: END IF;
1041: CLOSE GET_PC_HEADER_DET;
1042:
1043: document := document || l_body;

Line 1164: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');

1160: FETCH GET_PC_HEADER_DET into l_pc_header_rec;
1161:
1162: IF GET_PC_HEADER_DET%NOTFOUND
1163: THEN
1164: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE

Line 1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);

1161:
1162: IF GET_PC_HEADER_DET%NOTFOUND
1163: THEN
1164: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');

Line 1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

1162: IF GET_PC_HEADER_DET%NOTFOUND
1163: THEN
1164: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

Line 1167: l_body := fnd_message.get;

1163: THEN
1164: fnd_message.set_name('AHL', 'AHL_PC_HEADER_ID_INVALID');
1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

Line 1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');

1165: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID,false);
1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1172: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1173: l_body := fnd_message.get;

Line 1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);

1166: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1172: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1173: l_body := fnd_message.get;
1174: END IF;

Line 1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);

1167: l_body := fnd_message.get;
1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1172: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1173: l_body := fnd_message.get;
1174: END IF;
1175: CLOSE GET_PC_HEADER_DET;

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

1168: ELSE
1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1172: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1173: l_body := fnd_message.get;
1174: END IF;
1175: CLOSE GET_PC_HEADER_DET;
1176:

Line 1173: l_body := fnd_message.get;

1169: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_ACT');
1170: fnd_message.set_token('PC_HEADER_ID',l_pc_header_rec.PC_HEADER_ID ,false);
1171: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
1172: fnd_message.set_token('ERR_MSG',l_error_msg, false);
1173: l_body := fnd_message.get;
1174: END IF;
1175: CLOSE GET_PC_HEADER_DET;
1176:
1177: document := document || l_body;

Line 1335: fnd_message.set_name('AHL', 'AHL_APRV_OBJ_CHANGED');

1331: FETCH GET_PC_HEADER_DET INTO l_pc_header_det;
1332: CLOSE GET_PC_HEADER_DET;
1333: IF (l_pc_header_det.object_version_number <> l_object_version_number)
1334: THEN
1335: fnd_message.set_name('AHL', 'AHL_APRV_OBJ_CHANGED');
1336: fnd_msg_pub.add;
1337: l_msg_count := 1;
1338: l_return_status := FND_API.G_RET_STS_ERROR;
1339: ELSE