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_PROJECT_CORE1 dependencies on FND_API

Line 115: p_encoded => FND_API.G_TRUE,

111: x_msg_count := FND_MSG_PUB.count_msg;
112:
113: FND_MSG_PUB.get (
114: p_msg_index => 1,
115: p_encoded => FND_API.G_TRUE,
116: p_data => l_data,
117: p_msg_index_out => l_msg_index_out );
118:
119: if l_data is not null then

Line 1167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1163: ,x_return_status => l_return_status
1164: ,x_msg_count => l_msg_count
1165: ,x_msg_data => l_msg_data
1166: );
1167: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1168: ROLLBACK TO copy_project;
1169: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1170: x_err_code := 199;
1171: x_err_stage := 'API: '||'PA_PROJECT_CORE1.POPULATE_DEFAULT_COPY_OPTIONS'||

Line 1681: ,p_init_msg_list => FND_API.G_FALSE

1677:
1678: PA_PJP_PVT.Submit_Project_Aw -- Changed from FPA_PROCESS_PVT to PA_PJP_PVT package
1679: (
1680: p_api_version => 1.0
1681: ,p_init_msg_list => FND_API.G_FALSE
1682: ,p_commit => FND_API.G_FALSE
1683: ,p_project_id => x_new_project_id
1684: ,x_return_status => l_return_status
1685: ,x_msg_count => l_msg_count

Line 1682: ,p_commit => FND_API.G_FALSE

1678: PA_PJP_PVT.Submit_Project_Aw -- Changed from FPA_PROCESS_PVT to PA_PJP_PVT package
1679: (
1680: p_api_version => 1.0
1681: ,p_init_msg_list => FND_API.G_FALSE
1682: ,p_commit => FND_API.G_FALSE
1683: ,p_project_id => x_new_project_id
1684: ,x_return_status => l_return_status
1685: ,x_msg_count => l_msg_count
1686: ,x_msg_data => l_msg_data

Line 1831: ,p_init_msg_list => FND_API.G_TRUE

1827: ,p_object_id => x_new_project_id
1828: ,p_description => l_description
1829: ,p_record_version_number => 1
1830: ,p_calling_module => 'PROJECT_SUBTEAMS'
1831: ,p_init_msg_list => FND_API.G_TRUE
1832: ,p_validate_only => FND_API.G_FALSE
1833: ,x_new_subteam_id => l_new_subteam_id
1834: ,x_subteam_row_id => l_subteam_row_id
1835: ,x_return_status => l_return_status

Line 1832: ,p_validate_only => FND_API.G_FALSE

1828: ,p_description => l_description
1829: ,p_record_version_number => 1
1830: ,p_calling_module => 'PROJECT_SUBTEAMS'
1831: ,p_init_msg_list => FND_API.G_TRUE
1832: ,p_validate_only => FND_API.G_FALSE
1833: ,x_new_subteam_id => l_new_subteam_id
1834: ,x_subteam_row_id => l_subteam_row_id
1835: ,x_return_status => l_return_status
1836: ,x_msg_count => l_msg_count

Line 1953: ( p_validate_only => FND_API.G_FALSE

1949: CLOSE l_get_workplan_attrs_csr;
1950:
1951: BEGIN
1952: PA_WORKPLAN_ATTR_PUB.CREATE_PROJ_WORKPLAN_ATTRS
1953: ( p_validate_only => FND_API.G_FALSE
1954: ,p_project_id => x_new_project_id
1955: ,p_approval_reqd_flag => l_approval_reqd_flag
1956: ,p_auto_publish_flag => l_auto_publish_flag
1957: ,p_approver_source_id => l_approver_source_id

Line 2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

2155: --bug 2778730
2156: /* Bug 3022296 : End */
2157: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2158: p_api_version => 1.0 -- p_api_version
2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2160: , p_commit => FND_API.G_FALSE -- p_commit
2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2163: , p_debug_mode => 'N' -- p_debug_mode

Line 2160: , p_commit => FND_API.G_FALSE -- p_commit

2156: /* Bug 3022296 : End */
2157: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2158: p_api_version => 1.0 -- p_api_version
2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2160: , p_commit => FND_API.G_FALSE -- p_commit
2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2163: , p_debug_mode => 'N' -- p_debug_mode
2164: , p_object_id => x_new_project_id -- p_object_id

Line 2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only

2157: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2158: p_api_version => 1.0 -- p_api_version
2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2160: , p_commit => FND_API.G_FALSE -- p_commit
2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2163: , p_debug_mode => 'N' -- p_debug_mode
2164: , p_object_id => x_new_project_id -- p_object_id
2165: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 2162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

2158: p_api_version => 1.0 -- p_api_version
2159: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2160: , p_commit => FND_API.G_FALSE -- p_commit
2161: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2163: , p_debug_mode => 'N' -- p_debug_mode
2164: , p_object_id => x_new_project_id -- p_object_id
2165: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
2166: , p_project_role_id => v_null_number -- p_project_role_id

Line 2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list

2312: /* Bug 7482391 changes end here*/
2313: if (f_flag = 'Y') then -- Bug 7482391
2314: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2315: p_api_version => 1.0 -- p_api_version
2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2317: , p_commit => FND_API.G_FALSE -- p_commit
2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2319: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2320: , p_debug_mode => 'N' -- p_debug_mode

Line 2317: , p_commit => FND_API.G_FALSE -- p_commit

2313: if (f_flag = 'Y') then -- Bug 7482391
2314: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2315: p_api_version => 1.0 -- p_api_version
2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2317: , p_commit => FND_API.G_FALSE -- p_commit
2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2319: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2320: , p_debug_mode => 'N' -- p_debug_mode
2321: , p_object_id => x_new_project_id -- p_object_id

Line 2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only

2314: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2315: p_api_version => 1.0 -- p_api_version
2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2317: , p_commit => FND_API.G_FALSE -- p_commit
2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2319: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2320: , p_debug_mode => 'N' -- p_debug_mode
2321: , p_object_id => x_new_project_id -- p_object_id
2322: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

Line 2319: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

2315: p_api_version => 1.0 -- p_api_version
2316: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
2317: , p_commit => FND_API.G_FALSE -- p_commit
2318: , p_validate_only => FND_API.G_FALSE -- p_validate_only
2319: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
2320: , p_debug_mode => 'N' -- p_debug_mode
2321: , p_object_id => x_new_project_id -- p_object_id
2322: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
2323: , p_project_role_id => v_null_number -- p_project_role_id

Line 2495: , p_init_msg_list => FND_API.G_TRUE

2491: -- a customer billing account
2492: if c_cust_created_org_csr%NOTFOUND then
2493: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2494: p_api_version => 1.0
2495: , p_init_msg_list => FND_API.G_TRUE
2496: , p_commit => FND_API.G_FALSE
2497: , p_validate_only => FND_API.G_FALSE
2498: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2499: , p_debug_mode => 'N'

Line 2496: , p_commit => FND_API.G_FALSE

2492: if c_cust_created_org_csr%NOTFOUND then
2493: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2494: p_api_version => 1.0
2495: , p_init_msg_list => FND_API.G_TRUE
2496: , p_commit => FND_API.G_FALSE
2497: , p_validate_only => FND_API.G_FALSE
2498: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2499: , p_debug_mode => 'N'
2500: , p_object_id => x_new_project_id

Line 2497: , p_validate_only => FND_API.G_FALSE

2493: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2494: p_api_version => 1.0
2495: , p_init_msg_list => FND_API.G_TRUE
2496: , p_commit => FND_API.G_FALSE
2497: , p_validate_only => FND_API.G_FALSE
2498: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2499: , p_debug_mode => 'N'
2500: , p_object_id => x_new_project_id
2501: , p_OBJECT_TYPE => 'PA_PROJECTS'

Line 2498: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2494: p_api_version => 1.0
2495: , p_init_msg_list => FND_API.G_TRUE
2496: , p_commit => FND_API.G_FALSE
2497: , p_validate_only => FND_API.G_FALSE
2498: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2499: , p_debug_mode => 'N'
2500: , p_object_id => x_new_project_id
2501: , p_OBJECT_TYPE => 'PA_PROJECTS'
2502: , p_project_role_id => v_null_number

Line 2561: , p_init_msg_list => FND_API.G_TRUE

2557: -- a customer billing account
2558: if c_cust_created_org_csr%NOTFOUND then
2559: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2560: p_api_version => 1.0
2561: , p_init_msg_list => FND_API.G_TRUE
2562: , p_commit => FND_API.G_FALSE
2563: , p_validate_only => FND_API.G_FALSE
2564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2565: , p_debug_mode => 'N'

Line 2562: , p_commit => FND_API.G_FALSE

2558: if c_cust_created_org_csr%NOTFOUND then
2559: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2560: p_api_version => 1.0
2561: , p_init_msg_list => FND_API.G_TRUE
2562: , p_commit => FND_API.G_FALSE
2563: , p_validate_only => FND_API.G_FALSE
2564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2565: , p_debug_mode => 'N'
2566: , p_object_id => x_new_project_id

Line 2563: , p_validate_only => FND_API.G_FALSE

2559: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
2560: p_api_version => 1.0
2561: , p_init_msg_list => FND_API.G_TRUE
2562: , p_commit => FND_API.G_FALSE
2563: , p_validate_only => FND_API.G_FALSE
2564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2565: , p_debug_mode => 'N'
2566: , p_object_id => x_new_project_id
2567: , p_OBJECT_TYPE => 'PA_PROJECTS'

Line 2564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2560: p_api_version => 1.0
2561: , p_init_msg_list => FND_API.G_TRUE
2562: , p_commit => FND_API.G_FALSE
2563: , p_validate_only => FND_API.G_FALSE
2564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2565: , p_debug_mode => 'N'
2566: , p_object_id => x_new_project_id
2567: , p_OBJECT_TYPE => 'PA_PROJECTS'
2568: , p_project_role_id => v_null_number

Line 3026: p_validate_only => FND_API.G_FALSE

3022:
3023: if l_party_id is not null then
3024:
3025: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3026: p_validate_only => FND_API.G_FALSE
3027: , p_object_id => x_new_project_id
3028: , p_OBJECT_TYPE => 'PA_PROJECTS'
3029: , p_project_role_id => 100
3030: , p_project_role_type => 'CUSTOMER_ORG'

Line 3416: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN

3412: --Added the following if conditions for Bug#4770535.If there is no billing or shipping contact for this customer,
3413: --we should not copy the values returned from get_customer_info by mistake as it gives the contact at primary site.
3414:
3415:
3416: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN
3417: l_bill_to_contact_id := NULL;
3418: END IF;
3419:
3420: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN

Line 3420: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN

3416: IF (l_copy_bill_to_contact_id IS NULL OR l_copy_bill_to_contact_id= FND_API.G_MISS_NUM) THEN
3417: l_bill_to_contact_id := NULL;
3418: END IF;
3419:
3420: IF (l_copy_ship_to_contact_id IS NULL OR l_copy_ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3421: l_ship_to_contact_id := NULL;
3422: END IF;
3423:
3424:

Line 3746: p_validate_only => FND_API.G_FALSE

3742:
3743: if l_party_id is not null then
3744:
3745: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
3746: p_validate_only => FND_API.G_FALSE
3747: , p_object_id => x_new_project_id
3748: , p_OBJECT_TYPE => 'PA_PROJECTS'
3749: , p_project_role_id => 100
3750: , p_project_role_type => 'CUSTOMER_ORG'

Line 5223: IF l_return_status <> fnd_api.g_ret_sts_success

5219: P_object_id_to => x_new_project_id,
5220: x_return_status => l_return_status,
5221: x_msg_count => l_msg_count,
5222: x_msg_data => l_msg_data );
5223: IF l_return_status <> fnd_api.g_ret_sts_success
5224: THEN
5225: x_err_code := 730;
5226: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_OBJ_PG_LAY');
5227: x_err_stack := x_err_stack||'->PA_Page_layout_Utils.copy_object_page_layouts';

Line 5254: IF l_return_status <> fnd_api.g_ret_sts_success

5250: p_project_id_to => x_new_project_id,
5251: x_return_status => l_return_status,
5252: x_msg_count => l_msg_count,
5253: x_msg_data => l_msg_data );
5254: IF l_return_status <> fnd_api.g_ret_sts_success
5255: THEN
5256: x_err_code := 844;
5257: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_PROJ_ACTSET');
5258: x_err_stack := x_err_stack||'->PA_PROJ_STAT_ACTSET.copy_action_sets';

Line 5283: IF l_return_status <> fnd_api.g_ret_sts_success

5279: p_project_id_to => x_new_project_id,
5280: x_return_status => l_return_status,
5281: x_msg_count => l_msg_count,
5282: x_msg_data => l_msg_data );
5283: IF l_return_status <> fnd_api.g_ret_sts_success
5284: THEN
5285: x_err_code := 866;
5286: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_COPY_TASK_ACTSET');
5287: x_err_stack := x_err_stack||'->PA_TASK_PROG_ACTSET.copy_action_sets';

Line 5319: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

5315: ,x_return_status => l_return_status
5316: ,x_msg_count => l_msg_count
5317: ,x_msg_data => l_msg_data );
5318:
5319: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5320: x_err_code := 880;
5321: x_err_stage := pa_project_core1.get_message_from_stack('PA_PERF_COPY_RULES_ERR');
5322: x_err_stack := x_err_stack||'->PA_PERF_EXCP_UTILS.copy_object_rule_assoc';
5323: rollback to copy_project;

Line 5351: ,p_init_msg_list => fnd_api.g_FALSE

5347: IF 'Y' = l_pr_item_assoc_flag THEN
5348: PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS
5349: ( p_project_id_from => x_orig_project_id
5350: ,p_project_id_to => x_new_project_id
5351: ,p_init_msg_list => fnd_api.g_FALSE
5352: ,p_commit => fnd_api.g_FALSE
5353: ,x_return_status => l_return_status
5354: ,x_errorcode => l_errorcode
5355: ,x_msg_count => l_msg_count

Line 5352: ,p_commit => fnd_api.g_FALSE

5348: PA_EGO_WRAPPER_PUB.COPY_ITEM_ASSOCS
5349: ( p_project_id_from => x_orig_project_id
5350: ,p_project_id_to => x_new_project_id
5351: ,p_init_msg_list => fnd_api.g_FALSE
5352: ,p_commit => fnd_api.g_FALSE
5353: ,x_return_status => l_return_status
5354: ,x_errorcode => l_errorcode
5355: ,x_msg_count => l_msg_count
5356: ,x_msg_data => l_msg_data);

Line 5435: IF l_return_status <> fnd_api.g_ret_sts_success

5431: ,x_return_status => l_return_status
5432: ,x_msg_count => l_msg_count
5433: ,x_msg_data => l_msg_data
5434: );
5435: IF l_return_status <> fnd_api.g_ret_sts_success
5436: THEN
5437: x_err_code := 735;
5438: x_err_stage := pa_project_core1.get_message_from_stack('PA_ERR_INSERT_ACCUM');
5439: x_err_stack := x_err_stack||'->pa_accum_proj_list.Insert_Accum';

Line 5547: IF l_return_status <> fnd_api.g_ret_sts_success

5543: ,x_return_status => l_return_status
5544: ,x_msg_count => l_msg_count
5545: ,x_msg_data => l_msg_data
5546: );
5547: IF l_return_status <> fnd_api.g_ret_sts_success
5548: THEN
5549: IF l_msg_data IS NULL THEN
5550: l_msg_data := 'PA_ERR_COPY_FINPLANS';
5551: END IF ;

Line 6016: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6012: --
6013: -- HISTORY
6014: -- 11-MAR-2004 sabansal Created
6015: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6016: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6017: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6018: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6019: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6020: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6017: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6013: -- HISTORY
6014: -- 11-MAR-2004 sabansal Created
6015: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6016: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6017: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6018: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6019: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6020: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6021: ,p_debug_mode IN VARCHAR2 := 'N'

Line 6018: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

6014: -- 11-MAR-2004 sabansal Created
6015: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6016: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6017: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6018: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6019: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6020: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6021: ,p_debug_mode IN VARCHAR2 := 'N'
6022: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 6019: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6015: PROCEDURE populate_copy_options( p_api_version IN NUMBER := 1.0
6016: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6017: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6018: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6019: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6020: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6021: ,p_debug_mode IN VARCHAR2 := 'N'
6022: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
6023: ,p_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

Line 6037: x_return_status := FND_API.G_RET_STS_SUCCESS;

6033: l_debug_level5 CONSTANT NUMBER := 5;
6034: BEGIN
6035:
6036: x_msg_count := 0;
6037: x_return_status := FND_API.G_RET_STS_SUCCESS;
6038: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6039:
6040: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6041: FND_MSG_PUB.initialize;

Line 6040: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6036: x_msg_count := 0;
6037: x_return_status := FND_API.G_RET_STS_SUCCESS;
6038: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6039:
6040: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6041: FND_MSG_PUB.initialize;
6042: END IF;
6043:
6044: IF (p_commit = FND_API.G_TRUE) THEN

Line 6044: IF (p_commit = FND_API.G_TRUE) THEN

6040: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6041: FND_MSG_PUB.initialize;
6042: END IF;
6043:
6044: IF (p_commit = FND_API.G_TRUE) THEN
6045: SAVEPOINT pop_copy_options;
6046: END IF;
6047:
6048: IF l_debug_mode = 'Y' THEN

Line 6093: IF (p_commit = FND_API.G_TRUE) THEN

6089: );
6090: END LOOP;
6091: END IF;
6092:
6093: IF (p_commit = FND_API.G_TRUE) THEN
6094: COMMIT;
6095: END IF;
6096:
6097: EXCEPTION

Line 6099: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6095: END IF;
6096:
6097: EXCEPTION
6098: WHEN OTHERS THEN
6099: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6100: x_msg_count := 1;
6101: x_msg_data := SQLERRM;
6102:
6103: IF p_commit = FND_API.G_TRUE THEN

Line 6103: IF p_commit = FND_API.G_TRUE THEN

6099: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6100: x_msg_count := 1;
6101: x_msg_data := SQLERRM;
6102:
6103: IF p_commit = FND_API.G_TRUE THEN
6104: ROLLBACK TO pop_copy_options;
6105: END IF;
6106:
6107: Fnd_Msg_Pub.add_exc_msg

Line 6136: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

6132: -- options would be populated
6133: -- p_src_template_flag VARCHAR2 Y Whether the source is a project or a template
6134: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6135: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6136: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6137: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6138: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6139: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6140: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 6137: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

6133: -- p_src_template_flag VARCHAR2 Y Whether the source is a project or a template
6134: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6135: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6136: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6137: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6138: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6139: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6140: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6141: ,p_debug_mode IN VARCHAR2 := 'N'

Line 6138: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

6134: -- p_dest_template_flag VARCHAR2 Y Whether creating a project or a template
6135: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6136: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6137: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6138: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6139: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6140: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6141: ,p_debug_mode IN VARCHAR2 := 'N'
6142: ,p_src_project_id IN NUMBER

Line 6139: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6135: PROCEDURE populate_default_copy_options( p_api_version IN NUMBER := 1.0
6136: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6137: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6138: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6139: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6140: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6141: ,p_debug_mode IN VARCHAR2 := 'N'
6142: ,p_src_project_id IN NUMBER
6143: ,p_src_template_flag IN VARCHAR2

Line 6199: x_return_status := FND_API.G_RET_STS_SUCCESS;

6195:
6196: BEGIN
6197:
6198: x_msg_count := 0;
6199: x_return_status := FND_API.G_RET_STS_SUCCESS;
6200: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6201:
6202: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6203: FND_MSG_PUB.initialize;

Line 6202: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6198: x_msg_count := 0;
6199: x_return_status := FND_API.G_RET_STS_SUCCESS;
6200: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6201:
6202: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6203: FND_MSG_PUB.initialize;
6204: END IF;
6205:
6206: IF (p_commit = FND_API.G_TRUE) THEN

Line 6206: IF (p_commit = FND_API.G_TRUE) THEN

6202: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6203: FND_MSG_PUB.initialize;
6204: END IF;
6205:
6206: IF (p_commit = FND_API.G_TRUE) THEN
6207: SAVEPOINT def_copy_options;
6208: END IF;
6209:
6210: IF l_debug_mode = 'Y' THEN

Line 6236: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND

6232: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
6233: l_debug_level3);
6234: END IF;
6235:
6236: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND
6237: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6238: )
6239: THEN
6240: IF l_debug_mode = 'Y' THEN

Line 6237: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )

6233: l_debug_level3);
6234: END IF;
6235:
6236: IF ( ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM ) AND
6237: ( p_src_template_flag IS NULL OR p_src_template_flag = FND_API.G_MISS_CHAR )
6238: )
6239: THEN
6240: IF l_debug_mode = 'Y' THEN
6241: Pa_Debug.g_err_stage:= 'PA_PROJECT_CORE1 : populate_default_copy_options :

Line 6384: IF (p_commit = FND_API.G_TRUE) THEN

6380: END IF;--IF 'Y' = l_workplan_enabled AND cur_wp_record_present%NOTFOUND
6381:
6382: CLOSE cur_wp_record_present;
6383:
6384: IF (p_commit = FND_API.G_TRUE) THEN
6385: COMMIT;
6386: END IF;
6387:
6388: EXCEPTION

Line 6390: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6386: END IF;
6387:
6388: EXCEPTION
6389: WHEN Invalid_Arg_Exc THEN
6390: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6391: x_msg_count := 1;
6392: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6393:
6394: IF p_commit = FND_API.G_TRUE THEN

Line 6394: IF p_commit = FND_API.G_TRUE THEN

6390: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6391: x_msg_count := 1;
6392: x_msg_data := ' PA_PROJECT_CORE1 : populate_default_copy_options : NULL parameters passed';
6393:
6394: IF p_commit = FND_API.G_TRUE THEN
6395: ROLLBACK TO def_copy_options;
6396: END IF;
6397:
6398: Fnd_Msg_Pub.add_exc_msg

Line 6412: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6408: END IF;
6409: RAISE;
6410:
6411: WHEN OTHERS THEN
6412: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6413: x_msg_count := 1;
6414: x_msg_data := SQLERRM;
6415:
6416: IF p_commit = FND_API.G_TRUE THEN

Line 6416: IF p_commit = FND_API.G_TRUE THEN

6412: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6413: x_msg_count := 1;
6414: x_msg_data := SQLERRM;
6415:
6416: IF p_commit = FND_API.G_TRUE THEN
6417: ROLLBACK TO def_copy_options;
6418: END IF;
6419:
6420: Fnd_Msg_Pub.add_exc_msg