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_APPROVAL_PVT dependencies on AMS_APPROVAL_PVT

Line 1: PACKAGE BODY Ams_Approval_Pvt AS

1: PACKAGE BODY Ams_Approval_Pvt AS
2: /* $Header: amsvappb.pls 120.7.12020000.2 2013/02/21 09:59:40 amitamku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ams_approval_pvt';
5: G_ITEMTYPE CONSTANT VARCHAR2(30) := 'AMSAPRV';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ams_approval_pvt';

1: PACKAGE BODY Ams_Approval_Pvt AS
2: /* $Header: amsvappb.pls 120.7.12020000.2 2013/02/21 09:59:40 amitamku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ams_approval_pvt';
5: G_ITEMTYPE CONSTANT VARCHAR2(30) := 'AMSAPRV';
6:
7: /*************************** PRIVATE ROUTINES *******************************/
8: /*============================================================================*/

Line 240: Wf_Core.context ('ams_approval_pvt', 'Update_Status',p_activity_type

236:
237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: Wf_Core.context ('ams_approval_pvt', 'Update_Status',p_activity_type
241: ,p_activity_id ,'Unexpected error in Update_Status');
242: RAISE;
243:
244: END Update_Status;

Line 348: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type

344:
345: EXCEPTION
346: WHEN OTHERS THEN
347: -- wf_engine.threshold := l_save_threshold ;
348: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type
349: ,p_activity_id , 'Unexpected Error in Update_Note' );
350: RAISE;
351:
352: END Update_Note;

Line 444: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type

440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: -- wf_engine.threshold := l_save_threshold ;
444: Wf_Core.context ('ams_approval_pvt', 'Update_Note',p_activity_type
445: ,p_activity_id , 'Unexpected Error in Update_Note' );
446: RAISE;
447:
448: END Update_Justification_Note;

Line 489: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Name',p_user_id,

485: CLOSE c_resource ;
486: EXCEPTION
487: WHEN OTHERS THEN
488: -- wf_engine.threshold := l_save_threshold ;
489: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Name',p_user_id,
490: 'Unexpected Error IN Get_User_Name');
491: RAISE;
492:
493: END Get_User_Name;

Line 670: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Role',p_user_id

666: END IF;
667: EXCEPTION
668: WHEN OTHERS THEN
669: -- wf_engine.threshold := l_save_threshold ;
670: Wf_Core.context ('Ams_Approval_Pvt', 'Get_User_Role',p_user_id
671: ,'Unexpected Error IN Get_User_Role' );
672: RAISE;
673: END Get_User_Role;
674:

Line 932: Wf_Core.context ('ams_approval_pvt', 'Get_Activity_Details',p_activity_type

928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: -- wf_engine.threshold := l_save_threshold ;
932: Wf_Core.context ('ams_approval_pvt', 'Get_Activity_Details',p_activity_type
933: ,p_activity_id ,'Unexpected Error In Get_Activity_Details');
934: RAISE;
935:
936: END Get_Activity_Details;

Line 968: wf_core.context('ams_approval_pvt','get_ntf_rule_values','p_approver_name',

964: END IF;
965: CLOSE c_get_rule;
966: EXCEPTION
967: WHEN OTHERS THEN
968: wf_core.context('ams_approval_pvt','get_ntf_rule_values','p_approver_name',
969: 'Unexpected Error in Get_Ntf_Rule_Values');
970: RAISE;
971: END Get_Ntf_Rule_Values;
972:

Line 1022: Wf_Core.context ('Ams_Approval_Pvt', 'Get_line_amounts',p_activity_type

1018: CLOSE c_total_amount;
1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: Wf_Core.context ('Ams_Approval_Pvt', 'Get_line_amounts',p_activity_type
1023: ,p_activity_id ,'Unexpected Error IN Get_line_amounts');
1024: RAISE;
1025:
1026: END Get_line_amounts;

Line 1063: Wf_Core.context ('Ams_Approval_Pvt', 'Check_Approval_Required',p_approval_detail_id

1059: CLOSE c_check_app;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062:
1063: Wf_Core.context ('Ams_Approval_Pvt', 'Check_Approval_Required',p_approval_detail_id
1064: ,p_current_seq ,'Unexpected Error IN Check_Approval_Required');
1065: RAISE;
1066:
1067: END Check_Approval_Required;

Line 1231: Wf_Core.context ('Ams_Approval_Pvt', 'Get_Approver_Info',p_approval_detail_id

1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: -- wf_engine.threshold := l_save_threshold ;
1230:
1231: Wf_Core.context ('Ams_Approval_Pvt', 'Get_Approver_Info',p_approval_detail_id
1232: ,p_current_seq ,'Unexpected Error IN Get_Approver_Info');
1233: RAISE;
1234: END Get_Approver_Info;
1235:

Line 1935: Wf_Core.context ('Ams_Approval_Pvt', 'StartProcess',p_activity_type

1931: p_msg_count => l_msg_count, -- Number of error Messages
1932: p_msg_data => l_msg_data ,
1933: p_attr_name => 'AMS_ERROR_MSG',
1934: x_error_msg => l_error_msg );
1935: Wf_Core.context ('Ams_Approval_Pvt', 'StartProcess',p_activity_type
1936: ,p_activity_id ,l_error_msg);
1937: RAISE;
1938: WHEN OTHERS THEN
1939: -- wf_engine.threshold := l_save_threshold ;

Line 1952: Wf_Core.context ('Ams_Approval_Pvt', 'StartProcess',p_activity_type

1948: p_msg_data => l_msg_data ,
1949: p_attr_name => 'AMS_ERROR_MSG',
1950: x_error_msg => l_error_msg
1951: ) ;
1952: Wf_Core.context ('Ams_Approval_Pvt', 'StartProcess',p_activity_type
1953: ,p_activity_id ,l_error_msg);
1954: RAISE;
1955:
1956: END StartProcess;

Line 2175: wf_core.context('Ams_Approval_Pvt','Set_Activity_Details',

2171: x_error_msg => l_error_msg
2172: ) ;
2173:
2174: /*
2175: wf_core.context('Ams_Approval_Pvt','Set_Activity_Details',
2176: itemtype,itemkey,actid,l_error_msg); */
2177: -- RAISE FND_API.G_EXC_ERROR;
2178: resultout := 'COMPLETE:ERROR';
2179: RETURN;

Line 2216: /*wf_core.context('Ams_Approval_Pvt','Set_Activity_Details',

2212: p_attr_name => 'AMS_ERROR_MSG',
2213: x_error_msg => l_error_msg
2214: ) ;
2215: resultout := 'COMPLETE:ERROR';
2216: /*wf_core.context('Ams_Approval_Pvt','Set_Activity_Details',
2217: itemtype,itemkey,actid,funcmode,l_error_msg);
2218: raise; */
2219: WHEN OTHERS THEN
2220: Fnd_Msg_Pub.Count_And_Get (

Line 2233: Wf_Core.context('Ams_Approval_Pvt','Set_Activity_Details',

2229: p_msg_data => l_msg_data ,
2230: p_attr_name => 'AMS_ERROR_MSG',
2231: x_error_msg => l_error_msg
2232: ) ;
2233: Wf_Core.context('Ams_Approval_Pvt','Set_Activity_Details',
2234: itemtype,itemkey,actid,funcmode,l_error_msg);
2235: RAISE;
2236: END Set_Activity_Details ;
2237:

Line 2323: Wf_Core.context('Ams_Approval_Pvt',

2319: p_msg_data => l_msg_data ,
2320: p_attr_name => 'AMS_ERROR_MSG',
2321: x_error_msg => l_error_msg
2322: ) ;
2323: Wf_Core.context('Ams_Approval_Pvt',
2324: 'Check_Budget_Lines',
2325: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
2326: RAISE;
2327: END Check_Budget_Lines;

Line 2487: Wf_Core.context('Ams_Approval_Pvt',

2483: p_msg_data => l_msg_data ,
2484: p_attr_name => 'AMS_ERROR_MSG',
2485: x_error_msg => l_error_msg
2486: ) ;
2487: Wf_Core.context('Ams_Approval_Pvt',
2488: 'check_approval_rules',
2489: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
2490: RAISE;
2491: --

Line 2847: /*wf_core.context('Ams_Approval_Pvt',

2843: p_attr_name => 'AMS_ERROR_MSG',
2844: x_error_msg => l_error_msg
2845: ) ;
2846: resultout := 'COMPLETE:ERROR';
2847: /*wf_core.context('Ams_Approval_Pvt',
2848: 'set_approval_rules',
2849: itemtype, itemkey,to_char(actid),l_error_msg);
2850: RAISE; */
2851: WHEN OTHERS THEN

Line 2865: Wf_Core.context('Ams_Approval_Pvt',

2861: p_msg_data => l_msg_data ,
2862: p_attr_name => 'AMS_ERROR_MSG',
2863: x_error_msg => l_error_msg
2864: ) ;
2865: Wf_Core.context('Ams_Approval_Pvt',
2866: 'set_approval_rules',
2867: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
2868: RAISE;
2869: --

Line 3084: Wf_Core.context('Ams_Approval_Pvt',

3080: p_msg_data => l_msg_data ,
3081: p_attr_name => 'AMS_ERROR_MSG',
3082: x_error_msg => l_error_msg
3083: ) ;
3084: Wf_Core.context('Ams_Approval_Pvt',
3085: 'set_further_approvals',
3086: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
3087: RAISE;
3088: WHEN OTHERS THEN

Line 3102: Wf_Core.context('Ams_Approval_Pvt',

3098: p_msg_data => l_msg_data ,
3099: p_attr_name => 'AMS_ERROR_MSG',
3100: x_error_msg => l_error_msg
3101: ) ;
3102: Wf_Core.context('Ams_Approval_Pvt',
3103: 'set_further_approvals',
3104: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
3105: RAISE;
3106: --

Line 3252: Wf_Core.context('Ams_Approval_Pvt',

3248: p_msg_data => l_msg_data ,
3249: p_attr_name => 'AMS_ERROR_MSG',
3250: x_error_msg => l_error_msg
3251: ) ;
3252: Wf_Core.context('Ams_Approval_Pvt',
3253: 'Revert_status',
3254: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
3255: RAISE;
3256: END Revert_Status;

Line 3304: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_activity_type : '|| l_activity_type);

3300: itemkey => itemkey,
3301: aname => 'AMS_NEW_STAT_ID' );
3302:
3303:
3304: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_activity_type : '|| l_activity_type);
3305:
3306: IF (l_activity_type = 'OFFR') THEN
3307: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
3308: , itemkey => itemkey

Line 3322: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_user_id : '|| l_user_id);

3318: , itemkey => itemkey
3319: , aname => 'APPLICATION_ID'
3320: );
3321:
3322: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_user_id : '|| l_user_id);
3323: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_resp_id : '|| l_resp_id);
3324: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_appl_id : '|| l_appl_id);
3325:
3326:

Line 3323: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_resp_id : '|| l_resp_id);

3319: , aname => 'APPLICATION_ID'
3320: );
3321:
3322: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_user_id : '|| l_user_id);
3323: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_resp_id : '|| l_resp_id);
3324: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_appl_id : '|| l_appl_id);
3325:
3326:
3327: IF (l_user_id IS NOT NULL AND l_resp_id IS NOT NULL AND l_appl_id IS NOT NULL) THEN

Line 3324: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_appl_id : '|| l_appl_id);

3320: );
3321:
3322: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_user_id : '|| l_user_id);
3323: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_resp_id : '|| l_resp_id);
3324: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_appl_id : '|| l_appl_id);
3325:
3326:
3327: IF (l_user_id IS NOT NULL AND l_resp_id IS NOT NULL AND l_appl_id IS NOT NULL) THEN
3328: FND_GLOBAL.apps_initialize( user_id => l_user_id

Line 3336: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status list_header_id : '|| l_activity_id);

3332: );
3333: END IF;
3334:
3335:
3336: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status list_header_id : '|| l_activity_id);
3337:
3338: l_org_id := find_org_id (l_activity_id);
3339: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_org_id : '||l_org_id);
3340:

Line 3339: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_org_id : '||l_org_id);

3335:
3336: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status list_header_id : '|| l_activity_id);
3337:
3338: l_org_id := find_org_id (l_activity_id);
3339: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_org_id : '||l_org_id);
3340:
3341: IF l_org_id IS NOT NULL THEN
3342: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status before setting context : list_header_id '|| l_activity_id);
3343: set_org_ctx (l_org_id);

Line 3342: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status before setting context : list_header_id '|| l_activity_id);

3338: l_org_id := find_org_id (l_activity_id);
3339: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Approve_Activity_status l_org_id : '||l_org_id);
3340:
3341: IF l_org_id IS NOT NULL THEN
3342: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status before setting context : list_header_id '|| l_activity_id);
3343: set_org_ctx (l_org_id);
3344: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status after setting context : list_header_id '|| l_activity_id);
3345: END IF;
3346:

Line 3344: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status after setting context : list_header_id '|| l_activity_id);

3340:
3341: IF l_org_id IS NOT NULL THEN
3342: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status before setting context : list_header_id '|| l_activity_id);
3343: set_org_ctx (l_org_id);
3344: OZF_DEBUG_PVT.DEBUG_MO('AMS_Approval_PVT Approve_Activity_status after setting context : list_header_id '|| l_activity_id);
3345: END IF;
3346:
3347:
3348: END IF;

Line 3412: Wf_Core.context('Ams_Approval_Pvt',

3408: p_msg_data => l_msg_data ,
3409: p_attr_name => 'AMS_ERROR_MSG',
3410: x_error_msg => l_error_msg
3411: ) ;
3412: Wf_Core.context('Ams_Approval_Pvt',
3413: 'Approve_activity_status',
3414: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
3415: RAISE;
3416: END Approve_Activity_status;

Line 3623: Wf_Core.context('Ams_Approval_Pvt',

3619: p_msg_data => l_msg_data ,
3620: p_attr_name => 'AMS_ERROR_MSG',
3621: x_error_msg => l_error_msg
3622: ) ;
3623: Wf_Core.context('Ams_Approval_Pvt',
3624: 'Reject_activity_status',
3625: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
3626: RAISE;
3627: END Reject_Activity_status;

Line 3659: Wf_Core.context('Ams_Approval_Pvt',

3655: itemkey => itemkey ,
3656: process => p_workflowprocess);
3657: EXCEPTION
3658: WHEN OTHERS THEN
3659: Wf_Core.context('Ams_Approval_Pvt',
3660: 'AbortProcess',
3661: itemtype,
3662: itemkey
3663: ,p_workflowprocess);

Line 3964: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_user_id : '|| l_user_id);

3960: l_resp_id := FND_GLOBAL.resp_id;
3961: l_appl_id := FND_GLOBAL.resp_appl_id;
3962: l_security_group_id := FND_GLOBAL.security_group_id;
3963:
3964: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_user_id : '|| l_user_id);
3965: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_resp_id : '|| l_resp_id);
3966: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_appl_id : '|| l_appl_id);
3967:
3968: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,

Line 3965: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_resp_id : '|| l_resp_id);

3961: l_appl_id := FND_GLOBAL.resp_appl_id;
3962: l_security_group_id := FND_GLOBAL.security_group_id;
3963:
3964: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_user_id : '|| l_user_id);
3965: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_resp_id : '|| l_resp_id);
3966: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_appl_id : '|| l_appl_id);
3967:
3968: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3969: itemkey => l_itemkey,

Line 3966: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_appl_id : '|| l_appl_id);

3962: l_security_group_id := FND_GLOBAL.security_group_id;
3963:
3964: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_user_id : '|| l_user_id);
3965: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_resp_id : '|| l_resp_id);
3966: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','AMS_Approval_PVT Start_Process l_appl_id : '|| l_appl_id);
3967:
3968: WF_ENGINE.SetItemAttrNumber(itemtype => l_itemtype ,
3969: itemkey => l_itemkey,
3970: aname => 'USER_ID',

Line 4387: Wf_Core.context ('Ams_Approval_Pvt', 'Start_Process',

4383: p_msg_count => l_msg_count, -- Number of error Messages
4384: p_msg_data => l_msg_data ,
4385: p_attr_name => 'AMS_ERROR_MSG',
4386: x_error_msg => l_error_msg);
4387: Wf_Core.context ('Ams_Approval_Pvt', 'Start_Process',
4388: l_budget_type ,l_budget_id ,l_error_msg);
4389: RAISE;
4390: WHEN OTHERS THEN
4391: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

Line 4406: Wf_Core.context ('Ams_Approval_Pvt', 'Start_Process',

4402: p_msg_count => l_msg_count, -- Number of error Messages
4403: p_msg_data => l_msg_data ,
4404: p_attr_name => 'AMS_ERROR_MSG',
4405: x_error_msg => l_error_msg);
4406: Wf_Core.context ('Ams_Approval_Pvt', 'Start_Process',
4407: l_budget_type ,l_budget_id ,l_error_msg);
4408: RAISE;
4409: --
4410: END Start_Process;

Line 4576: -- AMS_APPROVAL_PVT AMS_START_LINE_APPROVAL

4572: -- - 'COMPLETE:N' If there is no parent process and this process can end
4573: --
4574: -- USED BY ACTIVITIES
4575: --
4576: -- AMS_APPROVAL_PVT AMS_START_LINE_APPROVAL
4577: --
4578: /*============================================================================*/
4579:
4580: PROCEDURE Start_Line_Approval( itemtype IN VARCHAR2,

Line 4773: /* wf_core.context('AMS_APPROVAL_PVT',

4769: p_msg_data => l_msg_data ,
4770: p_attr_name => 'AMS_ERROR_MSG',
4771: x_error_msg => l_error_msg);
4772: resultout := 'COMPLETE:ERROR';
4773: /* wf_core.context('AMS_APPROVAL_PVT',
4774: 'Start_Line_Approval',
4775: itemtype, itemkey,to_char(actid),l_error_msg);
4776: RAISE;
4777: */

Line 4790: Wf_Core.context('AMS_APPROVAL_PVT',

4786: p_msg_count => l_msg_count, -- Number of error Messages
4787: p_msg_data => l_msg_data ,
4788: p_attr_name => 'AMS_ERROR_MSG',
4789: x_error_msg => l_error_msg);
4790: Wf_Core.context('AMS_APPROVAL_PVT',
4791: 'Start_Line_Approval',
4792: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
4793: RAISE;
4794: --

Line 4813: -- AMS_APPROVAL_PVT AMS_GET_LINE_DETAILS

4809: -- Resultout - 'COMPLETE:' After getting line approver details
4810: --
4811: -- USED BY ACTIVITIES
4812: --
4813: -- AMS_APPROVAL_PVT AMS_GET_LINE_DETAILS
4814: --
4815: /*============================================================================*/
4816:
4817: PROCEDURE Get_Line_Approver_Details( itemtype IN VARCHAR2,

Line 5191: Wf_Core.context('AMS_APPROVAL_PVT',

5187: p_msg_count => l_msg_count, -- Number of error Messages
5188: p_msg_data => l_msg_data ,
5189: p_attr_name => 'AMS_ERROR_MSG',
5190: x_error_msg => l_error_msg);
5191: Wf_Core.context('AMS_APPROVAL_PVT',
5192: 'Get_Line_Approver_Details ' || l_approver || ' : ',
5193: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5194: RAISE;
5195: --

Line 5215: -- AMS_APPROVAL_PVT AMS_GET_APPROVER_DETAILS

5211: -- - 'COMPLETE:N' If line does not need further approvals
5212: --
5213: -- USED BY ACTIVITIES
5214: --
5215: -- AMS_APPROVAL_PVT AMS_GET_APPROVER_DETAILS
5216: --
5217: /*============================================================================*/
5218:
5219: PROCEDURE Check_Line_Further_Approval( itemtype IN VARCHAR2,

Line 5397: Wf_Core.context('AMS_APPROVAL_PVT',

5393: p_msg_count => l_msg_count, -- Number of error Messages
5394: p_msg_data => l_msg_data ,
5395: p_attr_name => 'AMS_ERROR_MSG',
5396: x_error_msg => l_error_msg);
5397: Wf_Core.context('AMS_APPROVAL_PVT',
5398: 'Check_Line_Further_Approval',
5399: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5400: RAISE;
5401: WHEN OTHERS THEN

Line 5418: Wf_Core.context('AMS_APPROVAL_PVT',

5414: p_msg_count => l_msg_count, -- Number of error Messages
5415: p_msg_data => l_msg_data ,
5416: p_attr_name => 'AMS_ERROR_MSG',
5417: x_error_msg => l_error_msg);
5418: Wf_Core.context('AMS_APPROVAL_PVT',
5419: 'Check_Line_Further_Approval',
5420: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5421: RAISE;
5422: --

Line 5441: -- AMS_APPROVAL_PVT AMS_APPROVE_BUDGET_LINE

5437: -- Resultout - 'COMPLETE:' After approval
5438: --
5439: -- USED BY ACTIVITIES
5440: --
5441: -- AMS_APPROVAL_PVT AMS_APPROVE_BUDGET_LINE
5442: --
5443: /*============================================================================*/
5444:
5445: PROCEDURE Approve_Budget_Line(itemtype IN VARCHAR2,

Line 5610: Wf_Core.context('AMS_APPROVAL_PVT',

5606: p_msg_count => l_msg_count, -- Number of error Messages
5607: p_msg_data => l_msg_data ,
5608: p_attr_name => 'AMS_ERROR_MSG',
5609: x_error_msg => l_error_msg);
5610: Wf_Core.context('AMS_APPROVAL_PVT',
5611: 'Approve_Budget_Line',
5612: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5613: RAISE;
5614: WHEN OTHERS THEN

Line 5626: Wf_Core.context('AMS_APPROVAL_PVT',

5622: p_msg_count => l_msg_count, -- Number of error Messages
5623: p_msg_data => l_msg_data ,
5624: p_attr_name => 'AMS_ERROR_MSG',
5625: x_error_msg => l_error_msg);
5626: Wf_Core.context('AMS_APPROVAL_PVT',
5627: 'Approve_Budget_Line',
5628: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5629: RAISE;
5630: END Approve_Budget_Line;

Line 5648: -- AMS_APPROVAL_PVT AMS_REJECT_BUDGET_LINE

5644: -- Resultout - 'COMPLETE:' After Rejection
5645: --
5646: -- USED BY ACTIVITIES
5647: --
5648: -- AMS_APPROVAL_PVT AMS_REJECT_BUDGET_LINE
5649: --
5650: /*============================================================================*/
5651:
5652: PROCEDURE Reject_Budget_Line(itemtype IN VARCHAR2,

Line 5901: Wf_Core.context('AMS_APPROVAL_PVT',

5897: p_msg_count => l_msg_count, -- Number of error Messages
5898: p_msg_data => l_msg_data ,
5899: p_attr_name => 'AMS_ERROR_MSG',
5900: x_error_msg => l_error_msg);
5901: Wf_Core.context('AMS_APPROVAL_PVT',
5902: 'Reject_Budget_Line',
5903: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5904: RAISE;
5905: WHEN OTHERS THEN

Line 5917: Wf_Core.context('AMS_APPROVAL_PVT',

5913: p_msg_count => l_msg_count, -- Number of error Messages
5914: p_msg_data => l_msg_data ,
5915: p_attr_name => 'AMS_ERROR_MSG',
5916: x_error_msg => l_error_msg);
5917: Wf_Core.context('AMS_APPROVAL_PVT',
5918: 'Reject_Budget_Line',
5919: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5920: RAISE;
5921: END Reject_Budget_Line;

Line 5939: -- AMS_APPROVAL_PVT AMS_REJECT_BUDGET_LINE

5935: -- Resultout - 'COMPLETE:' After Rejection
5936: --
5937: -- USED BY ACTIVITIES
5938: --
5939: -- AMS_APPROVAL_PVT AMS_REJECT_BUDGET_LINE
5940: --
5941: /*============================================================================*/
5942:
5943: PROCEDURE Revert_Budget_Line(itemtype IN VARCHAR2,

Line 6116: Wf_Core.context('AMS_APPROVAL_PVT',

6112: p_msg_count => l_msg_count, -- Number of error Messages
6113: p_msg_data => l_msg_data ,
6114: p_attr_name => 'AMS_ERROR_MSG',
6115: x_error_msg => l_error_msg);
6116: Wf_Core.context('AMS_APPROVAL_PVT',
6117: 'Revert_Budget_Line',
6118: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6119: RAISE;
6120: WHEN OTHERS THEN

Line 6132: Wf_Core.context('AMS_APPROVAL_PVT',

6128: p_msg_count => l_msg_count, -- Number of error Messages
6129: p_msg_data => l_msg_data ,
6130: p_attr_name => 'AMS_ERROR_MSG',
6131: x_error_msg => l_error_msg);
6132: Wf_Core.context('AMS_APPROVAL_PVT',
6133: 'Reject_Budget_Line',
6134: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6135: RAISE;
6136: END Revert_Budget_Line;

Line 6156: -- AMS_APPROVAL_PVT AMS_PARENT_EXISTS

6152: -- - 'COMPLETE:N' If there is no parent process and this process can end
6153: --
6154: -- USED BY ACTIVITIES
6155: --
6156: -- AMS_APPROVAL_PVT AMS_PARENT_EXISTS
6157: --
6158: --------------------------------------------------------------------------------
6159: PROCEDURE Is_Parent_Waiting (itemtype IN VARCHAR2,
6160: itemkey IN VARCHAR2,

Line 6226: Wf_Core.context('AMS_APPROVAL_PVT',

6222: p_msg_count => l_msg_count, -- Number of error Messages
6223: p_msg_data => l_msg_data ,
6224: p_attr_name => 'AMS_ERROR_MSG',
6225: x_error_msg => l_error_msg);
6226: Wf_Core.context('AMS_APPROVAL_PVT',
6227: 'Is_Parent_Waiting',
6228: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6229: RAISE;
6230: END Is_Parent_Waiting;

Line 6248: -- AMS_APPROVAL_PVT AMS_CHECK_LINE_APPROVAL_RULE

6244: -- - 'COMPLETE:N' If there is no parent process and this process can end
6245: --
6246: -- USED BY ACTIVITIES
6247: --
6248: -- AMS_APPROVAL_PVT AMS_CHECK_LINE_APPROVAL_RULE
6249: --
6250: --------------------------------------------------------------------------------
6251: PROCEDURE Check_Line_Approval_Rule(itemtype IN VARCHAR2,
6252: itemkey IN VARCHAR2,

Line 6374: Wf_Core.context('AMS_APPROVAL_PVT',

6370: p_msg_count => l_msg_count, -- Number of error Messages
6371: p_msg_data => l_msg_data ,
6372: p_attr_name => 'AMS_ERROR_MSG',
6373: x_error_msg => l_error_msg);
6374: Wf_Core.context('AMS_APPROVAL_PVT',
6375: 'Check_Line_Approval_Rule',
6376: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6377: RAISE;
6378: END Check_Line_Approval_Rule;

Line 6396: -- AMS_APPROVAL_PVT AMS_CHECK_MORE_LINES_REMAINING

6392: -- - 'COMPLETE:N' If there is no parent process and this process can end
6393: --
6394: -- USED BY ACTIVITIES
6395: --
6396: -- AMS_APPROVAL_PVT AMS_CHECK_MORE_LINES_REMAINING
6397: --
6398: --------------------------------------------------------------------------------
6399: PROCEDURE Check_More_Lines_Remaining(itemtype IN VARCHAR2,
6400: itemkey IN VARCHAR2,

Line 6504: Wf_Core.context('AMS_APPROVAL_PVT',

6500: p_msg_count => l_msg_count, -- Number of error Messages
6501: p_msg_data => l_msg_data ,
6502: p_attr_name => 'AMS_ERROR_MSG',
6503: x_error_msg => l_error_msg);
6504: Wf_Core.context('AMS_APPROVAL_PVT',
6505: 'Check_More_Lines_Remaining',
6506: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6507: RAISE;
6508: END Check_More_Lines_Remaining;

Line 6526: -- AMS_APPROVAL_PVT AMS_PARENT_EXISTS

6522: -- - 'COMPLETE:N' If there is no parent process and this process can end
6523: --
6524: -- USED BY ACTIVITIES
6525: --
6526: -- AMS_APPROVAL_PVT AMS_PARENT_EXISTS
6527: --
6528: --------------------------------------------------------------------------------
6529: PROCEDURE Can_Continue_Flow (itemtype IN VARCHAR2,
6530: itemkey IN VARCHAR2,

Line 6655: Wf_Core.context('AMS_APPROVAL_PVT',

6651: p_msg_count => l_msg_count, -- Number of error Messages
6652: p_msg_data => l_msg_data ,
6653: p_attr_name => 'AMS_ERROR_MSG',
6654: x_error_msg => l_error_msg);
6655: Wf_Core.context('AMS_APPROVAL_PVT',
6656: 'Can_Continue_Flow',
6657: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6658: RAISE;
6659: END Can_Continue_Flow;

Line 6677: -- AMS_APPROVAL_PVT AMS_CONTINUE_PARENT

6673: -- Resultout - 'COMPLETE:' none
6674: --
6675: -- USED BY ACTIVITIES
6676: --
6677: -- AMS_APPROVAL_PVT AMS_CONTINUE_PARENT
6678: --
6679: --------------------------------------------------------------------------------
6680: PROCEDURE Continue_Parent_Process (itemtype IN VARCHAR2,
6681: itemkey IN VARCHAR2,

Line 6758: Wf_Core.context('AMS_APPROVAL_PVT',

6754: p_msg_count => l_msg_count, -- Number of error Messages
6755: p_msg_data => l_msg_data ,
6756: p_attr_name => 'AMS_ERROR_MSG',
6757: x_error_msg => l_error_msg);
6758: Wf_Core.context('AMS_APPROVAL_PVT',
6759: 'Continue_Parent_Process',
6760: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
6761: RAISE;
6762: END Continue_Parent_Process;

Line 6888: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'

6884:
6885:
6886: EXCEPTION
6887: WHEN Fnd_Api.G_EXC_ERROR THEN
6888: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'
6889: ,p_deliverable_id ,p_workflowprocess);
6890: RAISE;
6891: WHEN OTHERS THEN
6892: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'

Line 6892: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'

6888: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'
6889: ,p_deliverable_id ,p_workflowprocess);
6890: RAISE;
6891: WHEN OTHERS THEN
6892: Wf_Core.context ('ams_approval_pvt', 'DelvStartProcess'
6893: ,p_deliverable_id ,p_workflowprocess);
6894: Ams_Utility_Pvt.debug_message('Inside Exception');
6895: RAISE;
6896: END DelvStartProcess;

Line 6982: Wf_Core.context ('ams_approval_pvt', 'StartProcess',l_activity_type

6978: p_msg_count => l_msg_count, -- Number of error Messages
6979: p_msg_data => l_msg_data ,
6980: p_attr_name => 'AMS_ERROR_MSG',
6981: x_error_msg => l_error_msg );
6982: Wf_Core.context ('ams_approval_pvt', 'StartProcess',l_activity_type
6983: ,l_activity_id ,l_error_msg);
6984: RAISE;
6985: END;
6986: ---------------------------------------------------------------------------

Line 7100: Wf_Core.context('AMS_APPROVAL_PVT',

7096: p_msg_data => l_msg_data ,
7097: p_attr_name => 'AMS_ERROR_MSG',
7098: x_error_msg => l_error_msg
7099: );
7100: Wf_Core.context('AMS_APPROVAL_PVT',
7101: 'Validate_Object_Budget_WF',
7102: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
7103: RAISE;
7104: --resultout := 'COMPLETE:ERROR';

Line 7117: Wf_Core.context('AMS_APPROVAL_PVT',

7113: p_msg_count => l_msg_count, -- Number of error Messages
7114: p_msg_data => l_msg_data ,
7115: p_attr_name => 'AMS_ERROR_MSG',
7116: x_error_msg => l_error_msg);
7117: Wf_Core.context('AMS_APPROVAL_PVT',
7118: 'Validate_Object_Budget_WF',
7119: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
7120: RAISE;
7121: END Validate_Object_Budget_WF;

Line 7343: AMS_Approval_Pvt.Get_Approval_Details(p_activity_id => p_activity_id,

7339: x_approval_detail_id => x_approval_detail_id,
7340: x_return_status => x_return_status);
7341: ELSE
7342:
7343: AMS_Approval_Pvt.Get_Approval_Details(p_activity_id => p_activity_id,
7344: p_activity_type => p_activity_type,
7345: p_approval_type => p_approval_type,
7346: p_act_budget_id => p_act_budget_id,
7347: x_object_details => l_obj_details,

Line 7520: wf_core.context('ams_approval_pvt','PostNotif_Update',

7516: wf_core.token('MESSAGE', l_error_msg);
7517: wf_core.raise('WF_PLSQL_ERROR');
7518:
7519: WHEN OTHERS THEN
7520: wf_core.context('ams_approval_pvt','PostNotif_Update',
7521: itemtype,itemkey,actid,funcmode,'Error in PNF');
7522: raise;
7523: END PostNotif_Update;
7524: ---------------------------------------------------------------

Line 7637: Wf_Core.context('AMS_APPROVAL_PVT',

7633: p_msg_data => l_msg_data ,
7634: p_attr_name => 'AMS_ERROR_MSG',
7635: x_error_msg => l_error_msg
7636: );
7637: Wf_Core.context('AMS_APPROVAL_PVT',
7638: 'Validate_Object_Budget_All_WF',
7639: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
7640: RAISE;
7641: --resultout := 'COMPLETE:ERROR';

Line 7654: Wf_Core.context('AMS_APPROVAL_PVT',

7650: p_msg_count => l_msg_count, -- Number of error Messages
7651: p_msg_data => l_msg_data ,
7652: p_attr_name => 'AMS_ERROR_MSG',
7653: x_error_msg => l_error_msg);
7654: Wf_Core.context('AMS_APPROVAL_PVT',
7655: 'Validate_Object_Budget_All_WF',
7656: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
7657: RAISE;
7658: END Validate_Object_Budget_All_WF;

Line 7852: END Ams_Approval_Pvt;

7848: end if;
7849:
7850: END Check_Object_Type;
7851: --------------------------------------------------------------------------
7852: END Ams_Approval_Pvt;