DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_UTILITY_PVT

Line 195: AMS_Utility_PVT.Create_Log (

191: aname => 'AMS_TRIGGER_ID');
192: l_obj_type := 'TRIG';
193: END IF;
194:
195: AMS_Utility_PVT.Create_Log (
196: x_return_status => l_return_status,
197: p_arc_log_used_by => l_obj_type,
198: p_log_used_by_id => l_trigger_id,
199: p_msg_data => 'Error msgs from handle_err for attribute '||p_attr_name,

Line 203: AMS_Utility_PVT.Create_Log (

199: p_msg_data => 'Error msgs from handle_err for attribute '||p_attr_name,
200: p_msg_type => 'DEBUG'
201: );
202:
203: AMS_Utility_PVT.Create_Log (
204: x_return_status => l_return_status,
205: p_arc_log_used_by => l_obj_type,
206: p_log_used_by_id => l_trigger_id,
207: p_msg_data => 'Total messages '||p_msg_count,

Line 220: AMS_Utility_PVT.Create_Log (

216: p_msg_index_out => l_msg_index ) ;
217: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);
218: l_cnt := l_cnt + 1 ;
219:
220: AMS_Utility_PVT.Create_Log (
221: x_return_status => l_return_status,
222: p_arc_log_used_by => l_obj_type,
223: p_log_used_by_id => l_trigger_id,
224: p_msg_data => l_msg_index||': '||l_msg_data ,

Line 323: Ams_Utility_pvt.debug_message('Start');

319: -- If workflowprocess is NOT passed, the selector function
320: -- defined in the item type will determine which process to run.
321: IF (AMS_DEBUG_HIGH_ON) THEN
322:
323: Ams_Utility_pvt.debug_message('Start');
324: END IF;
325: IF (AMS_DEBUG_HIGH_ON) THEN
326:
327: Ams_Utility_pvt.debug_message('Item Type : ' || itemtype);

Line 327: Ams_Utility_pvt.debug_message('Item Type : ' || itemtype);

323: Ams_Utility_pvt.debug_message('Start');
324: END IF;
325: IF (AMS_DEBUG_HIGH_ON) THEN
326:
327: Ams_Utility_pvt.debug_message('Item Type : ' || itemtype);
328: END IF;
329: IF (AMS_DEBUG_HIGH_ON) THEN
330:
331: Ams_Utility_pvt.debug_message('Item key : ' || itemkey);

Line 331: Ams_Utility_pvt.debug_message('Item key : ' || itemkey);

327: Ams_Utility_pvt.debug_message('Item Type : ' || itemtype);
328: END IF;
329: IF (AMS_DEBUG_HIGH_ON) THEN
330:
331: Ams_Utility_pvt.debug_message('Item key : ' || itemkey);
332: END IF;
333:
334: -- dbms_output.put_line('Creating process');
335: WF_ENGINE.CreateProcess (itemtype => 'AMS_TRIG', --itemtype,

Line 358: Ams_Utility_pvt.debug_message('After create desc wf_itemsItem key : ' || itemkey);

354: itemkey => itemkey ,
355: aname => 'AMS_TRIGGER_NAME');
356:
357: IF (AMS_DEBUG_HIGH_ON) THEN
358: Ams_Utility_pvt.debug_message('After create desc wf_itemsItem key : ' || itemkey);
359:
360: END IF;
361:
362: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

Line 724: AMS_Utility_PVT.Convert_Timezone(

720: END IF;
721:
722: -- The calls added to calculate the time in User's timezone
723:
724: AMS_Utility_PVT.Convert_Timezone(
725: p_init_msg_list => FND_API.G_FALSE,
726: x_return_status => l_return_status,
727: x_msg_count => l_msg_count,
728: x_msg_data => l_msg_data,

Line 750: AMS_Utility_PVT.Convert_Timezone(

746: result := 'COMPLETE:ERROR' ;
747: RETURN;
748: END IF;
749:
750: AMS_Utility_PVT.Convert_Timezone(
751: p_init_msg_list => FND_API.G_FALSE,
752: x_return_status => l_return_status,
753: x_msg_count => l_msg_count,
754: x_msg_data => l_msg_data,

Line 1489: AMS_Utility_PVT.Create_Log (

1485: itemtype => itemtype,
1486: itemkey => itemkey ,
1487: aname => 'AMS_SCHEDULE_ID');
1488:
1489: AMS_Utility_PVT.Create_Log (
1490: x_return_status => l_log_return_status,
1491: p_arc_log_used_by => 'CSCH',
1492: p_log_used_by_id => l_sch_id,
1493: p_msg_data => 'Activate Schedule through triggers: schedule id is '||l_sch_id,

Line 1503: AMS_Utility_PVT.Create_Log (

1499: OPEN c_det_tgrp_name(l_sch_id);
1500: FETCH c_det_tgrp_name INTO l_tgrp_name;
1501: CLOSE c_det_tgrp_name;
1502:
1503: AMS_Utility_PVT.Create_Log (
1504: x_return_status => l_log_return_status,
1505: p_arc_log_used_by => 'CSCH',
1506: p_log_used_by_id => l_sch_id,
1507: p_msg_data => 'Target group name is '||l_tgrp_name,

Line 1511: AMS_Utility_PVT.Create_Log (

1507: p_msg_data => 'Target group name is '||l_tgrp_name,
1508: p_msg_type => 'DEBUG'
1509: );
1510:
1511: AMS_Utility_PVT.Create_Log (
1512: x_return_status => l_log_return_status,
1513: p_arc_log_used_by => 'CSCH',
1514: p_log_used_by_id => l_sch_id,
1515: p_msg_data => 'Item type is '||itemtype,

Line 1525: Ams_Utility_pvt.debug_message('Before generating tgrp');

1521: aname => 'AMS_NEW_LIST_NAME',
1522: avalue => l_tgrp_name);
1523: IF (l_tgrp_name is not NULL) THEN
1524:
1525: Ams_Utility_pvt.debug_message('Before generating tgrp');
1526: AMS_Utility_PVT.Create_Log (
1527: x_return_status => l_log_return_status,
1528: p_arc_log_used_by => 'CSCH',
1529: p_log_used_by_id => l_sch_id,

Line 1526: AMS_Utility_PVT.Create_Log (

1522: avalue => l_tgrp_name);
1523: IF (l_tgrp_name is not NULL) THEN
1524:
1525: Ams_Utility_pvt.debug_message('Before generating tgrp');
1526: AMS_Utility_PVT.Create_Log (
1527: x_return_status => l_log_return_status,
1528: p_arc_log_used_by => 'CSCH',
1529: p_log_used_by_id => l_sch_id,
1530: p_msg_data => 'Before generating tgrp ' || itemkey ,

Line 1533: Ams_Utility_pvt.debug_message('Schedule id: '||l_sch_id);

1529: p_log_used_by_id => l_sch_id,
1530: p_msg_data => 'Before generating tgrp ' || itemkey ,
1531: p_msg_type => 'DEBUG'
1532: );
1533: Ams_Utility_pvt.debug_message('Schedule id: '||l_sch_id);
1534:
1535: AMS_Act_List_PVT.generate_target_group_list_old
1536: ( p_api_version => 1.0,
1537: p_init_msg_list => FND_API.G_FALSE,

Line 1547: Ams_Utility_pvt.debug_message('return status from generate target group: '||l_return_status);

1543: x_msg_count => l_msg_count,
1544: x_msg_data => l_msg_data
1545: ) ;
1546:
1547: Ams_Utility_pvt.debug_message('return status from generate target group: '||l_return_status);
1548: AMS_Utility_PVT.Create_Log (
1549: x_return_status => l_log_return_status,
1550: p_arc_log_used_by => 'CSCH',
1551: p_log_used_by_id => l_sch_id,

Line 1548: AMS_Utility_PVT.Create_Log (

1544: x_msg_data => l_msg_data
1545: ) ;
1546:
1547: Ams_Utility_pvt.debug_message('return status from generate target group: '||l_return_status);
1548: AMS_Utility_PVT.Create_Log (
1549: x_return_status => l_log_return_status,
1550: p_arc_log_used_by => 'CSCH',
1551: p_log_used_by_id => l_sch_id,
1552: p_msg_data => 'return status from generate target group: ' || l_return_status ,

Line 1580: Ams_Utility_pvt.debug_message('Before activating csch');

1576: END IF;
1577:
1578: -- soagrawa 26-sep-2003 commented the activation code and replaced it with raising business event
1579: /*
1580: Ams_Utility_pvt.debug_message('Before activating csch');
1581: AMS_Utility_PVT.Create_Log (
1582: x_return_status => l_log_return_status,
1583: p_arc_log_used_by => 'CSCH',
1584: p_log_used_by_id => l_sch_id,

Line 1581: AMS_Utility_PVT.Create_Log (

1577:
1578: -- soagrawa 26-sep-2003 commented the activation code and replaced it with raising business event
1579: /*
1580: Ams_Utility_pvt.debug_message('Before activating csch');
1581: AMS_Utility_PVT.Create_Log (
1582: x_return_status => l_log_return_status,
1583: p_arc_log_used_by => 'CSCH',
1584: p_log_used_by_id => l_sch_id,
1585: p_msg_data => 'Before activating csch: ' ,

Line 1598: Ams_Utility_pvt.debug_message('return status from activate schedule: '||l_return_status);

1594: ,x_msg_data => l_msg_data
1595: ,p_schedule_id => l_sch_id
1596: );
1597: -- end of the change 06-APR-2001
1598: Ams_Utility_pvt.debug_message('return status from activate schedule: '||l_return_status);
1599:
1600: AMS_Utility_PVT.Create_Log (
1601: x_return_status => l_log_return_status,
1602: p_arc_log_used_by => 'CSCH',

Line 1600: AMS_Utility_PVT.Create_Log (

1596: );
1597: -- end of the change 06-APR-2001
1598: Ams_Utility_pvt.debug_message('return status from activate schedule: '||l_return_status);
1599:
1600: AMS_Utility_PVT.Create_Log (
1601: x_return_status => l_log_return_status,
1602: p_arc_log_used_by => 'CSCH',
1603: p_log_used_by_id => l_sch_id,
1604: p_msg_data => 'return status from activate schedule: ' || l_return_status ,

Line 1635: AMS_UTILITY_PVT.Convert_Timezone(

1631: OPEN c_sch_det(l_sch_id);
1632: FETCH c_sch_det INTO l_start_time, l_timezone;
1633: CLOSE c_sch_det;
1634:
1635: AMS_UTILITY_PVT.Convert_Timezone(
1636: p_init_msg_list => FND_API.G_TRUE,
1637: x_return_status => l_return_status,
1638: x_msg_count => l_msg_count,
1639: x_msg_data => l_msg_data,

Line 1655: --AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');

1651: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1652: l_sys_start_time := SYSDATE;
1653: END IF;
1654:
1655: --AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');
1656: WF_EVENT.Raise
1657: ( p_event_name => 'oracle.apps.ams.campaign.ExecuteSchedule',
1658: p_event_key => l_new_item_key,
1659: p_parameters => l_parameter_list,

Line 1733: AMS_Utility_PVT.Create_Log (

1729: itemtype => itemtype,
1730: itemkey => itemkey ,
1731: aname => 'AMS_TRIGGER_ID');
1732:
1733: AMS_Utility_PVT.Create_Log (
1734: x_return_status => l_return_log_status,
1735: p_arc_log_used_by => 'TRIG',
1736: p_log_used_by_id => l_trigger_id,
1737: p_msg_data => 'Get_Aval_Sch : 1. Started ' || to_char(sysdate,'DD-MON-RRRR HH:MI:SS AM') ,

Line 1747: AMS_Utility_PVT.Create_Log (

1743:
1744: FOR l_sch_det_rec IN c_sch_det(l_trigger_id)
1745: LOOP
1746:
1747: AMS_Utility_PVT.Create_Log (
1748: x_return_status => l_return_log_status,
1749: p_arc_log_used_by => 'TRIG',
1750: p_log_used_by_id => l_trigger_id,
1751: p_msg_data => 'Get_Aval_Sch : Looping for schedule id ' ||l_sch_det_rec.schedule_id ,

Line 2286: AMS_Utility_PVT.Create_Log (

2282: itemtype => itemtype,
2283: itemkey => itemkey ,
2284: aname => 'AMS_TRIGGER_ID');
2285:
2286: AMS_Utility_PVT.Create_Log (
2287: x_return_status => l_return_status,
2288: p_arc_log_used_by => 'TRIG',
2289: p_log_used_by_id => l_trigger_id,
2290: p_msg_data => 'Action_Notification : trigger in RUN mode' ,

Line 2298: AMS_Utility_PVT.Create_Log (

2294: OPEN c_trig_notify(l_trigger_id);
2295: FETCH c_trig_notify INTO l_notify_flag;
2296: CLOSE c_trig_notify;
2297:
2298: AMS_Utility_PVT.Create_Log (
2299: x_return_status => l_return_status,
2300: p_arc_log_used_by => 'TRIG',
2301: p_log_used_by_id => l_trigger_id,
2302: p_msg_data => 'Action_Notification : notification flag is ' ||l_notify_flag,

Line 2337: AMS_Utility_PVT.Create_Log (

2333: ,avalue => '');
2334: result := 'COMPLETE:N' ;
2335: END IF;
2336:
2337: AMS_Utility_PVT.Create_Log (
2338: x_return_status => l_return_status,
2339: p_arc_log_used_by => 'TRIG',
2340: p_log_used_by_id => l_trigger_id,
2341: p_msg_data => 'Action_notification : AMS_NOTIF_TO_USER_NAME = ' || l_notify || ', '||l_display_name,

Line 2640: AMS_Utility_PVT.Create_Log (

2636: itemtype => itemtype,
2637: itemkey => itemkey ,
2638: aname => 'AMS_TRIGGER_ID');
2639:
2640: AMS_Utility_PVT.Create_Log (
2641: x_return_status => l_return_log_status,
2642: p_arc_log_used_by => 'TRIG',
2643: p_log_used_by_id => l_trigger_id,
2644: p_msg_data => 'Get_Aval_Repeat_Sch : 1. Started '|| to_char(sysdate,'DD-MON-RRRR HH:MI:SS AM') ,

Line 2699: AMS_Utility_PVT.Create_Log (

2695: l_trigger_end_date := WF_ENGINE.getItemAttrDate(itemtype => itemtype,
2696: itemkey => itemkey ,
2697: aname => 'AMS_TRIGGER_REPEAT_END_DATE');
2698:
2699: AMS_Utility_PVT.Create_Log (
2700: x_return_status => l_return_log_status,
2701: p_arc_log_used_by => 'TRIG',
2702: p_log_used_by_id => l_trigger_id,
2703: p_msg_data => 'Get_Aval_Repeat_Sch : Trigger Sched Date is '|| to_char(l_trigger_sched_date,'DD-MON-RRRR HH:MI:SS AM') || 'Trigger End Date is '|| to_char(l_trigger_end_date,'DD-MON-RRRR HH:MI:SS AM'),

Line 2720: AMS_Utility_PVT.Create_Log (

2716: OPEN c_sch_det(l_schedule_id);
2717: FETCH c_sch_det INTO l_sch_det_rec;
2718: CLOSE c_sch_det;
2719:
2720: AMS_Utility_PVT.Create_Log (
2721: x_return_status => l_return_log_status,
2722: p_arc_log_used_by => 'TRIG',
2723: p_log_used_by_id => l_trigger_id,
2724: p_msg_data => 'Get_Aval_Repeat_Sch : 2.Processing for schedule_id '|| l_sch_det_rec.schedule_id,

Line 2730: AMS_Utility_PVT.Create_Log (

2726: );
2727:
2728: l_item_key := l_sch_det_rec.schedule_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
2729:
2730: AMS_Utility_PVT.Create_Log (
2731: x_return_status => l_return_log_status,
2732: p_arc_log_used_by => 'TRIG',
2733: p_log_used_by_id => l_trigger_id,
2734: p_msg_data => 'Get_Aval_Repeat_Sch : 3.detail itemkey: '|| l_item_key,

Line 2738: AMS_Utility_PVT.Create_Log (

2734: p_msg_data => 'Get_Aval_Repeat_Sch : 3.detail itemkey: '|| l_item_key,
2735: p_msg_type => 'DEBUG'
2736: );
2737:
2738: AMS_Utility_PVT.Create_Log (
2739: x_return_status => l_return_log_status,
2740: p_arc_log_used_by => 'TRIG',
2741: p_log_used_by_id => l_trigger_id,
2742: p_msg_data => 'Get_Aval_Repeat_Sch : 4.Creating Process',

Line 2751: AMS_Utility_PVT.Create_Log (

2747: itemkey => l_item_key ,
2748: user_key => l_sch_det_rec.schedule_name,
2749: process => 'AMS_EXEC_ATTCH_SCH'); -- name of the process
2750:
2751: AMS_Utility_PVT.Create_Log (
2752: x_return_status => l_return_log_status,
2753: p_arc_log_used_by => 'TRIG',
2754: p_log_used_by_id => l_trigger_id,
2755: p_msg_data => 'Get_Aval_Repeat_Sch : 5.Created Process',

Line 2769: AMS_Utility_PVT.Create_Log (

2765: result := 'COMPLETE:ERROR';
2766: RETURN;
2767: END IF;
2768:
2769: AMS_Utility_PVT.Create_Log (
2770: x_return_status => l_return_log_status,
2771: p_arc_log_used_by => 'TRIG',
2772: p_log_used_by_id => l_trigger_id,
2773: p_msg_data => 'Get_Aval_Repeat_Sch : Setting WF Engine params',

Line 2912: AMS_Utility_PVT.Create_Log (

2908: -- aname => 'AMS_NTF_MESSAGE') );
2909:
2910: -- end soagrawa setting values
2911:
2912: AMS_Utility_PVT.Create_Log (
2913: x_return_status => l_return_log_status,
2914: p_arc_log_used_by => 'TRIG',
2915: p_log_used_by_id => l_trigger_id,
2916: p_msg_data => 'Get_Aval_Repeat_Sch : 6.Finished setting all params',

Line 2933: AMS_Utility_PVT.Create_Log (

2929: WF_ENGINE.StartProcess (itemtype => itemtype,
2930: itemkey => l_item_key);
2931:
2932:
2933: AMS_Utility_PVT.Create_Log (
2934: x_return_status => l_return_log_status,
2935: p_arc_log_used_by => 'TRIG',
2936: p_log_used_by_id => l_trigger_id,
2937: p_msg_data => 'Get_Aval_Repeat_Sch : 7.Started Process',

Line 2944: AMS_Utility_PVT.Create_Log (

2940:
2941:
2942: IF (l_trigger_sched_date < l_trigger_end_date) THEN
2943:
2944: AMS_Utility_PVT.Create_Log (
2945: x_return_status => l_return_log_status,
2946: p_arc_log_used_by => 'TRIG',
2947: p_log_used_by_id => l_trigger_id,
2948: p_msg_data => 'Get_Aval_Repeat_Sch : 8.Yes gotta create new csch',

Line 2999: AMS_Utility_PVT.Create_Log (

2995: OPEN c_camp_det(l_csch_rec.campaign_id);
2996: FETCH c_camp_det INTO l_camp_end_dt; -- campaign's end date
2997: CLOSE c_camp_det;
2998:
2999: AMS_Utility_PVT.Create_Log (
3000: x_return_status => l_return_log_status,
3001: p_arc_log_used_by => 'TRIG',
3002: p_log_used_by_id => l_trigger_id,
3003: p_msg_data => 'l_csch_rec.campaign_id = ' || l_csch_rec.campaign_id || ' l_camp_end_dt = ' || l_camp_end_dt,

Line 3017: AMS_Utility_PVT.Create_Log (

3013: l_child_sched_end_date_time := null;
3014: ELSE
3015: l_child_sched_end_date_time := l_child_sched_st_date + (l_csch_rec.end_date_time - l_csch_rec.start_date_time);
3016:
3017: AMS_Utility_PVT.Create_Log (
3018: x_return_status => l_return_log_status,
3019: p_arc_log_used_by => 'TRIG',
3020: p_log_used_by_id => l_trigger_id,
3021: p_msg_data => 'l_csch_rec.schedule_id = ' || l_csch_rec.schedule_id || ' l_camp_end_dt = ' || l_camp_end_dt || 'l_csch_rec.orig_csch_id = ' || l_csch_rec.orig_csch_id ,

Line 3037: AMS_Utility_PVT.Create_Log (

3033: OPEN c_orig_csch_name(l_csch_rec.schedule_id);
3034: FETCH c_orig_csch_name INTO l_orig_schedule_name;
3035: CLOSE c_orig_csch_name;
3036:
3037: AMS_Utility_PVT.Create_Log (
3038: x_return_status => l_return_log_status,
3039: p_arc_log_used_by => 'TRIG',
3040: p_log_used_by_id => l_trigger_id,
3041: p_msg_data => 'l_csch_rec.schedule_id used for getting ORIG CSCH NAME is '||l_csch_rec.schedule_id,

Line 3045: AMS_Utility_PVT.Create_Log (

3041: p_msg_data => 'l_csch_rec.schedule_id used for getting ORIG CSCH NAME is '||l_csch_rec.schedule_id,
3042: p_msg_type => 'DEBUG'
3043: );
3044:
3045: AMS_Utility_PVT.Create_Log (
3046: x_return_status => l_return_log_status,
3047: p_arc_log_used_by => 'TRIG',
3048: p_log_used_by_id => l_trigger_id,
3049: p_msg_data => 'ORIG CSCH NAME is '||l_orig_schedule_name,

Line 3071: AMS_Utility_PVT.Create_Log (

3067:
3068: IF l_return_status <> FND_API.g_ret_sts_success THEN
3069: l_failed := l_failed + 1;
3070: result := 'COMPLETE:ERROR';
3071: AMS_Utility_PVT.Create_Log (
3072: x_return_status => l_return_log_status,
3073: p_arc_log_used_by => 'TRIG',
3074: p_log_used_by_id => l_trigger_id,
3075: p_msg_data => 'Get_Aval_Repeat_Sch : 9.After AMS_SCHEDULER_PVT.Create_Next_Schedule call'||l_return_status,

Line 3087: AMS_Utility_PVT.Create_Log (

3083: --end fix#3063816 by cgoyal
3084: END IF;
3085: END LOOP;
3086:
3087: AMS_Utility_PVT.Create_Log (
3088: x_return_status => l_return_log_status,
3089: p_arc_log_used_by => 'TRIG',
3090: p_log_used_by_id => l_trigger_id,
3091: p_msg_data => 'Get_Aval_Repeat_Sch : Loop ends',

Line 3436: AMS_Utility_PVT.Create_Log (

3432: itemtype => itemtype,
3433: itemkey => itemkey ,
3434: aname => 'AMS_TRIGGER_ID');
3435:
3436: AMS_Utility_PVT.Create_Log (
3437: x_return_status => l_return_status,
3438: p_arc_log_used_by => 'TRIG',
3439: p_log_used_by_id => l_trigger_id,
3440: p_msg_data => 'WF_INIT_VAR: started',

Line 3687: AMS_Utility_PVT.Create_Log (

3683: CLOSE c_trig_exist_det;
3684:
3685: IF l_dummy IS NULL THEN
3686: result := 'COMPLETE:N' ;
3687: AMS_Utility_PVT.Create_Log (
3688: x_return_status => l_return_status,
3689: p_arc_log_used_by => 'TRIG',
3690: p_log_used_by_id => l_trigger_id,
3691: p_msg_data => 'Check_Trig_Exist : 1. For Trigger ID = ' || itemkey || result,

Line 3697: AMS_Utility_PVT.Create_Log (

3693: );
3694: RETURN;
3695: ELSE
3696: result := 'COMPLETE:Y' ;
3697: AMS_Utility_PVT.Create_Log (
3698: x_return_status => l_return_status,
3699: p_arc_log_used_by => 'TRIG',
3700: p_log_used_by_id => l_trigger_id,
3701: p_msg_data => 'Check_Trig_Exist : 1. For Trigger ID = ' || itemkey || result,

Line 3742: Ams_Utility_Pvt.Write_Conc_Log(TO_CHAR(DBMS_UTILITY.get_time)||': '||

3738:
3739: PROCEDURE write_msg(p_procedure IN VARCHAR2, p_message IN VARCHAR2)
3740: IS
3741: BEGIN
3742: Ams_Utility_Pvt.Write_Conc_Log(TO_CHAR(DBMS_UTILITY.get_time)||': '||
3743: G_PKG_NAME||'.'||p_procedure||': '||p_message);
3744: END;
3745:
3746: