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.CSP_RS_CUST_RELATION_PUB dependencies on AS_UTILITY_PVT

Line 164: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

160: END IF;
161:
162:
163: -- Debug Message
164: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
165:
166: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
167:
168: -- Initialize API return status to SUCCESS

Line 166: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

162:
163: -- Debug Message
164: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
165:
166: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
167:
168: -- Initialize API return status to SUCCESS
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:

Line 176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');

172: -- API body
173: --
174:
175: -- Debug Message
176: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');
177:
178: -- Convert the values to ids
179: --
180: Convert_RCR_Values_To_Ids (

Line 220: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

216: END IF;
217:
218:
219: -- Debug Message
220: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
221:
222: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223:
224: -- Standard call to get message count and if count is 1, get message info.

Line 222: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

218:
219: -- Debug Message
220: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
221:
222: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223:
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,

Line 232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

228: );
229:
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
233: P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
236: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 236: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
233: P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
236: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
237: ,X_MSG_COUNT => X_MSG_COUNT
238: ,X_MSG_DATA => X_MSG_DATA
239: ,X_RETURN_STATUS => X_RETURN_STATUS);
240:

Line 242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

238: ,X_MSG_DATA => X_MSG_DATA
239: ,X_RETURN_STATUS => X_RETURN_STATUS);
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
243: P_API_NAME => L_API_NAME
244: ,P_PKG_NAME => G_PKG_NAME
245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
243: P_API_NAME => L_API_NAME
244: ,P_PKG_NAME => G_PKG_NAME
245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
247: ,X_MSG_COUNT => X_MSG_COUNT
248: ,X_MSG_DATA => X_MSG_DATA
249: ,X_RETURN_STATUS => X_RETURN_STATUS);
250:

Line 252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

248: ,X_MSG_DATA => X_MSG_DATA
249: ,X_RETURN_STATUS => X_RETURN_STATUS);
250:
251: WHEN OTHERS THEN
252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
253: P_API_NAME => L_API_NAME
254: ,P_PKG_NAME => G_PKG_NAME
255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
256: ,P_SQLCODE => SQLCODE

Line 255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

251: WHEN OTHERS THEN
252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
253: P_API_NAME => L_API_NAME
254: ,P_PKG_NAME => G_PKG_NAME
255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
256: ,P_SQLCODE => SQLCODE
257: ,P_SQLERRM => SQLERRM
258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
259: ,X_MSG_COUNT => X_MSG_COUNT

Line 258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

254: ,P_PKG_NAME => G_PKG_NAME
255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
256: ,P_SQLCODE => SQLCODE
257: ,P_SQLERRM => SQLERRM
258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
259: ,X_MSG_COUNT => X_MSG_COUNT
260: ,X_MSG_DATA => X_MSG_DATA
261: ,X_RETURN_STATUS => X_RETURN_STATUS);
262: End Create_rs_cust_relation;

Line 303: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

299: END IF;
300:
301:
302: -- Debug Message
303: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
304:
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
306:
307: -- Initialize API return status to SUCCESS

Line 305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

301:
302: -- Debug Message
303: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
304:
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
306:
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:

Line 315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');

311: -- API body
312: --
313:
314: -- Debug Message
315: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');
316:
317: -- Convert the values to ids
318: --
319: Convert_RCR_Values_To_Ids (

Line 356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

352: END IF;
353:
354:
355: -- Debug Message
356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
357:
358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
359:
360: -- Standard call to get message count and if count is 1, get message info.

Line 358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

354:
355: -- Debug Message
356: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
357:
358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count,

Line 368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

364: );
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME
371: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
372: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 372: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME
371: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
372: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
373: ,X_MSG_COUNT => X_MSG_COUNT
374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:

Line 378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
382: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 382: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
382: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:

Line 388: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
387: WHEN OTHERS THEN
388: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
392: ,P_SQLCODE => SQLCODE

Line 391: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

387: WHEN OTHERS THEN
388: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
392: ,P_SQLCODE => SQLCODE
393: ,P_SQLERRM => SQLERRM
394: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
395: ,X_MSG_COUNT => X_MSG_COUNT

Line 394: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
392: ,P_SQLCODE => SQLCODE
393: ,P_SQLERRM => SQLERRM
394: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
395: ,X_MSG_COUNT => X_MSG_COUNT
396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);
398: End Update_rs_cust_relation;

Line 440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

436: END IF;
437:
438:
439: -- Debug Message
440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
441:
442: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
443:
444: -- Initialize API return status to SUCCESS

Line 442: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

438:
439: -- Debug Message
440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
441:
442: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
443:
444: -- Initialize API return status to SUCCESS
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:

Line 452: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');

