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.

[Home] [Help]

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 2617: pa_agreement_utils.create_funding(

2613:
2614:
2615:
2616: -- ADD FUNDING
2617: pa_agreement_utils.create_funding(
2618: p_Rowid => l_row_id,
2619: p_Project_Funding_Id => p_funding_id,
2620: p_Last_Update_Date => SYSDATE,
2621: p_Last_Updated_By => G_USER_ID,

Line 2693: pa_agreement_utils.summary_funding_insert_row

2689:
2690: ELSE
2691:
2692: -- UPDATE SUMMARY PROJECT FUNDINGS
2693: pa_agreement_utils.summary_funding_insert_row
2694: (p_agreement_id => p_agreement_id
2695: ,p_project_id => p_pa_project_id
2696: ,p_task_id => p_pa_task_id
2697: ,p_login_id => G_LOGIN_ID

Line 2751: -- pa_agreement_utils.delete_agreement

2747: --Called subprograms:
2748: -- pa_interface_utils_pub.map_new_amg_msg
2749: -- pa_agreement_pub.check_delete_funding_ok
2750: -- pa_agreement_pvt.convert_fu_ref_to_id
2751: -- pa_agreement_utils.delete_agreement
2752: --
2753: --
2754: --
2755: --History:

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

2818:
2819: -- This call is added for patchset K project role based security check
2820:
2821: -- Get the project id from this project funding line
2822: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,
2823: p_funding_reference => p_pm_funding_reference);
2824:
2825: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id;
2826:

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

2980: -- start
2981:
2982: IF p_check_y_n = 'Y' THEN
2983: IF pa_agreement_pvt.check_delete_funding_ok
2984: (p_agreement_id => pa_agreement_utils.get_agreement_id( p_funding_id => p_funding_id
2985: ,p_funding_reference => p_pm_funding_reference)
2986: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
2987: ,p_pm_funding_reference => p_pm_funding_reference) = 'N'
2988: THEN

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

2982: IF p_check_y_n = 'Y' THEN
2983: IF pa_agreement_pvt.check_delete_funding_ok
2984: (p_agreement_id => pa_agreement_utils.get_agreement_id( p_funding_id => p_funding_id
2985: ,p_funding_reference => p_pm_funding_reference)
2986: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
2987: ,p_pm_funding_reference => p_pm_funding_reference) = 'N'
2988: THEN
2989: p_return_status := FND_API.G_RET_STS_ERROR;
2990: RAISE FND_API.G_EXC_ERROR;

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

3001: p_return_status := l_return_status;
3002:
3003:
3004: -- GET THE VALUES OF AGREEMENT ID, FUNDING ID AND PROJECT ID BEFORE DELETING THE FUNDING
3005: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
3006: ,p_funding_reference => p_pm_funding_reference);
3007: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
3008: ,p_funding_reference => p_pm_funding_reference);
3009: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id

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

3003:
3004: -- GET THE VALUES OF AGREEMENT ID, FUNDING ID AND PROJECT ID BEFORE DELETING THE FUNDING
3005: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
3006: ,p_funding_reference => p_pm_funding_reference);
3007: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
3008: ,p_funding_reference => p_pm_funding_reference);
3009: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id
3010: ,p_funding_reference => p_pm_funding_reference);
3011:

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

3005: l_agreement_id := pa_agreement_utils.get_agreement_id (p_funding_id => p_funding_id
3006: ,p_funding_reference => p_pm_funding_reference);
3007: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id
3008: ,p_funding_reference => p_pm_funding_reference);
3009: l_task_id := pa_agreement_utils.get_task_id(p_funding_id => p_funding_id
3010: ,p_funding_reference => p_pm_funding_reference);
3011:
3012:
3013:

Line 3015: pa_agreement_utils.delete_funding

3011:
3012:
3013:
3014: -- DELETE FUNDING
3015: pa_agreement_utils.delete_funding
3016: (p_project_funding_id =>l_out_funding_id);
3017:
3018: -- TO BE CORRECTED - NIKHIL
3019: -- UPDATE SUMMARY PROJECT FUNDINGS

Line 3020: pa_agreement_utils.summary_funding_delete_row

3016: (p_project_funding_id =>l_out_funding_id);
3017:
3018: -- TO BE CORRECTED - NIKHIL
3019: -- UPDATE SUMMARY PROJECT FUNDINGS
3020: pa_agreement_utils.summary_funding_delete_row
3021: (p_agreement_id => l_agreement_id
3022: ,p_project_id => l_project_id
3023: ,p_task_id => l_task_id
3024: ,p_login_id => G_LOGIN_ID

Line 3471: ,p_customer_id => pa_agreement_utils.get_customer_id

3467: IF pa_agreement_pvt.check_update_funding_ok
3468: (p_project_id => p_project_id
3469: ,p_task_id => p_task_id
3470: ,p_agreement_id => p_agreement_id
3471: ,p_customer_id => pa_agreement_utils.get_customer_id
3472: (p_funding_id => l_out_funding_id
3473: ,p_funding_reference => p_pm_funding_reference)
3474: ,p_pm_funding_reference => p_pm_funding_reference
3475: ,p_funding_id => l_out_funding_id

Line 3566: pa_agreement_utils.update_funding

3562:
3563:
3564: -- TO BE CORRECTED - NIKHIL
3565: -- UPDATE FUNDING
3566: pa_agreement_utils.update_funding
3567: (p_project_funding_id => l_out_funding_id
3568: ,p_last_update_date => SYSDATE
3569: ,p_last_updated_by => G_USER_ID
3570: ,p_last_update_login => G_LOGIN_ID

Line 3640: pa_agreement_utils.summary_funding_update_row

3636: ELSE
3637:
3638:
3639: -- UPDATE SUMMARY PROJECT FUNDINGS
3640: pa_agreement_utils.summary_funding_update_row
3641: (p_agreement_id => p_agreement_id
3642: ,p_project_id => p_project_id
3643: ,p_task_id => p_task_id
3644: ,p_login_id => G_LOGIN_ID

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

4847: -- VALIDATE THE INCOMING PARAMETERS
4848:
4849: -- TO BE CORRECTED - NIKHIL
4850: -- Agreement Reference
4851: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
4852: THEN
4853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4854: THEN
4855: pa_interface_utils_pub.map_new_amg_msg

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

4868: END IF;
4869:
4870: /* NOT REQUIRED
4871: -- Agreement Id
4872: IF pa_agreement_utils.check_valid_agreement_id(p_agreement_id => p_agreement_id) = 'N'
4873: THEN
4874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4875: THEN
4876: pa_interface_utils_pub.map_new_amg_msg

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

5191: -- VALIDATE THE INCOMING PARAMETERS
5192:
5193: --TO BE CORRECTED - NIKHIL
5194: -- Agreement Reference
5195: IF pa_agreement_utils.check_valid_agreement_ref(p_agreement_reference => p_pm_agreement_reference) = 'N'
5196: THEN
5197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5198: THEN
5199: pa_interface_utils_pub.map_new_amg_msg

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

5211: RAISE FND_API.G_EXC_ERROR;
5212: END IF;
5213: /* NOT REQUIRED
5214: -- Funding Reference
5215: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5216: ,p_agreement_id => p_agreement_id) = 'N'
5217: THEN
5218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5219: THEN

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

5374: l_resp_id := FND_GLOBAL.Resp_id;
5375:
5376: -- Get the project id from this project funding line
5377:
5378: l_project_id := pa_agreement_utils.get_project_id(p_funding_id => p_funding_id,
5379: p_funding_reference => p_pm_funding_reference);
5380:
5381: -- This call is added for patchset K project role based security check
5382:

Line 5485: IF pa_agreement_utils.check_valid_funding_ref

5481:
5482: -- VALIDATE THE INCOMING PARAMETERS
5483: --TO BE CORRECTED - NIKHIL
5484: -- Funding Reference
5485: IF pa_agreement_utils.check_valid_funding_ref
5486: (p_funding_reference => p_pm_funding_reference
5487: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5488: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5489: THEN

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

5483: --TO BE CORRECTED - NIKHIL
5484: -- Funding Reference
5485: IF pa_agreement_utils.check_valid_funding_ref
5486: (p_funding_reference => p_pm_funding_reference
5487: ,p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5488: ,p_funding_reference => p_pm_funding_reference)) = 'N'
5489: THEN
5490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5491: THEN

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

5504: RAISE FND_API.G_EXC_ERROR;
5505: END IF;
5506:
5507: -- Funding Id
5508: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5509: ,p_funding_reference => p_pm_funding_reference)
5510: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5511: THEN
5512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

5506:
5507: -- Funding Id
5508: IF pa_agreement_utils.check_valid_funding_id(p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5509: ,p_funding_reference => p_pm_funding_reference)
5510: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)) = 'N'
5511: THEN
5512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5513: THEN
5514: pa_interface_utils_pub.map_new_amg_msg

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

5528:
5529: -- CALL THE CHECK DELETE FUNDING OK PRIVATE PROCEDURE
5530:
5531: p_del_funding_ok_flag := pa_agreement_pvt.check_delete_funding_ok
5532: (p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5533: ,p_funding_reference => p_pm_funding_reference)
5534: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
5535: ,p_pm_funding_reference => p_pm_funding_reference);
5536:

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

5530:
5531: p_del_funding_ok_flag := pa_agreement_pvt.check_delete_funding_ok
5532: (p_agreement_id => pa_agreement_utils.get_agreement_id(p_funding_id => p_funding_id
5533: ,p_funding_reference => p_pm_funding_reference)
5534: ,p_funding_id => pa_agreement_utils.get_funding_id(p_funding_reference => p_pm_funding_reference)
5535: ,p_pm_funding_reference => p_pm_funding_reference);
5536:
5537:
5538:

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

5762:
5763: -- VALIDATE THE INCOMING PARAMETERS
5764:
5765: -- Funding Reference
5766: IF pa_agreement_utils.check_valid_funding_ref(p_funding_reference => p_pm_funding_reference
5767: ,p_agreement_id => p_agreement_id) = 'N'
5768: THEN
5769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5770: THEN

Line 5787: IF pa_agreement_utils.check_valid_agreement_id

5783: RAISE FND_API.G_EXC_ERROR;
5784: END IF;
5785:
5786: -- Agreement Id
5787: IF pa_agreement_utils.check_valid_agreement_id
5788: (p_agreement_id => p_agreement_id) = 'N'
5789: THEN
5790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5791: THEN

Line 5850: ,p_customer_id => pa_agreement_utils.get_customer_id

5846: p_update_funding_ok_flag := pa_agreement_pvt.check_update_funding_ok
5847: (p_project_id => p_project_id
5848: ,p_task_id => p_task_id
5849: ,p_agreement_id => p_agreement_id
5850: ,p_customer_id => pa_agreement_utils.get_customer_id
5851: (p_funding_id => p_funding_id
5852: ,p_funding_reference => p_pm_funding_reference)
5853: ,p_pm_funding_reference => p_pm_funding_reference
5854: ,p_funding_id => p_funding_id