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.AML_MONITOR_WF dependencies on FND_MSG_PUB

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

1: PACKAGE BODY aml_monitor_wf AS
2: /* $Header: amlldmnb.pls 115.40 2004/06/02 01:37:25 chchandr ship $ */
3:
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlldmnb.pls';
5: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6:
7:
8:
9: -- Start of Comments

Line 185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API' || l_api_name );

181: ORDER BY item_key desc;
182:
183: BEGIN
184: IF (AS_DEBUG_LOW_ON) THEN
185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API' || l_api_name );
186: END IF;
187: -- Standard Start of API savepoint
188: SAVEPOINT LAUNCH_MONITOR_PUB;
189:

Line 202: FND_MSG_PUB.initialize;

198:
199: -- Initialize message list IF p_init_msg_list is set to TRUE.
200: IF FND_API.to_Boolean( p_init_msg_list )
201: THEN
202: FND_MSG_PUB.initialize;
203: END IF;
204:
205: -- Debug Message
206: IF (AS_DEBUG_LOW_ON) THEN

Line 207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'PVT:' || l_api_name || ' Start');

203: END IF;
204:
205: -- Debug Message
206: IF (AS_DEBUG_LOW_ON) THEN
207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'PVT:' || l_api_name || ' Start');
208: END IF;
209:
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 221: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

217: -- Validate Environment
218: -- ******************************************************************
219: IF FND_GLOBAL.User_Id IS NULL
220: THEN
221: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
222: THEN
223: AS_UTILITY_PVT.Set_Message(
224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
225: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

220: THEN
221: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
222: THEN
223: AS_UTILITY_PVT.Set_Message(
224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
225: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
226: p_token1 => 'PROFILE',
227: p_token1_value => 'USER_ID');
228: END IF;

Line 241: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_country '||l_lead_country );

237: fetch c_get_lead_info into l_lead_country, l_lead_rank_id,l_lead_creation_date;
238: close c_get_lead_info;
239:
240: IF (AS_DEBUG_LOW_ON) THEN
241: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_country '||l_lead_country );
242: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_rank_id '||l_lead_rank_id );
243: END IF;
244: -- See if this is a new lead or old_lead
245: if p_lead_action = 'CREATE' then

Line 242: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_rank_id '||l_lead_rank_id );

238: close c_get_lead_info;
239:
240: IF (AS_DEBUG_LOW_ON) THEN
241: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_country '||l_lead_country );
242: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_lead_rank_id '||l_lead_rank_id );
243: END IF;
244: -- See if this is a new lead or old_lead
245: if p_lead_action = 'CREATE' then
246: l_new_lead := 'Y';

Line 276: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'New Lead ' );

272: -- if new_lead, then need to try finding a creation date monitor
273: if l_new_lead = 'Y' then
274:
275: IF (AS_DEBUG_LOW_ON) THEN
276: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'New Lead ' );
277: END IF;
278:
279: open c_get_matching_monitors(l_lead_country, l_lead_rank_id , P_Changed_From_stage);
280: fetch c_get_matching_monitors into l_process_rule_id, l_monitor_condition_id, l_time_lag_num;

Line 289: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );

285: end if;
286: close c_get_matching_monitors;
287:
288: IF (AS_DEBUG_LOW_ON) THEN
289: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );
290: END IF;
291:
292: -- if no creation date monitors found, then look for assigned date monitor
293:

Line 335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);

331: loop
332: fetch c_get_existing_wf into l_existing_itemkey;
333:
334: IF (AS_DEBUG_LOW_ON) THEN
335: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);
336: END IF;
337: exit when c_get_existing_wf%NOTFOUND;
338:
339: IF (AS_DEBUG_LOW_ON) THEN

Line 340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);

336: END IF;
337: exit when c_get_existing_wf%NOTFOUND;
338:
339: IF (AS_DEBUG_LOW_ON) THEN
340: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);
341: END IF;
342:
343: if l_existing_itemkey is not null then
344: -- Find process_rule_id for the current one running

Line 366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after aborting the old one:' || l_existing_itemkey);

362: itemkey => l_existing_itemkey) ;
363: end if;
364:
365: IF (AS_DEBUG_LOW_ON) THEN
366: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after aborting the old one:' || l_existing_itemkey);
367: END IF;
368:
369:
370:

Line 400: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting Matching Monitor ' );

396: -- If found, then abort earlier process
397: -- Start New Process
398: -- ******************************************************************
399: IF (AS_DEBUG_LOW_ON) THEN
400: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting Matching Monitor ' );
401: END IF;
402:
403: open c_get_matching_monitors(l_lead_country, l_lead_rank_id , P_Changed_From_stage);
404: fetch c_get_matching_monitors into l_process_rule_id, l_monitor_condition_id, l_time_lag_num;

Line 413: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );

409: end if;
410: close c_get_matching_monitors;
411:
412: IF (AS_DEBUG_LOW_ON) THEN
413: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );
414: END IF;
415:
416: -- if no creation date monitors found, then look for assigned date monitor
417:

Line 436: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'inside l_monitor_found = Y :' );

432: --
433: IF l_monitor_found = 'Y' THEN
434: --
435: IF (AS_DEBUG_LOW_ON) THEN
436: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'inside l_monitor_found = Y :' );
437: END IF;
438: -- ******************************************************************
439: -- Find earlier Active Workflow for this lead
440: -- assuming only one active can exist at one time

Line 449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);

445: loop
446: fetch c_get_existing_wf into l_existing_itemkey;
447:
448: IF (AS_DEBUG_LOW_ON) THEN
449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);
450: END IF;
451: exit when c_get_existing_wf%NOTFOUND;
452:
453: IF (AS_DEBUG_LOW_ON) THEN

Line 454: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);

450: END IF;
451: exit when c_get_existing_wf%NOTFOUND;
452:
453: IF (AS_DEBUG_LOW_ON) THEN
454: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_existing_itemkey:' || l_existing_itemkey);
455: END IF;
456:
457: if l_existing_itemkey is not null then
458: -- abort existing process

Line 463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after aborting the old one:' || l_existing_itemkey);

459: Wf_Engine.AbortProcess(itemtype => l_itemtype,
460: itemkey => l_existing_itemkey) ;
461:
462: IF (AS_DEBUG_LOW_ON) THEN
463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after aborting the old one:' || l_existing_itemkey);
464: END IF;
465:
466:
467:

Line 492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemkey:' || itemkey);

488: from dual ;
489: end if;
490:
491: IF (AS_DEBUG_LOW_ON) THEN
492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemkey:' || itemkey);
493: END IF;
494:
495: itemtype := AML_MONITOR_WF.g_item_type;
496:

Line 522: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);

518: aname => 'PROCESS_RULE_ID',
519: avalue => l_process_rule_id);
520:
521: IF (AS_DEBUG_LOW_ON) THEN
522: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);
523: END IF;
524:
525: wf_engine.SetItemAttrNumber(itemtype => itemtype,
526: itemkey => itemkey,

Line 551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_time_lag_num:' || l_time_lag_num);

547: aname => 'MONITOR_LAUNCH_DATE',
548: avalue => l_monitor_launch_date);
549:
550: IF (AS_DEBUG_LOW_ON) THEN
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_time_lag_num:' || l_time_lag_num);
552: END IF;
553:
554: wf_engine.StartProcess(itemtype => ItemType,
555: itemkey => ItemKey );

Line 558: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after start process:' );

554: wf_engine.StartProcess(itemtype => ItemType,
555: itemkey => ItemKey );
556:
557: IF (AS_DEBUG_LOW_ON) THEN
558: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after start process:' );
559: END IF;
560:
561: wf_engine.ItemStatus(itemtype => ItemType,
562: itemkey => ItemKey,

Line 567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After ItemStatus:' || l_result);

563: status => l_status,
564: result => l_result);
565:
566: IF (AS_DEBUG_LOW_ON) THEN
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After ItemStatus:' || l_result);
568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);
569: END IF;
570:
571: l_itemtype := ItemType;

Line 568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);

564: result => l_result);
565:
566: IF (AS_DEBUG_LOW_ON) THEN
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After ItemStatus:' || l_result);
568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);
569: END IF;
570:
571: l_itemtype := ItemType;
572: l_itemkey := ItemKey;

Line 577: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'x_return_status: '|| x_return_status);

573: -- swkhanna 4/7/03 Bug2891236 - changed to check l_result instead of x_return_status
574: -- x_return_status := l_result ;
575:
576: IF (AS_DEBUG_LOW_ON) THEN
577: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'x_return_status: '|| x_return_status);
578: END IF;
579:
580: -- verify the valid values of return_status from WF and handle them
581: IF l_result = '#NULL' THEN

Line 585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AS_LEAD_MONITOR_START_FAIL');

581: IF l_result = '#NULL' THEN
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583: ELSIF l_result = 'ERROR' THEN
584: IF (AS_DEBUG_LOW_ON) THEN
585: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AS_LEAD_MONITOR_START_FAIL');
586: END IF;
587: RAISE FND_API.G_EXC_ERROR;
588: --ELSIF l_result = 'W' THEN
589: -- x_return_status := 'W';

Line 605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'PVT: ' || l_api_name || ' End');

601:
602: end if; --profile run_lead_monitor_engine
603: -- Debug Message
604: IF (AS_DEBUG_LOW_ON) THEN
605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'PVT: ' || l_api_name || ' End');
606: END IF;
607: -- Standard call to get message count and IF count is 1, get message info.
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count,

Line 608: FND_MSG_PUB.Count_And_Get

604: IF (AS_DEBUG_LOW_ON) THEN
605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'PVT: ' || l_api_name || ' End');
606: END IF;
607: -- Standard call to get message count and IF count is 1, get message info.
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data );
611:
612: EXCEPTION

Line 617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

613: WHEN FND_API.G_EXC_ERROR THEN
614: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
615: P_API_NAME => L_API_NAME
616: ,P_PKG_NAME => G_PKG_NAME
617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
618: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
619: ,X_MSG_COUNT => X_MSG_COUNT
620: ,X_MSG_DATA => X_MSG_DATA
621: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 627: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
625: P_API_NAME => L_API_NAME
626: ,P_PKG_NAME => G_PKG_NAME
627: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
628: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
629: ,X_MSG_COUNT => X_MSG_COUNT
630: ,X_MSG_DATA => X_MSG_DATA
631: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 803: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Get_Monitor_Details: Start');

799: where party_id = c_customer_id;
800:
801: BEGIN
802: IF (AS_DEBUG_LOW_ON) THEN
803: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Get_Monitor_Details: Start');
804: END IF;
805:
806: IF funcmode = 'RUN'
807: THEN

Line 833: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting monitor details:' || l_time_lag_from_stage);

829: l_timeout_uom_code, l_notify_owner, l_notify_manager;
830: CLOSE c_get_monitor_details;
831:
832: IF (AS_DEBUG_LOW_ON) THEN
833: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting monitor details:' || l_time_lag_from_stage);
834: END IF;
835: l_sales_lead_id := wf_engine.GetItemAttrNumber(
836: itemtype => itemtype,
837: itemkey => itemkey,

Line 847: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting lead details:' || l_creation_date);

843: l_resource_id, l_group_id , l_current_reroutes, l_description,l_customer_id;
844: close c_get_lead_details;
845:
846: IF (AS_DEBUG_LOW_ON) THEN
847: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting lead details:' || l_creation_date);
848: END IF;
849:
850: wf_engine.SetItemAttrDate(itemtype => itemtype,
851: itemkey => itemkey,

Line 986: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

982: aname => 'TIMEOUT_UOM_CODE',
983: avalue => l_timeout_uom_code);
984:
985: IF (AS_DEBUG_LOW_ON) THEN
986: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
987: 'l_process_rule_id:' || l_process_rule_id);
988: END IF;
989:
990: if l_current_Reroutes is null then

Line 1079: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1075: l_notify_role_list := substr(l_notify_role_list,2);
1076: l_notify_role := 'AML_' || itemKey;
1077:
1078: IF (AS_DEBUG_LOW_ON) THEN
1079: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1080: 'l_notify_role_list :' || l_notify_role_list);
1081:
1082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'l_notify_role :' || l_notify_role);

Line 1082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1078: IF (AS_DEBUG_LOW_ON) THEN
1079: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1080: 'l_notify_role_list :' || l_notify_role_list);
1081:
1082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'l_notify_role :' || l_notify_role);
1084: END IF;
1085:
1086: -- Create Role

Line 1114: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1110: role_users => null);
1111: end if;
1112:
1113: IF (AS_DEBUG_LOW_ON) THEN
1114: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1115: 'After createAdHocRole :');
1116: END IF;
1117:
1118: wf_engine.SetItemAttrText ( ItemType => itemType,

Line 1124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1120: aname => 'NOTIFY_ROLE',
1121: avalue => l_notify_role);
1122:
1123: IF (AS_DEBUG_LOW_ON) THEN
1124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1125: 'After setting notify role value :');
1126: END IF;
1127:
1128:

Line 1139: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1135:
1136: END IF;
1137:
1138: IF (AS_DEBUG_LOW_ON) THEN
1139: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1140: 'Result:' || l_result);
1141: END IF;
1142:
1143: result := l_result;

Line 1149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (AS_DEBUG_LOW_ON) THEN
1149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1150: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1151: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: SQLERRM);
1153: END IF;

Line 1151: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1147: WHEN OTHERS THEN
1148: IF (AS_DEBUG_LOW_ON) THEN
1149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1150: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1151: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: SQLERRM);
1153: END IF;
1154:
1155: wf_core.context(

Line 1185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1181: l_msg_data varchar2(2000);
1182: l_resultout varchar2(50);
1183: BEGIN
1184: IF (AS_DEBUG_LOW_ON) THEN
1185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1186: 'Owner_Needed: Start');
1187: END IF;
1188:
1189: IF funcmode = 'RUN'

Line 1207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1203:
1204: END IF;
1205:
1206: IF (AS_DEBUG_LOW_ON) THEN
1207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'Result:' || l_resultout);
1209: END IF;
1210:
1211: result := l_resultout;

Line 1215: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1211: result := l_resultout;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: IF (AS_DEBUG_LOW_ON) THEN
1215: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1216: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1217: END IF;
1218: wf_core.context(
1219: itemtype,

Line 1252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1248: l_msg_data varchar2(2000);
1249: l_resultout varchar2(50);
1250: BEGIN
1251: IF (AS_DEBUG_LOW_ON) THEN
1252: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1253: 'Timeout_Defined: Start');
1254: END IF;
1255:
1256: IF funcmode = 'RUN'

Line 1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1263: aname => 'TIMEOUT_DEFINED');
1264:
1265:
1266: IF (AS_DEBUG_LOW_ON) THEN
1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1268: 'l_timeout_defined:' || l_timeout_defined);
1269: END IF;
1270:
1271: if l_timeout_defined = 'Y' then

Line 1279: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1275: end if;
1276: END IF;
1277:
1278: IF (AS_DEBUG_LOW_ON) THEN
1279: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1280: 'Result:' || l_resultout);
1281: END IF;
1282: result := l_resultout;
1283: EXCEPTION

Line 1286: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1282: result := l_resultout;
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: IF (AS_DEBUG_LOW_ON) THEN
1286: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1287: SQLERRM);
1288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1290: END IF;

Line 1288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1284: WHEN OTHERS THEN
1285: IF (AS_DEBUG_LOW_ON) THEN
1286: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1287: SQLERRM);
1288: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1290: END IF;
1291: wf_core.context(
1292: itemtype,

Line 1326: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1322: l_due_date Date;
1323: l_relative_to_expiration varchar2(1);
1324: BEGIN
1325: IF (AS_DEBUG_LOW_ON) THEN
1326: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1327: 'SET_NOTIFY_ATTRIBUTES: Start');
1328: END IF;
1329:
1330: IF funcmode = 'RUN'

Line 1333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1329:
1330: IF funcmode = 'RUN'
1331: THEN
1332: IF (AS_DEBUG_LOW_ON) THEN
1333: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1334: 'SET_NOTIFY_ATTRIBUTES: Start');
1335: END IF;
1336:
1337:

Line 1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1340: itemkey => itemkey,
1341: aname => 'TIMELAG_NUM');
1342:
1343: IF (AS_DEBUG_LOW_ON) THEN
1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: ' l_timelag_number: '||l_timelag_number);
1346: END IF;
1347:
1348: l_monitor_launch_date := wf_engine.GetItemAttrDate(

Line 1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1350: itemkey => itemkey,
1351: aname => 'MONITOR_LAUNCH_DATE');
1352:
1353: IF (AS_DEBUG_LOW_ON) THEN
1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: ' l_monitor_launch_date: '||l_monitor_launch_date);
1356: END IF;
1357:
1358: l_relative_to_expiration:= wf_engine.GetItemAttrText(

Line 1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1360: itemkey => itemkey,
1361: aname => 'EXPIRATION_RELATIVE');
1362:
1363: IF (AS_DEBUG_LOW_ON) THEN
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: ' l_relative_to_expiration: '||l_relative_to_expiration);
1366: END IF;
1367:
1368: if l_relative_to_expiration is null then

Line 1378: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1374: itemkey => itemkey,
1375: aname => 'EXPIRATION_DATE');
1376:
1377: IF (AS_DEBUG_LOW_ON) THEN
1378: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1379: ' l_expiration_date: '||l_expiration_date);
1380: END IF;
1381:
1382: aml_monitor_wf.set_timelag

Line 1397: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1393: l_resultout := 'COMPLETE';
1394:
1395:
1396: IF (AS_DEBUG_LOW_ON) THEN
1397: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1398: ' l_timelag_due_date: '||l_timelag_due_date);
1399: END IF;
1400:
1401: elsif l_relative_to_expiration = 'Y' and l_expiration_date is not null then

Line 1438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1434:
1435: END IF;
1436:
1437: IF (AS_DEBUG_LOW_ON) THEN
1438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1439: 'Result:' || l_resultout);
1440: END IF;
1441: l_timelag_minutes := wf_engine.GetItemAttrNumber(
1442: itemtype => itemtype,

Line 1447: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1443: itemkey => itemkey,
1444: aname => 'TIMELAG_MINUTES');
1445:
1446: IF (AS_DEBUG_LOW_ON) THEN
1447: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1448: 'l_timelag_minutes:' || l_timelag_minutes);
1449: END IF;
1450: result := l_resultout;
1451: EXCEPTION

Line 1454: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1450: result := l_resultout;
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: IF (AS_DEBUG_LOW_ON) THEN
1454: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1455: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1456: END IF;
1457: wf_core.context(
1458: itemtype,

Line 1497: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1493: l_msg_data varchar2(2000);
1494: l_resultout varchar2(50);
1495: BEGIN
1496: IF (AS_DEBUG_LOW_ON) THEN
1497: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1498: 'LOG_NOTIFICATION_ACTION: Start');
1499: END IF;
1500:
1501: IF funcmode = 'RUN'

Line 1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1638: l_resultout := 'COMPLETE';
1639:
1640: END IF;
1641: IF (AS_DEBUG_LOW_ON) THEN
1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1643: 'Result:' || l_resultout);
1644: END IF;
1645:
1646: result := l_resultout;

Line 1651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1647: EXCEPTION
1648:
1649: WHEN OTHERS THEN
1650: IF (AS_DEBUG_LOW_ON) THEN
1651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1652: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1653: END IF;
1654: wf_core.context(
1655: itemtype,

Line 1686: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1682: l_reminder_defined varchar2(1);
1683: l_timeout_defined varchar2(1);
1684: BEGIN
1685: IF (AS_DEBUG_LOW_ON) THEN
1686: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1687: 'CHK_MAX_REMINDERS: Start');
1688: END IF;
1689:
1690: IF funcmode = 'RUN'

Line 1733: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1729: l_resultout := 'COMPLETE:'||'Y';
1730: end if;
1731:
1732: IF (AS_DEBUG_LOW_ON) THEN
1733: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1734: 'Result:' || l_resultout);
1735: END IF;
1736:
1737: result := l_resultout;

Line 1741: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1737: result := l_resultout;
1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: IF (AS_DEBUG_LOW_ON) THEN
1741: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1742: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1743: END IF;
1744: wf_core.context(
1745: itemtype,

Line 1777: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1773: l_due_date Date;
1774:
1775: BEGIN
1776: IF (AS_DEBUG_LOW_ON) THEN
1777: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1778: 'SET_REMINDER_ATTRIBUTES: Start');
1779: END IF;
1780:
1781: IF funcmode = 'RUN'

