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;
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;
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:
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');
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:
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
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: (
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
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:
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
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: (
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
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:
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
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: (
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
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:
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
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: (
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
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:
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
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: (
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
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:
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
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: (
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
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:
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
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: (
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
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
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');
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);
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);
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;
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;
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;
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:
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;
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
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');
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);
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);
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;
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;
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;
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:
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;
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
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');
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);
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);
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;
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;
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:
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;
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
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');
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);
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);
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;
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;
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;
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:
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;
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
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');
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);
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);
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);
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;
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;
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;
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:
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;
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
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');
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);
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);
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);
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;
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;
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;
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:
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;
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
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');
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);
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);
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;
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;
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;
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:
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;
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