DBA Data[Home] [Help]

APPS.ZPB_WF dependencies on FND_API

Line 812: p_init_msg_list => FND_API.G_TRUE,

808: DLcmd := 'call wf.call.mgr(' || taskID || ');';
809:
810:
811: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
812: p_init_msg_list => FND_API.G_TRUE,
813: x_return_status => returnStat,
814: x_msg_count => thisCount,
815: x_msg_data => msgData,
816: p_analysis_cycle_id => ACID,

Line 817: p_shared_rw => FND_API.G_FALSE);

813: x_return_status => returnStat,
814: x_msg_count => thisCount,
815: x_msg_data => msgData,
816: p_analysis_cycle_id => ACID,
817: p_shared_rw => FND_API.G_FALSE);
818:
819: DataAW := ZPB_AW.GET_SHARED_AW;
820: CodeAW := ZPB_AW.GET_CODE_AW;
821: AnnoAW := ZPB_AW.GET_ANNOTATION_AW;

Line 1264: p_shared_rw => FND_API.G_FALSE);

1260: x_msg_count => l_msgCnt,
1261: x_msg_data => l_msgData,
1262: p_business_area_id => sys_context('ZPB_CONTEXT', 'business_area_id'),
1263: p_shadow_id => sys_context('ZPB_CONTEXT','user_id'),
1264: p_shared_rw => FND_API.G_FALSE);
1265: zpb_aw.execute(l_tmpVar);
1266:
1267: return ;
1268: exception

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

1707:
1708: -- now delete any Data Collection templates
1709: -- associated with this cycle
1710: zpb_dc_objects_pvt.delete_template(
1711: 1.0, FND_API.G_TRUE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1712: l_return_status, l_msg_count, l_msg_data, InstanceID);
1713:
1714:
1715: -- b5007895

Line 2998: p_init_msg_list => FND_API.G_TRUE,

2994: from zpb_analysis_cycle_tasks
2995: where task_id = TaskID;
2996:
2997: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
2998: p_init_msg_list => FND_API.G_TRUE,
2999: x_return_status => returnStat,
3000: x_msg_count => thisCount,
3001: x_msg_data => msgData,
3002: p_analysis_cycle_id => l_InstanceID,

Line 3003: p_shared_rw => FND_API.G_TRUE);

2999: x_return_status => returnStat,
3000: x_msg_count => thisCount,
3001: x_msg_data => msgData,
3002: p_analysis_cycle_id => l_InstanceID,
3003: p_shared_rw => FND_API.G_TRUE);
3004: attached := 'Y';
3005:
3006: l_migration := 'N';
3007: for v_mparams in c_mparams loop

Line 3540: p_init_msg_list => FND_API.G_TRUE,

3536: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_START');
3537: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3538:
3539: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3540: p_init_msg_list => FND_API.G_TRUE,
3541: x_return_status => returnStat,
3542: x_msg_count => thisCount,
3543: x_msg_data => msgData,
3544: p_analysis_cycle_id => InstanceID,

Line 3545: p_shared_rw => FND_API.G_TRUE);

3541: x_return_status => returnStat,
3542: x_msg_count => thisCount,
3543: x_msg_data => msgData,
3544: p_analysis_cycle_id => InstanceID,
3545: p_shared_rw => FND_API.G_TRUE);
3546: -- Test run of solve
3547: attached := 'Y';
3548:
3549: ZPB_GEN_PHYS_MODEL.GEN_PHYSICAL_MODEL(InstanceID);

Line 3601: p_init_msg_list => FND_API.G_TRUE,

3597: zpb_util_pvt.set_opps(ZPB_UTIL_PVT.ZPB_OPPS_DATA_SOLVE, UserID);
3598:
3599: -- Test run of solve
3600: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3601: p_init_msg_list => FND_API.G_TRUE,
3602: x_return_status => retcode,
3603: x_msg_count => l_count,
3604: x_msg_data => errbuf,
3605: p_analysis_cycle_id => InstanceID,

Line 3606: p_shared_rw => FND_API.G_TRUE);

3602: x_return_status => retcode,
3603: x_msg_count => l_count,
3604: x_msg_data => errbuf,
3605: p_analysis_cycle_id => InstanceID,
3606: p_shared_rw => FND_API.G_TRUE);
3607: attached := 'Y';
3608:
3609: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3610: ZPB_AW.EXECUTE('APPS_USER_ID = ''' || TO_CHAR(UserID) || '''');

Line 3887: p_init_msg_list => FND_API.G_TRUE,

3883: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_START');
3884: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3885:
3886: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3887: p_init_msg_list => FND_API.G_TRUE,
3888: x_return_status => retcode,
3889: x_msg_count => l_count,
3890: x_msg_data => msgData,
3891: p_analysis_cycle_id => InstanceID,

Line 3892: p_shared_rw => FND_API.G_TRUE);

3888: x_return_status => retcode,
3889: x_msg_count => l_count,
3890: x_msg_data => msgData,
3891: p_analysis_cycle_id => InstanceID,
3892: p_shared_rw => FND_API.G_TRUE);
3893:
3894: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3895: attached := 'Y';
3896:

Line 3956: p_init_msg_list => FND_API.G_TRUE,

3952: delete from zpb_measures
3953: where instance_id = InstanceID;
3954:
3955: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3956: p_init_msg_list => FND_API.G_TRUE,
3957: x_return_status => retcode,
3958: x_msg_count => l_count,
3959: x_msg_data => errbuf,
3960: p_analysis_cycle_id => InstanceID,

Line 3961: p_shared_rw => FND_API.G_TRUE,

3957: x_return_status => retcode,
3958: x_msg_count => l_count,
3959: x_msg_data => errbuf,
3960: p_analysis_cycle_id => InstanceID,
3961: p_shared_rw => FND_API.G_TRUE,
3962: p_annot_rw => FND_API.G_TRUE);
3963: attached := 'Y';
3964:
3965: ZPB_AW.EXECUTE('call cm.delshinsts(''' || TO_CHAR(Instanceid) || ''')');

Line 3962: p_annot_rw => FND_API.G_TRUE);

3958: x_msg_count => l_count,
3959: x_msg_data => errbuf,
3960: p_analysis_cycle_id => InstanceID,
3961: p_shared_rw => FND_API.G_TRUE,
3962: p_annot_rw => FND_API.G_TRUE);
3963: attached := 'Y';
3964:
3965: ZPB_AW.EXECUTE('call cm.delshinsts(''' || TO_CHAR(Instanceid) || ''')');
3966:

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

4375: -- API to start task for instance for migration only.
4376:
4377: procedure RUN_MIGRATE_INST (p_InstanceID in NUMBER,
4378: p_api_version IN NUMBER,
4379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4380: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4382: x_return_status OUT nocopy varchar2,
4383: x_msg_count OUT nocopy number,

Line 4380: p_commit IN VARCHAR2 := FND_API.G_TRUE,

4376:
4377: procedure RUN_MIGRATE_INST (p_InstanceID in NUMBER,
4378: p_api_version IN NUMBER,
4379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4380: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4382: x_return_status OUT nocopy varchar2,
4383: x_msg_count OUT nocopy number,
4384: x_msg_data OUT nocopy varchar2)

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

4377: procedure RUN_MIGRATE_INST (p_InstanceID in NUMBER,
4378: p_api_version IN NUMBER,
4379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4380: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4382: x_return_status OUT nocopy varchar2,
4383: x_msg_count OUT nocopy number,
4384: x_msg_data OUT nocopy varchar2)
4385:

Line 4423: IF NOT FND_API.Compatible_API_Call( l_api_version,

4419:
4420: -- Standard Start of API savepoint
4421: SAVEPOINT zpb_request_explanation;
4422: -- Standard call to check for call compatibility.
4423: IF NOT FND_API.Compatible_API_Call( l_api_version,
4424: p_api_version,
4425: l_api_name,
4426: G_PKG_NAME)
4427: THEN

Line 4428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4424: p_api_version,
4425: l_api_name,
4426: G_PKG_NAME)
4427: THEN
4428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4429: END IF;
4430: -- Initialize message list if p_init_msg_list is set to TRUE.
4431: IF FND_API.to_Boolean(p_init_msg_list) THEN
4432: FND_MSG_PUB.initialize;

Line 4431: IF FND_API.to_Boolean(p_init_msg_list) THEN

4427: THEN
4428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4429: END IF;
4430: -- Initialize message list if p_init_msg_list is set to TRUE.
4431: IF FND_API.to_Boolean(p_init_msg_list) THEN
4432: FND_MSG_PUB.initialize;
4433: END IF;
4434: -- Initialize API return status to success
4435: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4435: x_return_status := FND_API.G_RET_STS_SUCCESS;

4431: IF FND_API.to_Boolean(p_init_msg_list) THEN
4432: FND_MSG_PUB.initialize;
4433: END IF;
4434: -- Initialize API return status to success
4435: x_return_status := FND_API.G_RET_STS_SUCCESS;
4436:
4437:
4438: begin
4439:

Line 4676: IF FND_API.To_Boolean( p_commit ) THEN

4672: -- DBMS_OUTPUT.PUT_LINE('The Workflow ITEM_KEY is: ' || newitemkey);
4673:
4674:
4675: -- Standard check of p_commit.
4676: IF FND_API.To_Boolean( p_commit ) THEN
4677: COMMIT WORK;
4678: END IF;
4679: -- Standard call to get message count and if count is 1, get message info.
4680: FND_MSG_PUB.Count_And_Get(

Line 4689: WHEN FND_API.G_EXC_ERROR THEN

4685:
4686: return;
4687:
4688: exception
4689: WHEN FND_API.G_EXC_ERROR THEN
4690: ROLLBACK TO zpb_request_explanation;
4691: x_return_status := FND_API.G_RET_STS_ERROR;
4692: FND_MSG_PUB.Count_And_Get(
4693: p_count => x_msg_count,

Line 4691: x_return_status := FND_API.G_RET_STS_ERROR;

4687:
4688: exception
4689: WHEN FND_API.G_EXC_ERROR THEN
4690: ROLLBACK TO zpb_request_explanation;
4691: x_return_status := FND_API.G_RET_STS_ERROR;
4692: FND_MSG_PUB.Count_And_Get(
4693: p_count => x_msg_count,
4694: p_data => x_msg_data
4695: );

Line 4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4692: FND_MSG_PUB.Count_And_Get(
4693: p_count => x_msg_count,
4694: p_data => x_msg_data
4695: );
4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: ROLLBACK TO zpb_request_explanation;
4698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4699: FND_MSG_PUB.Count_And_Get(
4700: p_count => x_msg_count,

Line 4698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4694: p_data => x_msg_data
4695: );
4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: ROLLBACK TO zpb_request_explanation;
4698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4699: FND_MSG_PUB.Count_And_Get(
4700: p_count => x_msg_count,
4701: p_data => x_msg_data
4702: );

Line 4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4701: p_data => x_msg_data
4702: );
4703: WHEN OTHERS THEN
4704: ROLLBACK TO zpb_request_explanation;
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4707: FND_MSG_PUB.Add_Exc_Msg(
4708: G_PKG_NAME,
4709: l_api_name