DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on STANDARD

Line 140: -- Standard Start of API savepoint

136: WHERE incident_id = p_incident_id;
137:
138: BEGIN
139:
140: -- Standard Start of API savepoint
141: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
142: -- Standard call to check for call compatibility.
143: IF NOT Fnd_Api.Compatible_API_Call
144: (l_api_version_number,

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

138: BEGIN
139:
140: -- Standard Start of API savepoint
141: SAVEPOINT CREATE_REPAIR_ORDER_PVT;
142: -- Standard call to check for call compatibility.
143: IF NOT Fnd_Api.Compatible_API_Call
144: (l_api_version_number,
145: p_api_version_number,
146: l_api_name,

Line 517: -- Standard check for p_commit

513: x_REPAIR_NUMBER := l_REPAIR_NUMBER;
514: --
515: -- End of API body
516: --
517: -- Standard check for p_commit
518: IF Fnd_Api.to_Boolean( p_commit )
519: THEN
520: COMMIT WORK;
521: END IF;

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

518: IF Fnd_Api.to_Boolean( p_commit )
519: THEN
520: COMMIT WORK;
521: END IF;
522: -- Standard call to get message count and if count is 1, get message info.
523: Fnd_Msg_Pub.Count_And_Get
524: (p_count => x_msg_count,
525: p_data => x_msg_data
526: );

Line 656: -- Standard Start of API savepoint

652: x_dff_value_rec csd_repairs_util.def_rec_type;
653:
654: BEGIN
655:
656: -- Standard Start of API savepoint
657: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
658: -- Standard call to check for call compatibility.
659: IF NOT Fnd_Api.Compatible_API_Call
660: (l_api_version_number,

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

654: BEGIN
655:
656: -- Standard Start of API savepoint
657: SAVEPOINT UPDATE_REPAIR_ORDER_PVT;
658: -- Standard call to check for call compatibility.
659: IF NOT Fnd_Api.Compatible_API_Call
660: (l_api_version_number,
661: p_api_version_number,
662: l_api_name,

Line 908: -- Standard check for p_commit

904:
905: --
906: -- End of API body.
907: --
908: -- Standard check for p_commit
909: IF Fnd_Api.to_Boolean(p_commit) THEN
910: COMMIT WORK;
911: END IF;
912: -- Standard call to get message count and if count is 1, get message info.

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

908: -- Standard check for p_commit
909: IF Fnd_Api.to_Boolean(p_commit) THEN
910: COMMIT WORK;
911: END IF;
912: -- Standard call to get message count and if count is 1, get message info.
913: Fnd_Msg_Pub.Count_And_Get
914: (p_count => x_msg_count,
915: p_data => x_msg_data
916: );

Line 968: -- Standard Start of API savepoint

964: l_api_version_number CONSTANT NUMBER := 1.0;
965:
966: BEGIN
967: --
968: -- Standard Start of API savepoint
969: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
970: -- Standard call to check for call compatibility.
971: IF NOT Fnd_Api.Compatible_API_Call
972: (l_api_version_number,

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

966: BEGIN
967: --
968: -- Standard Start of API savepoint
969: SAVEPOINT DELETE_REPAIR_ORDER_PVT;
970: -- Standard call to check for call compatibility.
971: IF NOT Fnd_Api.Compatible_API_Call
972: (l_api_version_number,
973: p_api_version_number,
974: l_api_name,

Line 994: -- Standard check for p_commit

990: p_REPAIR_LINE_ID => p_REPAIR_LINE_ID);
991:
992: -- End of API body
993:
994: -- Standard check for p_commit
995: IF Fnd_Api.to_Boolean(p_commit) THEN
996: COMMIT WORK;
997: END IF;
998: -- Standard call to get message count and if count is 1, get message info.

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

994: -- Standard check for p_commit
995: IF Fnd_Api.to_Boolean(p_commit) THEN
996: COMMIT WORK;
997: END IF;
998: -- Standard call to get message count and if count is 1, get message info.
999: Fnd_Msg_Pub.Count_And_Get
1000: (p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );

Line 2307: -- Standard Start of API savepoint

2303: l_refurbished_repair_type_flag VARCHAR2(1);
2304:
2305: BEGIN
2306:
2307: -- Standard Start of API savepoint
2308: SAVEPOINT VALIDATE_REPAIRS_PVT;
2309: -- Standard call to check for call compatibility.
2310: IF NOT Fnd_Api.Compatible_API_Call
2311: (l_api_version_number,

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

2305: BEGIN
2306:
2307: -- Standard Start of API savepoint
2308: SAVEPOINT VALIDATE_REPAIRS_PVT;
2309: -- Standard call to check for call compatibility.
2310: IF NOT Fnd_Api.Compatible_API_Call
2311: (l_api_version_number,
2312: p_api_version_number,
2313: l_api_name,

Line 2954: /* p_api_version Standard IN param */

2950: /* the original repair order to the new repair */
2951: /* order. */
2952: /* */
2953: /* */
2954: /* p_api_version Standard IN param */
2955: /* p_commit Standard IN param */
2956: /* p_init_msg_list Standard IN param */
2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */

Line 2955: /* p_commit Standard IN param */

2951: /* order. */
2952: /* */
2953: /* */
2954: /* p_api_version Standard IN param */
2955: /* p_commit Standard IN param */
2956: /* p_init_msg_list Standard IN param */
2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */

Line 2956: /* p_init_msg_list Standard IN param */

2952: /* */
2953: /* */
2954: /* p_api_version Standard IN param */
2955: /* p_commit Standard IN param */
2956: /* p_init_msg_list Standard IN param */
2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */
2960: /* x_return_status Standard OUT param */

Line 2957: /* p_validation_level Standard IN param */

2953: /* */
2954: /* p_api_version Standard IN param */
2955: /* p_commit Standard IN param */
2956: /* p_init_msg_list Standard IN param */
2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */
2960: /* x_return_status Standard OUT param */
2961: /* x_msg_count Standard OUT param */

Line 2960: /* x_return_status Standard OUT param */

2956: /* p_init_msg_list Standard IN param */
2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */
2960: /* x_return_status Standard OUT param */
2961: /* x_msg_count Standard OUT param */
2962: /* x_msg_data Standard OUT param */
2963: /* */
2964: /*-------------------------------------------------------------------*/

Line 2961: /* x_msg_count Standard OUT param */

2957: /* p_validation_level Standard IN param */
2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */
2960: /* x_return_status Standard OUT param */
2961: /* x_msg_count Standard OUT param */
2962: /* x_msg_data Standard OUT param */
2963: /* */
2964: /*-------------------------------------------------------------------*/
2965: PROCEDURE Copy_Attachments

Line 2962: /* x_msg_data Standard OUT param */

2958: /* p_original_ro_id Original Repair Line Id */
2959: /* p_new_ro_id New Repair Line Id */
2960: /* x_return_status Standard OUT param */
2961: /* x_msg_count Standard OUT param */
2962: /* x_msg_data Standard OUT param */
2963: /* */
2964: /*-------------------------------------------------------------------*/
2965: PROCEDURE Copy_Attachments
2966: ( p_api_version IN NUMBER,

Line 3079: -- Standard Start of API savepoint

3075: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3076:
3077: BEGIN
3078:
3079: -- Standard Start of API savepoint
3080: SAVEPOINT copy_Attachments;
3081:
3082: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3083: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

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

3084: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3085: 'Entered Copy_Attachments API');
3086: END IF;
3087:
3088: -- Standard call to check for call compatibility.
3089: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3090: p_api_version,
3091: l_api_name,
3092: G_PKG_NAME)

Line 3416: -- Standard check of p_commit.

3412: END IF;
3413:
3414: -- Api body ends here
3415:
3416: -- Standard check of p_commit.
3417: IF Fnd_Api.To_Boolean( p_commit ) THEN
3418: COMMIT;
3419: END IF;
3420:

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

3417: IF Fnd_Api.To_Boolean( p_commit ) THEN
3418: COMMIT;
3419: END IF;
3420:
3421: -- Standard call to get message count and if count is 1, get message info
3422: Fnd_Msg_Pub.Count_And_Get
3423: (p_count => x_msg_count,
3424: p_data => x_msg_data);
3425:

Line 3483: /* p_api_version Standard IN param */

3479: /* procedure name: Delete_Attachments */
3480: /* description : This procedure deletes all the attachements */
3481: /* linked with the repair line id. */
3482: /* */
3483: /* p_api_version Standard IN param */
3484: /* p_commit Standard IN param */
3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */

Line 3484: /* p_commit Standard IN param */

3480: /* description : This procedure deletes all the attachements */
3481: /* linked with the repair line id. */
3482: /* */
3483: /* p_api_version Standard IN param */
3484: /* p_commit Standard IN param */
3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */

Line 3485: /* p_init_msg_list Standard IN param */

3481: /* linked with the repair line id. */
3482: /* */
3483: /* p_api_version Standard IN param */
3484: /* p_commit Standard IN param */
3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */
3489: /* x_msg_count Standard OUT param */

Line 3486: /* p_validation_level Standard IN param */

3482: /* */
3483: /* p_api_version Standard IN param */
3484: /* p_commit Standard IN param */
3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */
3489: /* x_msg_count Standard OUT param */
3490: /* x_msg_data Standard OUT param */

Line 3488: /* x_return_status Standard OUT param */

3484: /* p_commit Standard IN param */
3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */
3489: /* x_msg_count Standard OUT param */
3490: /* x_msg_data Standard OUT param */
3491: /* */
3492: /*------------------------------------------------------------------*/

Line 3489: /* x_msg_count Standard OUT param */

3485: /* p_init_msg_list Standard IN param */
3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */
3489: /* x_msg_count Standard OUT param */
3490: /* x_msg_data Standard OUT param */
3491: /* */
3492: /*------------------------------------------------------------------*/
3493: PROCEDURE Delete_Attachments

Line 3490: /* x_msg_data Standard OUT param */

3486: /* p_validation_level Standard IN param */
3487: /* p_repair_line_id Repair Line Id */
3488: /* x_return_status Standard OUT param */
3489: /* x_msg_count Standard OUT param */
3490: /* x_msg_data Standard OUT param */
3491: /* */
3492: /*------------------------------------------------------------------*/
3493: PROCEDURE Delete_Attachments
3494: (p_api_version IN NUMBER,

Line 3513: -- Standard Start of API savepoint

3509: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
3510:
3511: BEGIN
3512:
3513: -- Standard Start of API savepoint
3514: SAVEPOINT Delete_Attachments;
3515:
3516: IF(Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level) THEN
3517: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

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

3518: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3519: 'Entered Delete_Attachments API');
3520: END IF;
3521:
3522: -- Standard call to check for call compatibility.
3523: IF NOT Fnd_Api.Compatible_API_Call (l_api_version,
3524: p_api_version,
3525: l_api_name,
3526: G_PKG_NAME)

Line 3685: -- Standard check of p_commit.

3681: WHERE fad.pk1_value = TO_CHAR(p_repair_line_id);
3682:
3683: -- Api body ends here
3684:
3685: -- Standard check of p_commit.
3686: IF Fnd_Api.To_Boolean( p_commit ) THEN
3687: COMMIT;
3688: END IF;
3689:

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

3686: IF Fnd_Api.To_Boolean( p_commit ) THEN
3687: COMMIT;
3688: END IF;
3689:
3690: -- Standard call to get message count and if count is 1, get message info
3691: Fnd_Msg_Pub.Count_And_Get
3692: (p_count => x_msg_count,
3693: p_data => x_msg_data);
3694:

Line 3816: --------------------Standard stuff -------------------------

3812: WHERE FLOW_STATUS_ID = p_repair_status_id;
3813:
3814:
3815: BEGIN
3816: --------------------Standard stuff -------------------------
3817: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
3818: Fnd_Log.STRING (Fnd_Log.level_procedure,
3819: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
3820: 'Entering update_ro_status private api');

Line 3941: -- Standard check of p_commit.

3937:
3938:
3939: -- Api body ends here
3940:
3941: -- Standard check of p_commit.
3942: IF Fnd_Api.to_boolean (p_commit) THEN
3943: COMMIT WORK;
3944: END IF;
3945:

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

3942: IF Fnd_Api.to_boolean (p_commit) THEN
3943: COMMIT WORK;
3944: END IF;
3945:
3946: -- Standard call to get message count and IF count is get message info.
3947: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3948:
3949: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
3950: Fnd_Log.STRING (Fnd_Log.level_procedure,

Line 4089: -- Standard Start of API savepoint

4085: WHERE repair_line_id = p_repair_line_id;
4086:
4087: BEGIN
4088:
4089: -- Standard Start of API savepoint
4090: SAVEPOINT Update_Flow_Status;
4091:
4092: -- Standard call to check for call compatibility.
4093: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

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

4088:
4089: -- Standard Start of API savepoint
4090: SAVEPOINT Update_Flow_Status;
4091:
4092: -- Standard call to check for call compatibility.
4093: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
4094: p_api_version,
4095: lc_api_name ,
4096: G_PKG_NAME )

Line 4505: -- Standard check of p_commit.

4501:
4502: -- Api body ends here
4503:
4504: --debug('update_flow_status: Step 13');
4505: -- Standard check of p_commit.
4506: IF Fnd_Api.To_Boolean( p_commit ) THEN
4507: COMMIT WORK;
4508: END IF;
4509: --debug('update_flow_status: Step 14');

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

4507: COMMIT WORK;
4508: END IF;
4509: --debug('update_flow_status: Step 14');
4510:
4511: -- Standard call to get message count and IF count is get message info.
4512: Fnd_Msg_Pub.Count_And_Get
4513: (p_count => x_msg_count,
4514: p_data => x_msg_data );
4515:

Line 4733: -- Standard Start of API savepoint

4729: CRTV1.REPAIR_TYPE_Id = p_to_repair_type_id;
4730:
4731: BEGIN
4732:
4733: -- Standard Start of API savepoint
4734: SAVEPOINT Update_Repair_Type;
4735:
4736: -- Standard call to check for call compatibility.
4737: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

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

4732:
4733: -- Standard Start of API savepoint
4734: SAVEPOINT Update_Repair_Type;
4735:
4736: -- Standard call to check for call compatibility.
4737: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
4738: p_api_version,
4739: lc_api_name ,
4740: G_PKG_NAME )

Line 5030: -- Standard check of p_commit.

5026: END IF;
5027:
5028: -- Api body ends here
5029:
5030: -- Standard check of p_commit.
5031: IF Fnd_Api.To_Boolean( p_commit ) THEN
5032: COMMIT WORK;
5033: END IF;
5034:

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

5031: IF Fnd_Api.To_Boolean( p_commit ) THEN
5032: COMMIT WORK;
5033: END IF;
5034:
5035: -- Standard call to get message count and IF count is get message info.
5036: Fnd_Msg_Pub.Count_And_Get
5037: (p_count => x_msg_count,
5038: p_data => x_msg_data );
5039:

Line 5229: -- Standard Start of API savepoint

5225: l_wf_avalue_TabType Wf_Engine.NumTabTyp;
5226:
5227: BEGIN
5228:
5229: -- Standard Start of API savepoint
5230: SAVEPOINT Launch_Flwsts_Wf;
5231:
5232: -- Standard call to check for call compatibility.
5233: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,

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

5228:
5229: -- Standard Start of API savepoint
5230: SAVEPOINT Launch_Flwsts_Wf;
5231:
5232: -- Standard call to check for call compatibility.
5233: IF NOT Fnd_Api.Compatible_API_Call (lc_api_version,
5234: p_api_version,
5235: lc_api_name,
5236: G_PKG_NAME)

Line 5397: -- Standard check of p_commit.

5393: Wf_Engine.threshold := l_wf_current_threshold;
5394:
5395: -- Api body ends here
5396:
5397: -- Standard check of p_commit.
5398: IF Fnd_Api.To_Boolean( p_commit ) THEN
5399: COMMIT WORK;
5400: END IF;
5401:

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

5398: IF Fnd_Api.To_Boolean( p_commit ) THEN
5399: COMMIT WORK;
5400: END IF;
5401:
5402: -- Standard call to get message count and IF count is get message info.
5403: Fnd_Msg_Pub.Count_And_Get
5404: (p_count => x_msg_count,
5405: p_data => x_msg_data );
5406:

Line 5537: -- Standard Start of API savepoint

5533: lc_api_name CONSTANT VARCHAR2(30) := 'update_ro_status_websrvc';
5534: lc_api_version CONSTANT NUMBER := 1.0;
5535:
5536: BEGIN
5537: -- Standard Start of API savepoint
5538: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
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: BEGIN
5537: -- Standard Start of API savepoint
5538: SAVEPOINT UPDATE_RO_STATUS_WEBSRVC_PVT;
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 5597: -- Standard check of p_commit.

5593: P_STATUS_CONTROL_REC => l_status_upd_control_rec,
5594: X_OBJECT_VERSION_NUMBER => l_object_Version_number);
5595: --
5596:
5597: -- Standard check of p_commit.
5598: IF Fnd_Api.To_Boolean( p_commit ) THEN
5599: COMMIT WORK;
5600: END IF;
5601:

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

5598: IF Fnd_Api.To_Boolean( p_commit ) THEN
5599: COMMIT WORK;
5600: END IF;
5601:
5602: -- Standard call to get message count and IF count is get message info.
5603: Fnd_Msg_Pub.Count_And_Get
5604: (p_count => x_msg_count,
5605: p_data => x_msg_data );
5606:

Line 5733: -- Standard check of p_commit.

5729: ( p_event_name => 'oracle.apps.csd.repair.status.change',
5730: p_event_key => l_event_key,
5731: p_parameters => l_param_list);
5732:
5733: -- Standard check of p_commit.
5734: If FND_API.To_Boolean( p_commit ) then
5735: commit;
5736: End if;
5737: