DBA Data[Home] [Help]

APPS.IGW_PROP_APPROVALS_PVT dependencies on FND_MESSAGE

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

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

Line 73: fnd_message.set_name(l_short_name, l_message_name);

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

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

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

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

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

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

163: EXCEPTION
164:
165: WHEN NO_DATA_FOUND THEN
166: x_return_status:= FND_API.G_RET_STS_ERROR;
167: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
168: fnd_msg_pub.add;
169:
170: WHEN too_many_rows THEN
171: NULL;

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

224:
225:
226: if l_count = 0 then
227:
228: fnd_message.set_name('IGW','IGW_ROUT_PR_OWNER_CAN_SUBMIT');
229: p_error_message := fnd_message.get_encoded;
230: p_return_status := 'E';
231: return;
232:

Line 229: p_error_message := fnd_message.get_encoded;

225:
226: if l_count = 0 then
227:
228: fnd_message.set_name('IGW','IGW_ROUT_PR_OWNER_CAN_SUBMIT');
229: p_error_message := fnd_message.get_encoded;
230: p_return_status := 'E';
231: return;
232:
233: end if;

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

253: proposal_id = g_proposal_id;
254:
255: if l_proposal_status = 'I' then
256:
257: fnd_message.set_name('IGW','IGW_ROUT_IPR_CANNOT_SUBMIT');
258: p_error_message := fnd_message.get_encoded;
259: p_return_status := 'E';
260: return;
261:

Line 258: p_error_message := fnd_message.get_encoded;

254:
255: if l_proposal_status = 'I' then
256:
257: fnd_message.set_name('IGW','IGW_ROUT_IPR_CANNOT_SUBMIT');
258: p_error_message := fnd_message.get_encoded;
259: p_return_status := 'E';
260: return;
261:
262: elsif l_proposal_status = 'A' then

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

260: return;
261:
262: elsif l_proposal_status = 'A' then
263:
264: fnd_message.set_name('IGW','IGW_ROUT_APR_CANNOT_SUBMIT');
265: p_error_message := fnd_message.get_encoded;
266: p_return_status := 'E';
267: return;
268:

Line 265: p_error_message := fnd_message.get_encoded;

261:
262: elsif l_proposal_status = 'A' then
263:
264: fnd_message.set_name('IGW','IGW_ROUT_APR_CANNOT_SUBMIT');
265: p_error_message := fnd_message.get_encoded;
266: p_return_status := 'E';
267: return;
268:
269:

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

268:
269:
270: elsif ((l_budget_complete = 'N') AND (l_budget_not_applicable = 'N')) then
271:
272: fnd_message.set_name('IGW','IGW_ROUT_BUDGET_INCOMPLETE');
273: p_error_message := fnd_message.get_encoded;
274: p_return_status := 'E';
275: return;
276:

Line 273: p_error_message := fnd_message.get_encoded;

269:
270: elsif ((l_budget_complete = 'N') AND (l_budget_not_applicable = 'N')) then
271:
272: fnd_message.set_name('IGW','IGW_ROUT_BUDGET_INCOMPLETE');
273: p_error_message := fnd_message.get_encoded;
274: p_return_status := 'E';
275: return;
276:
277: end if;

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

325: igw_workflow.start_workflow(p_proposal_id,l_run_id);
326:
327: else
328:
329: fnd_message.set_name('IGW','IGW_ROUT_NO_STOPS_FOUND');
330:
331: p_error_message := fnd_message.get_encoded;
332: p_return_status := 'E';
333: return;

Line 331: p_error_message := fnd_message.get_encoded;

327: else
328:
329: fnd_message.set_name('IGW','IGW_ROUT_NO_STOPS_FOUND');
330:
331: p_error_message := fnd_message.get_encoded;
332: p_return_status := 'E';
333: return;
334: end if;
335:

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

473: if (p_rule_type = 'V' and l_execute_result = '1=2' and l_valid_flag = 'V') or
474: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
475:
476:
477: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
478: fnd_message.set_token('RULE_NAME',l_rule_name);
479: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
480: p_error_message := fnd_message.get_encoded;
481:

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

474: (p_rule_type = 'V' and l_execute_result = '1=1' and l_valid_flag = 'I') then
475:
476:
477: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
478: fnd_message.set_token('RULE_NAME',l_rule_name);
479: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
480: p_error_message := fnd_message.get_encoded;
481:
482: close get_business_rules;

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

475:
476:
477: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
478: fnd_message.set_token('RULE_NAME',l_rule_name);
479: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
480: p_error_message := fnd_message.get_encoded;
481:
482: close get_business_rules;
483: p_invalid_flag := 'Y';

Line 480: p_error_message := fnd_message.get_encoded;

476:
477: fnd_message.set_name('IGW','IGW_ROUT_VALIDATION_FAILED');
478: fnd_message.set_token('RULE_NAME',l_rule_name);
479: fnd_message.set_token('ORGANIZATION_NAME',l_org_name);
480: p_error_message := fnd_message.get_encoded;
481:
482: close get_business_rules;
483: p_invalid_flag := 'Y';
484: exit;

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

524:
525: if p_rule_type = 'N' then
526:
527: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
528: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
529: fnd_message.set_token('RUN_ID', p_run_id);
530: l_wf_display_role_name := fnd_message.get;
531:
532:

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

525: if p_rule_type = 'N' then
526:
527: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
528: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
529: fnd_message.set_token('RUN_ID', p_run_id);
530: l_wf_display_role_name := fnd_message.get;
531:
532:
533: elsif p_rule_type = 'R' then

Line 530: l_wf_display_role_name := fnd_message.get;

526:
527: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-0-0';
528: fnd_message.set_name('IGW','IGW_ROUT_NOTIFICATION_ROLE');
529: fnd_message.set_token('RUN_ID', p_run_id);
530: l_wf_display_role_name := fnd_message.get;
531:
532:
533: elsif p_rule_type = 'R' then
534:

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

534:
535: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-'||
536: to_char(l_map_id)||'-'||to_char(c1.stop_id);
537:
538: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
539: fnd_message.set_token('MAP_NAME', l_description);
540: fnd_message.set_token('STOP_ID',c1.stop_id);
541: fnd_message.set_token('RUN_ID', p_run_id);
542: l_wf_display_role_name := fnd_message.get;

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

535: l_wf_role_name := 'IGW'||'-'||to_char(p_run_id)||'-'||
536: to_char(l_map_id)||'-'||to_char(c1.stop_id);
537:
538: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
539: fnd_message.set_token('MAP_NAME', l_description);
540: fnd_message.set_token('STOP_ID',c1.stop_id);
541: fnd_message.set_token('RUN_ID', p_run_id);
542: l_wf_display_role_name := fnd_message.get;
543:

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

536: to_char(l_map_id)||'-'||to_char(c1.stop_id);
537:
538: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
539: fnd_message.set_token('MAP_NAME', l_description);
540: fnd_message.set_token('STOP_ID',c1.stop_id);
541: fnd_message.set_token('RUN_ID', p_run_id);
542: l_wf_display_role_name := fnd_message.get;
543:
544: end if;

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

537:
538: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
539: fnd_message.set_token('MAP_NAME', l_description);
540: fnd_message.set_token('STOP_ID',c1.stop_id);
541: fnd_message.set_token('RUN_ID', p_run_id);
542: l_wf_display_role_name := fnd_message.get;
543:
544: end if;
545:

Line 542: l_wf_display_role_name := fnd_message.get;

538: fnd_message.set_name('IGW','IGW_ROUT_ROUTING_ROLE');
539: fnd_message.set_token('MAP_NAME', l_description);
540: fnd_message.set_token('STOP_ID',c1.stop_id);
541: fnd_message.set_token('RUN_ID', p_run_id);
542: l_wf_display_role_name := fnd_message.get;
543:
544: end if;
545:
546: insert into igw_prop_map_stops(prop_map_id,stop_id,