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.AMS_WFMOD_PVT dependencies on AMS_UTILITY_PVT

Line 146: AMS_Utility_PVT.debug_message ('URL: ' || wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), p_itemtype, p_itemkey, 'NO'));

142: , avalue => wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), p_itemtype, p_itemkey, 'NO')
143: );
144:
145: IF (AMS_DEBUG_HIGH_ON) THEN
146: AMS_Utility_PVT.debug_message ('URL: ' || wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), p_itemtype, p_itemkey, 'NO'));
147: END IF;
148:
149: WF_ENGINE.SetItemAttrNumber(
150: itemtype => p_itemtype

Line 173: AMS_Utility_PVT.convert_timezone (

169:
170: -- if needed, convert the time into system time from schedule time zone ??
171: -- for time being, assuming that shedule_date and workflow system date are in
172: -- in same time zone ??
173: AMS_Utility_PVT.convert_timezone (
174: p_init_msg_list => FND_API.G_FALSE,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,
177: x_msg_data => l_msg_data,

Line 188: AMS_Utility_PVT.debug_message ('SYSTEM SCHEDULED - WAIT: ' || TO_CHAR (l_system_scheduled_date, 'DD-MON-RRRR HH24:MI:SS'));

184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: IF (AMS_DEBUG_HIGH_ON) THEN
188: AMS_Utility_PVT.debug_message ('SYSTEM SCHEDULED - WAIT: ' || TO_CHAR (l_system_scheduled_date, 'DD-MON-RRRR HH24:MI:SS'));
189: END IF;
190:
191: WF_ENGINE.SetItemAttrDate(
192: itemtype => p_itemtype

Line 250: AMS_Utility_PVT.debug_message ('REQUEST_TYPE: ' || p_request_type);

246: END IF;
247: END IF;
248:
249: IF (AMS_DEBUG_HIGH_ON) THEN
250: AMS_Utility_PVT.debug_message ('REQUEST_TYPE: ' || p_request_type);
251: AMS_Utility_PVT.debug_message ('ORIG_USER_STATUS_ID: ' || p_user_status_id);
252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));
253: END IF;
254:

Line 251: AMS_Utility_PVT.debug_message ('ORIG_USER_STATUS_ID: ' || p_user_status_id);

247: END IF;
248:
249: IF (AMS_DEBUG_HIGH_ON) THEN
250: AMS_Utility_PVT.debug_message ('REQUEST_TYPE: ' || p_request_type);
251: AMS_Utility_PVT.debug_message ('ORIG_USER_STATUS_ID: ' || p_user_status_id);
252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));
253: END IF;
254:
255: END Initialize_Var ;

Line 252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));

248:
249: IF (AMS_DEBUG_HIGH_ON) THEN
250: AMS_Utility_PVT.debug_message ('REQUEST_TYPE: ' || p_request_type);
251: AMS_Utility_PVT.debug_message ('ORIG_USER_STATUS_ID: ' || p_user_status_id);
252: AMS_Utility_PVT.debug_message ('STATUS_CODE: ' || WF_ENGINE.GetItemAttrText(itemtype => p_itemtype, itemkey => p_itemkey, aname => 'STATUS_CODE'));
253: END IF;
254:
255: END Initialize_Var ;
256:

Line 330: AMS_Utility_PVT.create_log (

326: BEGIN
327: -- clear the message buffer
328: FND_MSG_PUB.initialize;
329:
330: AMS_Utility_PVT.create_log (
331: x_return_status => l_return_status,
332: p_arc_log_used_by => p_object_type,
333: p_log_used_by_id => p_object_id,
334: p_msg_data => L_API_NAME || ': begin ' || itemkey

Line 345: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_model_owner%NOTFOUND');

341: FETCH c_get_model_owner INTO l_owner_user_id;
342:
343: IF c_get_model_owner%NOTFOUND THEN
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_model_owner%NOTFOUND');
346: END IF;
347:
348: x_itemkey := NULL;
349:

Line 361: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_score_owner%NOTFOUND');

357: FETCH c_get_score_owner INTO l_owner_user_id;
358:
359: IF c_get_score_owner%NOTFOUND THEN
360: IF (AMS_DEBUG_HIGH_ON) THEN
361: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_score_owner%NOTFOUND');
362: END IF;
363:
364: x_itemkey := NULL;
365:

Line 380: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Failed. ');

376: x_return_status => l_return_status);
377:
378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
379: IF (AMS_DEBUG_HIGH_ON) THEN
380: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Failed. ');
381: END IF;
382:
383: x_itemkey := NULL;
384: ELSE

Line 387: Ams_Utility_pvt.debug_message('ITEMTYPE: ' || l_itemtype || ' - ITEMKEY: ' || itemkey);

383: x_itemkey := NULL;
384: ELSE
385:
386: IF (AMS_DEBUG_HIGH_ON) THEN
387: Ams_Utility_pvt.debug_message('ITEMTYPE: ' || l_itemtype || ' - ITEMKEY: ' || itemkey);
388: END IF;
389:
390: -- dbms_output.put_line('Start');
391: WF_ENGINE.CreateProcess ( itemtype => l_itemtype

Line 426: AMS_Utility_PVT.create_log (

422: END IF;
423:
424: write_buffer_to_log (p_object_type, p_object_id);
425:
426: AMS_Utility_PVT.create_log (
427: x_return_status => l_return_status,
428: p_arc_log_used_by => p_object_type,
429: p_log_used_by_id => p_object_id,
430: p_msg_data => L_API_NAME || ': end'

Line 504: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

500: --
501: -- RUN mode - normal process execution
502: --
503: IF (AMS_DEBUG_HIGH_ON) THEN
504: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
505: END IF;
506:
507: IF (funcmode = 'RUN') THEN
508: --

Line 642: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

638: , aname => 'OBJECT_TYPE'
639: );
640:
641: IF (AMS_DEBUG_HIGH_ON) THEN
642: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
643: END IF;
644:
645: -- RUN mode - Normal Process Execution
646: IF (funcmode = 'RUN') THEN

Line 659: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_model_details%NOTFOUND');

655: , l_target_active_flag;
656:
657: IF c_get_model_details%NOTFOUND THEN
658: IF (AMS_DEBUG_HIGH_ON) THEN
659: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_model_details%NOTFOUND');
660: END IF;
661: l_result_flag := 'F';
662: END IF;
663: CLOSE c_get_model_details;

Line 676: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_score_details%NOTFOUND');

672: , l_target_active_flag;
673:
674: IF c_get_score_details%NOTFOUND THEN
675: IF (AMS_DEBUG_HIGH_ON) THEN
676: AMS_Utility_PVT.debug_message (L_API_NAME || ' - c_get_score_details%NOTFOUND');
677: END IF;
678: l_result_flag := 'F';
679: END IF;
680: CLOSE c_get_score_details;

Line 684: AMS_Utility_PVT.debug_message (L_API_NAME || ' - OBJECT_TYPE: ' || l_object_type);

680: CLOSE c_get_score_details;
681: ELSE
682:
683: IF (AMS_DEBUG_HIGH_ON) THEN
684: AMS_Utility_PVT.debug_message (L_API_NAME || ' - OBJECT_TYPE: ' || l_object_type);
685: END IF;
686:
687: l_result_flag := 'F';
688: END IF;

Line 692: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Cannot proceed, the target is inactive...');

688: END IF;
689:
690: IF l_target_active_flag = 'N' THEN
691: IF (AMS_DEBUG_HIGH_ON) THEN
692: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Cannot proceed, the target is inactive...');
693: END IF;
694: AMS_Utility_PVT.error_message ('AMS_MODEL_TARGET_DISABLED');
695: l_result_flag := 'F';
696: END IF;

Line 694: AMS_Utility_PVT.error_message ('AMS_MODEL_TARGET_DISABLED');

690: IF l_target_active_flag = 'N' THEN
691: IF (AMS_DEBUG_HIGH_ON) THEN
692: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Cannot proceed, the target is inactive...');
693: END IF;
694: AMS_Utility_PVT.error_message ('AMS_MODEL_TARGET_DISABLED');
695: l_result_flag := 'F';
696: END IF;
697:
698: IF (AMS_DEBUG_HIGH_ON) THEN

Line 699: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT_FLAG: ' || l_result_flag);

695: l_result_flag := 'F';
696: END IF;
697:
698: IF (AMS_DEBUG_HIGH_ON) THEN
699: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT_FLAG: ' || l_result_flag);
700: END IF;
701:
702: -- Set all derived attirbutes, True status if result flag is true otherwise set False status
703: IF (l_result_flag = 'F') THEN

Line 718: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Failed. Result= ' || result);

714:
715: result := 'COMPLETE:F';
716:
717: IF (AMS_DEBUG_HIGH_ON) THEN
718: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Failed. Result= ' || result);
719: END IF;
720: ELSE
721:
722: IF (AMS_DEBUG_HIGH_ON) THEN

Line 723: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Succeeded. ' );

719: END IF;
720: ELSE
721:
722: IF (AMS_DEBUG_HIGH_ON) THEN
723: AMS_Utility_PVT.debug_message (L_API_NAME || ' - Get_User_Role Succeeded. ' );
724: END IF;
725:
726: WF_ENGINE.SetItemAttrText (
727: itemtype => itemtype

Line 778: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

774: result := '';
775: END IF;
776:
777: IF (AMS_DEBUG_HIGH_ON) THEN
778: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
779: END IF;
780:
781: write_buffer_to_log (l_object_type, l_object_id);
782:

Line 864: AMS_Utility_PVT.create_log (

860: , itemkey => itemkey
861: , aname => 'OBJECT_TYPE'
862: );
863:
864: AMS_Utility_PVT.create_log (
865: x_return_status => l_return_status,
866: p_arc_log_used_by => l_object_type,
867: p_log_used_by_id => l_object_id,
868: p_msg_data => L_API_NAME || ': begin'

Line 871: AMS_Utility_PVT.create_log (

867: p_log_used_by_id => l_object_id,
868: p_msg_data => L_API_NAME || ': begin'
869: );
870:
871: AMS_Utility_PVT.create_log (
872: x_return_status => l_return_status,
873: p_arc_log_used_by => l_object_type,
874: p_log_used_by_id => l_object_id,
875: p_msg_data => L_API_NAME || ' - FUNCMODE: ' || funcmode

Line 921: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

917: result := '';
918: END IF;
919:
920: IF (AMS_DEBUG_HIGH_ON) THEN
921: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
922: END IF;
923:
924: write_buffer_to_log (l_object_type, l_object_id);
925:

Line 926: AMS_Utility_PVT.create_log (

922: END IF;
923:
924: write_buffer_to_log (l_object_type, l_object_id);
925:
926: AMS_Utility_PVT.create_log (
927: x_return_status => l_return_status,
928: p_arc_log_used_by => l_object_type,
929: p_log_used_by_id => l_object_id,
930: p_msg_data => L_API_NAME || ': end'

Line 940: AMS_Utility_PVT.create_log (

936: END IF;
937:
938: write_buffer_to_log (l_object_type, l_object_id);
939:
940: AMS_Utility_PVT.create_log (
941: x_return_status => l_return_status,
942: p_arc_log_used_by => l_object_type,
943: p_log_used_by_id => l_object_id,
944: p_msg_data => L_API_NAME || ': EXCEPTION BUFFER WRITTEN'

Line 1044: AMS_Utility_PVT.create_log (

1040: , itemkey => itemkey
1041: , aname => 'OBJECT_TYPE'
1042: );
1043:
1044: AMS_Utility_PVT.create_log (
1045: x_return_status => l_log_return_status,
1046: p_arc_log_used_by => l_object_type,
1047: p_log_used_by_id => l_object_id,
1048: p_msg_data => L_API_NAME || ': begin'

Line 1051: AMS_Utility_PVT.create_log (

1047: p_log_used_by_id => l_object_id,
1048: p_msg_data => L_API_NAME || ': begin'
1049: );
1050:
1051: AMS_Utility_PVT.create_log (
1052: x_return_status => l_log_return_status,
1053: p_arc_log_used_by => l_object_type,
1054: p_log_used_by_id => l_object_id,
1055: p_msg_data => L_API_NAME || ' - FUNCMODE: ' || funcmode

Line 1098: AMS_Utility_PVT.create_log (

1094: , x_msg_count => l_msg_count
1095: , x_msg_data => l_msg_data
1096: );
1097:
1098: AMS_Utility_PVT.create_log (
1099: x_return_status => l_log_return_status,
1100: p_arc_log_used_by => l_object_type,
1101: p_log_used_by_id => l_object_id,
1102: p_msg_data => ' After generate_odm_input_views status ' || l_return_status

Line 1176: AMS_Utility_PVT.create_log (

1172: END IF;
1173:
1174: write_buffer_to_log (l_object_type, l_object_id);
1175:
1176: AMS_Utility_PVT.create_log (
1177: x_return_status => l_log_return_status,
1178: p_arc_log_used_by => l_object_type,
1179: p_log_used_by_id => l_object_id,
1180: p_msg_data => L_API_NAME || ' - RESULT: ' || result

Line 1183: AMS_Utility_PVT.create_log (

1179: p_log_used_by_id => l_object_id,
1180: p_msg_data => L_API_NAME || ' - RESULT: ' || result
1181: );
1182:
1183: AMS_Utility_PVT.create_log (
1184: x_return_status => l_log_return_status,
1185: p_arc_log_used_by => l_object_type,
1186: p_log_used_by_id => l_object_id,
1187: p_msg_data => L_API_NAME || ': end'

Line 1290: AMS_Utility_PVT.create_log (

1286: , itemkey => itemkey
1287: , aname => 'OBJECT_TYPE'
1288: );
1289:
1290: AMS_Utility_PVT.create_log (
1291: x_return_status => l_return_status,
1292: p_arc_log_used_by => l_object_type,
1293: p_log_used_by_id => l_object_id,
1294: p_msg_data => L_API_NAME || ': begin'

Line 1298: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

1294: p_msg_data => L_API_NAME || ': begin'
1295: );
1296:
1297: IF (AMS_DEBUG_HIGH_ON) THEN
1298: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
1299: END IF;
1300:
1301: -- RUN mode - Normal Process Execution
1302: IF (funcmode = 'RUN') THEN

Line 1355: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_ID: ' || l_request_id);

1351: );
1352: END IF;
1353:
1354: IF (AMS_DEBUG_HIGH_ON) THEN
1355: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_ID: ' || l_request_id);
1356: END IF;
1357:
1358: IF l_request_id <> 0 THEN
1359: WF_ENGINE.SetItemAttrNumber(

Line 1371: AMS_Utility_PVT.create_log (

1367: -- so concurrent manager will see the request,
1368: -- otherwise, the process will hang.
1369: COMMIT;
1370:
1371: AMS_Utility_PVT.create_log (
1372: x_return_status => l_return_status,
1373: p_arc_log_used_by => l_object_type,
1374: p_log_used_by_id => l_object_id,
1375: p_msg_data => L_API_NAME || ': REQUEST_ID - ' || l_request_id

Line 1391: AMS_Utility_PVT.create_log (

1387:
1388: IF l_dev_status = 'NORMAL' THEN
1389: result := 'COMPLETE:SUCCESS' ;
1390: ELSE
1391: AMS_Utility_PVT.create_log (
1392: x_return_status => l_return_status,
1393: p_arc_log_used_by => l_object_type,
1394: p_log_used_by_id => l_object_id,
1395: p_msg_data => L_API_NAME || ' - CONCURRENT REQUEST ERROR: ' || l_message

Line 1397: -- AMS_Utility_PVT.error_message ( L_API_NAME || '- CONCURRENT REQUEST ERROR: ' || l_message);

1393: p_arc_log_used_by => l_object_type,
1394: p_log_used_by_id => l_object_id,
1395: p_msg_data => L_API_NAME || ' - CONCURRENT REQUEST ERROR: ' || l_message
1396: );
1397: -- AMS_Utility_PVT.error_message ( L_API_NAME || '- CONCURRENT REQUEST ERROR: ' || l_message);
1398:
1399: /* populate status to DRAFT */
1400: WF_ENGINE.SetItemAttrText(
1401: itemtype => itemtype

Line 1409: AMS_Utility_PVT.create_log (

1405: );
1406: result := 'COMPLETE:FAILURE' ;
1407: END IF;
1408: ELSE
1409: AMS_Utility_PVT.create_log (
1410: x_return_status => l_return_status,
1411: p_arc_log_used_by => l_object_type,
1412: p_log_used_by_id => l_object_id,
1413: p_msg_data => L_API_NAME || '- NO CONCURRENT REQUEST '

Line 1415: -- AMS_Utility_PVT.error_message ( L_API_NAME || ' - NO CONCURRENT REQUEST');

1411: p_arc_log_used_by => l_object_type,
1412: p_log_used_by_id => l_object_id,
1413: p_msg_data => L_API_NAME || '- NO CONCURRENT REQUEST '
1414: );
1415: -- AMS_Utility_PVT.error_message ( L_API_NAME || ' - NO CONCURRENT REQUEST');
1416:
1417: /* populate status to DRAFT */
1418: WF_ENGINE.SetItemAttrText(
1419: itemtype => itemtype

Line 1442: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

1438: result := '';
1439: END IF;
1440:
1441: IF (AMS_DEBUG_HIGH_ON) THEN
1442: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
1443: END IF;
1444:
1445: write_buffer_to_log (l_object_type, l_object_id);
1446:

Line 1447: AMS_Utility_PVT.create_log (

1443: END IF;
1444:
1445: write_buffer_to_log (l_object_type, l_object_id);
1446:
1447: AMS_Utility_PVT.create_log (
1448: x_return_status => l_return_status,
1449: p_arc_log_used_by => l_object_type,
1450: p_log_used_by_id => l_object_id,
1451: p_msg_data => L_API_NAME || ': end'

Line 1558: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

1554: IF (AMS_DEBUG_HIGH_ON) THEN
1555:
1556:
1557:
1558: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
1559:
1560: END IF;
1561: -- RUN mode - Normal Process Execution
1562: IF (funcmode = 'RUN') THEN

Line 1576: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RETURN_STATUS: ' || l_return_status);

1572: , x_msg_data => l_msg_data
1573: );
1574: IF (AMS_DEBUG_HIGH_ON) THEN
1575:
1576: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RETURN_STATUS: ' || l_return_status);
1577: END IF;
1578: IF NVL(l_return_status,'E') = 'Y' THEN
1579: result := 'COMPLETE:YES' ;
1580: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1582: AMS_Utility_PVT.debug_message (L_API_NAME || ' - AQ MESG: ' || l_message);

1578: IF NVL(l_return_status,'E') = 'Y' THEN
1579: result := 'COMPLETE:YES' ;
1580: IF (AMS_DEBUG_HIGH_ON) THEN
1581:
1582: AMS_Utility_PVT.debug_message (L_API_NAME || ' - AQ MESG: ' || l_message);
1583: END IF;
1584: ELSIF NVL(l_return_status,'E') = 'N' THEN
1585: result := 'COMPLETE:NO' ;
1586: WF_ENGINE.SetItemAttrText(

Line 1620: AMS_Utility_PVT.error_message ('AMS_DM_DDML_ERROR', 'ERROR_MESSAGE', l_message);

1616: , itemkey => itemkey
1617: , aname => 'STATUS_CODE'
1618: , avalue => G_STATUS_DRAFT
1619: );
1620: AMS_Utility_PVT.error_message ('AMS_DM_DDML_ERROR', 'ERROR_MESSAGE', l_message);
1621: END IF; --IF NVL(l_return_status,'E') = 'Y' THEN
1622: -- CANCEL mode - Normal Process Execution
1623: ELSIF (funcmode = 'CANCEL') THEN
1624: result := 'COMPLETE' ;

Line 1641: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

1637: IF (AMS_DEBUG_HIGH_ON) THEN
1638:
1639:
1640:
1641: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
1642:
1643: END IF;
1644:
1645: write_buffer_to_log (l_object_type, l_object_id);

Line 1725: AMS_Utility_PVT.create_log (

1721: , itemkey => itemkey
1722: , aname => 'OBJECT_TYPE'
1723: );
1724:
1725: AMS_Utility_PVT.create_log (
1726: x_return_status => l_return_status,
1727: p_arc_log_used_by => l_object_type,
1728: p_log_used_by_id => l_object_id,
1729: p_msg_data => L_API_NAME || ': begin'

Line 1733: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

1729: p_msg_data => L_API_NAME || ': begin'
1730: );
1731:
1732: IF (AMS_DEBUG_HIGH_ON) THEN
1733: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
1734: END IF;
1735:
1736: -- RUN mode - Normal Process Execution
1737: IF (funcmode = 'RUN') THEN

Line 1768: AMS_Utility_PVT.create_log (

1764: );
1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: result := 'COMPLETE:FAILURE' ;
1767:
1768: AMS_Utility_PVT.create_log (
1769: x_return_status => l_return_status,
1770: p_arc_log_used_by => l_object_type,
1771: p_log_used_by_id => l_object_id,
1772: p_msg_data => 'L_API_NAME: AMS_DMSource_PVT.process_scores Failed'

Line 1883: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

1879: result := '';
1880: END IF;
1881:
1882: IF (AMS_DEBUG_HIGH_ON) THEN
1883: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
1884: END IF;
1885:
1886: write_buffer_to_log (l_object_type, l_object_id);
1887:

Line 1888: AMS_Utility_PVT.create_log (

1884: END IF;
1885:
1886: write_buffer_to_log (l_object_type, l_object_id);
1887:
1888: AMS_Utility_PVT.create_log (
1889: x_return_status => l_return_status,
1890: p_arc_log_used_by => l_object_type,
1891: p_log_used_by_id => l_object_id,
1892: p_msg_data => L_API_NAME || ': end'

Line 1982: AMS_Utility_PVT.create_log (

1978: , itemkey => itemkey
1979: , aname => 'REQUEST_TYPE'
1980: );
1981:
1982: AMS_Utility_PVT.create_log (
1983: x_return_status => l_return_status,
1984: p_arc_log_used_by => l_object_type,
1985: p_log_used_by_id => l_object_id,
1986: p_msg_data => L_API_NAME || ': begin'

Line 1990: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);

1986: p_msg_data => L_API_NAME || ': begin'
1987: );
1988:
1989: IF (AMS_DEBUG_HIGH_ON) THEN
1990: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || funcmode);
1991: END IF;
1992:
1993: -- RUN mode - Normal Process Execution
1994: IF (funcmode = 'RUN') THEN

Line 2002: AMS_Utility_PVT.create_log (

1998: , aname => 'STATUS_CODE'
1999: );
2000:
2001:
2002: AMS_Utility_PVT.create_log (
2003: x_return_status => l_return_status,
2004: p_arc_log_used_by => l_object_type,
2005: p_log_used_by_id => l_object_id,
2006: p_msg_data => L_API_NAME || ': ' || l_object_status

Line 2010: AMS_Utility_PVT.debug_message (L_API_NAME || ' - OBJECT_STATUS: ' || l_object_status);

2006: p_msg_data => L_API_NAME || ': ' || l_object_status
2007: );
2008:
2009: IF (AMS_DEBUG_HIGH_ON) THEN
2010: AMS_Utility_PVT.debug_message (L_API_NAME || ' - OBJECT_STATUS: ' || l_object_status);
2011: END IF;
2012:
2013: -- l_object_status is set to either DRAFT when preview process
2014: -- finishes or AVAILABLE when the build process is completed successfully

Line 2091: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);

2087: result := '';
2088: END IF;
2089:
2090: IF (AMS_DEBUG_HIGH_ON) THEN
2091: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || result);
2092: END IF;
2093:
2094: write_buffer_to_log (l_object_type, l_object_id);
2095:

Line 2096: AMS_Utility_PVT.create_log (

2092: END IF;
2093:
2094: write_buffer_to_log (l_object_type, l_object_id);
2095:
2096: AMS_Utility_PVT.create_log (
2097: x_return_status => l_return_status,
2098: p_arc_log_used_by => l_object_type,
2099: p_log_used_by_id => l_object_id,
2100: p_msg_data => L_API_NAME || ': end'

Line 2193: Ams_Utility_PVT.Create_Log (

2189:
2190: l_msg_count := FND_MSG_PUB.count_msg;
2191: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
2192: l_msg_data := FND_MSG_PUB.get(i, FND_API.G_FALSE);
2193: Ams_Utility_PVT.Create_Log (
2194: x_return_status => l_return_status_log
2195: , p_arc_log_used_by => p_object_type
2196: , p_log_used_by_id => p_object_id
2197: , p_msg_data => l_msg_data

Line 2291: AMS_Utility_PVT.convert_timezone (

2287: , itemkey => p_itemkey
2288: , aname => 'ORIG_USER_STATUS_ID'
2289: );
2290:
2291: AMS_Utility_PVT.convert_timezone (
2292: p_init_msg_list => FND_API.G_FALSE,
2293: x_return_status => x_return_status,
2294: x_msg_count => l_msg_count,
2295: x_msg_data => l_msg_data,

Line 2416: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || p_funcmode);

2412: , aname => 'REQUEST_TYPE'
2413: );
2414:
2415: IF (AMS_DEBUG_HIGH_ON) THEN
2416: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || p_funcmode);
2417: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_TYPE: ' || l_request_type);
2418: AMS_Utility_PVT.debug_message (L_API_NAME || ' - itemkey: ' || p_itemkey);
2419: END IF;
2420:

Line 2417: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_TYPE: ' || l_request_type);

2413: );
2414:
2415: IF (AMS_DEBUG_HIGH_ON) THEN
2416: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || p_funcmode);
2417: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_TYPE: ' || l_request_type);
2418: AMS_Utility_PVT.debug_message (L_API_NAME || ' - itemkey: ' || p_itemkey);
2419: END IF;
2420:
2421: IF (p_funcmode = 'RUN') THEN

Line 2418: AMS_Utility_PVT.debug_message (L_API_NAME || ' - itemkey: ' || p_itemkey);

2414:
2415: IF (AMS_DEBUG_HIGH_ON) THEN
2416: AMS_Utility_PVT.debug_message (L_API_NAME || ' - FUNCMODE: ' || p_funcmode);
2417: AMS_Utility_PVT.debug_message (L_API_NAME || ' - REQUEST_TYPE: ' || l_request_type);
2418: AMS_Utility_PVT.debug_message (L_API_NAME || ' - itemkey: ' || p_itemkey);
2419: END IF;
2420:
2421: IF (p_funcmode = 'RUN') THEN
2422:

Line 2437: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' Other Model/Score in Progress');

2433: -- If there is a Model or Scoring Run that is in progress.
2434: --IF (l_model_wf_itemkey IS NOT NULL) OR (l_score_wf_itemkey IS NOT NULL) THEN
2435:
2436: -- IF (AMS_DEBUG_HIGH_ON) THEN
2437: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' Other Model/Score in Progress');
2438: -- END IF;
2439:
2440: -- IF l_model_wf_itemkey IS NOT NULL THEN
2441: -- l_temp_wf_itemkey := l_model_wf_itemkey;

Line 2447: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' Other Model/Score wf_itemkey: ' || l_temp_wf_itemkey);

2443: -- l_temp_wf_itemkey := l_score_wf_itemkey;
2444: -- END IF;
2445:
2446: -- IF (AMS_DEBUG_HIGH_ON) THEN
2447: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' Other Model/Score wf_itemkey: ' || l_temp_wf_itemkey);
2448: -- END IF;
2449:
2450: -- If we are handling a Preview request, then check if the other Model/Scoring Run
2451: -- in progress has finished the aggregate_sources step.

Line 2459: -- AMS_Utility_PVT.debug_message(L_API_NAME || ': ' || ' l_preview_status (' || l_preview_status || ')');

2455: -- , itemkey => l_temp_wf_itemkey
2456: -- , aname => 'REQUEST_TYPE'
2457: -- );
2458: -- IF (AMS_DEBUG_HIGH_ON) THEN
2459: -- AMS_Utility_PVT.debug_message(L_API_NAME || ': ' || ' l_preview_status (' || l_preview_status || ')');
2460: -- END IF;
2461:
2462: --IF l_preview_status = G_PREVIEW_STARTED OR l_preview_status = '' OR l_preview_status IS NULL THEN
2463: -- The other model/scoring run has not yet finished the aggregate_sources step,

Line 2487: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' l_next_date ' || l_next_date);

2483: -- , avalue => l_next_date
2484: -- );
2485:
2486: -- IF (AMS_DEBUG_HIGH_ON) THEN
2487: -- AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || ' l_next_date ' || l_next_date);
2488: -- END IF;
2489:
2490: --ELSE
2491: -- No Model/Scoring Run in progress.

Line 2527: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || x_result);

2523: x_result := '';
2524: END IF; -- funcmode
2525:
2526: IF (AMS_DEBUG_HIGH_ON) THEN
2527: AMS_Utility_PVT.debug_message (L_API_NAME || ' - RESULT: ' || x_result);
2528: END IF;
2529:
2530: COMMIT; -- otherwise, the changes don't reflect in UI
2531:

Line 2604: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);

2600: );
2601:
2602:
2603: IF (AMS_DEBUG_HIGH_ON) THEN
2604: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);
2605: END IF;
2606:
2607: -- RUN mode - Normal Process Execution
2608: IF (p_funcmode = 'RUN') THEN

Line 2658: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);

2654: x_result := '';
2655: END IF;
2656:
2657: IF (AMS_DEBUG_HIGH_ON) THEN
2658: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);
2659: END IF;
2660:
2661: write_buffer_to_log (l_object_type, l_object_id);
2662:

Line 2753: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);

2749:
2750:
2751:
2752: IF (AMS_DEBUG_HIGH_ON) THEN
2753: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);
2754: END IF;
2755:
2756: -- RUN mode - Normal Process Execution
2757: IF (p_funcmode = 'RUN') THEN

Line 2799: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);

2795: x_result := '';
2796: END IF;
2797:
2798: IF (AMS_DEBUG_HIGH_ON) THEN
2799: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);
2800: END IF;
2801:
2802: write_buffer_to_log (l_object_type, l_object_id);
2803:

Line 2942: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);

2938:
2939:
2940:
2941: IF (AMS_DEBUG_HIGH_ON) THEN
2942: AMS_Utility_PVT.debug_message (L_API_NAME || ' BEGIN - FUNCMODE: ' || p_funcmode);
2943: END IF;
2944:
2945: -- RUN mode - Normal Process Execution
2946: IF (p_funcmode = 'RUN') THEN

Line 2965: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' ERROR: Target is disabled, cannot preview/build/score');

2961: x_is_enabled => l_is_enabled
2962: );
2963: IF l_is_enabled = FALSE THEN
2964: IF (AMS_DEBUG_HIGH_ON) THEN
2965: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' ERROR: Target is disabled, cannot preview/build/score');
2966: END IF;
2967: AMS_Utility_PVT.create_log (
2968: x_return_status => l_return_status,
2969: p_arc_log_used_by => l_object_type,

Line 2967: AMS_Utility_PVT.create_log (

2963: IF l_is_enabled = FALSE THEN
2964: IF (AMS_DEBUG_HIGH_ON) THEN
2965: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' ERROR: Target is disabled, cannot preview/build/score');
2966: END IF;
2967: AMS_Utility_PVT.create_log (
2968: x_return_status => l_return_status,
2969: p_arc_log_used_by => l_object_type,
2970: p_log_used_by_id => l_object_id,
2971: p_msg_data => L_API_NAME || ' ERROR: Target is disabled, cannot preview/build/score '

Line 2986: AMS_Utility_PVT.create_log (

2982: x_return_status => l_return_status,
2983: x_model_status => l_model_status
2984: );
2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2986: AMS_Utility_PVT.create_log (
2987: x_return_status => l_return_status,
2988: p_arc_log_used_by => 'SCOR',
2989: p_log_used_by_id => l_object_id,
2990: p_msg_data => L_API_NAME || ' ERROR: Model Status is ' || l_model_status

Line 3020: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);

3016: x_result := '';
3017: END IF;
3018:
3019: IF (AMS_DEBUG_HIGH_ON) THEN
3020: AMS_Utility_PVT.debug_message (L_API_NAME || ' END - RESULT: ' || x_result);
3021: END IF;
3022:
3023: write_buffer_to_log (l_object_type, l_object_id);
3024: