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.IEX_ROUTING_PVT dependencies on FND_API

Line 15: p_init_msg_list in varchar2 default fnd_api.g_false,

11:
12: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
13:
14: PROCEDURE isCustomerOverdue ( p_api_version in number,
15: p_init_msg_list in varchar2 default fnd_api.g_false,
16: p_commit in varchar2 default fnd_api.g_false,
17: p_validation_level in number default fnd_api.g_valid_level_full,
18: x_return_status out NOCOPY varchar2,
19: x_msg_count out NOCOPY number,

Line 16: p_commit in varchar2 default fnd_api.g_false,

12: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
13:
14: PROCEDURE isCustomerOverdue ( p_api_version in number,
15: p_init_msg_list in varchar2 default fnd_api.g_false,
16: p_commit in varchar2 default fnd_api.g_false,
17: p_validation_level in number default fnd_api.g_valid_level_full,
18: x_return_status out NOCOPY varchar2,
19: x_msg_count out NOCOPY number,
20: x_msg_data out NOCOPY varchar2,

Line 17: p_validation_level in number default fnd_api.g_valid_level_full,

13:
14: PROCEDURE isCustomerOverdue ( p_api_version in number,
15: p_init_msg_list in varchar2 default fnd_api.g_false,
16: p_commit in varchar2 default fnd_api.g_false,
17: p_validation_level in number default fnd_api.g_valid_level_full,
18: x_return_status out NOCOPY varchar2,
19: x_msg_count out NOCOPY number,
20: x_msg_data out NOCOPY varchar2,
21: p_customer_id in number,

Line 27: l_blank_chr varchar2(1) := FND_API.G_MISS_CHAR;

23:
24: AS
25: l_api_name constant varchar2(30) := 'isCustomerOverdue';
26: l_api_version constant number := 1.0;
27: l_blank_chr varchar2(1) := FND_API.G_MISS_CHAR;
28: i number := 0;
29:
30: /* Begin - Andre Araujo - Change the test to iex_delinquencies
31: CURSOR c_CustomerOverdue IS

Line 49: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

45: /* Standard start of API savepoint */
46: SAVEPOINT IEX_ROUTING_PVT;
47:
48: /* Standard call to check for call compatibility */
49: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: SAVEPOINT IEX_ROUTING_PVT;
47:
48: /* Standard call to check for call compatibility */
49: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: /* Initialize message list if p_init_msg_list is set to TRUE */
54: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 54: IF FND_API.To_Boolean(p_init_msg_list) THEN

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: /* Initialize message list if p_init_msg_list is set to TRUE */
54: IF FND_API.To_Boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: /* Initialize API return status to success */

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: END IF;
57:
58: /* Initialize API return status to success */
59:
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: /* API body */
63: /* Begin - Andre Araujo - Adapt the api to iex_delinquencies_all
64: i := 0;

Line 87: IF FND_API.To_Boolean(p_commit) THEN

83:
84: /* End of API body */
85:
86: /* Standard check of p_commit */
87: IF FND_API.To_Boolean(p_commit) THEN
88: COMMIT WORK;
89: END IF;
90:
91: /* Standard call to get message count and if count is 1, get message info */

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90:
91: /* Standard call to get message count and if count is 1, get message info */
92: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO IEX_ROUTING_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO IEX_ROUTING_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO IEX_ROUTING_PVT;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO IEX_ROUTING_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO IEX_ROUTING_PVT;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
102: WHEN OTHERS THEN

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO IEX_ROUTING_PVT;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
102: WHEN OTHERS THEN
103: ROLLBACK TO IEX_ROUTING_PVT;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
102: WHEN OTHERS THEN
103: ROLLBACK TO IEX_ROUTING_PVT;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
106: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 113: p_init_msg_list in varchar2 default fnd_api.g_false,

109:
110: END isCustomerOverdue;
111:
112: PROCEDURE getCollectors ( p_api_version in number,
113: p_init_msg_list in varchar2 default fnd_api.g_false,
114: p_commit in varchar2 default fnd_api.g_false,
115: p_validation_level in number default fnd_api.g_valid_level_full,
116: x_return_status out NOCOPY varchar2,
117: x_msg_count out NOCOPY number,

Line 114: p_commit in varchar2 default fnd_api.g_false,

110: END isCustomerOverdue;
111:
112: PROCEDURE getCollectors ( p_api_version in number,
113: p_init_msg_list in varchar2 default fnd_api.g_false,
114: p_commit in varchar2 default fnd_api.g_false,
115: p_validation_level in number default fnd_api.g_valid_level_full,
116: x_return_status out NOCOPY varchar2,
117: x_msg_count out NOCOPY number,
118: x_msg_data out NOCOPY varchar2,

Line 115: p_validation_level in number default fnd_api.g_valid_level_full,

111:
112: PROCEDURE getCollectors ( p_api_version in number,
113: p_init_msg_list in varchar2 default fnd_api.g_false,
114: p_commit in varchar2 default fnd_api.g_false,
115: p_validation_level in number default fnd_api.g_valid_level_full,
116: x_return_status out NOCOPY varchar2,
117: x_msg_count out NOCOPY number,
118: x_msg_data out NOCOPY varchar2,
119: p_customer_id in number,

Line 126: l_blank_chr varchar2(1) := FND_API.G_MISS_CHAR;

122: AS
123:
124: l_api_name constant varchar2(30) := 'getCollectors';
125: l_api_version constant number := 1.0;
126: l_blank_chr varchar2(1) := FND_API.G_MISS_CHAR;
127: i number := 0;
128:
129: CURSOR c_Collectors IS
130: select distinct collector_id

Line 140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

136: /* Standard start of API savepoint */
137: SAVEPOINT IEX_ROUTING_PVT;
138:
139: /* Standard call to check for call compatibility */
140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: SAVEPOINT IEX_ROUTING_PVT;
138:
139: /* Standard call to check for call compatibility */
140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: /* Initialize message list if p_init_msg_list is set to TRUE */
145: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 145: IF FND_API.To_Boolean(p_init_msg_list) THEN

141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: /* Initialize message list if p_init_msg_list is set to TRUE */
145: IF FND_API.To_Boolean(p_init_msg_list) THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: /* Initialize API return status to success */

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: END IF;
148:
149: /* Initialize API return status to success */
150:
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: /* API body */
154: i := 0;
155: FOR v_Collectors IN c_Collectors

Line 164: IF FND_API.To_Boolean(p_commit) THEN

160:
161: /* End of API body */
162:
163: /* Standard check of p_commit */
164: IF FND_API.To_Boolean(p_commit) THEN
165: COMMIT WORK;
166: END IF;
167:
168: /* Standard call to get message count and if count is 1, get message info */

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167:
168: /* Standard call to get message count and if count is 1, get message info */
169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO IEX_ROUTING_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 173: x_return_status := FND_API.G_RET_STS_ERROR;

169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO IEX_ROUTING_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO IEX_ROUTING_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO IEX_ROUTING_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO IEX_ROUTING_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN OTHERS THEN

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO IEX_ROUTING_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN OTHERS THEN
180: ROLLBACK TO IEX_ROUTING_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN OTHERS THEN
180: ROLLBACK TO IEX_ROUTING_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
184: END IF;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);