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.DPP_APPROVAL_PVT dependencies on DPP_UTILITY_PVT

Line 134: dpp_utility_pvt.debug_message( l_api_name||': Start');

130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132: -- Debug Message
133: IF G_DEBUG THEN
134: dpp_utility_pvt.debug_message( l_api_name||': Start');
135: END IF;
136: --Initialize message list if p_init_msg_list is TRUE.
137: IF FND_API.To_Boolean (p_init_msg_list) THEN
138: FND_MSG_PUB.initialize;

Line 159: dpp_utility_pvt.debug_message( 'l_act_approver_id : '||l_act_approver_id);

155: --Actual Approver is a User
156: l_act_approver_id := l_approver_id;
157: end if;
158: IF G_DEBUG THEN
159: dpp_utility_pvt.debug_message( 'l_act_approver_id : '||l_act_approver_id);
160: END IF;
161: IF l_act_approver_id = p_approval_rec.action_performed_by THEN
162: -- Update approval access table to revoke access
163: UPDATE DPP_APPROVAL_ACCESS

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

222: CLOSE csr_check_reassign_level;
223:
224: -- Debug Message
225: IF G_DEBUG THEN
226: dpp_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );

Line 227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );

223:
224: -- Debug Message
225: IF G_DEBUG THEN
226: dpp_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );

Line 228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );

224: -- Debug Message
225: IF G_DEBUG THEN
226: dpp_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );

Line 229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );

225: IF G_DEBUG THEN
226: dpp_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );

Line 230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );

226: dpp_utility_pvt.debug_message( 'Approval done by user in approval list? ' || l_approver_found );
227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
234: END IF;

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

227: dpp_utility_pvt.debug_message( 'Approver User Id ' || p_approval_rec.action_performed_by );
228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
234: END IF;
235:

Line 232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );

228: dpp_utility_pvt.debug_message( 'Approver Action ' || p_approval_rec.action_code );
229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
234: END IF;
235:
236: /*

Line 233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );

229: dpp_utility_pvt.debug_message( 'Approver Type ' || l_approver_type );
230: dpp_utility_pvt.debug_message( 'Act Approver User Id ' || l_act_approver_id );
231: dpp_utility_pvt.debug_message( 'Act Approver Person/User Id ' || l_approver_id );
232: dpp_utility_pvt.debug_message( 'Minimum Reassign Level ' || l_min_reassign_level );
233: dpp_utility_pvt.debug_message( 'l_action_code ' || l_action_code );
234: END IF;
235:
236: /*
237: Check for minimum Reassign Level is added because , if it is 0 then the case is No AME Rule was

Line 277: dpp_utility_pvt.debug_message( 'Revoke Access ' || p_approval_rec.action_code );

273: );
274: end if; -- End if minimum reassign Level not 0
275:
276: IF G_DEBUG THEN
277: dpp_utility_pvt.debug_message( 'Revoke Access ' || p_approval_rec.action_code );
278: END IF;
279: -- Revoke_Access - Revoke acces to previous appprovers in the chain
280: Revoke_Access(
281: p_api_version => p_api_version

Line 307: dpp_utility_pvt.debug_message( l_api_name||': End');

303: END IF;
304:
305: -- Debug Message
306: IF G_DEBUG THEN
307: dpp_utility_pvt.debug_message( l_api_name||': End');
308: END IF;
309: --Standard call to get message count and if count=1, get the message
310: FND_MSG_PUB.Count_And_Get (
311: p_encoded => FND_API.G_FALSE,

Line 418: dpp_utility_pvt.debug_message( l_api_name||': Start');

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416: -- Debug Message
417: IF G_DEBUG THEN
418: dpp_utility_pvt.debug_message( l_api_name||': Start');
419: END IF;
420: --Initialize message list if p_init_msg_list is TRUE.
421: IF FND_API.To_Boolean (p_init_msg_list) THEN
422: FND_MSG_PUB.initialize;

Line 435: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);

431: -- increment approval level by 1 for next approval;
432: l_approver_level := l_approver_level + 1;
433:
434: IF G_DEBUG THEN
435: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
436: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
437: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
438: END IF;
439:

Line 436: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);

432: l_approver_level := l_approver_level + 1;
433:
434: IF G_DEBUG THEN
435: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
436: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
437: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
438: END IF;
439:
440: -- Get Approver list from Approvals Manager

Line 437: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);

433:
434: IF G_DEBUG THEN
435: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
436: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
437: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
438: END IF;
439:
440: -- Get Approver list from Approvals Manager
441: AME_API.getNextApprover(applicationIdIn => l_application_id

Line 452: dpp_utility_pvt.debug_message( 'AME did not return any approvers in AME_API.getNextApprover call');

448: l_next_approver.user_id IS NULL AND
449: l_next_approver.approval_status IS NULL
450: THEN
451: IF G_DEBUG THEN
452: dpp_utility_pvt.debug_message( 'AME did not return any approvers in AME_API.getNextApprover call');
453: END IF;
454:
455: -- If first approval, get default approver from profile
456: IF p_approval_rec.action_code = 'SUBMIT' THEN

Line 458: dpp_utility_pvt.debug_message( 'Defulting to 1 as default approver');

454:
455: -- If first approval, get default approver from profile
456: IF p_approval_rec.action_code = 'SUBMIT' THEN
457: IF G_DEBUG THEN
458: dpp_utility_pvt.debug_message( 'Defulting to 1 as default approver');
459: END IF;
460: -- Get default approver
461: x_approvers := approvers_tbl_type ();
462: x_approvers.extend;

Line 475: dpp_utility_pvt.debug_message( 'Setting to final approval');

471: END IF;
472: -- If final approval, convey that information
473: IF p_approval_rec.action_code = 'APPROVE' THEN
474: IF G_DEBUG THEN
475: dpp_utility_pvt.debug_message( 'Setting to final approval');
476: END IF;
477: x_final_approval_flag := 'Y';
478: END IF;
479: ELSE

Line 481: dpp_utility_pvt.debug_message( 'AME returned approvers');

477: x_final_approval_flag := 'Y';
478: END IF;
479: ELSE
480: IF G_DEBUG THEN
481: dpp_utility_pvt.debug_message( 'AME returned approvers');
482: END IF;
483: x_final_approval_flag := 'N';
484: -- Construct the out record of approvers
485: x_approvers := approvers_tbl_type ();

Line 598: dpp_utility_pvt.debug_message( l_api_name||': Start');

594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596: -- Debug Message
597: IF G_DEBUG THEN
598: dpp_utility_pvt.debug_message( l_api_name||': Start');
599: END IF;
600: --Initialize message list if p_init_msg_list is TRUE.
601: IF FND_API.To_Boolean (p_init_msg_list) THEN
602: FND_MSG_PUB.initialize;

Line 608: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);

604: --Initialize API return status to sucess
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF G_DEBUG THEN
608: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
609: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
610: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
611: END IF;
612: --Get all the approvers for this transaction from Approvals Manager

Line 609: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);

605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF G_DEBUG THEN
608: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
609: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
610: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
611: END IF;
612: --Get all the approvers for this transaction from Approvals Manager
613: AME_API.getAllApprovers(applicationIdIn => l_application_id

Line 610: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);

606:
607: IF G_DEBUG THEN
608: dpp_utility_pvt.debug_message( 'l_application_id:'|| l_application_id);
609: dpp_utility_pvt.debug_message( 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
610: dpp_utility_pvt.debug_message( 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
611: END IF;
612: --Get all the approvers for this transaction from Approvals Manager
613: AME_API.getAllApprovers(applicationIdIn => l_application_id
614: ,transactionIdIn => p_approval_rec.object_id

Line 620: dpp_utility_pvt.debug_message( 'AME did not return any approvers in AME_API.getAllApprovers call');

616: ,approversOut => l_approversOut
617: );
618: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
619: IF G_DEBUG THEN
620: dpp_utility_pvt.debug_message( 'AME did not return any approvers in AME_API.getAllApprovers call');
621: dpp_utility_pvt.debug_message( 'Get the default approver from the profile value');
622: END IF;
623: -- Get default approver from profile (default approver)
624: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN

Line 621: dpp_utility_pvt.debug_message( 'Get the default approver from the profile value');

617: );
618: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
619: IF G_DEBUG THEN
620: dpp_utility_pvt.debug_message( 'AME did not return any approvers in AME_API.getAllApprovers call');
621: dpp_utility_pvt.debug_message( 'Get the default approver from the profile value');
622: END IF;
623: -- Get default approver from profile (default approver)
624: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
625: l_approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));

Line 654: dpp_utility_pvt.debug_message( 'No default approver set for the object type : '||p_approval_rec.object_type);

650: ELSE
651: FND_MESSAGE.set_name('DPP', 'DPP_AME_NO_APP');
652: FND_MSG_PUB.add;
653: IF G_DEBUG THEN
654: dpp_utility_pvt.debug_message( 'No default approver set for the object type : '||p_approval_rec.object_type);
655: END IF;
656: END IF;
657: ELSE -- Approver set up found in AME
658: IF G_DEBUG THEN

Line 659: dpp_utility_pvt.debug_message( 'AME returned approvers');

655: END IF;
656: END IF;
657: ELSE -- Approver set up found in AME
658: IF G_DEBUG THEN
659: dpp_utility_pvt.debug_message( 'AME returned approvers');
660: END IF;
661: --Assign the value to the out table type
662: FOR i IN l_approversOut.FIRST..l_approversOut.LAST LOOP
663: --Check if the person id is returned

Line 666: dpp_utility_pvt.debug_message( 'Person ID : '||l_approversOut(i).person_id);

662: FOR i IN l_approversOut.FIRST..l_approversOut.LAST LOOP
663: --Check if the person id is returned
664: IF l_approversOut(i).person_id IS NOT NULL THEN
665: IF G_DEBUG THEN
666: dpp_utility_pvt.debug_message( 'Person ID : '||l_approversOut(i).person_id);
667: END IF;
668: BEGIN
669: SELECT email_address
670: INTO l_approver_email

Line 709: dpp_utility_pvt.debug_message( 'No details retrieved for the Approver ');

705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END;
707: ELSE -- Both the person id and the user id are null
708: IF G_DEBUG THEN
709: dpp_utility_pvt.debug_message( 'No details retrieved for the Approver ');
710: END IF;
711: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_DETAIL');
712: FND_MSG_PUB.add;
713: l_approver_email := NULL;

Line 773: dpp_utility_pvt.debug_message( l_api_name||': End');

769: END LOOP;
770: END IF;
771: -- Debug Message
772: IF G_DEBUG THEN
773: dpp_utility_pvt.debug_message( l_api_name||': End');
774: END IF;
775: --Standard call to get message count and if count=1, get the message
776: FND_MSG_PUB.Count_And_Get (
777: p_encoded => FND_API.G_FALSE,

Line 877: dpp_utility_pvt.debug_message( l_api_name||': Start');

873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875: -- Debug Message
876: IF G_DEBUG THEN
877: dpp_utility_pvt.debug_message( l_api_name||': Start');
878: END IF;
879: --Initialize message list if p_init_msg_list is TRUE.
880: IF FND_API.To_Boolean (p_init_msg_list) THEN
881: FND_MSG_PUB.initialize;

Line 893: dpp_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');

889: CLOSE c_id;
890:
891: IF p_approval_rec.object_type IS NULL THEN
892: IF DPP_ERROR_ON THEN
893: dpp_utility_pvt.error_message('OZF_OBJECT_TYPE_NOT_FOUND');
894: x_return_status := FND_API.g_ret_sts_error;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897: END IF;

Line 901: dpp_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');

897: END IF;
898:
899: IF p_approval_rec.object_id IS NULL THEN
900: IF DPP_ERROR_ON THEN
901: dpp_utility_pvt.error_message('OZF_OBJECT_ID_NOT_FOUND');
902: x_return_status := FND_API.g_ret_sts_error;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905: END IF;

Line 911: dpp_utility_pvt.error_message('OZF_APPROVER_NOT_USER');

907: -- Validate if the approvers record is valid
908: FOR i in 1..p_approvers.count LOOP
909: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
910: IF DPP_ERROR_ON THEN
911: dpp_utility_pvt.error_message('OZF_APPROVER_NOT_USER');
912: x_return_status := FND_API.g_ret_sts_error;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915: END IF;

Line 919: dpp_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');

915: END IF;
916:
917: IF p_approvers(i).approver_level IS NULL THEN
918: IF DPP_ERROR_ON THEN
919: dpp_utility_pvt.error_message('OZF_APPROVAL_LEVEL_NOT_FOUND');
920: x_return_status := FND_API.g_ret_sts_error;
921: RAISE FND_API.G_EXC_ERROR;
922: END IF;
923: END IF;

Line 930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');

926: --Insert data into DPP_APPROVAL_ACCESS_all
927: FOR i in 1..p_approvers.count LOOP
928: BEGIN
929: IF G_DEBUG THEN
930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');
931: END IF;
932: --
933: INSERT INTO DPP_APPROVAL_ACCESS(
934: approval_access_id

Line 967: dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');

963: );
964: EXCEPTION
965: WHEN OTHERS THEN
966: IF DPP_ERROR_ON THEN
967: dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');
968: x_return_status := FND_API.g_ret_sts_error;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: END;

Line 980: dpp_utility_pvt.debug_message( l_api_name||': End');

976: COMMIT WORK;
977: END IF;
978: -- Debug Message
979: IF G_DEBUG THEN
980: dpp_utility_pvt.debug_message( l_api_name||': End');
981: END IF;
982: --Standard call to get message count and if count=1, get the message
983: FND_MSG_PUB.Count_And_Get (
984: p_encoded => FND_API.G_FALSE,

Line 1120: dpp_utility_pvt.debug_message( l_api_name||': End');

1116: COMMIT WORK;
1117: END IF;
1118: -- Debug Message
1119: IF G_DEBUG THEN
1120: dpp_utility_pvt.debug_message( l_api_name||': End');
1121: END IF;
1122: --Standard call to get message count and if count=1, get the message
1123: FND_MSG_PUB.Count_And_Get (
1124: p_encoded => FND_API.G_FALSE,

Line 1320: dpp_utility_pvt.debug_message( 'Event : ' || l_event);

1316: SAVEPOINT Raise_Event_PVT;
1317:
1318: l_event := Check_Event(p_event_name);
1319: IF G_DEBUG THEN
1320: dpp_utility_pvt.debug_message( 'Event : ' || l_event);
1321: END IF;
1322: --dpp_utility_pvt.error_message('Event Name', l_event);
1323:
1324: IF l_event = 'NOTFOUND' THEN

Line 1322: --dpp_utility_pvt.error_message('Event Name', l_event);

1318: l_event := Check_Event(p_event_name);
1319: IF G_DEBUG THEN
1320: dpp_utility_pvt.debug_message( 'Event : ' || l_event);
1321: END IF;
1322: --dpp_utility_pvt.error_message('Event Name', l_event);
1323:
1324: IF l_event = 'NOTFOUND' THEN
1325: IF DPP_ERROR_ON THEN
1326: dpp_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);

Line 1326: dpp_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);

1322: --dpp_utility_pvt.error_message('Event Name', l_event);
1323:
1324: IF l_event = 'NOTFOUND' THEN
1325: IF DPP_ERROR_ON THEN
1326: dpp_utility_pvt.error_message('OZF_WF_EVENT_NAME_NULL', 'NAME', p_event_name);
1327: END IF;
1328: x_return_status := FND_API.g_ret_sts_error;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;

Line 1348: dpp_utility_pvt.debug_message( 'Event Raise :' || p_event_name);

1344: l_parameter_list.extend;
1345: l_parameter_list(3) := l_parameter_t;
1346: -- Debug Message
1347: IF G_DEBUG THEN
1348: dpp_utility_pvt.debug_message( 'Event Raise :' || p_event_name);
1349: dpp_utility_pvt.debug_message( 'Event Key :' || p_event_key);
1350: END IF;
1351: -- Raise business event
1352: Wf_Event.Raise

Line 1349: dpp_utility_pvt.debug_message( 'Event Key :' || p_event_key);

1345: l_parameter_list(3) := l_parameter_t;
1346: -- Debug Message
1347: IF G_DEBUG THEN
1348: dpp_utility_pvt.debug_message( 'Event Raise :' || p_event_name);
1349: dpp_utility_pvt.debug_message( 'Event Key :' || p_event_key);
1350: END IF;
1351: -- Raise business event
1352: Wf_Event.Raise
1353: ( p_event_name => p_event_name,

Line 1359: dpp_utility_pvt.debug_message( 'event raised....');

1355: p_parameters => l_parameter_list,
1356: p_event_data => NULL);
1357: -- Debug Message
1358: IF G_DEBUG THEN
1359: dpp_utility_pvt.debug_message( 'event raised....');
1360: END IF;
1361: EXCEPTION
1362: WHEN FND_API.G_EXC_ERROR THEN
1363: ROLLBACK TO Raise_Event_PVT;

Line 1498: dpp_utility_pvt.debug_message( l_api_name||': Start');

1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: END IF;
1496: -- Debug Message
1497: IF G_DEBUG THEN
1498: dpp_utility_pvt.debug_message( l_api_name||': Start');
1499: END IF;
1500: --Initialize message list if p_init_msg_list is TRUE.
1501: IF FND_API.To_Boolean (p_init_msg_list) THEN
1502: FND_MSG_PUB.initialize;

Line 1514: dpp_utility_pvt.debug_message( 'Before constructing message ' || l_user_role || ' ' || l_object_id || ' ' || l_status);

1510: l_user_role := l_user_role; -- p_user_role;
1511: END IF;
1512:
1513: IF G_DEBUG THEN
1514: dpp_utility_pvt.debug_message( 'Before constructing message ' || l_user_role || ' ' || l_object_id || ' ' || l_status);
1515: END IF;
1516:
1517: /*
1518: If Approved Status , Chek if it if Final Approval or Not

Line 1540: dpp_utility_pvt.debug_message('Users List for sending notification' || l_role_list);

1536: l_role_list := substr(l_role_list,2);
1537: -- END IF;
1538:
1539: IF G_DEBUG THEN
1540: dpp_utility_pvt.debug_message('Users List for sending notification' || l_role_list);
1541: END IF;
1542:
1543: -- users returned from the search
1544: IF length(l_role_list) <> 0 THEN

Line 1548: dpp_utility_pvt.debug_message('l_item_key ' || l_item_key );

1544: IF length(l_role_list) <> 0 THEN
1545: l_item_key := l_msg_type||'|'||l_msg_name||'|'||l_object_id||
1546: '|'||to_char(sysdate,'YYYYMMDDHH24MISS');
1547: IF G_DEBUG THEN
1548: dpp_utility_pvt.debug_message('l_item_key ' || l_item_key );
1549: END IF;
1550: IF l_object_type = 'PRICE PROTECTION' THEN
1551: l_item_type := 'DPPTXAPP';
1552: END IF;

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

1551: l_item_type := 'DPPTXAPP';
1552: END IF;
1553:
1554: IF G_DEBUG THEN
1555: dpp_utility_pvt.debug_message('Creating process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);
1556: END IF;
1557:
1558: -- Create WF process to send notification
1559: wf_engine.CreateProcess ( ItemType => l_item_type,

Line 1565: dpp_utility_pvt.debug_message('Executing msg callback' || l_msg_callback_api );

1561: process => 'NOOP_PROCESS',
1562: user_key => l_item_key);
1563:
1564: IF G_DEBUG THEN
1565: dpp_utility_pvt.debug_message('Executing msg callback' || l_msg_callback_api );
1566: END IF;
1567:
1568: -- execute callback api to set the message attributes
1569: EXECUTE IMMEDIATE 'BEGIN ' ||

Line 1575: dpp_utility_pvt.debug_message('Adding adhoc users' || l_role_list );

1571: 'END;'
1572: USING l_item_type, l_item_key, l_object_id, l_status;
1573:
1574: IF G_DEBUG THEN
1575: dpp_utility_pvt.debug_message('Adding adhoc users' || l_role_list );
1576: END IF;
1577:
1578: -- create an adhoc role with named after itemkey
1579: l_adhoc_role := l_item_key;

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

1584:
1585: l_context := l_msg_type || ':' || l_item_key || ':';
1586:
1587: IF G_DEBUG THEN
1588: dpp_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);
1589: dpp_utility_pvt.debug_message('Sent notification to role : ' || l_adhoc_role);
1590: END IF;
1591:
1592: -- set the message to be sent

Line 1589: dpp_utility_pvt.debug_message('Sent notification to role : ' || l_adhoc_role);

1585: l_context := l_msg_type || ':' || l_item_key || ':';
1586:
1587: IF G_DEBUG THEN
1588: dpp_utility_pvt.debug_message('Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);
1589: dpp_utility_pvt.debug_message('Sent notification to role : ' || l_adhoc_role);
1590: END IF;
1591:
1592: -- set the message to be sent
1593: l_group_notify_id := wf_notification.sendGroup(

Line 1604: dpp_utility_pvt.debug_message('Sending notification to role : ' || l_adhoc_role);

1600: send_comment => NULL,
1601: priority => NULL );
1602:
1603: IF G_DEBUG THEN
1604: dpp_utility_pvt.debug_message('Sending notification to role : ' || l_adhoc_role);
1605: dpp_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1606: END IF;
1607:
1608: -- start the notification process to send message

Line 1605: dpp_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );

1601: priority => NULL );
1602:
1603: IF G_DEBUG THEN
1604: dpp_utility_pvt.debug_message('Sending notification to role : ' || l_adhoc_role);
1605: dpp_utility_pvt.debug_message('Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1606: END IF;
1607:
1608: -- start the notification process to send message
1609: wf_engine.StartProcess(itemtype => l_item_type,

Line 1630: dpp_utility_pvt.debug_message( l_api_name||': End');

1626: END IF;
1627:
1628: -- Debug Message
1629: IF G_DEBUG THEN
1630: dpp_utility_pvt.debug_message( l_api_name||': End');
1631: END IF;
1632: --Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,

Line 1747: dpp_utility_pvt.debug_message( l_api_name||': Start');

1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1744: END IF;
1745: -- Debug Message
1746: IF G_DEBUG THEN
1747: dpp_utility_pvt.debug_message( l_api_name||': Start');
1748: END IF;
1749: --Initialize message list if p_init_msg_list is TRUE.
1750: IF FND_API.To_Boolean (p_init_msg_list) THEN
1751: FND_MSG_PUB.initialize;

Line 1785: dpp_utility_pvt.debug_message( 'Update User Action ' || p_approval_rec.action_code );

1781: -- Update AME/approval tbl of users action and revoke access to existing approvers
1782: IF p_approval_rec.action_code = 'APPROVE' OR
1783: p_approval_rec.action_code = 'REJECT' THEN
1784: IF G_DEBUG THEN
1785: dpp_utility_pvt.debug_message( 'Update User Action ' || p_approval_rec.action_code );
1786: END IF;
1787:
1788: -- Update_User_Action - Update the user action in approval table
1789: Update_User_Action(

Line 1814: dpp_utility_pvt.debug_message( 'Get Approvers ' || p_approval_rec.action_code );

1810: IF p_approval_rec.action_code = 'SUBMIT' OR
1811: p_approval_rec.action_code = 'APPROVE' THEN
1812:
1813: IF G_DEBUG THEN
1814: dpp_utility_pvt.debug_message( 'Get Approvers ' || p_approval_rec.action_code );
1815: END IF;
1816: -- Get_Approvers - List of Approvers or Default Approver
1817: Get_Approvers(
1818: p_api_version => p_api_version

Line 1839: dpp_utility_pvt.debug_message( 'Add Access ' || p_approval_rec.action_code );

1835: -- Add access to users who have approval privileges
1836: IF p_approval_rec.action_code = 'SUBMIT' OR
1837: p_approval_rec.action_code = 'APPROVE' THEN
1838: IF G_DEBUG THEN
1839: dpp_utility_pvt.debug_message( 'Add Access ' || p_approval_rec.action_code );
1840: END IF;
1841:
1842: IF l_final_approval_flag <> 'Y' THEN
1843: --If no Approver Found Do not add record in Access table

Line 1867: dpp_utility_pvt.debug_message( 'Access Added ' || x_return_status );

1863:
1864: END IF;
1865:
1866: IF G_DEBUG THEN
1867: dpp_utility_pvt.debug_message( 'Access Added ' || x_return_status );
1868: END IF;
1869: END IF;
1870:
1871: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN

Line 1875: dpp_utility_pvt.debug_message('assigning the event name :'||l_event_name);

1871: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
1872:
1873: l_event_name := 'oracle.apps.dpp.request.Transaction.approval';
1874: IF G_DEBUG THEN
1875: dpp_utility_pvt.debug_message('assigning the event name :'||l_event_name);
1876: END IF;
1877: END IF;
1878:
1879: l_event_key := p_approval_rec.object_type || ':' || p_approval_rec.object_id || ':' || to_char(sysdate, 'DD:MON:YYYY HH:MI:SS');

Line 1919: DPP_UTILITY_PVT.debug_message('Unable to Update the column transaction_status in dpp_transaction_headers_all Table');

1915: WHERE transaction_header_id = p_approval_rec.object_id;
1916:
1917: IF SQL%ROWCOUNT = 0 THEN
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: DPP_UTILITY_PVT.debug_message('Unable to Update the column transaction_status in dpp_transaction_headers_all Table');
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922: EXCEPTION
1923: WHEN OTHERS THEN

Line 1939: dpp_utility_pvt.debug_message(substr(('Return status for Initiate_ExecutionProcess : ' || errbuff),1,4000));

1935: l_org_id,
1936: l_txn_number
1937: );
1938: IF G_DEBUG THEN
1939: dpp_utility_pvt.debug_message(substr(('Return status for Initiate_ExecutionProcess : ' || errbuff),1,4000));
1940: END IF;
1941: IF retcode = 0 THEN
1942: x_final_approval_flag := 'A';
1943: IF G_DEBUG THEN

Line 1944: dpp_utility_pvt.debug_message( 'Transaction is made Active ');

1940: END IF;
1941: IF retcode = 0 THEN
1942: x_final_approval_flag := 'A';
1943: IF G_DEBUG THEN
1944: dpp_utility_pvt.debug_message( 'Transaction is made Active ');
1945: END IF;
1946: ELSE
1947: IF G_DEBUG THEN
1948: dpp_utility_pvt.debug_message( 'Initiate_ExecutionProcess Errored out. Transaction not made Active ');

Line 1948: dpp_utility_pvt.debug_message( 'Initiate_ExecutionProcess Errored out. Transaction not made Active ');

1944: dpp_utility_pvt.debug_message( 'Transaction is made Active ');
1945: END IF;
1946: ELSE
1947: IF G_DEBUG THEN
1948: dpp_utility_pvt.debug_message( 'Initiate_ExecutionProcess Errored out. Transaction not made Active ');
1949: END IF;
1950: END IF; --retcode = 0
1951: ELSE
1952: IF G_DEBUG THEN

Line 1953: dpp_utility_pvt.debug_message( 'Transaction is Future dated and hence not made Active ');

1949: END IF;
1950: END IF; --retcode = 0
1951: ELSE
1952: IF G_DEBUG THEN
1953: dpp_utility_pvt.debug_message( 'Transaction is Future dated and hence not made Active ');
1954: END IF;
1955: END IF; --l_effective_date <= sysdate
1956: END IF; --x_final_approval_flag := 'Y'
1957: --Standard check of commit

Line 1963: dpp_utility_pvt.debug_message( l_api_name||': End');

1959: COMMIT WORK;
1960: END IF;
1961: -- Debug Message
1962: IF G_DEBUG THEN
1963: dpp_utility_pvt.debug_message( l_api_name||': End');
1964: END IF;
1965: --Standard call to get message count and if count=1, get the message
1966: FND_MSG_PUB.Count_And_Get (
1967: p_encoded => FND_API.G_FALSE,