Line 1790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1786: itemkey => itemkey,
1787: aname => 'TIMELAG_NUM');
1788:
1789: IF (AS_DEBUG_LOW_ON) THEN
1790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1791: 'l_timelag_number:' || l_timelag_number);
1792: END IF;
1793:
1794: l_current_reminder := wf_engine.GetItemAttrNumber(

Line 1800: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1796: itemkey => itemkey,
1797: aname => 'CURRENT_REMINDERS');
1798:
1799: IF (AS_DEBUG_LOW_ON) THEN
1800: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1801: 'l_current_reminder:' || l_current_reminder);
1802: END IF;
1803:
1804: l_reminder_frequency := wf_engine.GetItemAttrNumber(

Line 1810: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1806: itemkey => itemkey,
1807: aname => 'REMINDER_FREQUENCY');
1808:
1809: IF (AS_DEBUG_LOW_ON) THEN
1810: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1811: 'l_reminder_frequency:' || l_reminder_frequency);
1812: END IF;
1813:
1814: aml_monitor_wf.set_timelag

Line 1826: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1822: -- l_reminder_timelag_minutes := l_reminder_frequency*24*60;
1823: l_reminder_timelag_minutes := l_total_reminder_timelag*24*60;
1824:
1825: IF (AS_DEBUG_LOW_ON) THEN
1826: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1827: 'l_reminder:' || l_reminder_timelag_minutes);
1828: END IF;
1829:
1830: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 1846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1842:
1843: END IF;
1844:
1845: IF (AS_DEBUG_LOW_ON) THEN
1846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1847: 'Result:' || l_resultout);
1848: END IF;
1849:
1850: result := l_resultout;

Line 1854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1850: result := l_resultout;
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: IF (AS_DEBUG_LOW_ON) THEN
1854: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1855: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1856: END IF;
1857: wf_core.context(
1858: itemtype,

Line 1891: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1887:
1888: BEGIN
1889:
1890: IF (AS_DEBUG_LOW_ON) THEN
1891: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1892: 'INCREMENT_CURR_REMINDER: Start');
1893: END IF;
1894:
1895: IF funcmode = 'RUN'

Line 1918: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1914: l_resultout := 'COMPLETE';
1915:
1916: END IF;
1917: IF (AS_DEBUG_LOW_ON) THEN
1918: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1919: 'Result:' || l_resultout);
1920: END IF;
1921: result := l_resultout;
1922: EXCEPTION

Line 1925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1921: result := l_resultout;
1922: EXCEPTION
1923: WHEN OTHERS THEN
1924: IF (AS_DEBUG_LOW_ON) THEN
1925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1926: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1927: END IF;
1928: wf_core.context(
1929: itemtype,

Line 1960: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1956:
1957: BEGIN
1958:
1959: IF (AS_DEBUG_LOW_ON) THEN
1960: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1961: 'INCREMENT_CURR_REROUTES: Start');
1962: END IF;
1963:
1964: IF funcmode = 'RUN'

Line 1988: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1984: where sales_lead_id = l_sales_lead_id;
1985: exception
1986: when others then
1987: IF (AS_DEBUG_LOW_ON) THEN
1988: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1989: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
1990: END IF;
1991: raise;
1992: end;

Line 1999: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1995:
1996: END IF;
1997:
1998: IF (AS_DEBUG_LOW_ON) THEN
1999: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2000: 'Result:' || l_resultout);
2001: END IF;
2002:
2003: result := l_resultout;

Line 2007: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2003: result := l_resultout;
2004: EXCEPTION
2005: WHEN OTHERS THEN
2006: IF (AS_DEBUG_LOW_ON) THEN
2007: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2008: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2009: END IF;
2010: wf_core.context(
2011: itemtype,

Line 2044: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2040: l_due_date Date;
2041: l_total_timelag number;
2042: BEGIN
2043: IF (AS_DEBUG_LOW_ON) THEN
2044: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2045: 'Set_Timeout: Start');
2046: END IF;
2047:
2048: IF funcmode = 'RUN'

Line 2057: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2053: itemkey => itemkey,
2054: aname => 'TIMEOUT_DURATION');
2055:
2056: IF (AS_DEBUG_LOW_ON) THEN
2057: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2058: 'l_timeout_duration:' || l_timeout_duration);
2059: END IF;
2060:
2061: l_monitor_launch_date := wf_engine.GetItemAttrDate(

Line 2078: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2074:
2075: l_timeout_due_date := l_monitor_launch_date + l_total_timelag;
2076:
2077: IF (AS_DEBUG_LOW_ON) THEN
2078: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2079: ' l_timeout_duration_minutes:' || l_timeout_duration_minutes);
2080: END IF;
2081:
2082: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 2102: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2098: l_resultout := 'COMPLETE';
2099:
2100: END IF;
2101: IF (AS_DEBUG_LOW_ON) THEN
2102: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2103: 'Result:' || l_resultout);
2104: END IF;
2105:
2106: result := l_resultout;

Line 2110: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2106: result := l_resultout;
2107: EXCEPTION
2108: WHEN OTHERS THEN
2109: IF (AS_DEBUG_LOW_ON) THEN
2110: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2111: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2112: END IF;
2113: wf_core.context(
2114: itemtype,

Line 2153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2149:
2150:
2151: BEGIN
2152: IF (AS_DEBUG_LOW_ON) THEN
2153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2154: 'Chk_Max_Reroutes: Start');
2155: END IF;
2156:
2157: IF funcmode = 'RUN'

Line 2195: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2191: l_resultout := 'COMPLETE:'||'Y';
2192: end if;
2193: END IF;
2194: IF (AS_DEBUG_LOW_ON) THEN
2195: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2196: 'Result:' || l_resultout);
2197: END IF;
2198:
2199: result := l_resultout;

Line 2203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2199: result := l_resultout;
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: IF (AS_DEBUG_LOW_ON) THEN
2203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2204: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2205: END IF;
2206: wf_core.context(
2207: itemtype,

Line 2269: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2265:
2266: BEGIN
2267:
2268: IF (AS_DEBUG_LOW_ON) THEN
2269: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2270: 'CHK_TIMELAG_CONDITION_TRUE: Start');
2271: END IF;
2272:
2273: IF funcmode = 'RUN'

Line 2528: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2524:
2525: END IF;
2526:
2527: IF (AS_DEBUG_LOW_ON) THEN
2528: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2529: 'Result:' || l_resultout);
2530: END IF;
2531:
2532: result := l_resultout;

Line 2536: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2532: result := l_resultout;
2533: EXCEPTION
2534: WHEN OTHERS THEN
2535: IF (AS_DEBUG_LOW_ON) THEN
2536: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2537: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2538: END IF;
2539: wf_core.context(
2540: itemtype,

Line 2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2683: aname => 'DEFAULT_RESOURCE_SET',
2684: avalue => 'Y');
2685:
2686: IF (AS_DEBUG_LOW_ON) THEN
2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2688: 'Result:' || l_resultout);
2689: END IF;
2690:
2691: l_resultout := 'COMPLETE';

Line 2697: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2693: result := l_resultout;
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: IF (AS_DEBUG_LOW_ON) THEN
2697: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2698: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2699: END IF;
2700: wf_core.context(
2701: itemtype,

Line 2731: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2727: l_default_resource_set varchar2(1);
2728: l_timelag_from_stage varchar2(60);
2729: BEGIN
2730: IF (AS_DEBUG_LOW_ON) THEN
2731: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2732: 'Chk_Restart_Reqd: Start');
2733: END IF;
2734:
2735: IF funcmode = 'RUN'

Line 2761: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2757: end if;
2758: end if;
2759: END IF;
2760: IF (AS_DEBUG_LOW_ON) THEN
2761: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2762: 'Result:' || l_resultout);
2763:
2764: END IF;
2765: result := l_resultout;

Line 2769: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2765: result := l_resultout;
2766: EXCEPTION
2767: WHEN OTHERS THEN
2768: IF (AS_DEBUG_LOW_ON) THEN
2769: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2770: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2771: END IF;
2772: wf_core.context(
2773: itemtype,

Line 2913: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting Matching Monitor ' );

2909: -- If found, then abort earlier process
2910: -- Start New Process
2911: -- ******************************************************************
2912: IF (AS_DEBUG_LOW_ON) THEN
2913: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting Matching Monitor ' );
2914: END IF;
2915: open c_get_matching_monitors1(l_lead_country, l_lead_rank_id , 'ASSIGNED_DATE');
2916: fetch c_get_matching_monitors1 into l_process_rule_id, l_monitor_condition_id, l_time_lag_num;
2917: if c_get_matching_monitors1%NOTFOUND then

Line 2925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );

2921: end if;
2922: close c_get_matching_monitors1;
2923:
2924: IF (AS_DEBUG_LOW_ON) THEN
2925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_monitor_found '||l_monitor_found );
2926: END IF;
2927: --
2928:
2929:

Line 2942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);

2938: aname => 'PROCESS_RULE_ID',
2939: avalue => l_process_rule_id);
2940:
2941: IF (AS_DEBUG_LOW_ON) THEN
2942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);
2943: END IF;
2944:
2945: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2946: itemkey => itemkey,

Line 2997: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2993:
2994: EXCEPTION
2995: WHEN OTHERS THEN
2996: IF (AS_DEBUG_LOW_ON) THEN
2997: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2998: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
2999: END IF;
3000: wf_core.context(
3001: itemtype,

Line 3149: /* IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

3145:
3146: l_matched_GMT_time := to_char(l_matched_GMT_date,'DD-MON-YYYY HH:MI')||' '||'GMT';*/
3147:
3148:
3149: /* IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3150: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3151: fnd_message.Set_Token('TEXT', 'Matched GMT timeout is '|| l_matched_GMT_time);
3152: fnd_msg_pub.Add;
3153: END IF;

Line 3152: fnd_msg_pub.Add;

3148:
3149: /* IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3150: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3151: fnd_message.Set_Token('TEXT', 'Matched GMT timeout is '|| l_matched_GMT_time);
3152: fnd_msg_pub.Add;
3153: END IF;
3154:
3155:
3156:

Line 3265: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_sales_lead_id :' || l_sales_lead_id);

3261: itemkey => itemkey,
3262: aname => 'NOTIFY_LD_OWNR_MANAGER');
3263:
3264: IF (AS_DEBUG_LOW_ON) THEN
3265: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_sales_lead_id :' || l_sales_lead_id);
3266: END IF;
3267:
3268: -- Get Lead Details
3269: open c_get_lead_details(l_sales_lead_id);

Line 3274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_resource_id :' || l_resource_id);

3270: fetch c_get_lead_details into l_assign_date, l_resource_id, l_group_id, l_person_id ;
3271: close c_get_lead_details;
3272:
3273: IF (AS_DEBUG_LOW_ON) THEN
3274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_resource_id :' || l_resource_id);
3275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_group_id :' || l_group_id);
3276: END IF;
3277:
3278:

Line 3275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_group_id :' || l_group_id);

3271: close c_get_lead_details;
3272:
3273: IF (AS_DEBUG_LOW_ON) THEN
3274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_resource_id :' || l_resource_id);
3275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_group_id :' || l_group_id);
3276: END IF;
3277:
3278:
3279: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 3368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '1' || l_notify_role_list);

3364:
3365: end if; -- if fnd user
3366:
3367: IF (AS_DEBUG_LOW_ON) THEN
3368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '1' || l_notify_role_list);
3369: END IF;
3370:
3371: end if; -- if notify_owner
3372:

Line 3470: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '8' || l_notify_role_list);

3466: l_notify_role_list := substr(l_notify_role_list,2);
3467: l_notify_role := 'AML_' || itemKey;
3468:
3469: IF (AS_DEBUG_LOW_ON) THEN
3470: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '8' || l_notify_role_list);
3471: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_notify_role :' || l_notify_role);
3472: END IF;
3473:
3474: -- Create Role

Line 3471: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_notify_role :' || l_notify_role);

3467: l_notify_role := 'AML_' || itemKey;
3468:
3469: IF (AS_DEBUG_LOW_ON) THEN
3470: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '8' || l_notify_role_list);
3471: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_notify_role :' || l_notify_role);
3472: END IF;
3473:
3474: -- Create Role
3475:

Line 3487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After calling adduserstoadhocrole :');

3483: (role_name => l_notify_role,
3484: role_users => l_notify_role_list);
3485:
3486: IF (AS_DEBUG_LOW_ON) THEN
3487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After calling adduserstoadhocrole :');
3488: END IF;
3489:
3490:
3491: wf_engine.SetItemAttrText ( ItemType => itemType,

Line 3497: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After setting notify role value :');

3493: aname => 'NOTIFY_ROLE',
3494: avalue => l_notify_role);
3495:
3496: IF (AS_DEBUG_LOW_ON) THEN
3497: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After setting notify role value :');
3498: END IF;
3499:
3500: exception
3501: when others then

Line 3503: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3499:
3500: exception
3501: when others then
3502: IF (AS_DEBUG_LOW_ON) THEN
3503: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3504: SQLERRM);
3505: END IF;
3506: raise;
3507: