DBA Data[Home] [Help]

APPS.ZPB_WF dependencies on FND_MESSAGE

Line 1333: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_START');

1329: return;
1330: end if;
1331:
1332: -- Begining the creation of a new Business Process Run
1333: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_START');
1334: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1335:
1336: -- call ops prg to make new instance
1337: ZPB_AC_OPS.CREATE_NEW_INSTANCE(ACID, outInstanceID);

Line 1334: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1330: end if;
1331:
1332: -- Begining the creation of a new Business Process Run
1333: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_START');
1334: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1335:
1336: -- call ops prg to make new instance
1337: ZPB_AC_OPS.CREATE_NEW_INSTANCE(ACID, outInstanceID);
1338:

Line 1600: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_END');

1596: +======================================================================+*/
1597:
1598:
1599: -- The new Business Process Run has started
1600: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_END');
1601: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1602:
1603: -- b 5170327 - retcode is an OUT parameter conc program standard - 0=success, 1=warning or 2=error.
1604: -- will have warning if set by AW dml from call to ZPB_WF.INIT_BUSINESS_PROCESS

Line 1601: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1597:
1598:
1599: -- The new Business Process Run has started
1600: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_NEW_BP_END');
1601: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1602:
1603: -- b 5170327 - retcode is an OUT parameter conc program standard - 0=success, 1=warning or 2=error.
1604: -- will have warning if set by AW dml from call to ZPB_WF.INIT_BUSINESS_PROCESS
1605: retcode := ZPB_ERROR_HANDLER.GET_CONC_REQ_STATUS;

Line 3536: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_START');

3532: -- set olap page pool size based on ZPB_OPPS_AW_BUILD profile setting
3533: zpb_util_pvt.set_opps(ZPB_UTIL_PVT.ZPB_OPPS_AW_BUILD, UserID);
3534:
3535: --log START Generate Physical Model
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,

Line 3537: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3533: zpb_util_pvt.set_opps(ZPB_UTIL_PVT.ZPB_OPPS_AW_BUILD, UserID);
3534:
3535: --log START Generate Physical Model
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,

Line 3555: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_END');

3551: ZPB_AW.DETACH_ALL;
3552: attached := 'N';
3553:
3554: --log END Generate Physical Model has completed
3555: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_END');
3556: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3557:
3558: -- NEW CALL to intialize process run data for instance
3559: ZPB_WF.INIT_PROC_RUN_DATA (ACID, InstanceID, TaskID, UserID);

Line 3556: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3552: attached := 'N';
3553:
3554: --log END Generate Physical Model has completed
3555: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_END');
3556: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3557:
3558: -- NEW CALL to intialize process run data for instance
3559: ZPB_WF.INIT_PROC_RUN_DATA (ACID, InstanceID, TaskID, UserID);
3560:

Line 3568: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_ERROR');

3564: exception
3565: when others then
3566:
3567: --log Generate Physical Model has errored
3568: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_ERROR');
3569: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3570:
3571: if attached = 'Y' then
3572: ZPB_AW.DETACH_ALL;

Line 3569: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3565: when others then
3566:
3567: --log Generate Physical Model has errored
3568: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_ERROR');
3569: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3570:
3571: if attached = 'Y' then
3572: ZPB_AW.DETACH_ALL;
3573: end if;

Line 3626: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVEOK');

3622: ZPB_AW.DETACH_ALL;
3623: attached := 'N';
3624:
3625: --log solve OK
3626: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVEOK');
3627: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3628:
3629: return;
3630:

Line 3627: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3623: attached := 'N';
3624:
3625: --log solve OK
3626: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVEOK');
3627: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3628:
3629: return;
3630:
3631: exception

Line 3641: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVE_NOTOK');

3637: ZPB_AW.DETACH_ALL;
3638: end if;
3639:
3640: --log solve OK
3641: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVE_NOTOK');
3642: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3643: errbuf:=substr(sqlerrm, 1, 255);
3644:
3645: -- update zpb instance info with ERROR

Line 3642: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3638: end if;
3639:
3640: --log solve OK
3641: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVE_NOTOK');
3642: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3643: errbuf:=substr(sqlerrm, 1, 255);
3644:
3645: -- update zpb instance info with ERROR
3646: UPDATE_STATUS('ERROR', Instanceid, taskid, UserID);

Line 3883: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_START');

3879:
3880: -- retcode := '0';
3881:
3882: --log Initialization of Business Process Run data has started
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,

Line 3884: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3880: -- retcode := '0';
3881:
3882: --log Initialization of Business Process Run data has started
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,

Line 3908: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_END');

3904: ZPB_AW.DETACH_ALL;
3905: attached := 'N';
3906:
3907: --log Initialization of Business Process Run data has completed
3908: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_END');
3909: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3910:
3911: return;
3912:

Line 3909: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3905: attached := 'N';
3906:
3907: --log Initialization of Business Process Run data has completed
3908: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_END');
3909: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3910:
3911: return;
3912:
3913: exception

Line 3922: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_ERROR');

3918: ZPB_AW.DETACH_ALL;
3919: end if;
3920:
3921: --log Initialization of Business Process Run data encountered an error
3922: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_ERROR');
3923: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3924: -- errbuf:=substr(sqlerrm, 1, 255);
3925:
3926: -- update zpb instance info with ERROR

Line 3923: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3919: end if;
3920:
3921: --log Initialization of Business Process Run data encountered an error
3922: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_ERROR');
3923: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3924: -- errbuf:=substr(sqlerrm, 1, 255);
3925:
3926: -- update zpb instance info with ERROR
3927: UPDATE_STATUS('ERROR', Instanceid);

Line 3949: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_BEGDELINST');

3945:
3946: retcode := '0';
3947:
3948: --log DEL INST OK
3949: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_BEGDELINST');
3950: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3951:
3952: delete from zpb_measures
3953: where instance_id = InstanceID;

Line 3950: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3946: retcode := '0';
3947:
3948: --log DEL INST OK
3949: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_BEGDELINST');
3950: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3951:
3952: delete from zpb_measures
3953: where instance_id = InstanceID;
3954:

Line 3997: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ENDDELINST');

3993: ZPB_AW.DETACH_ALL;
3994: attached := 'N';
3995:
3996: --log DEL INST OK
3997: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ENDDELINST');
3998: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3999:
4000: return;
4001:

Line 3998: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

3994: attached := 'N';
3995:
3996: --log DEL INST OK
3997: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ENDDELINST');
3998: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3999:
4000: return;
4001:
4002: exception

Line 4012: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ERRDELINST');

4008: ZPB_AW.DETACH_ALL;
4009: end if;
4010:
4011: --log DEL INST ERR
4012: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ERRDELINST');
4013: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
4014: errbuf:=substr(sqlerrm, 1, 255);
4015:
4016: -- do not update zpb instance info with ERROR from this procedure

Line 4013: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

4009: end if;
4010:
4011: --log DEL INST ERR
4012: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ERRDELINST');
4013: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
4014: errbuf:=substr(sqlerrm, 1, 255);
4015:
4016: -- do not update zpb instance info with ERROR from this procedure
4017: -- as this would cause another DELAWISNT CM request causing