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_LEAD_ROUTING_WF dependencies on FND_MSG_PUB

Line 87: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

83: |
84: | PUBLIC ROUTINES
85: |
86: *-------------------------------------------------------------------------*/
87: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
88: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
89: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
90: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
91:

Line 88: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

84: | PUBLIC ROUTINES
85: |
86: *-------------------------------------------------------------------------*/
87: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
88: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
89: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
90: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
91:
92: PROCEDURE StartProcess(

Line 89: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

85: |
86: *-------------------------------------------------------------------------*/
87: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
88: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
89: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
90: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
91:
92: PROCEDURE StartProcess(
93: p_sales_lead_id IN NUMBER,

Line 90: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

86: *-------------------------------------------------------------------------*/
87: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
88: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
89: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
90: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
91:
92: PROCEDURE StartProcess(
93: p_sales_lead_id IN NUMBER,
94: p_salesgroup_id IN NUMBER,

Line 179: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

175: status => l_status,
176: result => l_result);
177:
178: IF (AS_DEBUG_LOW_ON) THEN
179: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
180: 'After ItemStatus:' || l_result);
181: END IF;
182:
183: x_item_type := Item_Type;

Line 295: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

291: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
292: IF l_rs_id IS NULL
293: THEN
294: IF (AS_DEBUG_LOW_ON) THEN
295: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
296: 'profile not set');
297: END IF;
298: -- Profile is not set. hence going against the logged in user
299:

Line 305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

301: FETCH C_get_current_resource INTO l_rs_id;
302: IF (C_get_current_resource%NOTFOUND)
303: THEN
304: IF (AS_DEBUG_LOW_ON) THEN
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
306: 'No resource found for login user!');
307: END IF;
308: CLOSE C_get_current_resource;
309: RETURN;

Line 316: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

312:
313: IF l_rs_id IS NOT NULL
314: THEN
315: IF (AS_DEBUG_LOW_ON) THEN
316: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
317: 'User''s resource id is:' || l_rs_id);
318: END IF;
319: IF g_user_group_id = fnd_api.g_miss_num
320: THEN

Line 333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

329: OPEN c_get_person_id (l_rs_id);
330: FETCH c_get_person_id INTO g_person_id_tbl(1);
331: CLOSE c_get_person_id;
332: IF (AS_DEBUG_LOW_ON) THEN
333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
334: 'Users group id is:' || g_group_id_tbl(1));
335: END IF;
336: g_resource_id_tbl(1) := l_rs_id;
337: g_resource_flag_tbl(1) := 'L';

Line 342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

338: END IF;
339:
340: ELSE -- profile resource id is not null
341: IF (AS_DEBUG_LOW_ON) THEN
342: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
343: 'Profile resource id :'|| l_rs_id);
344: END IF;
345: g_group_id_tbl(1) := NULL;
346: OPEN c_get_group_id (l_rs_id);

Line 353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

349: OPEN c_get_person_id (l_rs_id);
350: FETCH c_get_person_id INTO g_person_id_tbl(1);
351: CLOSE c_get_person_id;
352: IF (AS_DEBUG_LOW_ON) THEN
353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
354: 'Profile group id :' || g_group_id_tbl(1));
355: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
356: 'Profile person id :' || g_person_id_tbl(1));
357: END IF;

Line 355: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

351: CLOSE c_get_person_id;
352: IF (AS_DEBUG_LOW_ON) THEN
353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
354: 'Profile group id :' || g_group_id_tbl(1));
355: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
356: 'Profile person id :' || g_person_id_tbl(1));
357: END IF;
358: g_resource_id_tbl(1) := l_rs_id;
359: g_resource_flag_tbl(1) := 'D';

Line 368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

364: THEN
365: CLOSE C_get_current_resource;
366: -- result := 'COMPLETE:ERROR';
367: IF (AS_DEBUG_LOW_ON) THEN
368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
369: 'No resource found!');
370: END IF;
371: RETURN;
372: END IF;

Line 379: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

375: IF l_rs_id IS NOT NULL AND
376: l_rs_id <> g_resource_id_tbl(1)
377: THEN
378: IF (AS_DEBUG_LOW_ON) THEN
379: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
380: 'User''s resource id is:' || l_rs_id);
381: END IF;
382: IF g_user_group_id = fnd_api.g_miss_num
383: THEN

Line 396: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

392: OPEN c_get_person_id (l_rs_id);
393: FETCH c_get_person_id INTO g_person_id_tbl(2);
394: CLOSE c_get_person_id;
395: IF (AS_DEBUG_LOW_ON) THEN
396: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
397: 'Users group id is:' || g_group_id_tbl(2));
398: END IF;
399: g_resource_id_tbl(2) := l_rs_id;
400: g_resource_flag_tbl(2) := 'L';

Line 451: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

447: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))
448: ORDER BY ACC.ACCESS_ID;
449: BEGIN
450: IF (AS_DEBUG_LOW_ON) THEN
451: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
452: 'GetAvailableResource: Start');
453: END IF;
454:
455: IF funcmode = 'RUN'

Line 463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

459: itemkey => itemkey,
460: aname => 'SALES_LEAD_ID');
461:
462: IF (AS_DEBUG_LOW_ON) THEN
463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
464: 'sl_id:' || l_sales_lead_id);
465: END IF;
466:
467: -- Get sales team for the sales lead

Line 477: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

473:
474: l_check_calendar :=
475: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
476: IF (AS_DEBUG_LOW_ON) THEN
477: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
478: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
479: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
480: 'Check calendar?' || l_check_calendar);
481: END IF;

Line 479: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

475: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
476: IF (AS_DEBUG_LOW_ON) THEN
477: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
478: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
479: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
480: 'Check calendar?' || l_check_calendar);
481: END IF;
482:
483: g_resource_id_tbl.delete;

Line 493: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

489: WHILE l_index1 <= l_last
490: LOOP
491: IF (AS_DEBUG_LOW_ON) THEN
492: AS_UTILITY_PVT.Debug_Message(
493: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
494: 'Check resource ' || l_resource_id_tbl(l_index1));
495: END IF;
496: -- Check the calendar for resource availability
497: -- Call Calendar API

Line 519: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

515: THEN
516: -- Unexpected Execution Error from call to Calendar
517: IF (AS_DEBUG_LOW_ON) THEN
518: AS_UTILITY_PVT.Debug_Message(
519: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
520: 'JTF Calendar failed');
521: END IF;
522: -- RAISE fnd_api.g_exc_unexpected_error;
523: END IF;

Line 527: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

523: END IF;
524:
525: IF (AS_DEBUG_LOW_ON) THEN
526: AS_UTILITY_PVT.Debug_Message(
527: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
528: 'l_shift_construct_id=' || l_shift_construct_id);
529: END IF;
530: IF l_shift_construct_id IS NOT NULL
531: THEN

Line 550: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

546: g_resource_flag_tbl := l_resource_flag_tbl;
547: END IF; -- l_check_calendar = 'Y' AND l_last > 0
548:
549: IF (AS_DEBUG_LOW_ON) THEN
550: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
551: 'g_resource_id_tbl.count=' || g_resource_id_tbl.count);
552: END IF;
553: result := 'COMPLETE:S';
554: END IF; -- function mode check

Line 556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

552: END IF;
553: result := 'COMPLETE:S';
554: END IF; -- function mode check
555: IF (AS_DEBUG_LOW_ON) THEN
556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
557: 'GetAvailableResource: End');
558: END IF;
559:
560: EXCEPTION

Line 563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF (AS_DEBUG_LOW_ON) THEN
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
564: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
565: END IF;
566: wf_core.context(
567: itemtype,

Line 638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

634: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
635: AND ACC.CREATED_BY_TAP_FLAG = 'Y';
636: BEGIN
637: IF (AS_DEBUG_LOW_ON) THEN
638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
639: 'GetOwner: Start');
640: END IF;
641:
642: IF funcmode = 'RUN'

Line 650: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

646: itemkey => itemkey,
647: aname => 'SALES_LEAD_ID');
648:
649: IF (AS_DEBUG_LOW_ON) THEN
650: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
651: 'sl_id:' || l_sales_lead_id);
652: END IF;
653:
654: IF g_resource_id_tbl.count = 0

Line 666: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

662: -- USER HOOK standard : customer pre-processing section - mandatory
663: IF l_call_user_hook
664: THEN
665: IF (AS_DEBUG_LOW_ON) THEN
666: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
667: 'Call user_hook is true');
668: END IF;
669: OPEN c_get_sales_lead(l_sales_lead_id);
670: FETCH c_get_sales_lead INTO

Line 742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

738: l_sales_lead_rec.LEAD_RANK_IND,
739: l_sales_lead_rec.CURRENT_REROUTES;
740: CLOSE c_get_sales_lead;
741: IF (AS_DEBUG_LOW_ON) THEN
742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
743: 'desc:' || l_sales_lead_rec.description);
744: END IF;
745:
746: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(

Line 777: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

773: IF NOT l_call_user_hook
774: THEN
775: IF (AS_DEBUG_LOW_ON) THEN
776: AS_UTILITY_PVT.Debug_Message(
777: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
778: 'There''s no customer user hook');
779: END IF;
780: ELSE
781: IF (AS_DEBUG_LOW_ON) THEN

Line 783: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

779: END IF;
780: ELSE
781: IF (AS_DEBUG_LOW_ON) THEN
782: AS_UTILITY_PVT.Debug_Message(
783: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
784: 'User hook doesn''t return resource');
785: END IF;
786: END IF;
787:

Line 810: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

806: FETCH c_get_resource_avail INTO l_resource_avail_flag;
807: CLOSE c_get_resource_avail;
808: IF (AS_DEBUG_LOW_ON) THEN
809: AS_UTILITY_PVT.Debug_Message(
810: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
811: 'res avail?' || l_resource_avail_flag);
812: END IF;
813:
814: IF l_resource_avail_flag = 'Y'

Line 819: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

815: THEN
816: -- There are resources available, but they were previous
817: -- lead owners.
818: AS_UTILITY_PVT.Set_Message(
819: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
820: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
821: ELSE
822: AS_UTILITY_PVT.Set_Message(
823: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 823: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

819: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
820: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
821: ELSE
822: AS_UTILITY_PVT.Set_Message(
823: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
824: p_msg_name => 'AS_WARN_USING_DEF_RESOURCE_ID');
825: END IF;
826: ELSIF g_resource_flag_tbl(1) = 'L'
827: THEN

Line 837: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

833: aname => 'DEFAULT_RESOURCE_ID',
834: avalue => l_resource_id);
835:
836: AS_UTILITY_PVT.Set_Message(
837: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
838: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
839: END IF;
840: END IF;
841: IF (AS_DEBUG_LOW_ON) THEN

Line 842: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

838: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
839: END IF;
840: END IF;
841: IF (AS_DEBUG_LOW_ON) THEN
842: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
843: 'Set owner rs_id=' || l_resource_id);
844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
845: ' group_id=' || l_group_id);
846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

840: END IF;
841: IF (AS_DEBUG_LOW_ON) THEN
842: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
843: 'Set owner rs_id=' || l_resource_id);
844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
845: ' group_id=' || l_group_id);
846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
847: ' person_id=' || l_person_id);
848: END IF;

Line 846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

842: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
843: 'Set owner rs_id=' || l_resource_id);
844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
845: ' group_id=' || l_group_id);
846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
847: ' person_id=' || l_person_id);
848: END IF;
849: SetResource( itemtype, itemkey, l_resource_id, l_group_id, l_person_id);
850: result := 'COMPLETE:S';

Line 854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

850: result := 'COMPLETE:S';
851: END IF; -- funcmode = 'RUN'
852:
853: IF (AS_DEBUG_LOW_ON) THEN
854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
855: 'GetOwner: End');
856: END IF;
857: EXCEPTION
858: WHEN OTHERS THEN

Line 860: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

856: END IF;
857: EXCEPTION
858: WHEN OTHERS THEN
859: IF (AS_DEBUG_LOW_ON) THEN
860: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
861: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
862: END IF;
863: wf_core.context(
864: itemtype,

Line 923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

919: AND sl.status_code = sta.status_code
920: AND sl.lead_rank_id = rk.rank_id(+);
921: BEGIN
922: IF (AS_DEBUG_LOW_ON) THEN
923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
924: 'UpdateSalesLeads: Start');
925: END IF;
926: IF funcmode = 'RUN'
927: THEN

Line 949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

945: itemkey => itemkey,
946: aname => 'PERSON_ID' );
947:
948: IF (AS_DEBUG_LOW_ON) THEN
949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
950: 'res id in upd=' || l_Resource_Id);
951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
952: 'group id in upd='||l_group_id);
953: END IF;

Line 951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

947:
948: IF (AS_DEBUG_LOW_ON) THEN
949: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
950: 'res id in upd=' || l_Resource_Id);
951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
952: 'group id in upd='||l_group_id);
953: END IF;
954:
955: OPEN c_sales_lead(l_sales_lead_id);

Line 1141: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1137:
1138: result := 'COMPLETE:S';
1139: END IF; -- funcmode = 'RUN'
1140: IF (AS_DEBUG_LOW_ON) THEN
1141: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1142: 'UpdateSalesLeads: End');
1143: END IF;
1144:
1145: EXCEPTION

Line 1217: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1213:
1214: IF l_Assign_Id_tbl.count = 0 THEN
1215: result := 'COMPLETE:NORES';
1216: IF (AS_DEBUG_ERROR_ON) THEN
1217: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1218: 'JTF AM - No resource found!');
1219: END IF;
1220: return;
1221: ELSE