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_PROP_APPROVALS_PVT dependencies on FND_MSG_PUB

Line 34: fnd_msg_pub.initialize;

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

Line 66: fnd_msg_pub.initialize;

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

Line 74: fnd_msg_pub.add;

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

Line 77: fnd_msg_pub.initialize;

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

Line 85: fnd_msg_pub.add;

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

Line 129: /* fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_APPROVALS_PVT',

125:
126: x_msg_count := 1;
127: x_msg_data := l_message_name;
128:
129: /* fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_APPROVALS_PVT',
130: p_procedure_name => 'START_APPROVAL',
131: p_error_text => SUBSTRB(SQLERRM,1,240));
132:
133: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

129: /* fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_APPROVALS_PVT',
130: p_procedure_name => 'START_APPROVAL',
131: p_error_text => SUBSTRB(SQLERRM,1,240));
132:
133: fnd_msg_pub.count_and_get(p_count => x_msg_count,
134: p_data => x_msg_data);
135: */
136:
137: END start_approval_process;

Line 168: fnd_msg_pub.add;

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

Line 175: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_APPROVALS_PVT',

171: NULL;
172:
173: WHEN OTHERS THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_APPROVALS_PVT',
176: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
177: p_error_text => SUBSTRB(SQLERRM,1,240));
178: raise fnd_api.g_exc_unexpected_error;
179: END VALIDATE_LOGGED_USER_RIGHTS;

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

348: exception
349: when others then
350:
351: -- dbms_output.put_line('Inside when other exception');
352: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','START_APPROVAL');
353:
354: p_error_message := fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
355: p_encoded => FND_API.G_TRUE);
356:

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

350:
351: -- dbms_output.put_line('Inside when other exception');
352: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','START_APPROVAL');
353:
354: p_error_message := fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
355: p_encoded => FND_API.G_TRUE);
356:
357: p_return_status := 'U';
358: -- dbms_output.put_line('p_error_message --> ' || p_error_message);

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

622: end loop;
623:
624: exception
625: when others then
626: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_BUSINESS_RULES');
627: raise;
628: end get_business_rules;
629:
630:

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

682: end if;
683:
684: exception
685: when others then
686: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_BUSINESS_RULE');
687: raise;
688:
689: end execute_business_rule;
690:

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

960: end if;
961:
962: exception
963: when others then
964: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_LINE');
965: raise;
966: end execute_line;
967:
968:

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

980: end if;
981:
982: exception
983: when others then
984: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','FOUND_STRING');
985: raise;
986: end found_string;
987:
988:

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

999: end if;
1000:
1001: exception
1002: when others then
1003: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','NOT_FOUND_STRING');
1004: raise;
1005: end not_found_string;
1006:
1007:

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

1028: end if;
1029:
1030: exception
1031: when others then
1032: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','EXECUTE_DYNAMIC_SQL');
1033: raise;
1034: end execute_dynamic_sql;
1035:
1036:

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

1056: return l_org_id_parent;
1057:
1058: exception
1059: when others then
1060: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','GET_PARENT_ORG_ID');
1061: raise;
1062: end get_parent_org_id;
1063:
1064:

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

1243: end loop;
1244:
1245: exception
1246: when others then
1247: fnd_msg_pub.add_exc_msg('IGW_PROPOSAL_APPROVAL','POPULATE_LOCAL_WF_TABLES');
1248: raise;
1249: end populate_local_wf_tables;
1250:
1251: