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_UTILITIES dependencies on FND_API

Line 42: IF NOT FND_API.Compatible_API_Call (l_api_version,

38:
39: amount := 0;
40: total := 0;
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call (l_api_version,
43: p_api_version,
44: l_api_name,
45: G_PKG_NAME) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42: IF NOT FND_API.Compatible_API_Call (l_api_version,
43: p_api_version,
44: l_api_name,
45: G_PKG_NAME) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49: -- Check p_init_msg_list
50: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 50: IF FND_API.to_Boolean( p_init_msg_list ) THEN

46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49: -- Check p_init_msg_list
50: IF FND_API.to_Boolean( p_init_msg_list ) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: IF FND_API.to_Boolean( p_init_msg_list ) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: SELECT nvl( SUM (acctd_amount_due_remaining), 0) AMOUNT
57: into Amount
58: FROM AR_PAYMENT_SCHEDULES

Line 92: IF FND_API.To_Boolean(p_commit) THEN

88: total := total + amount ;
89: x_balance := total ;
90:
91: -- Standard check of p_commit
92: IF FND_API.To_Boolean(p_commit) THEN
93: COMMIT WORK;
94: END IF;
95:
96: -- Standard call to get message count and if count is 1, get message info

Line 100: WHEN FND_API.G_EXC_ERROR THEN

96: -- Standard call to get message count and if count is 1, get message info
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO Acct_Balance_PVT;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
104:

Line 102: x_return_status := FND_API.G_RET_STS_ERROR;

98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: ROLLBACK TO Acct_Balance_PVT;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO Acct_Balance_PVT;

Line 105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

101: ROLLBACK TO Acct_Balance_PVT;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO Acct_Balance_PVT;
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:

Line 107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

103: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO Acct_Balance_PVT;
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
110: WHEN OTHERS THEN
111: ROLLBACK TO Acct_Balance_PVT;

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
110: WHEN OTHERS THEN
111: ROLLBACK TO Acct_Balance_PVT;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: -- Standard Start of API savepoint
152: SAVEPOINT Validate_any_id_PVT;
153:
154: -- Initialize API return status to SUCCESS
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: vstr1 := ' Select ''X'' ';
158: vstr2 := ' From ';
159: vstr3 := ' Where exists ';

Line 167: IF NOT FND_API.Compatible_API_Call (l_api_version,

163: vstr7 := ' = :a1)';
164:
165:
166: -- Standard call to check for call compatibility.
167: IF NOT FND_API.Compatible_API_Call (l_api_version,
168: p_api_version,
169: l_api_name,
170: G_PKG_NAME)
171: THEN

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: p_api_version,
169: l_api_name,
170: G_PKG_NAME)
171: THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean(p_init_msg_list)

Line 176: IF FND_API.to_Boolean(p_init_msg_list)

172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean(p_init_msg_list)
177: THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180:

Line 211: l_return_status := FND_API.G_RET_STS_SUCCESS;

207:
208: if valid_id%FOUND then
209: --dbms_output.put_line('FOUND!!');
210: WriteLog('iexvutlb:validateid:Found!');
211: l_return_status := FND_API.G_RET_STS_SUCCESS;
212: else
213: --dbms_output.put_line('NOT FOUND!!');
214: WriteLog('iexvutlb:validateid:NotFound!');
215: l_return_status := FND_API.G_RET_STS_ERROR;

Line 215: l_return_status := FND_API.G_RET_STS_ERROR;

211: l_return_status := FND_API.G_RET_STS_SUCCESS;
212: else
213: --dbms_output.put_line('NOT FOUND!!');
214: WriteLog('iexvutlb:validateid:NotFound!');
215: l_return_status := FND_API.G_RET_STS_ERROR;
216: end if;
217: CLOSE valid_id;
218:
219: x_return_status := l_return_status;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218:
219: x_return_status := l_return_status;
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Validate_any_id_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO Validate_any_id_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Validate_any_id_PVT;

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: ROLLBACK TO Validate_any_id_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Validate_any_id_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
231:

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO Validate_any_id_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO Validate_any_id_PVT;

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO Validate_any_id_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
237: END IF;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: -- Standard Start of API savepoint
276: SAVEPOINT Validate_any_varchar_PVT;
277:
278: -- Initialize API return status to SUCCESS
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281:
282: vstr1 := ' Select ''X'' ';
283: vstr2 := ' From ';

Line 291: IF NOT FND_API.Compatible_API_Call (l_api_version,

287: vstr6 := ' Where ' ;
288: vstr7 := ' = :a1)';
289:
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.Compatible_API_Call (l_api_version,
292: p_api_version,
293: l_api_name,
294: G_PKG_NAME)
295: THEN

Line 296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

292: p_api_version,
293: l_api_name,
294: G_PKG_NAME)
295: THEN
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: END IF;
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean(p_init_msg_list)

Line 300: IF FND_API.to_Boolean(p_init_msg_list)

296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: END IF;
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean(p_init_msg_list)
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:

Line 331: l_return_status := FND_API.G_RET_STS_SUCCESS;

327: FETCH valid_id INTO count_id;
328:
329: if valid_id%FOUND then
330: --dbms_output.put_line('FOUND!!');
331: l_return_status := FND_API.G_RET_STS_SUCCESS;
332: else
333: --dbms_output.put_line('NOT FOUND!!');
334: l_return_status := FND_API.G_RET_STS_ERROR;
335: end if;

Line 334: l_return_status := FND_API.G_RET_STS_ERROR;

330: --dbms_output.put_line('FOUND!!');
331: l_return_status := FND_API.G_RET_STS_SUCCESS;
332: else
333: --dbms_output.put_line('NOT FOUND!!');
334: l_return_status := FND_API.G_RET_STS_ERROR;
335: end if;
336: CLOSE valid_id;
337:
338: x_return_status := l_return_status;

Line 341: WHEN FND_API.G_EXC_ERROR THEN

337:
338: x_return_status := l_return_status;
339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Validate_any_varchar_PVT;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
345:

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Validate_any_varchar_PVT;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Validate_any_varchar_PVT;

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: ROLLBACK TO Validate_any_varchar_PVT;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Validate_any_varchar_PVT;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
350:

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Validate_any_varchar_PVT;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
350:
351: WHEN OTHERS THEN
352: ROLLBACK TO Validate_any_varchar_PVT;

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
350:
351: WHEN OTHERS THEN
352: ROLLBACK TO Validate_any_varchar_PVT;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: -- Standard Start of API savepoint
394: SAVEPOINT Validate_any_varchar_PVT;
395:
396: -- Initialize API return status to SUCCESS
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: vstr1 := 'Select Count(LOOKUP_CODE) ';
400: vstr2 := 'From ';
401: vstr3 := 'Where LOOKUP_TYPE = :l_lookup_type ' ;

Line 406: IF NOT FND_API.Compatible_API_Call (l_api_version,

402: vstr4 := ' AND LOOKUP_CODE = :l_lookup_code ';
403: vstr5 := ' AND ENABLED_FLAG = ''Y''';
404:
405: -- Standard call to check for call compatibility.
406: IF NOT FND_API.Compatible_API_Call (l_api_version,
407: p_api_version,
408: l_api_name,
409: G_PKG_NAME)
410: THEN

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: p_api_version,
408: l_api_name,
409: G_PKG_NAME)
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: -- Initialize message list if p_init_msg_list is set to TRUE.
415: IF FND_API.to_Boolean(p_init_msg_list)

Line 415: IF FND_API.to_Boolean(p_init_msg_list)

411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: -- Initialize message list if p_init_msg_list is set to TRUE.
415: IF FND_API.to_Boolean(p_init_msg_list)
416: THEN
417: FND_MSG_PUB.initialize;
418: END IF;
419:

Line 471: l_return_status := FND_API.G_RET_STS_SUCCESS;

467:
468: WriteLog('iexvutlb:validatelookup:count_id='||count_id);
469:
470: IF (count_id > 0) then
471: l_return_status := FND_API.G_RET_STS_SUCCESS;
472: ELSE
473: l_return_status := FND_API.G_RET_STS_ERROR;
474: END IF ;
475: x_return_status := l_return_status;

Line 473: l_return_status := FND_API.G_RET_STS_ERROR;

469:
470: IF (count_id > 0) then
471: l_return_status := FND_API.G_RET_STS_SUCCESS;
472: ELSE
473: l_return_status := FND_API.G_RET_STS_ERROR;
474: END IF ;
475: x_return_status := l_return_status;
476:
477: EXCEPTION

Line 478: WHEN FND_API.G_EXC_ERROR THEN

474: END IF ;
475: x_return_status := l_return_status;
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: ROLLBACK TO Validate_any_varchar_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: ROLLBACK TO Validate_any_varchar_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Validate_any_varchar_PVT;

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: ROLLBACK TO Validate_any_varchar_PVT;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Validate_any_varchar_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Validate_any_varchar_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:
488: WHEN OTHERS THEN
489: ROLLBACK TO Validate_any_varchar_PVT;

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
487:
488: WHEN OTHERS THEN
489: ROLLBACK TO Validate_any_varchar_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
492: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
493: END IF;
494: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 551: IF NOT FND_API.Compatible_API_Call (l_api_version,

547: END IF;
548: SAVEPOINT Access_Resources_Pvt;
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (l_api_version,
552: p_api_version,
553: l_api_name,
554: G_PKG_NAME) THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: IF NOT FND_API.Compatible_API_Call (l_api_version,
552: p_api_version,
553: l_api_name,
554: G_PKG_NAME) THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558: -- Check p_init_msg_list
559: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 559: IF FND_API.to_Boolean( p_init_msg_list ) THEN

555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558: -- Check p_init_msg_list
559: IF FND_API.to_Boolean( p_init_msg_list ) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: IF FND_API.to_Boolean( p_init_msg_list ) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565: FOR r_person IN c_get_person LOOP
566: IF PG_DEBUG < 10 THEN
567: iex_debug_pub.logmessage ('employee_id = ' || r_person.employee_id);

Line 589: IF FND_API.To_Boolean(p_commit) THEN

585: CLOSE c_get_resource;
586: End LOOP;
587:
588: -- Standard check of p_commit
589: IF FND_API.To_Boolean(p_commit) THEN
590: COMMIT WORK;
591: END IF;
592:
593: -- Standard call to get message count and if count is 1, get message info

Line 601: WHEN FND_API.G_EXC_ERROR THEN

597: iex_debug_pub.logmessage ('**** END get_access_resources ************');
598: END IF;
599:
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO Access_Resources_Pvt;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
605:

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599:
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO Access_Resources_Pvt;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Access_Resources_Pvt;

Line 606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

602: ROLLBACK TO Access_Resources_Pvt;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Access_Resources_Pvt;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
610:

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Access_Resources_Pvt;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
610:
611: WHEN OTHERS THEN
612: ROLLBACK TO Access_Resources_Pvt;

Line 613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
610:
611: WHEN OTHERS THEN
612: ROLLBACK TO Access_Resources_Pvt;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
616: END IF;
617: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 755: IF NOT FND_API.Compatible_API_Call (l_api_version,

751:
752: SAVEPOINT get_assign_resources;
753:
754: -- Standard call to check for call compatibility.
755: IF NOT FND_API.Compatible_API_Call (l_api_version,
756: p_api_version,
757: l_api_name,
758: G_PKG_NAME) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755: IF NOT FND_API.Compatible_API_Call (l_api_version,
756: p_api_version,
757: l_api_name,
758: G_PKG_NAME) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761:
762: -- Check p_init_msg_list
763: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 763: IF FND_API.to_Boolean( p_init_msg_list ) THEN

759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761:
762: -- Check p_init_msg_list
763: IF FND_API.to_Boolean( p_init_msg_list ) THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763: IF FND_API.to_Boolean( p_init_msg_list ) THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769: FOR r_person IN c_get_person LOOP
770: idx := idx + 1;
771: iex_debug_pub.logmessage ('idx= ' || idx);

Line 787: IF FND_API.To_Boolean(p_commit) THEN

783: */
784:
785: /*
786: -- Standard check of p_commit
787: IF FND_API.To_Boolean(p_commit) THEN
788: COMMIT WORK;
789: END IF;
790:
791: -- Standard call to get message count and if count is 1, get message info

Line 797: WHEN FND_API.G_EXC_ERROR THEN

793:
794: iex_debug_pub.logmessage ('**** END get_access_resources ************');
795:
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO get_assign_resources;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
801:

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

795:
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO get_assign_resources;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO get_assign_resources;

Line 802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

798: ROLLBACK TO get_assign_resources;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO get_assign_resources;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806:

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO get_assign_resources;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806:
807: WHEN OTHERS THEN
808: ROLLBACK TO get_assign_resources;

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806:
807: WHEN OTHERS THEN
808: ROLLBACK TO get_assign_resources;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 928: IF NOT FND_API.Compatible_API_Call (l_api_version,

924:
925: SAVEPOINT get_assign_account_resources;
926:
927: -- Standard call to check for call compatibility.
928: IF NOT FND_API.Compatible_API_Call (l_api_version,
929: p_api_version,
930: l_api_name,
931: G_PKG_NAME) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: IF NOT FND_API.Compatible_API_Call (l_api_version,
929: p_api_version,
930: l_api_name,
931: G_PKG_NAME) THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: -- Check p_init_msg_list
936: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 936: IF FND_API.to_Boolean( p_init_msg_list ) THEN

932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: -- Check p_init_msg_list
936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 940: x_return_status := FND_API.G_RET_STS_SUCCESS;

936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942: FOR r_person IN c_get_person LOOP
943: idx := idx + 1;
944: iex_debug_pub.logmessage ('idx= ' || idx);

Line 960: /* IF FND_API.To_Boolean(p_commit) THEN

956: */
957:
958:
959: -- Standard check of p_commit
960: /* IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info

Line 970: WHEN FND_API.G_EXC_ERROR THEN

966:
967: iex_debug_pub.logmessage ('**** END get_access_resources ************');
968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO get_assign_account_resources;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
974:

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO get_assign_account_resources;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO get_assign_account_resources;

Line 975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

971: ROLLBACK TO get_assign_account_resources;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO get_assign_account_resources;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:

Line 977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

973: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO get_assign_account_resources;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN OTHERS THEN
981: ROLLBACK TO get_assign_account_resources;

Line 982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN OTHERS THEN
981: ROLLBACK TO get_assign_account_resources;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
985: END IF;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1041: IF NOT FND_API.Compatible_API_Call (l_api_version,

1037:
1038: SAVEPOINT get_case_resources;
1039:
1040: -- Standard call to check for call compatibility.
1041: IF NOT FND_API.Compatible_API_Call (l_api_version,
1042: p_api_version,
1043: l_api_name,
1044: G_PKG_NAME) THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1041: IF NOT FND_API.Compatible_API_Call (l_api_version,
1042: p_api_version,
1043: l_api_name,
1044: G_PKG_NAME) THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048: -- Check p_init_msg_list
1049: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1049: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048: -- Check p_init_msg_list
1049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1050: FND_MSG_PUB.initialize;
1051: END IF;
1052:
1053: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1053: x_return_status := FND_API.G_RET_STS_SUCCESS;

1049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1050: FND_MSG_PUB.initialize;
1051: END IF;
1052:
1053: x_return_status := FND_API.G_RET_STS_SUCCESS;
1054:
1055: FOR r_person IN c_get_person LOOP
1056: idx := idx + 1;
1057: iex_debug_pub.logmessage ('idx= ' || idx);

Line 1064: IF FND_API.To_Boolean(p_commit) THEN

1060: x_resource_tab(idx).person_id := r_person.employee_id;
1061: End LOOP;
1062:
1063: -- Standard check of p_commit
1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

1070:
1071: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO get_case_resources;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078:

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR;

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO get_case_resources;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO get_case_resources;

Line 1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1075: ROLLBACK TO get_case_resources;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO get_case_resources;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1083:

Line 1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO get_case_resources;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1083:
1084: WHEN OTHERS THEN
1085: ROLLBACK TO get_case_resources;

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1082: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1083:
1084: WHEN OTHERS THEN
1085: ROLLBACK TO get_case_resources;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1253: IF NOT FND_API.Compatible_API_Call (l_api_version,

1249:
1250: SAVEPOINT get_assign_resources;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call (l_api_version,
1254: p_api_version,
1255: l_api_name,
1256: G_PKG_NAME) THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: IF NOT FND_API.Compatible_API_Call (l_api_version,
1254: p_api_version,
1255: l_api_name,
1256: G_PKG_NAME) THEN
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: END IF;
1259:
1260: -- Check p_init_msg_list
1261: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1261: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: END IF;
1259:
1260: -- Check p_init_msg_list
1261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1262: FND_MSG_PUB.initialize;
1263: END IF;
1264:
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1265: x_return_status := FND_API.G_RET_STS_SUCCESS;

1261: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1262: FND_MSG_PUB.initialize;
1263: END IF;
1264:
1265: x_return_status := FND_API.G_RET_STS_SUCCESS;
1266:
1267: FOR r_person IN c_get_person LOOP
1268: idx := idx + 1;
1269: iex_debug_pub.logmessage ('idx= ' || idx);

Line 1276: IF FND_API.To_Boolean(p_commit) THEN

1272: x_resource_tab(idx).person_id := r_person.employee_id;
1273: End LOOP;
1274:
1275: -- Standard check of p_commit
1276: IF FND_API.To_Boolean(p_commit) THEN
1277: COMMIT WORK;
1278: END IF;
1279:
1280: -- Standard call to get message count and if count is 1, get message info

Line 1286: WHEN FND_API.G_EXC_ERROR THEN

1282:
1283: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1284:
1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287: ROLLBACK TO get_assign_resources;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1290:

Line 1288: x_return_status := FND_API.G_RET_STS_ERROR;

1284:
1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287: ROLLBACK TO get_assign_resources;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: ROLLBACK TO get_assign_resources;

Line 1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1287: ROLLBACK TO get_assign_resources;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: ROLLBACK TO get_assign_resources;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1295:

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1290:
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: ROLLBACK TO get_assign_resources;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO get_assign_resources;

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO get_assign_resources;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1301: END IF;
1302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2164: IF NOT FND_API.Compatible_API_Call (l_api_version,

2160:
2161: SAVEPOINT get_assigned_collector;
2162:
2163: -- Standard call to check for call compatibility.
2164: IF NOT FND_API.Compatible_API_Call (l_api_version,
2165: p_api_version,
2166: l_api_name,
2167: G_PKG_NAME) THEN
2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2164: IF NOT FND_API.Compatible_API_Call (l_api_version,
2165: p_api_version,
2166: l_api_name,
2167: G_PKG_NAME) THEN
2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2169: END IF;
2170:
2171: -- Check p_init_msg_list
2172: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2172: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2169: END IF;
2170:
2171: -- Check p_init_msg_list
2172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2173: FND_MSG_PUB.initialize;
2174: END IF;
2175:
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2176: x_return_status := FND_API.G_RET_STS_SUCCESS;

2172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2173: FND_MSG_PUB.initialize;
2174: END IF;
2175:
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177:
2178: --Start Bug 7134688 gnramasa 17th June 08
2179:
2180: -- Initialize SQL statements - REMEMBER CHANGING 1 MEANS CHANGING ALL

Line 2388: IF FND_API.To_Boolean(p_commit) THEN

2384:
2385: CLOSE c_collector;
2386:
2387: -- Standard check of p_commit
2388: IF FND_API.To_Boolean(p_commit) THEN
2389: COMMIT WORK;
2390: END IF;
2391:
2392: -- Standard call to get message count and if count is 1, get message info

Line 2398: WHEN FND_API.G_EXC_ERROR THEN

2394:
2395: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO get_assigned_collector;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2402:

Line 2400: x_return_status := FND_API.G_RET_STS_ERROR;

2396:
2397: EXCEPTION
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO get_assigned_collector;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2402:
2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2404: ROLLBACK TO get_assigned_collector;

Line 2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2399: ROLLBACK TO get_assigned_collector;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2402:
2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2404: ROLLBACK TO get_assigned_collector;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2407:

Line 2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2402:
2403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2404: ROLLBACK TO get_assigned_collector;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO get_assigned_collector;

Line 2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO get_assigned_collector;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: END IF;
2414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);