DBA Data[Home] [Help]

APPS.IGW_PROPOSAL_APPROVAL dependencies on FND_MESSAGE

Line 65: -- fnd_message.parse_encoded(encoded_message => l_msg_data,

61: -- dbms_output.put_line(l_message_name);
62:
63: if (l_return_status = 'E') then
64: fnd_msg_pub.initialize;
65: -- fnd_message.parse_encoded(encoded_message => l_msg_data,
66: -- app_short_name => l_short_name,
67: -- message_name => l_message_name);
68: -- dbms_output.put_line(l_msg_data);
69: -- dbms_output.put_line(l_message_name);

Line 71: -- fnd_message.set_name(l_short_name, l_message_name);

67: -- message_name => l_message_name);
68: -- dbms_output.put_line(l_msg_data);
69: -- dbms_output.put_line(l_message_name);
70:
71: -- fnd_message.set_name(l_short_name, l_message_name);
72: -- fnd_msg_pub.add;
73: raise fnd_api.g_exc_error;
74: elsif (l_return_status = 'U') then
75: fnd_msg_pub.initialize;

Line 76: fnd_message.parse_encoded(encoded_message => l_msg_data,

72: -- fnd_msg_pub.add;
73: raise fnd_api.g_exc_error;
74: elsif (l_return_status = 'U') then
75: fnd_msg_pub.initialize;
76: fnd_message.parse_encoded(encoded_message => l_msg_data,
77: app_short_name => l_short_name,
78: message_name => l_message_name);
79: -- dbms_output.put_line(l_msg_data);
80: -- dbms_output.put_line(l_message_name);

Line 82: -- fnd_message.set_name('l_short_name', l_message_name);

78: message_name => l_message_name);
79: -- dbms_output.put_line(l_msg_data);
80: -- dbms_output.put_line(l_message_name);
81:
82: -- fnd_message.set_name('l_short_name', l_message_name);
83: -- fnd_msg_pub.add;
84: raise fnd_api.g_exc_unexpected_error;
85: elsif (l_return_status = 'S') then
86: update igw_proposals_all set proposal_status = 'I' where proposal_id = p_proposal_id;

Line 158: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');

154: EXCEPTION
155:
156: WHEN NO_DATA_FOUND THEN
157: x_return_status:= FND_API.G_RET_STS_ERROR;
158: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
159: fnd_msg_pub.add;
160: raise;
161: WHEN too_many_rows THEN
162: NULL;

Line 223: fnd_message.set_name('IGW','IGW_ROUT_PR_OWNER_CAN_SUBMIT');

219: and sysdate <= nvl(ppu.end_date_active,sysdate);
220:
221: if l_count = 0 then
222:
223: fnd_message.set_name('IGW','IGW_ROUT_PR_OWNER_CAN_SUBMIT');
224: fnd_msg_pub.add; -- Debashis
225: p_error_message := fnd_message.get_encoded;
226: p_return_status := 'E';
227: raise fnd_api.g_exc_error;

Line 225: p_error_message := fnd_message.get_encoded;

221: if l_count = 0 then
222:
223: fnd_message.set_name('IGW','IGW_ROUT_PR_OWNER_CAN_SUBMIT');
224: fnd_msg_pub.add; -- Debashis
225: p_error_message := fnd_message.get_encoded;
226: p_return_status := 'E';
227: raise fnd_api.g_exc_error;
228: -- return;
229:

Line 257: fnd_message.set_name('IGW','IGW_ROUT_IPR_CANNOT_SUBMIT');

253:
254:
255: if l_proposal_status = 'I' then
256:
257: fnd_message.set_name('IGW','IGW_ROUT_IPR_CANNOT_SUBMIT');
258: fnd_msg_pub.add; -- Debashis
259: p_error_message := fnd_message.get_encoded;
260: p_return_status := 'E';
261: raise fnd_api.g_exc_error;

Line 259: p_error_message := fnd_message.get_encoded;

255: if l_proposal_status = 'I' then
256:
257: fnd_message.set_name('IGW','IGW_ROUT_IPR_CANNOT_SUBMIT');
258: fnd_msg_pub.add; -- Debashis
259: p_error_message := fnd_message.get_encoded;
260: p_return_status := 'E';
261: raise fnd_api.g_exc_error;
262: -- return;
263:

Line 266: fnd_message.set_name('IGW','IGW_ROUT_APR_CANNOT_SUBMIT');

262: -- return;
263:
264: elsif l_proposal_status = 'A' then
265:
266: fnd_message.set_name('IGW','IGW_ROUT_APR_CANNOT_SUBMIT');
267: fnd_msg_pub.add; -- Debashis
268: p_error_message := fnd_message.get_encoded;
269: p_return_status := 'E';
270: raise fnd_api.g_exc_error;

Line 268: p_error_message := fnd_message.get_encoded;

264: elsif l_proposal_status = 'A' then
265:
266: fnd_message.set_name('IGW','IGW_ROUT_APR_CANNOT_SUBMIT');
267: fnd_msg_pub.add; -- Debashis
268: p_error_message := fnd_message.get_encoded;
269: p_return_status := 'E';
270: raise fnd_api.g_exc_error;
271: -- return;
272:

Line 276: fnd_message.set_name('IGW','IGW_ROUT_BUDGET_INCOMPLETE');

272:
273:
274: elsif ((l_budget_complete = 'N') AND (l_budget_not_applicable = 'N')) then
275:
276: fnd_message.set_name('IGW','IGW_ROUT_BUDGET_INCOMPLETE');
277: fnd_msg_pub.add; -- Debashis
278: p_error_message := fnd_message.get_encoded;
279: p_return_status := 'E';
280: raise fnd_api.g_exc_error;

Line 278: p_error_message := fnd_message.get_encoded;

274: elsif ((l_budget_complete = 'N') AND (l_budget_not_applicable = 'N')) then
275:
276: fnd_message.set_name('IGW','IGW_ROUT_BUDGET_INCOMPLETE');
277: fnd_msg_pub.add; -- Debashis
278: p_error_message := fnd_message.get_encoded;
279: p_return_status := 'E';
280: raise fnd_api.g_exc_error;
281: -- return;
282:

Line 330: fnd_message.set_name('IGW','IGW_ROUT_NO_STOPS_FOUND');

326: igw_workflow.start_workflow(p_proposal_id,l_run_id);
327:
328: else
329:
330: fnd_message.set_name('IGW','IGW_ROUT_NO_STOPS_FOUND');
331: fnd_msg_pub.add; -- Debashis
332: p_error_message := fnd_message.get_encoded;
333: p_return_status := 'E';
334: raise fnd_api.g_exc_error;

Line 332: p_error_message := fnd_message.get_encoded;

328: else
329:
330: fnd_message.set_name('IGW','IGW_ROUT_NO_STOPS_FOUND');
331: fnd_msg_pub.add; -- Debashis
332: p_error_message := fnd_message.get_encoded;
333: p_return_status := 'E';
334: raise fnd_api.g_exc_error;
335: -- return;
336: end if;

Line 481: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');

477: if (p_rule_type = 'V' and l_execute_result = '1=2' and l_valid_flag = 'V') or
478: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
479:
480:
481: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
482: fnd_message.set_token('RULE_NAME',l_rule_name);
483: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
484: fnd_msg_pub.add; -- Debashis
485: p_error_message := fnd_message.get_encoded;

Line 482: fnd_message.set_token('RULE_NAME',l_rule_name);

478: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
479:
480:
481: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
482: fnd_message.set_token('RULE_NAME',l_rule_name);
483: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
484: fnd_msg_pub.add; -- Debashis
485: p_error_message := fnd_message.get_encoded;
486:

Line 483: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);

479:
480:
481: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
482: fnd_message.set_token('RULE_NAME',l_rule_name);
483: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
484: fnd_msg_pub.add; -- Debashis
485: p_error_message := fnd_message.get_encoded;
486:
487: close get_business_rules;

Line 485: p_error_message := fnd_message.get_encoded;

481: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
482: fnd_message.set_token('RULE_NAME',l_rule_name);
483: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
484: fnd_msg_pub.add; -- Debashis
485: p_error_message := fnd_message.get_encoded;
486:
487: close get_business_rules;
488: p_invalid_flag := 'Y';
489: raise fnd_api.g_exc_error;

Line 535: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');

531:
532: if p_rule_type = 'N' then
533:
534: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
535: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
536: fnd_message.set_token('RUN_ID', p_run_id);
537:
538: l_wf_display_role_name := fnd_message.get;
539:

Line 536: fnd_message.set_token('RUN_ID', p_run_id);

532: if p_rule_type = 'N' then
533:
534: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
535: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
536: fnd_message.set_token('RUN_ID', p_run_id);
537:
538: l_wf_display_role_name := fnd_message.get;
539:
540:

Line 538: l_wf_display_role_name := fnd_message.get;

534: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
535: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
536: fnd_message.set_token('RUN_ID', p_run_id);
537:
538: l_wf_display_role_name := fnd_message.get;
539:
540:
541: elsif p_rule_type = 'R' then
542:

Line 546: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');

542:
543: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-'||
544: to_char(l_map_id)||'-'||to_char(c1.stop_id);
545:
546: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
547: fnd_message.set_token('MAP_NAME', l_description);
548: fnd_message.set_token('STOP_ID',c1.stop_id);
549: fnd_message.set_token('RUN_ID', p_run_id);
550:

Line 547: fnd_message.set_token('MAP_NAME', l_description);

543: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-'||
544: to_char(l_map_id)||'-'||to_char(c1.stop_id);
545:
546: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
547: fnd_message.set_token('MAP_NAME', l_description);
548: fnd_message.set_token('STOP_ID',c1.stop_id);
549: fnd_message.set_token('RUN_ID', p_run_id);
550:
551: l_wf_display_role_name := fnd_message.get;

Line 548: fnd_message.set_token('STOP_ID',c1.stop_id);

544: to_char(l_map_id)||'-'||to_char(c1.stop_id);
545:
546: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
547: fnd_message.set_token('MAP_NAME', l_description);
548: fnd_message.set_token('STOP_ID',c1.stop_id);
549: fnd_message.set_token('RUN_ID', p_run_id);
550:
551: l_wf_display_role_name := fnd_message.get;
552:

Line 549: fnd_message.set_token('RUN_ID', p_run_id);

545:
546: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
547: fnd_message.set_token('MAP_NAME', l_description);
548: fnd_message.set_token('STOP_ID',c1.stop_id);
549: fnd_message.set_token('RUN_ID', p_run_id);
550:
551: l_wf_display_role_name := fnd_message.get;
552:
553: end if;

Line 551: l_wf_display_role_name := fnd_message.get;

547: fnd_message.set_token('MAP_NAME', l_description);
548: fnd_message.set_token('STOP_ID',c1.stop_id);
549: fnd_message.set_token('RUN_ID', p_run_id);
550:
551: l_wf_display_role_name := fnd_message.get;
552:
553: end if;
554:
555: insert into igw_prop_map_stops(prop_map_id,stop_id,