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.OZF_APPROVAL_PVT dependencies on OZF_UTILITY_PVT

Line 161: ozf_utility_pvt.debug_message( l_api_name||': Start');

157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159: -- Debug Message
160: IF G_DEBUG THEN
161: ozf_utility_pvt.debug_message( l_api_name||': Start');
162: END IF;
163: --Initialize message list if p_init_msg_list is TRUE.
164: IF FND_API.To_Boolean (p_init_msg_list) THEN
165: FND_MSG_PUB.initialize;

Line 293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );

289: CLOSE csr_check_reassign_level;
290:
291: -- Debug Message
292: IF G_DEBUG THEN
293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );

Line 294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );

290:
291: -- Debug Message
292: IF G_DEBUG THEN
293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );

Line 295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );

291: -- Debug Message
292: IF G_DEBUG THEN
293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );

Line 296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );

292: IF G_DEBUG THEN
293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );

Line 297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );

293: ozf_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );

Line 298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );

294: ozf_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
302: END IF;

Line 299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );

295: ozf_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
302: END IF;
303:

Line 300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );

296: ozf_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
302: END IF;
303:
304: /*

Line 301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );

297: ozf_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
298: ozf_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
299: ozf_utility_pvt.debug_message( 'Is Super User ' || l_is_super_user );
300: ozf_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
301: ozf_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
302: END IF;
303:
304: /*
305: Check for minimum Reassign Level is added because , if it is 0 then the case is No AME Rule was

Line 392: ozf_utility_pvt.debug_message( 'Revoke Access ' || p_approval_rec.action_code );

388: );
389: end if; -- End if minimum reassign Level not 0
390:
391: IF G_DEBUG THEN
392: ozf_utility_pvt.debug_message( 'Revoke Access ' || p_approval_rec.action_code );
393: END IF;
394: -- Revoke_Access - Revoke acces to previous appprovers in the chain
395: Revoke_Access(
396: p_api_version => p_api_version

Line 424: ozf_utility_pvt.debug_message( l_api_name||': End');

420: END IF;
421:
422: -- Debug Message
423: IF G_DEBUG THEN
424: ozf_utility_pvt.debug_message( l_api_name||': End');
425: END IF;
426: --Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,

Line 522: ozf_utility_pvt.debug_message( l_api_name||': Start');

518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: END IF;
520: -- Debug Message
521: IF G_DEBUG THEN
522: ozf_utility_pvt.debug_message( l_api_name||': Start');
523: END IF;
524: --Initialize message list if p_init_msg_list is TRUE.
525: IF FND_API.To_Boolean (p_init_msg_list) THEN
526: FND_MSG_PUB.initialize;

Line 552: ozf_utility_pvt.debug_message( 'AME did not return any approvers');

548: l_next_approver.user_id IS NULL AND
549: l_next_approver.approval_status IS NULL
550: THEN
551: IF G_DEBUG THEN
552: ozf_utility_pvt.debug_message( 'AME did not return any approvers');
553: END IF;
554:
555: -- If first approval, get default approver from profile
556: IF p_approval_rec.action_code = 'SUBMIT' THEN

Line 558: ozf_utility_pvt.debug_message( 'Defulting to 1 as default approver');

554:
555: -- If first approval, get default approver from profile
556: IF p_approval_rec.action_code = 'SUBMIT' THEN
557: IF G_DEBUG THEN
558: ozf_utility_pvt.debug_message( 'Defulting to 1 as default approver');
559: END IF;
560: -- Get default approver
561: x_approvers := approvers_tbl_type ();
562: x_approvers.extend;

Line 595: ozf_utility_pvt.debug_message( 'Setting to final approval');

591:
592: -- If final approval, convey that information
593: IF p_approval_rec.action_code = 'APPROVE' THEN
594: IF G_DEBUG THEN
595: ozf_utility_pvt.debug_message( 'Setting to final approval');
596: END IF;
597: x_final_approval_flag := 'Y';
598: END IF;
599: ELSE

Line 602: l_resource_id := ozf_utility_pvt.get_resource_id (l_next_approver.user_id);

598: END IF;
599: ELSE
600: /*
601: -- Get resoutce id
602: l_resource_id := ozf_utility_pvt.get_resource_id (l_next_approver.user_id);
603:
604: -- raise error if resource is null
605: IF l_resource_id IS NULL THEN
606: IF OZF_ERROR_ON THEN

Line 607: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');

603:
604: -- raise error if resource is null
605: IF l_resource_id IS NULL THEN
606: IF OZF_ERROR_ON THEN
607: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
608: x_return_status := FND_API.g_ret_sts_error;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;

Line 615: ozf_utility_pvt.debug_message( 'AME returned approvers');

611: END IF;
612: */
613:
614: IF G_DEBUG THEN
615: ozf_utility_pvt.debug_message( 'AME returned approvers');
616: END IF;
617: x_final_approval_flag := 'N';
618: -- Construct the out record of approvers
619: x_approvers := approvers_tbl_type ();

Line 634: ozf_utility_pvt.debug_message( l_api_name||': End' || x_approvers(1).approver_id);

630:
631: -- Debug Message
632: /*
633: IF G_DEBUG THEN
634: ozf_utility_pvt.debug_message( l_api_name||': End' || x_approvers(1).approver_id);
635: END IF;
636: */
637: --Standard call to get message count and if count=1, get the message
638: FND_MSG_PUB.Count_And_Get (

Line 724: ozf_utility_pvt.debug_message( l_api_name||': Start');

720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: END IF;
722: -- Debug Message
723: IF G_DEBUG THEN
724: ozf_utility_pvt.debug_message( l_api_name||': Start');
725: END IF;
726: --Initialize message list if p_init_msg_list is TRUE.
727: IF FND_API.To_Boolean (p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;

Line 740: ozf_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');

736: CLOSE c_id;
737:
738: IF p_approval_rec.object_type IS NULL THEN
739: IF OZF_ERROR_ON THEN
740: ozf_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');
741: x_return_status := FND_API.g_ret_sts_error;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: END IF;

Line 748: ozf_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');

744: END IF;
745:
746: IF p_approval_rec.object_id IS NULL THEN
747: IF OZF_ERROR_ON THEN
748: ozf_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');
749: x_return_status := FND_API.g_ret_sts_error;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: END IF;

Line 758: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_USER');

754: -- Validate if the approvers record is valid
755: FOR i in 1..p_approvers.count LOOP
756: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
757: IF OZF_ERROR_ON THEN
758: ozf_utility_pvt.error_message('OZF_APPROVER_NOT_USER');
759: x_return_status := FND_API.g_ret_sts_error;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;

Line 765: -- ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');

761: END IF;
762: END IF;
763: --IF NOT resource_valid(p_approvers(i).approver_id) THEN
764: -- IF OZF_ERROR_ON THEN
765: -- ozf_utility_pvt.error_message('OZF_APPROVER_NOT_RESOURCE');
766: -- x_return_status := FND_API.g_ret_sts_error;
767: -- RAISE FND_API.G_EXC_ERROR;
768: -- END IF;
769: --END IF;

Line 772: ozf_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');

768: -- END IF;
769: --END IF;
770: IF p_approvers(i).approver_level IS NULL THEN
771: IF OZF_ERROR_ON THEN
772: ozf_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');
773: x_return_status := FND_API.g_ret_sts_error;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: END IF;

Line 783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');

779: --Insert data into ozf_approval_access_all
780: FOR i in 1..p_approvers.count LOOP
781: BEGIN
782: IF G_DEBUG THEN
783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');
784: END IF;
785: --
786: INSERT INTO OZF_APPROVAL_ACCESS(
787: approval_access_id

Line 820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');

816: );
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF OZF_ERROR_ON THEN
820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');
821: x_return_status := FND_API.g_ret_sts_error;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END;

Line 833: ozf_utility_pvt.debug_message( l_api_name||': End');

829: COMMIT WORK;
830: END IF;
831: -- Debug Message
832: IF G_DEBUG THEN
833: ozf_utility_pvt.debug_message( l_api_name||': End');
834: END IF;
835: --Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,

Line 958: ozf_utility_pvt.debug_message( l_api_name||': End');

954: COMMIT WORK;
955: END IF;
956: -- Debug Message
957: IF G_DEBUG THEN
958: ozf_utility_pvt.debug_message( l_api_name||': End');
959: END IF;
960: --Standard call to get message count and if count=1, get the message
961: FND_MSG_PUB.Count_And_Get (
962: p_encoded => FND_API.G_FALSE,

Line 1145: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);

1141: l_event := Check_Event(p_event_name);
1142:
1143: IF l_event = 'NOTFOUND' THEN
1144: IF OZF_ERROR_ON THEN
1145: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);
1146: END IF;
1147: x_return_status := FND_API.g_ret_sts_error;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;

Line 1329: ozf_utility_pvt.debug_message( l_api_name||': Start');

1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327: -- Debug Message
1328: IF G_DEBUG THEN
1329: ozf_utility_pvt.debug_message( l_api_name||': Start');
1330: END IF;
1331: --Initialize message list if p_init_msg_list is TRUE.
1332: IF FND_API.To_Boolean (p_init_msg_list) THEN
1333: FND_MSG_PUB.initialize;

Line 1345: ozf_utility_pvt.debug_message( 'Before constructing message ' || l_user_role || ' ' || l_object_id || ' ' || l_status);

1341: l_user_role := l_user_role; -- p_user_role;
1342: END IF;
1343:
1344: IF G_DEBUG THEN
1345: ozf_utility_pvt.debug_message( 'Before constructing message ' || l_user_role || ' ' || l_object_id || ' ' || l_status);
1346: END IF;
1347:
1348: /*
1349: If Approved Status , Chek if it if Final Approval or Not

Line 1368: ozf_utility_pvt.debug_message('Executing Callback API ' || l_user_callback_api);

1364: FETCH csr_message INTO l_user_type, l_msg_type, l_msg_name;
1365: EXIT WHEN csr_message%NOTFOUND;
1366:
1367: IF G_DEBUG THEN
1368: ozf_utility_pvt.debug_message('Executing Callback API ' || l_user_callback_api);
1369: END IF;
1370:
1371: l_role_list := '';
1372:

Line 1395: ozf_utility_pvt.debug_message('No users found from Callback API ' || l_user_callback_api);

1391:
1392: -- execute pre-defined user list criterias
1393: IF l_role_list IS NULL THEN
1394: IF G_DEBUG THEN
1395: ozf_utility_pvt.debug_message('No users found from Callback API ' || l_user_callback_api);
1396: END IF;
1397:
1398: IF l_user_type = 'CHANNEL_MANAGER' then
1399: FOR l_row IN csr_cm(l_partner_id) LOOP

Line 1410: ozf_utility_pvt.debug_message('No users found ');

1406: END LOOP;
1407: l_role_list := substr(l_role_list,2);
1408: ELSE
1409: IF G_DEBUG THEN
1410: ozf_utility_pvt.debug_message('No users found ');
1411: END IF;
1412: END IF;
1413: END IF;
1414:

Line 1416: ozf_utility_pvt.debug_message('Users List ' || l_user_type || 'for sending notification' || l_role_list);

1412: END IF;
1413: END IF;
1414:
1415: IF G_DEBUG THEN
1416: ozf_utility_pvt.debug_message('Users List ' || l_user_type || 'for sending notification' || l_role_list);
1417: END IF;
1418:
1419: -- users returned from the search
1420: IF length(l_role_list) <> 0 THEN

Line 1433: ozf_utility_pvt.debug_message('Creating process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);

1429:
1430: -- l_item_type := 'PVREFFRL';
1431:
1432: IF G_DEBUG THEN
1433: ozf_utility_pvt.debug_message('Creating process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);
1434: END IF;
1435:
1436: -- Create WF process to send notification
1437: wf_engine.CreateProcess ( ItemType => l_item_type,

Line 1443: ozf_utility_pvt.debug_message('Executing msg callback' || l_msg_callback_api );

1439: process => 'NOOP_PROCESS',
1440: user_key => l_item_key);
1441:
1442: IF G_DEBUG THEN
1443: ozf_utility_pvt.debug_message('Executing msg callback' || l_msg_callback_api );
1444: END IF;
1445:
1446: -- execute callback api to set the message attributes
1447: EXECUTE IMMEDIATE 'BEGIN ' ||

Line 1453: ozf_utility_pvt.debug_message('Adding adhoc users' || l_role_list );

1449: 'END;'
1450: USING l_item_type, l_item_key, l_object_id, l_user_type, l_status;
1451:
1452: IF G_DEBUG THEN
1453: ozf_utility_pvt.debug_message('Adding adhoc users' || l_role_list );
1454: END IF;
1455:
1456: -- create an adhoc role with named after itemkey
1457: l_adhoc_role := l_item_key;

Line 1465: ozf_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);

1461:
1462: l_context := l_msg_type || ':' || l_item_key || ':';
1463:
1464: IF G_DEBUG THEN
1465: ozf_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);
1466: END IF;
1467:
1468: -- set the message to be sent
1469: l_group_notify_id := wf_notification.sendGroup(

Line 1480: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);

1476: send_comment => NULL,
1477: priority => NULL );
1478:
1479: IF G_DEBUG THEN
1480: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
1481: ozf_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1482: END IF;
1483:
1484: -- start the notification process to send message

Line 1481: ozf_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );

1477: priority => NULL );
1478:
1479: IF G_DEBUG THEN
1480: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
1481: ozf_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1482: END IF;
1483:
1484: -- start the notification process to send message
1485: wf_engine.StartProcess(itemtype => l_item_type,

Line 1490: ozf_utility_pvt.debug_message('No users found for user type: ' || l_user_type);

1486: itemkey => l_item_key);
1487: -- no users returned from the search
1488: ELSE
1489: IF G_DEBUG THEN
1490: ozf_utility_pvt.debug_message('No users found for user type: ' || l_user_type);
1491: END IF;
1492: END IF;
1493: END LOOP;
1494: CLOSE csr_message;

Line 1513: ozf_utility_pvt.debug_message( l_api_name||': End');

1509: END IF;
1510:
1511: -- Debug Message
1512: IF G_DEBUG THEN
1513: ozf_utility_pvt.debug_message( l_api_name||': End');
1514: END IF;
1515: --Standard call to get message count and if count=1, get the message
1516: FND_MSG_PUB.Count_And_Get (
1517: p_encoded => FND_API.G_FALSE,

Line 1541: -- ozf_utility_pvt.debug_message('Error OTHERS >>>>>>>>> ' || substr(sqlerrm,1,140));

1537: p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );
1540: WHEN OTHERS THEN
1541: -- ozf_utility_pvt.debug_message('Error OTHERS >>>>>>>>> ' || substr(sqlerrm,1,140));
1542: ROLLBACK TO Send_Notification_PVT;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: IF OZF_UNEXP_ERROR_ON
1545: THEN

Line 1626: ozf_utility_pvt.debug_message( l_api_name||': Start');

1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624: -- Debug Message
1625: IF G_DEBUG THEN
1626: ozf_utility_pvt.debug_message( l_api_name||': Start');
1627: END IF;
1628: --Initialize message list if p_init_msg_list is TRUE.
1629: IF FND_API.To_Boolean (p_init_msg_list) THEN
1630: FND_MSG_PUB.initialize;

Line 1683: ozf_utility_pvt.debug_message( 'Forward Request ' || p_approval_rec.action_code );

1679:
1680: --l_approvers_tbl(1).APPROVER_LEVEL := 5; -- how to decide level for reassign???
1681:
1682: IF G_DEBUG THEN
1683: ozf_utility_pvt.debug_message( 'Forward Request ' || p_approval_rec.action_code );
1684: END IF;
1685:
1686: -- Raise error if no approvers are sent for reassignment.
1687: IF l_approvers_tbl.count = 0 THEN

Line 1689: ozf_utility_pvt.error_message('OZF_NO_APPR_FOUND_FOR_FORWARD');

1685:
1686: -- Raise error if no approvers are sent for reassignment.
1687: IF l_approvers_tbl.count = 0 THEN
1688: IF OZF_ERROR_ON THEN
1689: ozf_utility_pvt.error_message('OZF_NO_APPR_FOUND_FOR_FORWARD');
1690: x_return_status := FND_API.g_ret_sts_error;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;

Line 1697: ozf_utility_pvt.debug_message( 'Update User Action ' || p_approval_rec.action_code );

1693: END IF;
1694: END IF;
1695:
1696: IF G_DEBUG THEN
1697: ozf_utility_pvt.debug_message( 'Update User Action ' || p_approval_rec.action_code );
1698: END IF;
1699:
1700: -- Update_User_Action - Update the user action in approval table
1701: Update_User_Action(

Line 1728: ozf_utility_pvt.debug_message( 'Get Approvers ' || p_approval_rec.action_code );

1724: p_approval_rec.action_code = 'APPROVE'
1725: THEN
1726:
1727: IF G_DEBUG THEN
1728: ozf_utility_pvt.debug_message( 'Get Approvers ' || p_approval_rec.action_code );
1729: END IF;
1730:
1731: -- Get_Approvers - List of Approvers or Default Approver
1732: Get_Approvers(

Line 1756: ozf_utility_pvt.debug_message( 'Add Access ' || p_approval_rec.action_code );

1752: p_approval_rec.action_code = 'APPROVE' OR
1753: p_approval_rec.action_code = 'FORWARD'
1754: THEN
1755: IF G_DEBUG THEN
1756: ozf_utility_pvt.debug_message( 'Add Access ' || p_approval_rec.action_code );
1757: END IF;
1758:
1759: IF l_final_approval_flag <> 'Y' THEN
1760: --If no Approver Found Do not add record in Access table

Line 1784: ozf_utility_pvt.debug_message( 'Access Added ' || x_return_status );

1780:
1781: END IF;
1782:
1783: IF G_DEBUG THEN
1784: ozf_utility_pvt.debug_message( 'Access Added ' || x_return_status );
1785: END IF;
1786: END IF;
1787:
1788: IF p_approval_rec.object_type = 'SPECIAL_PRICE' THEN

Line 1828: ozf_utility_pvt.debug_message( 'Send Notification liu feng' || l_benefit_id ||'Parner ' || l_partner_id );

1824: FETCH csr_request INTO l_benefit_id, l_partner_id;
1825: CLOSE csr_request;
1826:
1827: IF G_DEBUG THEN
1828: ozf_utility_pvt.debug_message( 'Send Notification liu feng' || l_benefit_id ||'Parner ' || l_partner_id );
1829: END IF;
1830:
1831: -- Call PRM api to send notification based on setups
1832: PV_BENFT_STATUS_CHANGE.status_change_raise(

Line 1850: ozf_utility_pvt.debug_message( 'Raise Notification Event ' || x_return_status );

1846: x_msg_data => x_msg_data);
1847:
1848:
1849: IF G_DEBUG THEN
1850: ozf_utility_pvt.debug_message( 'Raise Notification Event ' || x_return_status );
1851: END IF;
1852:
1853: IF l_return_status = FND_API.g_ret_sts_error THEN
1854: RAISE FND_API.g_exc_error;

Line 1868: ozf_utility_pvt.debug_message( l_api_name||': End');

1864:
1865: x_final_approval_flag := l_final_approval_flag;
1866: -- Debug Message
1867: IF G_DEBUG THEN
1868: ozf_utility_pvt.debug_message( l_api_name||': End');
1869: END IF;
1870: --Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (
1872: p_encoded => FND_API.G_FALSE,

Line 1957: ozf_utility_pvt.debug_message('liufeng: ' || l_return_status);

1953: p_approval_rec => l_approval_rec,
1954: p_approver_id => l_approver_id,
1955: x_final_approval_flag => l_final_approval);
1956:
1957: ozf_utility_pvt.debug_message('liufeng: ' || l_return_status);
1958: ozf_utility_pvt.debug_message(l_msg_count);
1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);
1960:
1961: for i in 1..l_msg_count loop

Line 1958: ozf_utility_pvt.debug_message(l_msg_count);

1954: p_approver_id => l_approver_id,
1955: x_final_approval_flag => l_final_approval);
1956:
1957: ozf_utility_pvt.debug_message('liufeng: ' || l_return_status);
1958: ozf_utility_pvt.debug_message(l_msg_count);
1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);
1960:
1961: for i in 1..l_msg_count loop
1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));

Line 1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);

1955: x_final_approval_flag => l_final_approval);
1956:
1957: ozf_utility_pvt.debug_message('liufeng: ' || l_return_status);
1958: ozf_utility_pvt.debug_message(l_msg_count);
1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);
1960:
1961: for i in 1..l_msg_count loop
1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));
1963: end loop;

Line 1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));

1958: ozf_utility_pvt.debug_message(l_msg_count);
1959: ozf_utility_pvt.debug_message('approval: ' ||l_final_approval);
1960:
1961: for i in 1..l_msg_count loop
1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));
1963: end loop;
1964:
1965: -- FOR i in 1..l_approvers_tbl.count LOOP
1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);

Line 1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);

1962: ozf_utility_pvt.debug_message(substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254));
1963: end loop;
1964:
1965: -- FOR i in 1..l_approvers_tbl.count LOOP
1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);
1967: -- ozf_utility_pvt.debug_message('Approver Level ' || l_approvers_tbl(i).APPROVER_LEVEL);
1968: -- END LOOP;
1969:
1970: ozf_utility_pvt.debug_message('Final Approval ' || l_final_approval);

Line 1967: -- ozf_utility_pvt.debug_message('Approver Level ' || l_approvers_tbl(i).APPROVER_LEVEL);

1963: end loop;
1964:
1965: -- FOR i in 1..l_approvers_tbl.count LOOP
1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);
1967: -- ozf_utility_pvt.debug_message('Approver Level ' || l_approvers_tbl(i).APPROVER_LEVEL);
1968: -- END LOOP;
1969:
1970: ozf_utility_pvt.debug_message('Final Approval ' || l_final_approval);
1971:

Line 1970: ozf_utility_pvt.debug_message('Final Approval ' || l_final_approval);

1966: -- ozf_utility_pvt.debug_message('Approver Id ' || l_approvers_tbl(i).APPROVER_ID);
1967: -- ozf_utility_pvt.debug_message('Approver Level ' || l_approvers_tbl(i).APPROVER_LEVEL);
1968: -- END LOOP;
1969:
1970: ozf_utility_pvt.debug_message('Final Approval ' || l_final_approval);
1971:
1972: end;
1973:
1974:

Line 2058: ozf_utility_pvt.debug_message( l_api_name||': Start');

2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: -- Debug Message
2057: IF G_DEBUG THEN
2058: ozf_utility_pvt.debug_message( l_api_name||': Start');
2059: END IF;
2060: --Initialize message list if p_init_msg_list is TRUE.
2061: IF FND_API.To_Boolean (p_init_msg_list) THEN
2062: FND_MSG_PUB.initialize;

Line 2070: ozf_utility_pvt.debug_message( 'Get Approvers for request_header_id: ' || p_object_id );

2066: -- If action code is SUBMIT get the approver list from AME setup
2067: -- and populate OZF_SD_REQUEST_ACCESS table
2068: IF (p_action_code = 'SUBMIT') THEN
2069: IF G_DEBUG THEN
2070: ozf_utility_pvt.debug_message( 'Get Approvers for request_header_id: ' || p_object_id );
2071: END IF;
2072: Get_All_Approvers(
2073: p_api_version => p_api_version
2074: ,p_init_msg_list => p_init_msg_list

Line 2117: ozf_utility_pvt.debug_message( 'Invoke Add_SD_Access for AME approver: ' || l_orig_system_id);

2113: -- This procedure will do required validation and
2114: -- insert the record in OZF_SD_REQUEST_ACCESS table
2115: IF (l_insert_mode = 'Y') THEN
2116: IF G_DEBUG THEN
2117: ozf_utility_pvt.debug_message( 'Invoke Add_SD_Access for AME approver: ' || l_orig_system_id);
2118: END IF;
2119: Add_SD_Access(
2120: p_api_version => p_api_version
2121: ,p_init_msg_list => p_init_msg_list

Line 2169: ozf_utility_pvt.debug_message( 'Invoke Add_SD_Access for default approver: ' || l_user_id);

2165: END IF;
2166:
2167: IF (l_insert_mode = 'Y') THEN
2168: IF G_DEBUG THEN
2169: ozf_utility_pvt.debug_message( 'Invoke Add_SD_Access for default approver: ' || l_user_id);
2170: END IF;
2171: Add_SD_Access(
2172: p_api_version => p_api_version
2173: ,p_init_msg_list => p_init_msg_list

Line 2192: ozf_utility_pvt.debug_message('Add_SD_Access is ended for default approver: '||x_return_status);

2188: RAISE FND_API.g_exc_unexpected_error;
2189: END IF;
2190: END IF;
2191: IF G_DEBUG THEN
2192: ozf_utility_pvt.debug_message('Add_SD_Access is ended for default approver: '||x_return_status);
2193: END IF;
2194: END IF;
2195: END IF;
2196: l_event_key := p_object_id || ':' || to_char(sysdate, 'DD:MON:YYYY HH:MI:SS');

Line 2212: ozf_utility_pvt.debug_message( l_api_name||': End');

2208: COMMIT WORK;
2209: END IF;
2210: -- Debug Message
2211: IF G_DEBUG THEN
2212: ozf_utility_pvt.debug_message( l_api_name||': End');
2213: END IF;
2214: --Standard call to get message count and if count=1, get the message
2215: FND_MSG_PUB.Count_And_Get (
2216: p_encoded => FND_API.G_FALSE,

Line 2302: ozf_utility_pvt.debug_message( l_api_name||': Start');

2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2299: END IF;
2300: -- Debug Message
2301: IF G_DEBUG THEN
2302: ozf_utility_pvt.debug_message( l_api_name||': Start');
2303: END IF;
2304: --Initialize message list if p_init_msg_list is TRUE.
2305: IF FND_API.To_Boolean (p_init_msg_list) THEN
2306: FND_MSG_PUB.initialize;

Line 2426: ozf_utility_pvt.debug_message( l_api_name||': Start');

2422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2423: END IF;
2424: -- Debug Message
2425: IF G_DEBUG THEN
2426: ozf_utility_pvt.debug_message( l_api_name||': Start');
2427: END IF;
2428: --Initialize message list if p_init_msg_list is TRUE.
2429: IF FND_API.To_Boolean (p_init_msg_list) THEN
2430: FND_MSG_PUB.initialize;

Line 2442: ozf_utility_pvt.error_message('OZF_SD_REQUEST_HEADER_ID_NULL');

2438: -- If both owner_flag and approver_flag are null
2439: -- Set the appropriate return status and raise an exception
2440: IF (p_request_header_id IS NULL) THEN
2441: IF OZF_ERROR_ON THEN
2442: ozf_utility_pvt.error_message('OZF_SD_REQUEST_HEADER_ID_NULL');
2443: x_return_status := FND_API.g_ret_sts_error;
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446: END IF;

Line 2450: ozf_utility_pvt.error_message('OZF_SD_USER_RESOURCE_ID_NULL');

2446: END IF;
2447:
2448: IF (p_user_id IS NULL AND p_resource_id IS NULL) THEN
2449: IF OZF_ERROR_ON THEN
2450: ozf_utility_pvt.error_message('OZF_SD_USER_RESOURCE_ID_NULL');
2451: x_return_status := FND_API.g_ret_sts_error;
2452: RAISE FND_API.G_EXC_ERROR;
2453: END IF;
2454: END IF;

Line 2458: ozf_utility_pvt.error_message('OZF_SD_OWNER_APPROVER_NULL');

2454: END IF;
2455:
2456: IF (p_owner_flag IS NULL AND p_approver_flag IS NULL) THEN
2457: IF OZF_ERROR_ON THEN
2458: ozf_utility_pvt.error_message('OZF_SD_OWNER_APPROVER_NULL');
2459: x_return_status := FND_API.g_ret_sts_error;
2460: RAISE FND_API.G_EXC_ERROR;
2461: END IF;
2462: END IF;

Line 2493: ozf_utility_pvt.error_message('OZF_SD_USER_IS_NOT_RESOURCE');

2489: END IF;
2490:
2491: IF (l_access_rec.USER_ID IS NULL OR l_access_rec.RESOURCE_ID IS NULL) THEN
2492: IF OZF_ERROR_ON THEN
2493: ozf_utility_pvt.error_message('OZF_SD_USER_IS_NOT_RESOURCE');
2494: x_return_status := FND_API.g_ret_sts_error;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497: END IF;

Line 2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);

2502: l_access_rec.APPROVER_FLAG := p_approver_flag;
2503: l_access_rec.ENABLED_FLAG := p_enabled_flag;
2504:
2505: IF G_DEBUG THEN
2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);
2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);

Line 2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);

2503: l_access_rec.ENABLED_FLAG := p_enabled_flag;
2504:
2505: IF G_DEBUG THEN
2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);
2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);

Line 2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);

2504:
2505: IF G_DEBUG THEN
2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);
2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);
2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);

Line 2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);

2505: IF G_DEBUG THEN
2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);
2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);
2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);
2513: END IF;

Line 2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);

2506: ozf_utility_pvt.debug_message( 'REQUEST HEADER ID: '||l_access_rec.REQUEST_HEADER_ID);
2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);
2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);
2513: END IF;
2514:

Line 2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);

2507: ozf_utility_pvt.debug_message( 'USER ID: '||l_access_rec.USER_ID);
2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);
2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);
2513: END IF;
2514:
2515: Add_SD_Access(

Line 2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);

2508: ozf_utility_pvt.debug_message( 'RESOURCE ID: '||l_access_rec.RESOURCE_ID);
2509: ozf_utility_pvt.debug_message( 'PERSON ID: '||l_access_rec.PERSON_ID);
2510: ozf_utility_pvt.debug_message( 'OWNER FLAG: '||l_access_rec.OWNER_FLAG);
2511: ozf_utility_pvt.debug_message( 'APPROVER FLAG: '||l_access_rec.APPROVER_FLAG);
2512: ozf_utility_pvt.debug_message( 'ENABLED FLAG: '||l_access_rec.ENABLED_FLAG);
2513: END IF;
2514:
2515: Add_SD_Access(
2516: p_api_version => p_api_version

Line 2531: ozf_utility_pvt.debug_message( l_api_name||': End');

2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: -- Debug Message
2530: IF G_DEBUG THEN
2531: ozf_utility_pvt.debug_message( l_api_name||': End');
2532: END IF;
2533: --Standard call to get message count and if count=1, get the message
2534: FND_MSG_PUB.Count_And_Get (
2535: p_encoded => FND_API.G_FALSE,

Line 2643: ozf_utility_pvt.debug_message( l_api_name||': Start');

2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2640: END IF;
2641: -- Debug Message
2642: IF G_DEBUG THEN
2643: ozf_utility_pvt.debug_message( l_api_name||': Start');
2644: END IF;
2645: --Initialize message list if p_init_msg_list is TRUE.
2646: IF FND_API.To_Boolean (p_init_msg_list) THEN
2647: FND_MSG_PUB.initialize;

Line 2741: ozf_utility_pvt.debug_message( 'Inserting data into OZF_SD_REQUEST_ACCESS table');

2737:
2738: IF (l_insert_mode = 'Y') THEN
2739: BEGIN
2740: IF G_DEBUG THEN
2741: ozf_utility_pvt.debug_message( 'Inserting data into OZF_SD_REQUEST_ACCESS table');
2742: END IF;
2743: -- GET PRIMARY KEY
2744: OPEN c_id;
2745: FETCH c_id INTO l_approval_access_id;

Line 2781: ozf_utility_pvt.error_message('OZF_SD_REQ_ACCESS_INSERT_ERR');

2777: );
2778: EXCEPTION
2779: WHEN OTHERS THEN
2780: IF OZF_ERROR_ON THEN
2781: ozf_utility_pvt.error_message('OZF_SD_REQ_ACCESS_INSERT_ERR');
2782: x_return_status := FND_API.g_ret_sts_error;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785: END;

Line 2793: ozf_utility_pvt.debug_message( l_api_name||': End');

2789: COMMIT WORK;
2790: END IF;
2791: -- Debug Message
2792: IF G_DEBUG THEN
2793: ozf_utility_pvt.debug_message( l_api_name||': End');
2794: END IF;
2795: --Standard call to get message count and if count=1, get the message
2796: FND_MSG_PUB.Count_And_Get (
2797: p_encoded => FND_API.G_FALSE,

Line 2870: ozf_utility_pvt.debug_message( l_api_name||': Start');

2866: BEGIN
2867: SAVEPOINT Raise_SD_Event;
2868: -- Debug Message
2869: IF G_DEBUG THEN
2870: ozf_utility_pvt.debug_message( l_api_name||': Start');
2871: END IF;
2872: -- Initialize API return status to sucess
2873: x_return_status := FND_API.G_RET_STS_SUCCESS;
2874:

Line 2878: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', l_sd_event_name);

2874:
2875: l_event := Check_Event(l_sd_event_name);
2876: IF l_event = 'NOTFOUND' THEN
2877: IF OZF_ERROR_ON THEN
2878: ozf_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', l_sd_event_name);
2879: END IF;
2880: x_return_status := FND_API.g_ret_sts_error;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;

Line 2903: ozf_utility_pvt.debug_message( l_api_name||': End');

2899: p_event_data => NULL);
2900:
2901: -- Debug Message
2902: IF G_DEBUG THEN
2903: ozf_utility_pvt.debug_message( l_api_name||': End');
2904: END IF;
2905: --Standard call to get message count and if count=1, get the message
2906: FND_MSG_PUB.Count_And_Get (
2907: p_encoded => FND_API.G_FALSE,

Line 3100: ozf_utility_pvt.debug_message( l_api_name||': Start');

3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3097: END IF;
3098: -- Debug Message
3099: IF G_DEBUG THEN
3100: ozf_utility_pvt.debug_message( l_api_name||': Start');
3101: END IF;
3102: --Initialize message list if p_init_msg_list is TRUE.
3103: IF FND_API.To_Boolean (p_init_msg_list) THEN
3104: FND_MSG_PUB.initialize;

Line 3110: ozf_utility_pvt.debug_message( 'Construct the message for request_header_id: '||p_object_id);

3106: -- Initialize API return status to sucess
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;
3108:
3109: IF G_DEBUG THEN
3110: ozf_utility_pvt.debug_message( 'Construct the message for request_header_id: '||p_object_id);
3111: END IF;
3112: -- if action code is SUBMIT, send the notification only to approvers (PMs)
3113: IF (p_action_code = 'SUBMIT') THEN
3114: FOR l_row IN csr_approvers(p_object_id) LOOP

Line 3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);

3159: FETCH request_type_setup_info INTO l_request_type_setup_name;
3160: CLOSE request_type_setup_info;
3161:
3162: IF G_DEBUG THEN
3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);
3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);

Line 3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);

3160: CLOSE request_type_setup_info;
3161:
3162: IF G_DEBUG THEN
3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);
3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);

Line 3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);

3161:
3162: IF G_DEBUG THEN
3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);
3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));

Line 3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);

3162: IF G_DEBUG THEN
3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);
3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));

Line 3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);

3163: ozf_utility_pvt.debug_message( 'request number: '||l_request_number);
3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));

Line 3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);

3164: ozf_utility_pvt.debug_message( 'request type setup name: '||l_request_type_setup_name);
3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));

Line 3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));

3165: ozf_utility_pvt.debug_message( 'requester name: '||l_requester_name);
3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));

Line 3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));

3166: ozf_utility_pvt.debug_message( 'supplier name: '||l_supplier_name);
3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));

Line 3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));

3167: ozf_utility_pvt.debug_message( 'assignee name: '||l_assignee_name);
3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));

Line 3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));

3168: ozf_utility_pvt.debug_message( 'operating unit: '||l_operating_unit);
3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));
3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);

Line 3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));

3169: ozf_utility_pvt.debug_message( 'request creation date: '||TO_CHAR(l_creation_date));
3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));
3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);
3177: END IF;

Line 3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));

3170: ozf_utility_pvt.debug_message( 'request start date: '||TO_CHAR(l_start_date));
3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));
3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);
3177: END IF;
3178:

Line 3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));

3171: ozf_utility_pvt.debug_message( 'request end date: '||TO_CHAR(l_end_date));
3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));
3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);
3177: END IF;
3178:
3179: IF G_DEBUG THEN

Line 3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);

3172: ozf_utility_pvt.debug_message( 'supplier response date: '||TO_CHAR(l_supplier_resp_date));
3173: ozf_utility_pvt.debug_message( 'supplier_response by date: '||TO_CHAR(l_supplier_resp_by_date));
3174: ozf_utility_pvt.debug_message( 'assignee response date: '||TO_CHAR(l_assignee_resp_date));
3175: ozf_utility_pvt.debug_message( 'assignee response by date: '||TO_CHAR(l_assignee_resp_by_date));
3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);
3177: END IF;
3178:
3179: IF G_DEBUG THEN
3180: ozf_utility_pvt.debug_message('Create process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);

Line 3180: ozf_utility_pvt.debug_message('Create process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);

3176: ozf_utility_pvt.debug_message( 'authorization number: '||l_authorization_number);
3177: END IF;
3178:
3179: IF G_DEBUG THEN
3180: ozf_utility_pvt.debug_message('Create process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);
3181: END IF;
3182: -- Create WF process to send notification
3183: wf_engine.CreateProcess ( ItemType => l_item_type,
3184: ItemKey => l_item_key,

Line 3188: ozf_utility_pvt.debug_message('Set attributes for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);

3184: ItemKey => l_item_key,
3185: process => 'NOOP_PROCESS',
3186: user_key => l_item_key);
3187: IF G_DEBUG THEN
3188: ozf_utility_pvt.debug_message('Set attributes for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);
3189: END IF;
3190:
3191: -- Set WF attributes to send notification
3192: wf_engine.SetItemAttrText(itemtype => l_item_type,

Line 3279: ozf_utility_pvt.debug_message('Adding adhoc users' || l_role_list );

3275: itemkey => l_item_key,
3276: aname => 'LOGIN_URL',
3277: avalue => l_login_url );
3278: IF G_DEBUG THEN
3279: ozf_utility_pvt.debug_message('Adding adhoc users' || l_role_list );
3280: END IF;
3281:
3282: -- create an adhoc role with named after itemkey
3283: l_adhoc_role := l_item_key;

Line 3290: ozf_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_item_type || ' ' || l_item_name);

3286: role_display_name => l_adhoc_role,
3287: role_users => l_role_list);
3288: l_context := l_item_type || ':' || l_item_key || ':';
3289: IF G_DEBUG THEN
3290: ozf_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_item_type || ' ' || l_item_name);
3291: END IF;
3292: -- set the message to be sent
3293: l_group_notify_id := wf_notification.sendGroup(
3294: role => l_adhoc_role,

Line 3306: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);

3302: -- start the notification process to send message
3303: wf_engine.StartProcess(itemtype => l_item_type,
3304: itemkey => l_item_key);
3305: IF G_DEBUG THEN
3306: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
3307: ozf_utility_pvt.debug_message('Using message: ' || l_item_name || '. Notify id: ' || l_group_notify_id );
3308: END IF;
3309: --Standard check of commit
3310: IF FND_API.To_Boolean ( p_commit ) THEN

Line 3307: ozf_utility_pvt.debug_message('Using message: ' || l_item_name || '. Notify id: ' || l_group_notify_id );

3303: wf_engine.StartProcess(itemtype => l_item_type,
3304: itemkey => l_item_key);
3305: IF G_DEBUG THEN
3306: ozf_utility_pvt.debug_message('Sent notification to role: ' || l_adhoc_role);
3307: ozf_utility_pvt.debug_message('Using message: ' || l_item_name || '. Notify id: ' || l_group_notify_id );
3308: END IF;
3309: --Standard check of commit
3310: IF FND_API.To_Boolean ( p_commit ) THEN
3311: COMMIT WORK;

Line 3316: ozf_utility_pvt.debug_message( l_api_name||': End');

3312: END IF;
3313:
3314: -- Debug Message
3315: IF G_DEBUG THEN
3316: ozf_utility_pvt.debug_message( l_api_name||': End');
3317: END IF;
3318: --Standard call to get message count and if count=1, get the message
3319: FND_MSG_PUB.Count_And_Get (
3320: p_encoded => FND_API.G_FALSE,