DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on STANDARD

Line 167: -- Standard Start of API savepoint

163: -- end bug#13698799
164:
165: BEGIN
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
169: -- Standard call to check for call compatibility.
170: IF NOT Fnd_Api.Compatible_API_Call
171: (l_api_version_number,

Line 169: -- Standard call to check for call compatibility.

165: BEGIN
166:
167: -- Standard Start of API savepoint
168: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
169: -- Standard call to check for call compatibility.
170: IF NOT Fnd_Api.Compatible_API_Call
171: (l_api_version_number,
172: p_api_version_number,
173: l_api_name,

Line 697: -- Standard check for p_commit

693:
694: --
695: -- End of API body
696: --
697: -- Standard check for p_commit
698: IF Fnd_Api.to_Boolean( p_commit )
699: THEN
700: COMMIT WORK;
701: END IF;

Line 702: -- Standard call to get message count and if count is 1, get message info.

698: IF Fnd_Api.to_Boolean( p_commit )
699: THEN
700: COMMIT WORK;
701: END IF;
702: -- Standard call to get message count and if count is 1, get message info.
703: Fnd_Msg_Pub.Count_And_Get
704: (p_count => x_msg_count,
705: p_data => x_msg_data
706: );

Line 870: -- Standard Start of API savepoint

866: x_dff_value_rec csd_repairs_util.def_rec_type;
867:
868: BEGIN
869:
870: -- Standard Start of API savepoint
871: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
872: -- Standard call to check for call compatibility.
873: IF NOT Fnd_Api.Compatible_API_Call
874: (l_api_version_number,

Line 872: -- Standard call to check for call compatibility.

868: BEGIN
869:
870: -- Standard Start of API savepoint
871: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
872: -- Standard call to check for call compatibility.
873: IF NOT Fnd_Api.Compatible_API_Call
874: (l_api_version_number,
875: p_api_version_number,
876: l_api_name,

Line 1202: -- Standard check for p_commit

1198:
1199: --
1200: -- End of API body.
1201: --
1202: -- Standard check for p_commit
1203: IF Fnd_Api.to_Boolean(p_commit) THEN
1204: COMMIT WORK;
1205: END IF;
1206: -- Standard call to get message count and if count is 1, get message info.

Line 1206: -- Standard call to get message count and if count is 1, get message info.

1202: -- Standard check for p_commit
1203: IF Fnd_Api.to_Boolean(p_commit) THEN
1204: COMMIT WORK;
1205: END IF;
1206: -- Standard call to get message count and if count is 1, get message info.
1207: Fnd_Msg_Pub.Count_And_Get
1208: (p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );

Line 1262: -- Standard Start of API savepoint

1258: l_api_version_number CONSTANT NUMBER := 1.0;
1259:
1260: BEGIN
1261: --
1262: -- Standard Start of API savepoint
1263: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
1264: -- Standard call to check for call compatibility.
1265: IF NOT Fnd_Api.Compatible_API_Call
1266: (l_api_version_number,

Line 1264: -- Standard call to check for call compatibility.

1260: BEGIN
1261: --
1262: -- Standard Start of API savepoint
1263: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
1264: -- Standard call to check for call compatibility.
1265: IF NOT Fnd_Api.Compatible_API_Call
1266: (l_api_version_number,
1267: p_api_version_number,
1268: l_api_name,

Line 1288: -- Standard check for p_commit

1284: p_REPAIR_LINE_ID => p_REPAIR_LINE_ID);
1285:
1286: -- End of API body
1287:
1288: -- Standard check for p_commit
1289: IF Fnd_Api.to_Boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292: -- Standard call to get message count and if count is 1, get message info.

Line 1292: -- Standard call to get message count and if count is 1, get message info.

1288: -- Standard check for p_commit
1289: IF Fnd_Api.to_Boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292: -- Standard call to get message count and if count is 1, get message info.
1293: Fnd_Msg_Pub.Count_And_Get
1294: (p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );

Line 2615: -- Standard Start of API savepoint

2611: l_refurbished_repair_type_flag VARCHAR2(1);
2612:
2613: BEGIN
2614:
2615: -- Standard Start of API savepoint
2616: SAVEPOINT VALIDATE_REPAIRS_PVT;
2617: -- Standard call to check for call compatibility.
2618: IF NOT Fnd_Api.Compatible_API_Call
2619: (l_api_version_number,

Line 2617: -- Standard call to check for call compatibility.

2613: BEGIN
2614:
2615: -- Standard Start of API savepoint
2616: SAVEPOINT VALIDATE_REPAIRS_PVT;
2617: -- Standard call to check for call compatibility.
2618: IF NOT Fnd_Api.Compatible_API_Call
2619: (l_api_version_number,
2620: p_api_version_number,
2621: l_api_name,

Line 3262: /* p_api_version Standard IN param */

3258: /* the original repair order to the new repair */
3259: /* order. */
3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */

Line 3263: /* p_commit Standard IN param */

3259: /* order. */
3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */

Line 3264: /* p_init_msg_list Standard IN param */

3260: /* */
3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */

Line 3265: /* p_validation_level Standard IN param */

3261: /* */
3262: /* p_api_version Standard IN param */
3263: /* p_commit Standard IN param */
3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */

Line 3268: /* x_return_status Standard OUT param */

3264: /* p_init_msg_list Standard IN param */
3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/

Line 3269: /* x_msg_count Standard OUT param */

3265: /* p_validation_level Standard IN param */
3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/
3273: PROCEDURE Copy_Attachments

Line 3270: /* x_msg_data Standard OUT param */

3266: /* p_original_ro_id Original Repair Line Id */
3267: /* p_new_ro_id New Repair Line Id */
3268: /* x_return_status Standard OUT param */
3269: /* x_msg_count Standard OUT param */
3270: /* x_msg_data Standard OUT param */
3271: /* */
3272: /*-------------------------------------------------------------------*/
3273: PROCEDURE Copy_Attachments
3274: ( p_api_version IN NUMBER,

Line 3387: -- Standard Start of API savepoint

3383: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3384:
3385: BEGIN
3386:
3387: -- Standard Start of API savepoint
3388: SAVEPOINT copy_Attachments;
3389:
3390: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3391: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 3396: -- Standard call to check for call compatibility.

3392: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3393: 'Entered Copy_Attachments API');
3394: END IF;
3395:
3396: -- Standard call to check for call compatibility.
3397: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3398: p_api_version,
3399: l_api_name,
3400: G_PKG_NAME)

Line 3724: -- Standard check of p_commit.

3720: END IF;
3721:
3722: -- Api body ends here
3723:
3724: -- Standard check of p_commit.
3725: IF Fnd_Api.To_Boolean( p_commit ) THEN
3726: COMMIT;
3727: END IF;
3728:

Line 3729: -- Standard call to get message count and if count is 1, get message info

3725: IF Fnd_Api.To_Boolean( p_commit ) THEN
3726: COMMIT;
3727: END IF;
3728:
3729: -- Standard call to get message count and if count is 1, get message info
3730: Fnd_Msg_Pub.Count_And_Get
3731: (p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:

Line 3791: /* p_api_version Standard IN param */

3787: /* procedure name: Delete_Attachments */
3788: /* description : This procedure deletes all the attachements */
3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */

Line 3792: /* p_commit Standard IN param */

3788: /* description : This procedure deletes all the attachements */
3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */

Line 3793: /* p_init_msg_list Standard IN param */

3789: /* linked with the repair line id. */
3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */

Line 3794: /* p_validation_level Standard IN param */

3790: /* */
3791: /* p_api_version Standard IN param */
3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */

Line 3796: /* x_return_status Standard OUT param */

3792: /* p_commit Standard IN param */
3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/

Line 3797: /* x_msg_count Standard OUT param */

3793: /* p_init_msg_list Standard IN param */
3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/
3801: PROCEDURE Delete_Attachments

Line 3798: /* x_msg_data Standard OUT param */

3794: /* p_validation_level Standard IN param */
3795: /* p_repair_line_id Repair Line Id */
3796: /* x_return_status Standard OUT param */
3797: /* x_msg_count Standard OUT param */
3798: /* x_msg_data Standard OUT param */
3799: /* */
3800: /*------------------------------------------------------------------*/
3801: PROCEDURE Delete_Attachments
3802: (p_api_version IN NUMBER,

Line 3821: -- Standard Start of API savepoint

3817: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3818:
3819: BEGIN
3820:
3821: -- Standard Start of API savepoint
3822: SAVEPOINT Delete_Attachments;
3823:
3824: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3825: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 3830: -- Standard call to check for call compatibility.

3826: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3827: 'Entered Delete_Attachments API');
3828: END IF;
3829:
3830: -- Standard call to check for call compatibility.
3831: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3832: p_api_version,
3833: l_api_name,
3834: G_PKG_NAME)

Line 3993: -- Standard check of p_commit.

3989: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);
3990:
3991: -- Api body ends here
3992:
3993: -- Standard check of p_commit.
3994: IF Fnd_Api.To_Boolean( p_commit ) THEN
3995: COMMIT;
3996: END IF;
3997:

Line 3998: -- Standard call to get message count and if count is 1, get message info

3994: IF Fnd_Api.To_Boolean( p_commit ) THEN
3995: COMMIT;
3996: END IF;
3997:
3998: -- Standard call to get message count and if count is 1, get message info
3999: Fnd_Msg_Pub.Count_And_Get
4000: (p_count => x_msg_count,
4001: p_data => x_msg_data);
4002:

Line 4124: --------------------Standard stuff -------------------------

4120: WHERE FLOW_STATUS_ID = p_repair_status_id;
4121:
4122:
4123: BEGIN
4124: --------------------Standard stuff -------------------------
4125: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4126: Fnd_Log.STRING (Fnd_Log.level_procedure,
4127: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
4128: 'Entering update_ro_status private api');

Line 4249: -- Standard check of p_commit.

4245:
4246:
4247: -- Api body ends here
4248:
4249: -- Standard check of p_commit.
4250: IF Fnd_Api.to_boolean (p_commit) THEN
4251: COMMIT WORK;
4252: END IF;
4253:

Line 4254: -- Standard call to get message count and IF count is get message info.

4250: IF Fnd_Api.to_boolean (p_commit) THEN
4251: COMMIT WORK;
4252: END IF;
4253:
4254: -- Standard call to get message count and IF count is get message info.
4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4256:
4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4258: Fnd_Log.STRING (Fnd_Log.level_procedure,

Line 4397: -- Standard Start of API savepoint

4393: WHERE repair_line_id = p_repair_line_id;
4394:
4395: BEGIN
4396:
4397: -- Standard Start of API savepoint
4398: SAVEPOINT Update_Flow_Status;
4399:
4400: -- Standard call to check for call compatibility.
4401: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

Line 4400: -- Standard call to check for call compatibility.

4396:
4397: -- Standard Start of API savepoint
4398: SAVEPOINT Update_Flow_Status;
4399:
4400: -- Standard call to check for call compatibility.
4401: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
4402: p_api_version,
4403: lc_api_name ,
4404: G_PKG_NAME )

Line 4813: -- Standard check of p_commit.

4809:
4810: -- Api body ends here
4811:
4812: --debug('update_flow_status: Step 13');
4813: -- Standard check of p_commit.
4814: IF Fnd_Api.To_Boolean( p_commit ) THEN
4815: COMMIT WORK;
4816: END IF;
4817: --debug('update_flow_status: Step 14');

Line 4819: -- Standard call to get message count and IF count is get message info.

4815: COMMIT WORK;
4816: END IF;
4817: --debug('update_flow_status: Step 14');
4818:
4819: -- Standard call to get message count and IF count is get message info.
4820: Fnd_Msg_Pub.Count_And_Get
4821: (p_count => x_msg_count,
4822: p_data => x_msg_data );
4823:

Line 5041: -- Standard Start of API savepoint

5037: CRTV1.REPAIR_TYPE_Id = p_to_repair_type_id;
5038:
5039: BEGIN
5040:
5041: -- Standard Start of API savepoint
5042: SAVEPOINT Update_Repair_Type;
5043:
5044: -- Standard call to check for call compatibility.
5045: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

Line 5044: -- Standard call to check for call compatibility.

5040:
5041: -- Standard Start of API savepoint
5042: SAVEPOINT Update_Repair_Type;
5043:
5044: -- Standard call to check for call compatibility.
5045: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5046: p_api_version,
5047: lc_api_name ,
5048: G_PKG_NAME )

Line 5338: -- Standard check of p_commit.

5334: END IF;
5335:
5336: -- Api body ends here
5337:
5338: -- Standard check of p_commit.
5339: IF Fnd_Api.To_Boolean( p_commit ) THEN
5340: COMMIT WORK;
5341: END IF;
5342:

Line 5343: -- Standard call to get message count and IF count is get message info.

5339: IF Fnd_Api.To_Boolean( p_commit ) THEN
5340: COMMIT WORK;
5341: END IF;
5342:
5343: -- Standard call to get message count and IF count is get message info.
5344: Fnd_Msg_Pub.Count_And_Get
5345: (p_count => x_msg_count,
5346: p_data => x_msg_data );
5347:

Line 5537: -- Standard Start of API savepoint

5533: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5534:
5535: BEGIN
5536:
5537: -- Standard Start of API savepoint
5538: SAVEPOINT Launch_Flwsts_Wf;
5539:
5540: -- Standard call to check for call compatibility.
5541: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

Line 5540: -- Standard call to check for call compatibility.

5536:
5537: -- Standard Start of API savepoint
5538: SAVEPOINT Launch_Flwsts_Wf;
5539:
5540: -- Standard call to check for call compatibility.
5541: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5542: p_api_version,
5543: lc_api_name,
5544: G_PKG_NAME)

Line 5708: -- Standard check of p_commit.

5704: -- Wf_Engine.threshold := l_wf_current_threshold;
5705:
5706: -- Api body ends here
5707:
5708: -- Standard check of p_commit.
5709: IF Fnd_Api.To_Boolean( p_commit ) THEN
5710: COMMIT WORK;
5711: END IF;
5712:

Line 5713: -- Standard call to get message count and IF count is get message info.

5709: IF Fnd_Api.To_Boolean( p_commit ) THEN
5710: COMMIT WORK;
5711: END IF;
5712:
5713: -- Standard call to get message count and IF count is get message info.
5714: Fnd_Msg_Pub.Count_And_Get
5715: (p_count => x_msg_count,
5716: p_data => x_msg_data );
5717:

Line 5848: -- Standard Start of API savepoint

5844: lc_api_name CONSTANT VARCHAR2(30) := 'update_ro_status_websrvc';
5845: lc_api_version CONSTANT NUMBER := 1.0;
5846:
5847: BEGIN
5848: -- Standard Start of API savepoint
5849: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
5850:
5851: -- Standard call to check for call compatibility.
5852: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

Line 5851: -- Standard call to check for call compatibility.

5847: BEGIN
5848: -- Standard Start of API savepoint
5849: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
5850:
5851: -- Standard call to check for call compatibility.
5852: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5853: p_api_version,
5854: lc_api_name,
5855: G_PKG_NAME)

Line 5908: -- Standard check of p_commit.

5904: P_STATUS_CONTROL_REC => l_status_upd_control_rec,
5905: X_OBJECT_VERSION_NUMBER => l_object_Version_number);
5906: --
5907:
5908: -- Standard check of p_commit.
5909: IF Fnd_Api.To_Boolean( p_commit ) THEN
5910: COMMIT WORK;
5911: END IF;
5912:

Line 5913: -- Standard call to get message count and IF count is get message info.

5909: IF Fnd_Api.To_Boolean( p_commit ) THEN
5910: COMMIT WORK;
5911: END IF;
5912:
5913: -- Standard call to get message count and IF count is get message info.
5914: Fnd_Msg_Pub.Count_And_Get
5915: (p_count => x_msg_count,
5916: p_data => x_msg_data );
5917:

Line 6044: -- Standard check of p_commit.

6040: ( p_event_name => 'oracle.apps.csd.repair.status.change',
6041: p_event_key => l_event_key,
6042: p_parameters => l_param_list);
6043:
6044: -- Standard check of p_commit.
6045: If FND_API.To_Boolean( p_commit ) then
6046: commit;
6047: End if;
6048: