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

Line 68: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');

64: END IF;
65:
66: -- Debug Message
67: IF l_debug THEN
68: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
69: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
70: END IF;
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 69: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

65:
66: -- Debug Message
67: IF l_debug THEN
68: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
69: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
70: END IF;
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:

Line 80: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Get_Potential_Opportunity');

76: --
77:
78: -- Calling private API
79: IF l_debug THEN
80: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Get_Potential_Opportunity');
81: END IF;
82:
83: AS_SALES_LEAD_OPP_PVT.Get_Potential_Opportunity(
84: P_Api_Version_Number => 2.0,

Line 118: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');

114: END IF;
115:
116: -- Debug Message
117: IF l_debug THEN
118: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
119: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.

Line 119: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

115:
116: -- Debug Message
117: IF l_debug THEN
118: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
119: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.
123: FND_MSG_PUB.Count_And_Get

Line 130: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

126: );
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_MODULE => l_module
132: ,P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 135: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

131: P_MODULE => l_module
132: ,P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
135: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:

Line 141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_MODULE => l_module
143: ,P_API_NAME => L_API_NAME
144: ,P_PKG_NAME => G_PKG_NAME
145: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 146: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

142: P_MODULE => l_module
143: ,P_API_NAME => L_API_NAME
144: ,P_PKG_NAME => G_PKG_NAME
145: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
146: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
147: ,X_MSG_COUNT => X_MSG_COUNT
148: ,X_MSG_DATA => X_MSG_DATA
149: ,X_RETURN_STATUS => X_RETURN_STATUS);
150:

Line 152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

148: ,X_MSG_DATA => X_MSG_DATA
149: ,X_RETURN_STATUS => X_RETURN_STATUS);
150:
151: WHEN OTHERS THEN
152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
153: P_MODULE => l_module
154: ,P_API_NAME => L_API_NAME
155: ,P_PKG_NAME => G_PKG_NAME
156: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 156: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
153: P_MODULE => l_module
154: ,P_API_NAME => L_API_NAME
155: ,P_PKG_NAME => G_PKG_NAME
156: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
157: ,P_SQLCODE => SQLCODE
158: ,P_SQLERRM => SQLERRM
159: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
160: ,X_MSG_COUNT => X_MSG_COUNT

Line 159: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

155: ,P_PKG_NAME => G_PKG_NAME
156: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
157: ,P_SQLCODE => SQLCODE
158: ,P_SQLERRM => SQLERRM
159: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:

Line 221: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');

217: END IF;
218:
219: -- Debug Message
220: IF l_debug THEN
221: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
222: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223: END IF;
224: -- Initialize API return status to SUCCESS
225: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

218:
219: -- Debug Message
220: IF l_debug THEN
221: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
222: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
223: END IF;
224: -- Initialize API return status to SUCCESS
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226:

Line 236: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');

232: 'B','C');
233:
234: IF l_call_pre_uhk THEN
235: IF l_debug THEN
236: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
237: END IF;
238: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Pre (
239: p_api_version_number => 2.0,
240: p_init_msg_list => FND_API.G_FALSE,

Line 261: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Copy_Lead_To_Opportunity');

257: -- API body
258: --
259: -- Calling private API
260: IF l_debug THEN
261: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Copy_Lead_To_Opportunity');
262: END IF;
263: AS_SALES_LEAD_OPP_PVT.Copy_Lead_To_Opportunity(
264: P_Api_Version_Number => 2.0,
265: P_Init_Msg_List => FND_API.G_FALSE,

Line 301: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');

297: 'A','C');
298:
299: IF l_call_post_uhk THEN
300: IF l_debug THEN
301: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
302: END IF;
303: AS_LINK_LEAD_OPP_UHK.Copy_Lead_To_Opp_Post (
304: p_api_version_number => 2.0,
305: p_init_msg_list => FND_API.G_FALSE,

Line 328: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');

324: END IF;
325:
326: -- Debug Message
327: IF l_debug THEN
328: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
329: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
330: END IF;
331:
332: -- Standard call to get message count and if count is 1, get message info.

Line 329: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

325:
326: -- Debug Message
327: IF l_debug THEN
328: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
329: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
330: END IF;
331:
332: -- Standard call to get message count and if count is 1, get message info.
333: FND_MSG_PUB.Count_And_Get

Line 340: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

336: );
337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
341: P_MODULE => l_module
342: ,P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 345: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

341: P_MODULE => l_module
342: ,P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
345: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349:

Line 351: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
352: P_MODULE => l_module
353: ,P_API_NAME => L_API_NAME
354: ,P_PKG_NAME => G_PKG_NAME
355: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 356: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

352: P_MODULE => l_module
353: ,P_API_NAME => L_API_NAME
354: ,P_PKG_NAME => G_PKG_NAME
355: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
356: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
357: ,X_MSG_COUNT => X_MSG_COUNT
358: ,X_MSG_DATA => X_MSG_DATA
359: ,X_RETURN_STATUS => X_RETURN_STATUS);
360:

Line 362: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

358: ,X_MSG_DATA => X_MSG_DATA
359: ,X_RETURN_STATUS => X_RETURN_STATUS);
360:
361: WHEN OTHERS THEN
362: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
363: P_MODULE => l_module
364: ,P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 366: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

362: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
363: P_MODULE => l_module
364: ,P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
367: ,P_SQLCODE => SQLCODE
368: ,P_SQLERRM => SQLERRM
369: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
370: ,X_MSG_COUNT => X_MSG_COUNT

Line 369: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
367: ,P_SQLCODE => SQLCODE
368: ,P_SQLERRM => SQLERRM
369: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
370: ,X_MSG_COUNT => X_MSG_COUNT
371: ,X_MSG_DATA => X_MSG_DATA
372: ,X_RETURN_STATUS => X_RETURN_STATUS);
373: End Copy_Lead_To_Opportunity;

Line 429: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');

425: END IF;
426:
427: -- Debug Message
428: IF l_debug THEN
429: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
431: END IF;
432: -- Initialize API return status to SUCCESS
433: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

426:
427: -- Debug Message
428: IF l_debug THEN
429: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
431: END IF;
432: -- Initialize API return status to SUCCESS
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:

Line 444: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');

440: 'B','C');
441:
442: IF l_call_pre_uhk THEN
443: IF l_debug THEN
444: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
445: END IF;
446: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Pre (
447: p_api_version_number => 2.0,
448: p_init_msg_list => FND_API.G_FALSE,

Line 469: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Link_Lead_To_Opportunity');

465: -- API body
466: --
467: -- Calling private API
468: IF l_debug THEN
469: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Call PVT.Link_Lead_To_Opportunity');
470: END IF;
471: AS_SALES_LEAD_OPP_PVT.Link_Lead_To_Opportunity(
472: P_Api_Version_Number => 2.0,
473: P_Init_Msg_List => FND_API.G_FALSE,

Line 504: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');

500: 'A','C');
501:
502: IF l_call_post_uhk THEN
503: IF l_debug THEN
504: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
505: END IF;
506: AS_LINK_LEAD_OPP_UHK.Link_Lead_To_Opp_Post (
507: p_api_version_number => 2.0,
508: p_init_msg_list => FND_API.G_FALSE,

Line 534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');

530: END IF;
531:
532: -- Debug Message
533: IF l_debug THEN
534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
535: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
536: END IF;
537:
538: -- Standard call to get message count and if count is 1, get message info.

Line 535: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

531:
532: -- Debug Message
533: IF l_debug THEN
534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
535: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
536: END IF;
537:
538: -- Standard call to get message count and if count is 1, get message info.
539: FND_MSG_PUB.Count_And_Get

Line 546: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

542: );
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_MODULE => l_module
548: ,P_API_NAME => L_API_NAME
549: ,P_PKG_NAME => G_PKG_NAME
550: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 551: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

547: P_MODULE => l_module
548: ,P_API_NAME => L_API_NAME
549: ,P_PKG_NAME => G_PKG_NAME
550: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
551: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
552: ,X_MSG_COUNT => X_MSG_COUNT
553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);
555:

Line 557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);
555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_MODULE => l_module
559: ,P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 562: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

558: P_MODULE => l_module
559: ,P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
562: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
563: ,X_MSG_COUNT => X_MSG_COUNT
564: ,X_MSG_DATA => X_MSG_DATA
565: ,X_RETURN_STATUS => X_RETURN_STATUS);
566:

Line 568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

564: ,X_MSG_DATA => X_MSG_DATA
565: ,X_RETURN_STATUS => X_RETURN_STATUS);
566:
567: WHEN OTHERS THEN
568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
569: P_MODULE => l_module
570: ,P_API_NAME => L_API_NAME
571: ,P_PKG_NAME => G_PKG_NAME
572: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 572: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
569: P_MODULE => l_module
570: ,P_API_NAME => L_API_NAME
571: ,P_PKG_NAME => G_PKG_NAME
572: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
573: ,P_SQLCODE => SQLCODE
574: ,P_SQLERRM => SQLERRM
575: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
576: ,X_MSG_COUNT => X_MSG_COUNT

Line 575: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

571: ,P_PKG_NAME => G_PKG_NAME
572: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
573: ,P_SQLCODE => SQLCODE
574: ,P_SQLERRM => SQLERRM
575: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
576: ,X_MSG_COUNT => X_MSG_COUNT
577: ,X_MSG_DATA => X_MSG_DATA
578: ,X_RETURN_STATUS => X_RETURN_STATUS);
579: End Link_Lead_To_Opportunity;

Line 646: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');

642: END IF;
643:
644: -- Debug Message
645: IF l_debug THEN
646: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
647: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648: END IF;
649:
650: -- Initialize API return status to SUCCESS

Line 647: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

643:
644: -- Debug Message
645: IF l_debug THEN
646: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' Start');
647: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648: END IF;
649:
650: -- Initialize API return status to SUCCESS
651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 662: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');

658: 'B','C');
659:
660: IF l_call_pre_uhk THEN
661: IF l_debug THEN
662: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call pre user hook is true');
663: END IF;
664: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Pre (
665: p_api_version_number => 2.0,
666: p_init_msg_list => FND_API.G_FALSE,

Line 687: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Calling PVT.Create_Opportunity_For_Lead');

683: -- API body
684: --
685: -- Calling private API
686: IF l_debug THEN
687: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PUB: Calling PVT.Create_Opportunity_For_Lead');
688: END IF;
689:
690: AS_SALES_LEAD_OPP_PVT.Create_Opportunity_For_Lead(
691: P_Api_Version_Number => 2.0,

Line 725: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');

721: 'A','C');
722:
723: IF l_call_post_uhk THEN
724: IF l_debug THEN
725: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Call post user hook is true');
726: END IF;
727: AS_LINK_LEAD_OPP_UHK.Create_Opp_For_Lead_Post (
728: p_api_version_number => 2.0,
729: p_init_msg_list => FND_API.G_FALSE,

Line 754: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');

750: END IF;
751:
752: -- Debug Message
753: IF l_debug THEN
754: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
755: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
757: -- Standard call to get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get

Line 755: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

751:
752: -- Debug Message
753: IF l_debug THEN
754: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Pub: ' || l_api_name || ' End');
755: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
757: -- Standard call to get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get
759: ( p_count => x_msg_count,

Line 764: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

760: p_data => x_msg_data
761: );
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN
764: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
765: P_MODULE => l_module
766: ,P_API_NAME => L_API_NAME
767: ,P_PKG_NAME => G_PKG_NAME
768: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 769: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

765: P_MODULE => l_module
766: ,P_API_NAME => L_API_NAME
767: ,P_PKG_NAME => G_PKG_NAME
768: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
769: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
770: ,X_MSG_COUNT => X_MSG_COUNT
771: ,X_MSG_DATA => X_MSG_DATA
772: ,X_RETURN_STATUS => X_RETURN_STATUS);
773:

Line 775: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

771: ,X_MSG_DATA => X_MSG_DATA
772: ,X_RETURN_STATUS => X_RETURN_STATUS);
773:
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
776: P_MODULE => l_module
777: ,P_API_NAME => L_API_NAME
778: ,P_PKG_NAME => G_PKG_NAME
779: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 780: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

776: P_MODULE => l_module
777: ,P_API_NAME => L_API_NAME
778: ,P_PKG_NAME => G_PKG_NAME
779: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
780: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
781: ,X_MSG_COUNT => X_MSG_COUNT
782: ,X_MSG_DATA => X_MSG_DATA
783: ,X_RETURN_STATUS => X_RETURN_STATUS);
784:

Line 786: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

782: ,X_MSG_DATA => X_MSG_DATA
783: ,X_RETURN_STATUS => X_RETURN_STATUS);
784:
785: WHEN OTHERS THEN
786: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
787: P_MODULE => l_module
788: ,P_API_NAME => L_API_NAME
789: ,P_PKG_NAME => G_PKG_NAME
790: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 790: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

786: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
787: P_MODULE => l_module
788: ,P_API_NAME => L_API_NAME
789: ,P_PKG_NAME => G_PKG_NAME
790: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
791: ,P_SQLCODE => SQLCODE
792: ,P_SQLERRM => SQLERRM
793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
794: ,X_MSG_COUNT => X_MSG_COUNT

Line 793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB

789: ,P_PKG_NAME => G_PKG_NAME
790: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
791: ,P_SQLCODE => SQLCODE
792: ,P_SQLERRM => SQLERRM
793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
794: ,X_MSG_COUNT => X_MSG_COUNT
795: ,X_MSG_DATA => X_MSG_DATA
796: ,X_RETURN_STATUS => X_RETURN_STATUS);
797: End Create_Opportunity_For_Lead;