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.ZPB_AC_OPS dependencies on FND_API

Line 1088: delete_tasks IN VARCHAR2 default FND_API.G_TRUE)

1084: /*
1085: * Public */
1086: PROCEDURE delete_ac (
1087: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1088: delete_tasks IN VARCHAR2 default FND_API.G_TRUE)
1089: IS
1090: CURSOR ac_task_cur IS
1091: SELECT *
1092: FROM zpb_analysis_cycle_tasks

Line 1141: IF FND_API.To_Boolean(delete_tasks) THEN

1137: WHEN NO_DATA_FOUND THEN
1138: NULL;
1139: END;
1140:
1141: IF FND_API.To_Boolean(delete_tasks) THEN
1142:
1143: FOR ac_task_rec IN ac_task_cur LOOP
1144: DELETE FROM zpb_task_parameters
1145: WHERE task_id = ac_task_rec.task_id;

Line 1887: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1883:
1884: -- now delete any Data Collection templates
1885: -- associated with this cycle
1886: zpb_dc_objects_pvt.delete_template(
1887: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1888: l_return_status, l_msg_count, l_msg_data, ac_id_in);
1889:
1890: zpb_dc_objects_pvt.delete_template(
1891: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

Line 1891: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1887: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1888: l_return_status, l_msg_count, l_msg_data, ac_id_in);
1889:
1890: zpb_dc_objects_pvt.delete_template(
1891: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1892: l_return_status, l_msg_count, l_msg_data, tmp_ac_id);
1893:
1894: zpb_dc_objects_pvt.delete_template(
1895: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

Line 1895: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1891: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1892: l_return_status, l_msg_count, l_msg_data, tmp_ac_id);
1893:
1894: zpb_dc_objects_pvt.delete_template(
1895: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1896: l_return_status, l_msg_count, l_msg_data, edit_ac_id);
1897:
1898: --Loop over all completed/errored instances and delete them
1899: IF prev_instance_options_in = 'DELETE_PREVIOUS_INSTANCE' THEN

Line 1923: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1919:
1920: -- now delete any Data Collection templates
1921: -- associated with this cycle
1922: zpb_dc_objects_pvt.delete_template(
1923: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1924: l_return_status, l_msg_count, l_msg_data, instance_rec.instance_ac_id);
1925: END LOOP;
1926: END IF;
1927:

Line 1954: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1950:
1951: -- now delete any Data Collection templates
1952: -- associated with this cycle
1953: zpb_dc_objects_pvt.delete_template(
1954: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1955: l_return_status, l_msg_count, l_msg_data, ac_id_in);
1956:
1957: END IF;
1958:

Line 2196: delete_ac(instance_rec.instance_ac_id, FND_API.G_FALSE);

2192: INTO ac_rec
2193: FROM zpb_analysis_cycles
2194: WHERE analysis_cycle_id = instance_rec.instance_ac_id;
2195:
2196: delete_ac(instance_rec.instance_ac_id, FND_API.G_FALSE);
2197:
2198: -- copy all parts - but only those tasks that have not yet started
2199:
2200: copy_ac_table_rec(instance_rec.analysis_cycle_id, instance_rec.instance_ac_id);

Line 2281: RAISE FND_API.G_EXC_ERROR;

2277: IF lock_val <> lock_val_in THEN
2278: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUS_PROC_LOCKED');
2279: x_msg_data := 'ZPB_BUS_PROC_LOCKED';
2280: FND_MSG_PUB.ADD;
2281: RAISE FND_API.G_EXC_ERROR;
2282: END IF;
2283: END IF;
2284: SELECT *
2285: INTO pet_row_rec

Line 2321: WHEN FND_API.G_EXC_ERROR THEN

2317:
2318: editable_ac_id_out := new_ac_id;
2319:
2320: EXCEPTION
2321: WHEN FND_API.G_EXC_ERROR THEN
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323: editable_ac_id_out := null;
2324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2325: p_data => msg_data );

Line 2322: x_return_status := FND_API.G_RET_STS_ERROR;

2318: editable_ac_id_out := new_ac_id;
2319:
2320: EXCEPTION
2321: WHEN FND_API.G_EXC_ERROR THEN
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323: editable_ac_id_out := null;
2324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2325: p_data => msg_data );
2326: IF lock_cursor%ISOPEN THEN

Line 2667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2663:
2664:
2665: procedure create_partial_cycle (
2666: p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2668: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2669: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status OUT NOCOPY VARCHAR2 ,
2671: x_msg_count OUT NOCOPY NUMBER,

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

2664:
2665: procedure create_partial_cycle (
2666: p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2668: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2669: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status OUT NOCOPY VARCHAR2 ,
2671: x_msg_count OUT NOCOPY NUMBER,
2672: x_msg_data OUT NOCOPY VARCHAR2,

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

2665: procedure create_partial_cycle (
2666: p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2668: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2669: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status OUT NOCOPY VARCHAR2 ,
2671: x_msg_count OUT NOCOPY NUMBER,
2672: x_msg_data OUT NOCOPY VARCHAR2,
2673: p_apps_user_id in number,

Line 2710: IF NOT FND_API.Compatible_API_Call( l_api_version,

2706: begin
2707: -- Standard Start of API savepoint
2708: SAVEPOINT create_partial_cycle;
2709: -- Standard call to check for call compatibility.
2710: IF NOT FND_API.Compatible_API_Call( l_api_version,
2711: p_api_version,
2712: l_api_name,
2713: G_PKG_NAME)
2714: THEN

Line 2715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2711: p_api_version,
2712: l_api_name,
2713: G_PKG_NAME)
2714: THEN
2715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2716: END IF;
2717:
2718: -- Initialize message list if p_init_msg_list is set to TRUE.
2719: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2719: IF FND_API.to_Boolean(p_init_msg_list) THEN

2715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2716: END IF;
2717:
2718: -- Initialize message list if p_init_msg_list is set to TRUE.
2719: IF FND_API.to_Boolean(p_init_msg_list) THEN
2720: FND_MSG_PUB.initialize;
2721: END IF;
2722:
2723: -- Initialize API return status to success

Line 2724: x_return_status := FND_API.G_RET_STS_SUCCESS;

2720: FND_MSG_PUB.initialize;
2721: END IF;
2722:
2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
2728:

Line 2892: IF FND_API.To_Boolean( p_commit ) THEN

2888:
2889:
2890: create_cycle_model_dimensions(new_ac_id, p_model_dimensions,p_apps_user_id);
2891: -- Standard check of p_commit.
2892: IF FND_API.To_Boolean( p_commit ) THEN
2893: COMMIT WORK;
2894: END IF;
2895: -- Standard call to get message count and if count is 1, get message info.
2896: FND_MSG_PUB.Count_And_Get(

Line 2907: x_return_status := FND_API.G_RET_STS_ERROR;

2903: WHEN invalid_calendar_start_type then
2904: ROLLBACK TO create_partial_cycle;
2905: x_msg_count := 1;
2906: x_msg_data := 'Invalid calendar start type';
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: WHEN invalid_calendar_end_type then
2909: ROLLBACK TO create_partial_cycle;
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: x_msg_count := 1;

Line 2910: x_return_status := FND_API.G_RET_STS_ERROR;

2906: x_msg_data := 'Invalid calendar start type';
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: WHEN invalid_calendar_end_type then
2909: ROLLBACK TO create_partial_cycle;
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: x_msg_count := 1;
2912: x_msg_data := 'Invalid calendar end type';
2913: WHEN invalid_calendar_end_pf then
2914: ROLLBACK TO create_partial_cycle;

Line 2917: x_return_status := FND_API.G_RET_STS_ERROR;

2913: WHEN invalid_calendar_end_pf then
2914: ROLLBACK TO create_partial_cycle;
2915: x_msg_count := 1;
2916: x_msg_data := 'Invalid calendar end pf';
2917: x_return_status := FND_API.G_RET_STS_ERROR;
2918: WHEN invalid_calendar_start_pf then
2919: ROLLBACK TO create_partial_cycle;
2920: x_msg_count := 1;
2921: x_msg_data := 'Invalid calendar start pf';

Line 2922: x_return_status := FND_API.G_RET_STS_ERROR;

2918: WHEN invalid_calendar_start_pf then
2919: ROLLBACK TO create_partial_cycle;
2920: x_msg_count := 1;
2921: x_msg_data := 'Invalid calendar start pf';
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: WHEN invalid_appended then
2924: ROLLBACK TO create_partial_cycle;
2925: x_msg_count := 1;
2926: x_msg_data := 'Invalid appended';

Line 2927: x_return_status := FND_API.G_RET_STS_ERROR;

2923: WHEN invalid_appended then
2924: ROLLBACK TO create_partial_cycle;
2925: x_msg_count := 1;
2926: x_msg_data := 'Invalid appended';
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: WHEN invalid_versions then
2929: ROLLBACK TO create_partial_cycle;
2930: x_msg_count := 1;
2931: x_msg_data := 'Invalid versions';

Line 2932: x_return_status := FND_API.G_RET_STS_ERROR;

2928: WHEN invalid_versions then
2929: ROLLBACK TO create_partial_cycle;
2930: x_msg_count := 1;
2931: x_msg_data := 'Invalid versions';
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: ROLLBACK TO create_partial_cycle;
2935: x_return_status := FND_API.G_RET_STS_ERROR;
2936: FND_MSG_PUB.Count_And_Get(

Line 2933: WHEN FND_API.G_EXC_ERROR THEN

2929: ROLLBACK TO create_partial_cycle;
2930: x_msg_count := 1;
2931: x_msg_data := 'Invalid versions';
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: ROLLBACK TO create_partial_cycle;
2935: x_return_status := FND_API.G_RET_STS_ERROR;
2936: FND_MSG_PUB.Count_And_Get(
2937: p_count => x_msg_count,

Line 2935: x_return_status := FND_API.G_RET_STS_ERROR;

2931: x_msg_data := 'Invalid versions';
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: ROLLBACK TO create_partial_cycle;
2935: x_return_status := FND_API.G_RET_STS_ERROR;
2936: FND_MSG_PUB.Count_And_Get(
2937: p_count => x_msg_count,
2938: p_data => x_msg_data
2939: );

Line 2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2936: FND_MSG_PUB.Count_And_Get(
2937: p_count => x_msg_count,
2938: p_data => x_msg_data
2939: );
2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2941: ROLLBACK TO create_partial_cycle;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: FND_MSG_PUB.Count_And_Get(
2944: p_count => x_msg_count,

Line 2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2938: p_data => x_msg_data
2939: );
2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2941: ROLLBACK TO create_partial_cycle;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: FND_MSG_PUB.Count_And_Get(
2944: p_count => x_msg_count,
2945: p_data => x_msg_data
2946: );

Line 2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2945: p_data => x_msg_data
2946: );
2947: WHEN OTHERS THEN
2948: ROLLBACK TO create_partial_cycle;
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2952: FND_MSG_PUB.Add_Exc_Msg(
2953: G_PKG_NAME,

Line 3130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3126: end create_cycle_curinst_task;
3127:
3128: procedure create_migrate_inst(
3129: p_api_version IN NUMBER,
3130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3133: x_return_status OUT NOCOPY VARCHAR2 ,
3134: x_msg_count OUT NOCOPY NUMBER,

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

3127:
3128: procedure create_migrate_inst(
3129: p_api_version IN NUMBER,
3130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3133: x_return_status OUT NOCOPY VARCHAR2 ,
3134: x_msg_count OUT NOCOPY NUMBER,
3135: x_msg_data OUT NOCOPY VARCHAR2,

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

3128: procedure create_migrate_inst(
3129: p_api_version IN NUMBER,
3130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3133: x_return_status OUT NOCOPY VARCHAR2 ,
3134: x_msg_count OUT NOCOPY NUMBER,
3135: x_msg_data OUT NOCOPY VARCHAR2,
3136: p_apps_user_id in NUMBER,

Line 3155: IF NOT FND_API.Compatible_API_Call( l_api_version,

3151:
3152: -- Standard Start of API savepoint
3153: SAVEPOINT create_migrate_inst;
3154: -- Standard call to check for call compatibility.
3155: IF NOT FND_API.Compatible_API_Call( l_api_version,
3156: p_api_version,
3157: l_api_name,
3158: G_PKG_NAME)
3159: THEN

Line 3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3156: p_api_version,
3157: l_api_name,
3158: G_PKG_NAME)
3159: THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: -- Initialize message list if p_init_msg_list is set to TRUE.
3164: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3164: IF FND_API.to_Boolean(p_init_msg_list) THEN

3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: -- Initialize message list if p_init_msg_list is set to TRUE.
3164: IF FND_API.to_Boolean(p_init_msg_list) THEN
3165: FND_MSG_PUB.initialize;
3166: END IF;
3167:
3168: -- Initialize API return status to success

Line 3169: x_return_status := FND_API.G_RET_STS_SUCCESS;

3165: FND_MSG_PUB.initialize;
3166: END IF;
3167:
3168: -- Initialize API return status to success
3169: x_return_status := FND_API.G_RET_STS_SUCCESS;
3170:
3171: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
3172:
3173: copy_ac_table_rec(p_analysis_cycle_id, new_ac_id);

Line 3244: IF FND_API.To_Boolean( p_commit ) THEN

3240: create_cycle_curinst_task(new_ac_id,p_apps_user_id);
3241: end if;
3242:
3243: -- Standard check of p_commit.
3244: IF FND_API.To_Boolean( p_commit ) THEN
3245: COMMIT WORK;
3246: END IF;
3247: -- Standard call to get message count and if count is 1, get message info.
3248: FND_MSG_PUB.Count_And_Get(

Line 3258: x_return_status := FND_API.G_RET_STS_ERROR;

3254: WHEN invalid_calendar_start_member then
3255: ROLLBACK TO create_migrate_inst;
3256: x_msg_count := 1;
3257: x_msg_data := 'Invalid calendar start member';
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: WHEN invalid_calendar_end_member then
3260: ROLLBACK TO create_migrate_inst;
3261: x_msg_count := 1;
3262: x_msg_data := 'Invalid calendar end member';

Line 3263: x_return_status := FND_API.G_RET_STS_ERROR;

3259: WHEN invalid_calendar_end_member then
3260: ROLLBACK TO create_migrate_inst;
3261: x_msg_count := 1;
3262: x_msg_data := 'Invalid calendar end member';
3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO create_migrate_inst;
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267: FND_MSG_PUB.Count_And_Get(

Line 3264: WHEN FND_API.G_EXC_ERROR THEN

3260: ROLLBACK TO create_migrate_inst;
3261: x_msg_count := 1;
3262: x_msg_data := 'Invalid calendar end member';
3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO create_migrate_inst;
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,

Line 3266: x_return_status := FND_API.G_RET_STS_ERROR;

3262: x_msg_data := 'Invalid calendar end member';
3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO create_migrate_inst;
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data
3270: );

Line 3271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data
3270: );
3271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3272: ROLLBACK TO create_migrate_inst;
3273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3274: FND_MSG_PUB.Count_And_Get(
3275: p_count => x_msg_count,

Line 3273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3269: p_data => x_msg_data
3270: );
3271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3272: ROLLBACK TO create_migrate_inst;
3273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3274: FND_MSG_PUB.Count_And_Get(
3275: p_count => x_msg_count,
3276: p_data => x_msg_data
3277: );

Line 3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3276: p_data => x_msg_data
3277: );
3278: WHEN OTHERS THEN
3279: ROLLBACK TO create_migrate_inst;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
3282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3283: FND_MSG_PUB.Add_Exc_Msg(
3284: G_PKG_NAME,

Line 3300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3296: --
3297: PROCEDURE Create_Hier_Order
3298: (
3299: p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,

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

3297: PROCEDURE Create_Hier_Order
3298: (
3299: p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,
3305: x_msg_data OUT NOCOPY VARCHAR2,

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

3298: (
3299: p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3301: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3302: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3303: x_return_status OUT NOCOPY VARCHAR2,
3304: x_msg_count OUT NOCOPY NUMBER,
3305: x_msg_data OUT NOCOPY VARCHAR2,
3306: p_analysis_cycle_id IN NUMBER

Line 3383: IF NOT FND_API.Compatible_API_Call(l_api_version,

3379:
3380: SAVEPOINT Create_Hier_Order;
3381:
3382: -- Standard call to check for call compatibility.
3383: IF NOT FND_API.Compatible_API_Call(l_api_version,
3384: p_api_version,
3385: l_api_name,
3386: G_PKG_NAME)
3387: THEN

Line 3388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3384: p_api_version,
3385: l_api_name,
3386: G_PKG_NAME)
3387: THEN
3388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3389: END IF;
3390:
3391: -- Initialize message list if p_init_msg_list is set to TRUE.
3392: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3392: IF FND_API.to_Boolean(p_init_msg_list) THEN

3388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3389: END IF;
3390:
3391: -- Initialize message list if p_init_msg_list is set to TRUE.
3392: IF FND_API.to_Boolean(p_init_msg_list) THEN
3393: FND_MSG_PUB.initialize;
3394: END IF;
3395:
3396: -- Initialize API return status to success

Line 3397: x_return_status := FND_API.G_RET_STS_SUCCESS;

3393: FND_MSG_PUB.initialize;
3394: END IF;
3395:
3396: -- Initialize API return status to success
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;
3398:
3399: l_user_id := fnd_global.user_id;
3400: l_login_id := fnd_global.user_id;
3401: l_object_version_number := 1;

Line 3537: IF p_commit = FND_API.G_TRUE

3533: AND dimension = l_final_rec.dimension
3534: AND hierarchy_order = l_final_rec.max;
3535: END LOOP; -- for l_final_rec in l_final_csr loop
3536:
3537: IF p_commit = FND_API.G_TRUE
3538: THEN
3539: COMMIT;
3540: END IF;
3541:

Line 3544: WHEN FND_API.G_EXC_ERROR

3540: END IF;
3541:
3542: EXCEPTION
3543:
3544: WHEN FND_API.G_EXC_ERROR
3545: THEN
3546: NULL;
3547: ROLLBACK TO Create_Hier_Order;
3548: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3548: x_return_status := FND_API.G_RET_STS_ERROR;

3544: WHEN FND_API.G_EXC_ERROR
3545: THEN
3546: NULL;
3547: ROLLBACK TO Create_Hier_Order;
3548: x_return_status := FND_API.G_RET_STS_ERROR;
3549: FND_MSG_PUB.Count_And_Get(
3550: p_count => x_msg_count,
3551: p_data => x_msg_data
3552: );

Line 3554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3550: p_count => x_msg_count,
3551: p_data => x_msg_data
3552: );
3553:
3554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3555: THEN
3556: ROLLBACK TO Create_Hier_Order;
3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3558: FND_MSG_PUB.Count_And_Get(

Line 3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3553:
3554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3555: THEN
3556: ROLLBACK TO Create_Hier_Order;
3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3558: FND_MSG_PUB.Count_And_Get(
3559: p_count => x_msg_count,
3560: p_data => x_msg_data
3561: );

Line 3566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3562:
3563: WHEN OTHERS
3564: THEN
3565: ROLLBACK TO Create_Hier_Order;
3566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3567: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3568: || substr(sqlerrm,1,90));
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3570: THEN

Line 3590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3586: -- added for bug 5436923
3587: PROCEDURE Get_VM_instance_id
3588: (
3589: p_api_version IN NUMBER,
3590: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3591: x_return_status OUT NOCOPY VARCHAR2,
3592: x_msg_count OUT NOCOPY NUMBER,
3593: x_msg_data OUT NOCOPY VARCHAR2,
3594: p_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,

Line 3606: IF NOT FND_API.Compatible_API_Call(l_api_version,

3602:
3603: BEGIN
3604:
3605: -- Standard call to check for call compatibility.
3606: IF NOT FND_API.Compatible_API_Call(l_api_version,
3607: p_api_version,
3608: l_api_name,
3609: G_PKG_NAME)
3610: THEN

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: p_api_version,
3608: l_api_name,
3609: G_PKG_NAME)
3610: THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613:
3614: -- Initialize message list if p_init_msg_list is set to TRUE.
3615: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3615: IF FND_API.to_Boolean(p_init_msg_list) THEN

3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613:
3614: -- Initialize message list if p_init_msg_list is set to TRUE.
3615: IF FND_API.to_Boolean(p_init_msg_list) THEN
3616: FND_MSG_PUB.initialize;
3617: END IF;
3618:
3619: -- Initialize API return status to success

Line 3620: x_return_status := FND_API.G_RET_STS_SUCCESS;

3616: FND_MSG_PUB.initialize;
3617: END IF;
3618:
3619: -- Initialize API return status to success
3620: x_return_status := FND_API.G_RET_STS_SUCCESS;
3621:
3622: SELECT value
3623: INTO l_param_value
3624: FROM ZPB_AC_PARAM_VALUES

Line 3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3640: END IF;
3641:
3642: EXCEPTION
3643:
3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3645: THEN
3646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3647: FND_MSG_PUB.Count_And_Get(
3648: p_count => x_msg_count,

Line 3646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3642: EXCEPTION
3643:
3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3645: THEN
3646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3647: FND_MSG_PUB.Count_And_Get(
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3650: );

Line 3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3650: );
3651:
3652: WHEN others
3653: THEN
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3655: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3656: || substr(sqlerrm,1,90));
3657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3658: THEN