448: -- API body
449: --
450:
451: -- Debug Message
452: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS: Public API: Convert_RCR_Values_To_Ids');
453:
454: -- Convert the values to ids
455: --
456: Convert_RCR_Values_To_Ids (

Line 492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

488: END IF;
489:
490:
491: -- Debug Message
492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
493:
494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
495:
496: -- Standard call to get message count and if count is 1, get message info.

Line 494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

490:
491: -- Debug Message
492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
493:
494: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
495:
496: -- Standard call to get message count and if count is 1, get message info.
497: FND_MSG_PUB.Count_And_Get
498: ( p_count => x_msg_count,

Line 505: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

501:
502:
503: EXCEPTION
504: WHEN FND_API.G_EXC_ERROR THEN
505: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
506: P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

505: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
506: P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
509: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:

Line 515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_API_NAME => L_API_NAME
517: ,P_PKG_NAME => G_PKG_NAME
518: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_API_NAME => L_API_NAME
517: ,P_PKG_NAME => G_PKG_NAME
518: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
519: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
520: ,X_MSG_COUNT => X_MSG_COUNT
521: ,X_MSG_DATA => X_MSG_DATA
522: ,X_RETURN_STATUS => X_RETURN_STATUS);
523:

Line 525: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

521: ,X_MSG_DATA => X_MSG_DATA
522: ,X_RETURN_STATUS => X_RETURN_STATUS);
523:
524: WHEN OTHERS THEN
525: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
526: P_API_NAME => L_API_NAME
527: ,P_PKG_NAME => G_PKG_NAME
528: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
529: ,P_SQLCODE => SQLCODE

Line 528: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

524: WHEN OTHERS THEN
525: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
526: P_API_NAME => L_API_NAME
527: ,P_PKG_NAME => G_PKG_NAME
528: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
529: ,P_SQLCODE => SQLCODE
530: ,P_SQLERRM => SQLERRM
531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
532: ,X_MSG_COUNT => X_MSG_COUNT

Line 531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

527: ,P_PKG_NAME => G_PKG_NAME
528: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
529: ,P_SQLCODE => SQLCODE
530: ,P_SQLERRM => SQLERRM
531: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
532: ,X_MSG_COUNT => X_MSG_COUNT
533: ,X_MSG_DATA => X_MSG_DATA
534: ,X_RETURN_STATUS => X_RETURN_STATUS);
535: End Delete_rs_cust_relation;

Line 585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');

581: END IF;
582:
583:
584: -- Debug Message
585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
586:
587: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588:
589: -- Initialize API return status to SUCCESS

Line 587: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

583:
584: -- Debug Message
585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'start');
586:
587: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588:
589: -- Initialize API return status to SUCCESS
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:

Line 596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: - Calling PVT.Get_RS_CUST_RELATION');

592: --
593: -- API body
594: --
595: -- Debug Message
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: - Calling PVT.Get_RS_CUST_RELATION');
597: /*
598: CSP_rs_cust_relation_PVT.Get_rs_cust_relation(
599: P_Api_Version_Number => 2.0,
600: P_Init_Msg_List => FND_API.G_FALSE,

Line 634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

630: -- End of API body
631: --
632:
633: -- Debug Message
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
635:
636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
637:
638: -- Standard call to get message count and if count is 1, get message info.

Line 636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

632:
633: -- Debug Message
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
635:
636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get
640: ( p_count => x_msg_count,

Line 646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

642: );
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
647: P_API_NAME => L_API_NAME
648: ,P_PKG_NAME => G_PKG_NAME
649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
647: P_API_NAME => L_API_NAME
648: ,P_PKG_NAME => G_PKG_NAME
649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
651: ,X_MSG_COUNT => X_MSG_COUNT
652: ,X_MSG_DATA => X_MSG_DATA
653: ,X_RETURN_STATUS => X_RETURN_STATUS);
654:

Line 656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

652: ,X_MSG_DATA => X_MSG_DATA
653: ,X_RETURN_STATUS => X_RETURN_STATUS);
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
657: P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

Line 660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
657: P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
660: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
661: ,X_MSG_COUNT => X_MSG_COUNT
662: ,X_MSG_DATA => X_MSG_DATA
663: ,X_RETURN_STATUS => X_RETURN_STATUS);
664:

Line 666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

662: ,X_MSG_DATA => X_MSG_DATA
663: ,X_RETURN_STATUS => X_RETURN_STATUS);
664:
665: WHEN OTHERS THEN
666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_API_NAME => L_API_NAME
668: ,P_PKG_NAME => G_PKG_NAME
669: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
670: ,P_SQLCODE => SQLCODE

Line 669: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

665: WHEN OTHERS THEN
666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_API_NAME => L_API_NAME
668: ,P_PKG_NAME => G_PKG_NAME
669: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
670: ,P_SQLCODE => SQLCODE
671: ,P_SQLERRM => SQLERRM
672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
673: ,X_MSG_COUNT => X_MSG_COUNT

Line 672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

668: ,P_PKG_NAME => G_PKG_NAME
669: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
670: ,P_SQLCODE => SQLCODE
671: ,P_SQLERRM => SQLERRM
672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
673: ,X_MSG_COUNT => X_MSG_COUNT
674: ,X_MSG_DATA => X_MSG_DATA
675: ,X_RETURN_STATUS => X_RETURN_STATUS);
676: End Get_rs_cust_relation;