DBA Data[Home] [Help]

APPS.AS_SCORECARD_RULES_PUB dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.initialize;

64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list )
67: THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Debug Message
72: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 72: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Debug Message
72: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
73: 'Public API: ' || l_api_name || 'start');
74:
75: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
76: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 75: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

71: -- Debug Message
72: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
73: 'Public API: ' || l_api_name || 'start');
74:
75: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
76: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
77:
78:
79: -- Initialize API return status to SUCCESS

Line 87: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

83: -- API body
84: --
85:
86: -- Calling Private package: Create_SALES_LEADS
87: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
88: 'Public API: Calling AS_SCORECARD_RULES_PVT.Create_Scorecard');
89:
90: AS_SCORECARD_RULES_PVT.Create_ScoreCard(
91: p_api_version => p_api_version

Line 120: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

116: COMMIT WORK;
117: END IF;
118:
119: -- Debug Message
120: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
121: 'PUB: ' || l_api_name || ' end');
122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
123: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124:

Line 122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

118:
119: -- Debug Message
120: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
121: 'PUB: ' || l_api_name || ' end');
122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
123: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124:
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get

Line 126: FND_MSG_PUB.Count_And_Get

122: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
123: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
124:
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130:

Line 136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

132: WHEN FND_API.G_EXC_ERROR THEN
133: as_utility_pvt.HANDLE_EXCEPTIONS(
134: P_API_NAME => L_API_NAME
135: ,P_PKG_NAME => G_PKG_NAME
136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
137: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
138: ,X_MSG_COUNT => X_MSG_COUNT
139: ,X_MSG_DATA => X_MSG_DATA
140: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 146: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: as_utility_pvt.HANDLE_EXCEPTIONS(
144: P_API_NAME => L_API_NAME
145: ,P_PKG_NAME => G_PKG_NAME
146: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
147: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
148: ,X_MSG_COUNT => X_MSG_COUNT
149: ,X_MSG_DATA => X_MSG_DATA
150: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 201: FND_MSG_PUB.initialize;

197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Debug Message
205: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 205: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Debug Message
205: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
206: 'PUB: ' || l_api_name || ' start');
207: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
208: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
209:

Line 207: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

203:
204: -- Debug Message
205: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
206: 'PUB: ' || l_api_name || ' start');
207: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
208: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
209:
210:
211: -- Initialize API return status to SUCCESS

Line 219: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

215: -- Api body
216: --
217:
218: -- Debug Message
219: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
220: 'Public API: Calling AS_SALES_LEADS_PVT.Update_sales_lead');
221:
222: AS_SCORECARD_RULES_PVT.Update_ScoreCard(
223: p_api_version => p_api_version

Line 250: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

246: COMMIT WORK;
247: END IF;
248:
249: -- Debug Message
250: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
251: 'PUB: ' || l_api_name || ' end');
252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
253: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
254:

Line 252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

248:
249: -- Debug Message
250: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
251: 'PUB: ' || l_api_name || ' end');
252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
253: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
254:
255: -- Standard call to get message count and if count is 1, get message info.
256: FND_MSG_PUB.Count_And_Get

Line 256: FND_MSG_PUB.Count_And_Get

252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
253: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
254:
255: -- Standard call to get message count and if count is 1, get message info.
256: FND_MSG_PUB.Count_And_Get
257: ( p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: EXCEPTION

Line 265: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

261: WHEN FND_API.G_EXC_ERROR THEN
262: as_utility_pvt.HANDLE_EXCEPTIONS(
263: P_API_NAME => L_API_NAME
264: ,P_PKG_NAME => G_PKG_NAME
265: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
266: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
267: ,X_MSG_COUNT => X_MSG_COUNT
268: ,X_MSG_DATA => X_MSG_DATA
269: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: as_utility_pvt.HANDLE_EXCEPTIONS(
273: P_API_NAME => L_API_NAME
274: ,P_PKG_NAME => G_PKG_NAME
275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
276: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
277: ,X_MSG_COUNT => X_MSG_COUNT
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 329: FND_MSG_PUB.initialize;

325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Debug Message
333: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 333: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Debug Message
333: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
334: 'PUB:' || l_api_name || 'start');
335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
336: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
337:

Line 335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

331:
332: -- Debug Message
333: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
334: 'PUB:' || l_api_name || 'start');
335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
336: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
337:
338:
339: -- Initialize API return status to SUCCESS

Line 346: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

342: --
343: -- Api body
344: --
345:
346: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
347: 'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_SCORECARD');
348:
349: AS_SCORECARD_RULES_PVT.Delete_ScoreCard(
350: p_api_version => p_api_version

Line 379: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

375: COMMIT WORK;
376: END IF;
377:
378: -- Debug Message
379: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
380: 'PUB: ' || l_api_name || ' end');
381: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
382: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
383:

Line 381: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

377:
378: -- Debug Message
379: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
380: 'PUB: ' || l_api_name || ' end');
381: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
382: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
383:
384: FND_MSG_PUB.Count_And_Get
385: ( p_count => x_msg_count,

Line 384: FND_MSG_PUB.Count_And_Get

380: 'PUB: ' || l_api_name || ' end');
381: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
382: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
383:
384: FND_MSG_PUB.Count_And_Get
385: ( p_count => x_msg_count,
386: p_data => x_msg_data );
387:
388: EXCEPTION

Line 393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

389: WHEN FND_API.G_EXC_ERROR THEN
390: as_utility_pvt.HANDLE_EXCEPTIONS(
391: P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
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);

Line 403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: as_utility_pvt.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
404: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
405: ,X_MSG_COUNT => X_MSG_COUNT
406: ,X_MSG_DATA => X_MSG_DATA
407: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 456: FND_MSG_PUB.initialize;

452:
453: -- Initialize message list if p_init_msg_list is set to TRUE.
454: IF FND_API.to_Boolean( p_init_msg_list )
455: THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:
459: -- Debug Message
460: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 460: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

456: FND_MSG_PUB.initialize;
457: END IF;
458:
459: -- Debug Message
460: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
461: 'PUB: ' || l_api_name || ' start');
462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
463: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
464:

Line 462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

458:
459: -- Debug Message
460: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
461: 'PUB: ' || l_api_name || ' start');
462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
463: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
464:
465:
466: -- Initialize API return status to SUCCESS

Line 474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

470: -- API body
471: --
472:
473: -- Calling Private package: Create_SALES_LEADS
474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
475: 'Public API: Calling AS_SCORECARD_RULES_PVT.Create_CardRule_Qual');
476:
477: AS_SCORECARD_RULES_PVT.Create_CardRule_Qual(
478: p_api_version => p_api_version

Line 506: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

502: COMMIT WORK;
503: END IF;
504:
505: -- Debug Message
506: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
507: 'PUB: ' || l_api_name || ' end');
508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
509: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
510:

Line 508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

504:
505: -- Debug Message
506: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
507: 'PUB: ' || l_api_name || ' end');
508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
509: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
510:
511: -- Standard call to get message count and if count is 1, get message info.
512: FND_MSG_PUB.Count_And_Get

Line 512: FND_MSG_PUB.Count_And_Get

508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
509: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
510:
511: -- Standard call to get message count and if count is 1, get message info.
512: FND_MSG_PUB.Count_And_Get
513: ( p_count => x_msg_count,
514: p_data => x_msg_data
515: );
516:

Line 522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

518: WHEN FND_API.G_EXC_ERROR THEN
519: as_utility_pvt.HANDLE_EXCEPTIONS(
520: P_API_NAME => L_API_NAME
521: ,P_PKG_NAME => G_PKG_NAME
522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
523: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
524: ,X_MSG_COUNT => X_MSG_COUNT
525: ,X_MSG_DATA => X_MSG_DATA
526: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: as_utility_pvt.HANDLE_EXCEPTIONS(
530: P_API_NAME => L_API_NAME
531: ,P_PKG_NAME => G_PKG_NAME
532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
533: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
534: ,X_MSG_COUNT => X_MSG_COUNT
535: ,X_MSG_DATA => X_MSG_DATA
536: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 585: FND_MSG_PUB.initialize;

581:
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )
584: THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: -- Debug Message
589: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 589: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: -- Debug Message
589: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
590: 'PUB: ' || l_api_name || ' start');
591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
592: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
593:

Line 591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

587:
588: -- Debug Message
589: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
590: 'PUB: ' || l_api_name || ' start');
591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
592: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
593:
594:
595: -- Initialize API return status to SUCCESS

Line 603: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

599: -- Api body
600: --
601:
602: -- Debug Message
603: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
604: 'Public API: Calling AS_SCORECARD_RULES_PVT.Update_CardRule_Qual');
605:
606:
607: AS_SCORECARD_RULES_PVT.Update_CardRule_Qual(

Line 635: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

631: COMMIT WORK;
632: END IF;
633:
634: -- Debug Message
635: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
636: 'PUB: ' || l_api_name || ' end');
637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
638: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
639:

Line 637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

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

Line 641: FND_MSG_PUB.Count_And_Get

637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
638: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,
643: p_data => x_msg_data );
644:
645: EXCEPTION

Line 650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 712: FND_MSG_PUB.initialize;

708:
709: -- Initialize message list if p_init_msg_list is set to TRUE.
710: IF FND_API.to_Boolean( p_init_msg_list )
711: THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: -- Debug Message
716: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 716: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: -- Debug Message
716: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
717: 'PUB:' || l_api_name || 'start');
718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
719: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
720:

Line 718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

714:
715: -- Debug Message
716: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
717: 'PUB:' || l_api_name || 'start');
718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
719: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
720:
721:
722: -- Initialize API return status to SUCCESS

Line 729: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

725: --
726: -- Api body
727: --
728:
729: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
730: 'Public API: Calling AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual');
731:
732: AS_SCORECARD_RULES_PVT.Delete_CardRule_Qual(
733: p_api_version => p_api_version

Line 760: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

756: COMMIT WORK;
757: END IF;
758:
759: -- Debug Message
760: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
761: 'PUB: ' || l_api_name || ' end');
762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
763: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
764:

Line 762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

758:
759: -- Debug Message
760: AS_UTILITY_PVT.DEBUG_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
761: 'PUB: ' || l_api_name || ' end');
762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
763: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
764:
765: FND_MSG_PUB.Count_And_Get
766: ( p_count => x_msg_count,

Line 765: FND_MSG_PUB.Count_And_Get

761: 'PUB: ' || l_api_name || ' end');
762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
763: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
764:
765: FND_MSG_PUB.Count_And_Get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data );
768:
769: EXCEPTION

Line 774: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

770: WHEN FND_API.G_EXC_ERROR THEN
771: as_utility_pvt.HANDLE_EXCEPTIONS(
772: P_API_NAME => L_API_NAME
773: ,P_PKG_NAME => G_PKG_NAME
774: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
775: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
776: ,X_MSG_COUNT => X_MSG_COUNT
777: ,X_MSG_DATA => X_MSG_DATA
778: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 784: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: as_utility_pvt.HANDLE_EXCEPTIONS(
782: P_API_NAME => L_API_NAME
783: ,P_PKG_NAME => G_PKG_NAME
784: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
785: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
786: ,X_MSG_COUNT => X_MSG_COUNT
787: ,X_MSG_DATA => X_MSG_DATA
788: ,X_RETURN_STATUS => X_RETURN_STATUS);