DBA Data[Home] [Help]

APPS.GCS_WF_NTF_PKG dependencies on FND_MESSAGE

Line 146: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_COMPLETE_TITLE');

142: FND_FILE.NEW_LINE(FND_FILE.LOG);
143:
144: -- consolidation successfully completed
145: IF ((l_status = 'COMPLETED' OR l_status = 'WARNING') AND l_category_code = 'AGGREGATION') THEN
146: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_COMPLETE_TITLE');
147: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
148: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
149: l_subject := FND_MESSAGE.GET;
150: -- suspense violation

Line 147: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);

143:
144: -- consolidation successfully completed
145: IF ((l_status = 'COMPLETED' OR l_status = 'WARNING') AND l_category_code = 'AGGREGATION') THEN
146: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_COMPLETE_TITLE');
147: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
148: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
149: l_subject := FND_MESSAGE.GET;
150: -- suspense violation
151: ELSIF (l_status = 'WARNING') THEN

Line 148: FND_MESSAGE.set_token('DATE_TOKEN', l_date);

144: -- consolidation successfully completed
145: IF ((l_status = 'COMPLETED' OR l_status = 'WARNING') AND l_category_code = 'AGGREGATION') THEN
146: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_COMPLETE_TITLE');
147: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
148: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
149: l_subject := FND_MESSAGE.GET;
150: -- suspense violation
151: ELSIF (l_status = 'WARNING') THEN
152: IF (l_category_code = 'DATAPREPARATION') THEN

Line 149: l_subject := FND_MESSAGE.GET;

145: IF ((l_status = 'COMPLETED' OR l_status = 'WARNING') AND l_category_code = 'AGGREGATION') THEN
146: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_COMPLETE_TITLE');
147: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
148: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
149: l_subject := FND_MESSAGE.GET;
150: -- suspense violation
151: ELSIF (l_status = 'WARNING') THEN
152: IF (l_category_code = 'DATAPREPARATION') THEN
153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');

Line 153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');

149: l_subject := FND_MESSAGE.GET;
150: -- suspense violation
151: ELSIF (l_status = 'WARNING') THEN
152: IF (l_category_code = 'DATAPREPARATION') THEN
153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');
154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
155: ELSIF (l_category_code = 'INTERCOMPANY' or l_category_code = 'INTRACOMPANY') THEN
156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');
157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);

Line 154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);

150: -- suspense violation
151: ELSIF (l_status = 'WARNING') THEN
152: IF (l_category_code = 'DATAPREPARATION') THEN
153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');
154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
155: ELSIF (l_category_code = 'INTERCOMPANY' or l_category_code = 'INTRACOMPANY') THEN
156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');
157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
158: FND_MESSAGE.set_token('ENTITY_2', l_counter_entity_name);

Line 156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');

152: IF (l_category_code = 'DATAPREPARATION') THEN
153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');
154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
155: ELSIF (l_category_code = 'INTERCOMPANY' or l_category_code = 'INTRACOMPANY') THEN
156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');
157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
158: FND_MESSAGE.set_token('ENTITY_2', l_counter_entity_name);
159: IF ((l_category_code = 'INTERCOMPANY' OR l_category_code = 'INTRACOMPANY') AND l_counter_entity_id IS NOT NULL) THEN
160: BEGIN

Line 157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);

153: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_DP_TITLE');
154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
155: ELSIF (l_category_code = 'INTERCOMPANY' or l_category_code = 'INTRACOMPANY') THEN
156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');
157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
158: FND_MESSAGE.set_token('ENTITY_2', l_counter_entity_name);
159: IF ((l_category_code = 'INTERCOMPANY' OR l_category_code = 'INTRACOMPANY') AND l_counter_entity_id IS NOT NULL) THEN
160: BEGIN
161: -- Get contact for counter entity

Line 158: FND_MESSAGE.set_token('ENTITY_2', l_counter_entity_name);

154: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
155: ELSIF (l_category_code = 'INTERCOMPANY' or l_category_code = 'INTRACOMPANY') THEN
156: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_INTER_TITLE');
157: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
158: FND_MESSAGE.set_token('ENTITY_2', l_counter_entity_name);
159: IF ((l_category_code = 'INTERCOMPANY' OR l_category_code = 'INTRACOMPANY') AND l_counter_entity_id IS NOT NULL) THEN
160: BEGIN
161: -- Get contact for counter entity
162: SELECT fea_counter.varchar_assign_value

Line 183: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ELIM_TITLE');

179: EXCEPTION WHEN OTHERS THEN NULL;
180: END;
181: END IF;
182: ELSE
183: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ELIM_TITLE');
184: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
185: END IF;
186: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
187: l_subject := FND_MESSAGE.GET;

Line 184: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);

180: END;
181: END IF;
182: ELSE
183: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ELIM_TITLE');
184: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
185: END IF;
186: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
187: l_subject := FND_MESSAGE.GET;
188:

Line 186: FND_MESSAGE.set_token('DATE_TOKEN', l_date);

182: ELSE
183: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ELIM_TITLE');
184: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
185: END IF;
186: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
187: l_subject := FND_MESSAGE.GET;
188:
189: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||l_run_name||'&'||'CONS_ENTITY_ID='||l_cons_entity_id||'&'||'CATEGORY='||l_category_code||'&'||'RUN_DETAIL_ID='||p_cons_detail_id;
190: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;

