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.PA_AGREEMENT_PUB dependencies on PA_AGREEMENT_UTILS

Line 22: -- pa_agreement_utils.validate_flex_fields

18: --
19: --Called subprograms:
20: -- pa_interface_utils_pub.map_new_amg_msg
21: -- pa_agreement_pub.check_create_agreement_ok
22: -- pa_agreement_utils.validate_flex_fields
23: -- pa_agreement_pvt.convert_ag_ref_to_id
24: -- pa_agreement_utils.create_agreement
25: -- pa_agreement_pub.add_funding
26: --

Line 24: -- pa_agreement_utils.create_agreement

20: -- pa_interface_utils_pub.map_new_amg_msg
21: -- pa_agreement_pub.check_create_agreement_ok
22: -- pa_agreement_utils.validate_flex_fields
23: -- pa_agreement_pvt.convert_ag_ref_to_id
24: -- pa_agreement_utils.create_agreement
25: -- pa_agreement_pub.add_funding
26: --
27: --
28: --

Line 704: pa_agreement_utils.create_agreement

700: l_agreement_in_rec.attribute25 := NULL;
701: END IF;
702:
703: -- CREATE AGREEMENT
704: pa_agreement_utils.create_agreement
705: (p_rowid => l_row_id
706: ,p_agreement_id => l_out_agreement_id
707: ,p_customer_id => l_agreement_in_rec.customer_id
708: ,p_agreement_num => l_agreement_in_rec.agreement_num

Line 953: -- pa_agreement_utils.delete_agreement

949: --Called subprograms:
950: -- pa_interface_utils_pub.map_new_amg_msg
951: -- pa_agreement_pub.check_delete_agreement_ok
952: -- pa_agreement_pvt.convert_ag_ref_to_id
953: -- pa_agreement_utils.delete_agreement
954:
955: --
956: --
957: --

Line 1194: pa_agreement_utils.delete_agreement

1190: CLOSE l_funding_id_csr;
1191:
1192: -- DELETE AGREEMENT
1193:
1194: pa_agreement_utils.delete_agreement
1195: (p_agreement_id => l_out_agreement_id);
1196:
1197: IF FND_API.to_boolean( p_commit )
1198: THEN

Line 1261: -- pa_agreement_utils.validate_flex_fields

1257: --
1258: --Called subprograms:
1259: -- pa_interface_utils_pub.map_new_amg_msg
1260: -- pa_agreement_pub.check_update_agreement_ok
1261: -- pa_agreement_utils.validate_flex_fields
1262: -- pa_agreement_pvt.convert_ag_ref_to_id
1263: -- pa_agreement_utils.update_agreement
1264: -- pa_agreement_pub.add_funding
1265: --

Line 1263: -- pa_agreement_utils.update_agreement

1259: -- pa_interface_utils_pub.map_new_amg_msg
1260: -- pa_agreement_pub.check_update_agreement_ok
1261: -- pa_agreement_utils.validate_flex_fields
1262: -- pa_agreement_pvt.convert_ag_ref_to_id
1263: -- pa_agreement_utils.update_agreement
1264: -- pa_agreement_pub.add_funding
1265: --
1266: --
1267: --

Line 1665: pa_agreement_utils.update_agreement

1661: END IF;
1662:
1663:
1664: -- UPDATE AGREEMENT
1665: pa_agreement_utils.update_agreement
1666: (p_agreement_id => l_out_agreement_id
1667: ,p_customer_id => l_agreement_in_rec.customer_id
1668: ,p_agreement_num => l_agreement_in_rec.agreement_num
1669: ,p_agreement_type => l_agreement_in_rec.agreement_type

Line 1940: -- pa_agreement_utils.validate_flex_fields

1936: --
1937: --Called subprograms:
1938: -- pa_interface_utils_pub.map_new_amg_msg
1939: -- pa_agreement_pub.check_add_funding_ok
1940: -- pa_agreement_utils.validate_flex_fields
1941: -- pa_agreement_pvt.convert_fu_ref_to_id
1942: -- pa_agreement_utils.add_funding
1943: --
1944: --

Line 1942: -- pa_agreement_utils.add_funding

1938: -- pa_interface_utils_pub.map_new_amg_msg
1939: -- pa_agreement_pub.check_add_funding_ok
1940: -- pa_agreement_utils.validate_flex_fields
1941: -- pa_agreement_pvt.convert_fu_ref_to_id
1942: -- pa_agreement_utils.add_funding
1943: --
1944: --
1945: --
1946: --History:

Line 2554: pa_agreement_utils.create_funding(

2550:
2551:
2552:
2553: -- ADD FUNDING
2554: pa_agreement_utils.create_funding(
2555: p_Rowid => l_row_id,
2556: p_Project_Funding_Id => p_funding_id,
2557: p_Last_Update_Date => SYSDATE,
2558: p_Last_Updated_By => G_USER_ID,

Line 2630: pa_agreement_utils.summary_funding_insert_row

2626:
2627: ELSE
2628:
2629: -- UPDATE SUMMARY PROJECT FUNDINGS
2630: pa_agreement_utils.summary_funding_insert_row
2631: (p_agreement_id => p_agreement_id
2632: ,p_project_id => p_pa_project_id
2633: ,p_task_id => p_pa_task_id
2634: ,p_login_id => G_LOGIN_ID

Line 2688: -- pa_agreement_utils.delete_agreement

2684: --Called subprograms:
2685: -- pa_interface_utils_pub.map_new_amg_msg
2686: -- pa_agreement_pub.check_delete_funding_ok
2687: -- pa_agreement_pvt.convert_fu_ref_to_id
2688: -- pa_agreement_utils.delete_agreement
2689: --
2690: --
2691: --
2692: --History:

Line 2759: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,

2755:
2756: -- This call is added for patchset K project role based security check
2757:
2758: -- Get the project id from this project funding line
2759: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,
2760: p_funding_reference => p_pm_funding_reference);
2761:
2762: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id;
2763:

Line 2921: (p_agreement_id => pa_agreement_utils.get_agreement_id( p_funding_id => p_funding_id

2917: -- start
2918:
2919: IF p_check_y_n = 'Y' THEN
2920: IF pa_agreement_pvt.check_delete_funding_ok
2921: (p_agreement_id => pa_agreement_utils.get_agreement_id( p_funding_id => p_funding_id
2922: ,p_funding_reference => p_pm_funding_reference)
2923: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
2924: ,p_pm_funding_reference => p_pm_funding_reference) = 'N'
2925: THEN

Line 2923: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)

2919: IF p_check_y_n = 'Y' THEN
2920: IF pa_agreement_pvt.check_delete_funding_ok
2921: (p_agreement_id => pa_agreement_utils.get_agreement_id( p_funding_id => p_funding_id
2922: ,p_funding_reference => p_pm_funding_reference)
2923: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
2924: ,p_pm_funding_reference => p_pm_funding_reference) = 'N'
2925: THEN
2926: p_return_status := FND_API.G_RET_STS_ERROR;
2927: RAISE FND_API.G_EXC_ERROR;

Line 2942: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id

2938: p_return_status := l_return_status;
2939:
2940:
2941: -- GET THE VALUES OF AGREEMENT ID, FUNDING ID AND PROJECT ID BEFORE DELETING THE FUNDING
2942: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
2943: ,p_funding_reference => p_pm_funding_reference);
2944: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
2945: ,p_funding_reference => p_pm_funding_reference);
2946: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id

Line 2944: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id

2940:
2941: -- GET THE VALUES OF AGREEMENT ID, FUNDING ID AND PROJECT ID BEFORE DELETING THE FUNDING
2942: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
2943: ,p_funding_reference => p_pm_funding_reference);
2944: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
2945: ,p_funding_reference => p_pm_funding_reference);
2946: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id
2947: ,p_funding_reference => p_pm_funding_reference);
2948:

Line 2946: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id

2942: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
2943: ,p_funding_reference => p_pm_funding_reference);
2944: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
2945: ,p_funding_reference => p_pm_funding_reference);
2946: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id
2947: ,p_funding_reference => p_pm_funding_reference);
2948:
2949:
2950:

Line 2952: pa_agreement_utils.delete_funding

2948:
2949:
2950:
2951: -- DELETE FUNDING
2952: pa_agreement_utils.delete_funding
2953: (p_project_funding_id =>l_out_funding_id);
2954:
2955: -- TO BE CORRECTED - NIKHIL
2956: -- UPDATE SUMMARY PROJECT FUNDINGS

Line 2957: pa_agreement_utils.summary_funding_delete_row

2953: (p_project_funding_id =>l_out_funding_id);
2954:
2955: -- TO BE CORRECTED - NIKHIL
2956: -- UPDATE SUMMARY PROJECT FUNDINGS
2957: pa_agreement_utils.summary_funding_delete_row
2958: (p_agreement_id => l_agreement_id
2959: ,p_project_id => l_project_id
2960: ,p_task_id => l_task_id
2961: ,p_login_id => G_LOGIN_ID

Line 3337: ,p_customer_id => pa_agreement_utils.get_customer_id

3333: IF pa_agreement_pvt.check_update_funding_ok
3334: (p_project_id => p_project_id
3335: ,p_task_id => p_task_id
3336: ,p_agreement_id => p_agreement_id
3337: ,p_customer_id => pa_agreement_utils.get_customer_id
3338: (p_funding_id => l_out_funding_id
3339: ,p_funding_reference => p_pm_funding_reference)
3340: ,p_pm_funding_reference => p_pm_funding_reference
3341: ,p_funding_id => l_out_funding_id

Line 3432: pa_agreement_utils.update_funding

3428:
3429:
3430: -- TO BE CORRECTED - NIKHIL
3431: -- UPDATE FUNDING
3432: pa_agreement_utils.update_funding
3433: (p_project_funding_id => l_out_funding_id
3434: ,p_last_update_date => SYSDATE
3435: ,p_last_updated_by => G_USER_ID
3436: ,p_last_update_login => G_LOGIN_ID

Line 3506: pa_agreement_utils.summary_funding_update_row

3502: ELSE
3503:
3504:
3505: -- UPDATE SUMMARY PROJECT FUNDINGS
3506: pa_agreement_utils.summary_funding_update_row
3507: (p_agreement_id => p_agreement_id
3508: ,p_project_id => p_project_id
3509: ,p_task_id => p_task_id
3510: ,p_login_id => G_LOGIN_ID

Line 4717: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'

4713: -- VALIDATE THE INCOMING PARAMETERS
4714:
4715: -- TO BE CORRECTED - NIKHIL
4716: -- Agreement Reference
4717: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
4718: THEN
4719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4720: THEN
4721: pa_interface_utils_pub.map_new_amg_msg

Line 4738: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'

4734: END IF;
4735:
4736: /* NOT REQUIRED
4737: -- Agreement Id
4738: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'
4739: THEN
4740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4741: THEN
4742: pa_interface_utils_pub.map_new_amg_msg

Line 5061: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'

5057: -- VALIDATE THE INCOMING PARAMETERS
5058:
5059: --TO BE CORRECTED - NIKHIL
5060: -- Agreement Reference
5061: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
5062: THEN
5063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5064: THEN
5065: pa_interface_utils_pub.map_new_amg_msg

Line 5081: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference

5077: RAISE FND_API.G_EXC_ERROR;
5078: END IF;
5079: /* NOT REQUIRED
5080: -- Funding Reference
5081: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5082: ,p_agreement_id => p_agreement_id) = 'N'
5083: THEN
5084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5085: THEN

Line 5244: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,

5240: l_resp_id := FND_GLOBAL.Resp_id;
5241:
5242: -- Get the project id from this project funding line
5243:
5244: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,
5245: p_funding_reference => p_pm_funding_reference);
5246:
5247: -- This call is added for patchset K project role based security check
5248:

Line 5351: IF pa_agreement_utils.check_valid_funding_ref

5347:
5348: -- VALIDATE THE INCOMING PARAMETERS
5349: --TO BE CORRECTED - NIKHIL
5350: -- Funding Reference
5351: IF pa_agreement_utils.check_valid_funding_ref
5352: (p_funding_reference => p_pm_funding_reference
5353: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5354: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5355: THEN

Line 5353: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id

5349: --TO BE CORRECTED - NIKHIL
5350: -- Funding Reference
5351: IF pa_agreement_utils.check_valid_funding_ref
5352: (p_funding_reference => p_pm_funding_reference
5353: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5354: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5355: THEN
5356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5357: THEN

Line 5374: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id

5370: RAISE FND_API.G_EXC_ERROR;
5371: END IF;
5372:
5373: -- Funding Id
5374: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5375: ,p_funding_reference => p_pm_funding_reference)
5376: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5377: THEN
5378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 5376: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'

5372:
5373: -- Funding Id
5374: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5375: ,p_funding_reference => p_pm_funding_reference)
5376: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5377: THEN
5378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5379: THEN
5380: pa_interface_utils_pub.map_new_amg_msg

Line 5398: (p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id

5394:
5395: -- CALL THE CHECK DELETE FUNDING OK PRIVATE PROCEDURE
5396:
5397: p_del_funding_ok_flag := pa_agreement_pvt.check_delete_funding_ok
5398: (p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5399: ,p_funding_reference => p_pm_funding_reference)
5400: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
5401: ,p_pm_funding_reference => p_pm_funding_reference);
5402:

Line 5400: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)

5396:
5397: p_del_funding_ok_flag := pa_agreement_pvt.check_delete_funding_ok
5398: (p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5399: ,p_funding_reference => p_pm_funding_reference)
5400: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
5401: ,p_pm_funding_reference => p_pm_funding_reference);
5402:
5403:
5404:

Line 5632: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference

5628:
5629: -- VALIDATE THE INCOMING PARAMETERS
5630:
5631: -- Funding Reference
5632: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5633: ,p_agreement_id => p_agreement_id) = 'N'
5634: THEN
5635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5636: THEN

Line 5653: IF pa_agreement_utils.check_valid_agreement_id

5649: RAISE FND_API.G_EXC_ERROR;
5650: END IF;
5651:
5652: -- Agreement Id
5653: IF pa_agreement_utils.check_valid_agreement_id
5654: (p_agreement_id => p_agreement_id) = 'N'
5655: THEN
5656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5657: THEN

Line 5716: ,p_customer_id => pa_agreement_utils.get_customer_id

5712: p_update_funding_ok_flag := pa_agreement_pvt.check_update_funding_ok
5713: (p_project_id => p_project_id
5714: ,p_task_id => p_task_id
5715: ,p_agreement_id => p_agreement_id
5716: ,p_customer_id => pa_agreement_utils.get_customer_id
5717: (p_funding_id => p_funding_id
5718: ,p_funding_reference => p_pm_funding_reference)
5719: ,p_pm_funding_reference => p_pm_funding_reference
5720: ,p_funding_id => p_funding_id