eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROPOSAL_APPROVAL dependencies on FND_MSG_PUB

Line 32: fnd_msg_pub.initialize;

28: END IF;
29:
30: -- initialize message list if p_init_msg_list is true
31: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
32: fnd_msg_pub.initialize;
33: end if;
34:
35: -- initialize return_status to success
36: x_return_status := fnd_api.g_ret_sts_success;

Line 64: fnd_msg_pub.initialize;

60: -- dbms_output.put_line(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);

Line 72: -- fnd_msg_pub.add;

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;
76: fnd_message.parse_encoded(encoded_message => l_msg_data,

Line 75: fnd_msg_pub.initialize;

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;
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);

Line 83: -- fnd_msg_pub.add;

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;
87: end if;

Line 109: fnd_msg_pub.count_and_get(p_count => x_msg_count,

105: END IF;
106:
107: x_return_status := FND_API.G_RET_STS_ERROR;
108:
109: fnd_msg_pub.count_and_get(p_count => x_msg_count,
110: p_data => x_msg_data);
111:
112:
113:

Line 121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSAL_APPROVAL',

117: END IF;
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSAL_APPROVAL',
122: p_procedure_name => 'START_APPROVAL_PROCESS',
123: p_error_text => SUBSTRB(SQLERRM,1,240));
124:
125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSAL_APPROVAL',
122: p_procedure_name => 'START_APPROVAL_PROCESS',
123: p_error_text => SUBSTRB(SQLERRM,1,240));
124:
125: fnd_msg_pub.count_and_get(p_count => x_msg_count,
126: p_data => x_msg_data);
127:
128:
129: END start_approval_process;

Line 159: fnd_msg_pub.add;

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;
163:

Line 166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSAL_APPROVAL',

162: NULL;
163:
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROPOSAL_APPROVAL',
167: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
168: p_error_text => SUBSTRB(SQLERRM,1,240));
169: raise fnd_api.g_exc_unexpected_error;
170: END VALIDATE_LOGGED_USER_RIGHTS;

Line 224: fnd_msg_pub.add; -- Debashis

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;
228: -- return;

Line 258: fnd_msg_pub.add; -- Debashis

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;
262: -- return;

Line 267: fnd_msg_pub.add; -- Debashis

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;
271: -- return;

Line 277: fnd_msg_pub.add; -- Debashis

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;
281: -- return;

Line 331: fnd_msg_pub.add; -- Debashis

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;
335: -- return;

Line 356: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','START_APPROVAL');

352: p_return_status := FND_API.G_RET_STS_ERROR;
353: raise fnd_api.g_exc_error;
354:
355: when others then
356: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','START_APPROVAL');
357:
358: p_error_message := fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
359: p_encoded => FND_API.G_TRUE);
360:

Line 358: p_error_message := fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

354:
355: when others then
356: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','START_APPROVAL');
357:
358: p_error_message := fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
359: p_encoded => FND_API.G_TRUE);
360:
361:
362: p_return_status := 'U';

Line 484: fnd_msg_pub.add; -- Debashis

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;
488: p_invalid_flag := 'Y';

Line 638: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_BUSINESS_RULES');

634: WHEN FND_API.G_EXC_ERROR THEN
635: raise fnd_api.g_exc_error;
636:
637: when others then
638: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_BUSINESS_RULES');
639: raise;
640: end get_business_rules;
641:
642:

Line 698: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_BUSINESS_RULE');

694: end if;
695:
696: exception
697: when others then
698: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_BUSINESS_RULE');
699: raise;
700:
701: end execute_business_rule;
702:

Line 976: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_LINE');

972: end if;
973:
974: exception
975: when others then
976: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_LINE');
977: raise;
978: end execute_line;
979:
980:

Line 996: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','FOUND_STRING');

992: end if;
993:
994: exception
995: when others then
996: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','FOUND_STRING');
997: raise;
998: end found_string;
999:
1000:

Line 1015: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','NOT_FOUND_STRING');

1011: end if;
1012:
1013: exception
1014: when others then
1015: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','NOT_FOUND_STRING');
1016: raise;
1017: end not_found_string;
1018:
1019:

Line 1044: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_DYNAMIC_SQL');

1040: end if;
1041:
1042: exception
1043: when others then
1044: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_DYNAMIC_SQL');
1045: raise;
1046: end execute_dynamic_sql;
1047:
1048:

Line 1072: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_PARENT_ORG_ID');

1068: return l_org_id_parent;
1069:
1070: exception
1071: when others then
1072: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_PARENT_ORG_ID');
1073: raise;
1074: end get_parent_org_id;
1075:
1076:

Line 1258: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','POPULATE_LOCAL_WF_TABLES');

1254: end loop;
1255:
1256: exception
1257: when others then
1258: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','POPULATE_LOCAL_WF_TABLES');
1259: raise;
1260: end populate_local_wf_tables;
1261:
1262: end igw_proposal_approval;