Line 187: l_subject := FND_MESSAGE.GET;

183: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ELIM_TITLE');
184: FND_MESSAGE.set_token('ENTITY_1', l_entity_name);
185: END IF;
186: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
187: l_subject := FND_MESSAGE.GET;
188:
189: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||l_run_name||'&'||'CONS_ENTITY_ID='||l_cons_entity_id||'&'||'CATEGORY='||l_category_code||'&'||'RUN_DETAIL_ID='||p_cons_detail_id;
190: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;
191: -- error

Line 193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');

189: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||l_run_name||'&'||'CONS_ENTITY_ID='||l_cons_entity_id||'&'||'CATEGORY='||l_category_code||'&'||'RUN_DETAIL_ID='||p_cons_detail_id;
190: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;
191: -- error
192: ELSE
193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');
194: FND_MESSAGE.set_token('CATEGORY', l_category_code);
195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
197: l_subject := FND_MESSAGE.GET;

Line 194: FND_MESSAGE.set_token('CATEGORY', l_category_code);

190: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;
191: -- error
192: ELSE
193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');
194: FND_MESSAGE.set_token('CATEGORY', l_category_code);
195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
197: l_subject := FND_MESSAGE.GET;
198:

Line 195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);

191: -- error
192: ELSE
193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');
194: FND_MESSAGE.set_token('CATEGORY', l_category_code);
195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
197: l_subject := FND_MESSAGE.GET;
198:
199: END IF;

Line 196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);

192: ELSE
193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');
194: FND_MESSAGE.set_token('CATEGORY', l_category_code);
195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
197: l_subject := FND_MESSAGE.GET;
198:
199: END IF;
200:

Line 197: l_subject := FND_MESSAGE.GET;

193: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_ERROR_TITLE');
194: FND_MESSAGE.set_token('CATEGORY', l_category_code);
195: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
196: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
197: l_subject := FND_MESSAGE.GET;
198:
199: END IF;
200:
201: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);

Line 319: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_IMPACTED_TITLE');

315: -- Bug fix 5245250
316: --l_event_key := substr(l_cons_entity_name, 1, 150) || ' impacted on ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS');
317: l_event_key := 'Consolidation Impact Notification: ' || l_seq;
318:
319: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_IMPACTED_TITLE');
320: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
321: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
322: l_subject := FND_MESSAGE.GET;
323:

Line 320: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);

316: --l_event_key := substr(l_cons_entity_name, 1, 150) || ' impacted on ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS');
317: l_event_key := 'Consolidation Impact Notification: ' || l_seq;
318:
319: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_IMPACTED_TITLE');
320: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
321: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
322: l_subject := FND_MESSAGE.GET;
323:
324: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||

Line 321: FND_MESSAGE.set_token('DATE_TOKEN', l_date);

317: l_event_key := 'Consolidation Impact Notification: ' || l_seq;
318:
319: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_IMPACTED_TITLE');
320: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
321: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
322: l_subject := FND_MESSAGE.GET;
323:
324: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||
325: p_run_name||'&'||'CONS_ENTITY_ID='||p_cons_entity_id||'&'||'CATEGORY=IMPACTED';

Line 322: l_subject := FND_MESSAGE.GET;

318:
319: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_IMPACTED_TITLE');
320: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
321: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
322: l_subject := FND_MESSAGE.GET;
323:
324: l_wf_region := 'JSP:/OA_HTML/OA.jsp?OAFunc=FCH_WF_EMBEDDED_RG'||'&'||'RUNNAME='||
325: p_run_name||'&'||'CONS_ENTITY_ID='||p_cons_entity_id||'&'||'CATEGORY=IMPACTED';
326:

Line 439: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_LOCKED_TITLE');

435: -- Bug fix 5245250
436: --l_event_key := substr(l_cons_entity_name, 1, 150) || ' locked on ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS');
437: l_event_key := 'Consolidation Lock Notification: ' || l_seq;
438:
439: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_LOCKED_TITLE');
440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:

Line 440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);

436: --l_event_key := substr(l_cons_entity_name, 1, 150) || ' locked on ' || to_char(sysdate, 'DD-MON-RR HH24:MI:SS');
437: l_event_key := 'Consolidation Lock Notification: ' || l_seq;
438:
439: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_LOCKED_TITLE');
440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);

Line 441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);

437: l_event_key := 'Consolidation Lock Notification: ' || l_seq;
438:
439: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_LOCKED_TITLE');
440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);

Line 442: l_subject := FND_MESSAGE.GET;

438:
439: FND_MESSAGE.SET_NAME ('GCS', 'GCS_WF_LOCKED_TITLE');
440: FND_MESSAGE.set_token('ENTITY_NAME', l_cons_entity_name);
441: FND_MESSAGE.set_token('DATE_TOKEN', l_date);
442: l_subject := FND_MESSAGE.GET;
443:
444: WF_ENGINE.CreateProcess('FCHNTFWF', l_event_key, 'GCS NOTIFICATION PROCESS', l_event_key, null);
445: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_1', null);
446: WF_ENGINE.SetItemAttrText('FCHNTFWF', l_event_key, 'ENTITY_2', null);