[Home] [Help]
23: /* Function name: DEBUG */
24: /* Description : Logs the debug message */
25: /* Called from : Called from Update API */
26: /* */
27: /* STANDARD PARAMETERS */
28: /* In Parameters : */
29: /* p_message Required Debug message that needs to be logged */
30: /* p_mod_name Required Module name */
31: /* p_severity_level Required Severity level */
29: /* p_message Required Debug message that needs to be logged */
30: /* p_mod_name Required Module name */
31: /* p_severity_level Required Severity level */
32: /* Output Parameters: */
33: /* NON-STANDARD PARAMETERS */
34: /* In Parameters */
35: /* Out parameters */
36: /* Change Hist : */
37: /* 09/20/03 vlakaman Initial Creation. */
174: FROM hz_party_sites
175: WHERE party_site_id = p_party_site_id;
176:
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT process_service_request;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT process_service_request;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
183: p_api_version,
184: l_api_name,
185: G_PKG_NAME)
361: END IF;
362:
363: -- Api body ends here
364:
365: -- Standard check of p_commit.
366: IF Fnd_Api.To_Boolean(p_commit)
367: THEN
368: COMMIT WORK;
369: END IF;
367: THEN
368: COMMIT WORK;
369: END IF;
370:
371: -- Standard call to get message count and IF count is get message info.
372: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
373: p_data => x_msg_data);
374: EXCEPTION
375: WHEN Fnd_Api.G_EXC_ERROR THEN
429:
430: BEGIN
431: Debug('At the Beginning of process_charge_lines', l_mod_name, 1);
432:
433: -- Standard Start of API savepoint
434: SAVEPOINT process_charge_lines;
435:
436: -- Standard call to check for call compatibility.
437: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
432:
433: -- Standard Start of API savepoint
434: SAVEPOINT process_charge_lines;
435:
436: -- Standard call to check for call compatibility.
437: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
438: p_api_version,
439: l_api_name,
440: G_PKG_NAME)
668: END IF;
669:
670: -- Api body ends here
671:
672: -- Standard check of p_commit.
673: IF Fnd_Api.To_Boolean(p_commit)
674: THEN
675: COMMIT WORK;
676: END IF;
674: THEN
675: COMMIT WORK;
676: END IF;
677:
678: -- Standard call to get message count and IF count is get message info.
679: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
680: p_data => x_msg_data);
681: EXCEPTION
682: WHEN Fnd_Api.G_EXC_ERROR THEN
721: l_msg_data VARCHAR2(2000);
722: l_msg_index NUMBER;
723:
724: BEGIN
725: -- Standard Start of API savepoint
726: SAVEPOINT apply_contract;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
724: BEGIN
725: -- Standard Start of API savepoint
726: SAVEPOINT apply_contract;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
730: p_api_version,
731: l_api_name,
732: G_PKG_NAME)
772: -- (p_incident_id => p_incident_id ) ;
773:
774: -- Api body ends here
775:
776: -- Standard check of p_commit.
777: IF Fnd_Api.To_Boolean(p_commit)
778: THEN
779: COMMIT WORK;
780: END IF;
778: THEN
779: COMMIT WORK;
780: END IF;
781:
782: -- Standard call to get message count and IF count is get message info.
783: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
784: p_data => x_msg_data);
785: EXCEPTION
786: WHEN Fnd_Api.G_EXC_ERROR THEN
908: AND wdd.inventory_item_id = mtl.inventory_item_id
909: AND wdd.ship_from_location_id = mtl.organization_id;
910:
911: BEGIN
912: -- Standard Start of API savepoint
913: SAVEPOINT ship_sales_order;
914:
915: -- Standard call to check for call compatibility.
916: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
911: BEGIN
912: -- Standard Start of API savepoint
913: SAVEPOINT ship_sales_order;
914:
915: -- Standard call to check for call compatibility.
916: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
917: p_api_version,
918: l_api_name,
919: G_PKG_NAME)
1164: END; -- end of delivery action
1165:
1166: -- Api body ends here
1167:
1168: -- Standard check of p_commit.
1169: IF Fnd_Api.To_Boolean(p_commit)
1170: THEN
1171: COMMIT WORK;
1172: END IF;
1170: THEN
1171: COMMIT WORK;
1172: END IF;
1173:
1174: -- Standard call to get message count and IF count is get message info.
1175: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1176: p_data => x_msg_data);
1177:
1178: EXCEPTION
1412: BEGIN
1413: -- Debug message
1414: Debug('At the Beginning of process_sales_order', l_mod_name, 1);
1415:
1416: -- Standard Start of API savepoint
1417: SAVEPOINT process_sales_order;
1418:
1419: -- Standard call to check for call compatibility.
1420: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1415:
1416: -- Standard Start of API savepoint
1417: SAVEPOINT process_sales_order;
1418:
1419: -- Standard call to check for call compatibility.
1420: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1421: p_api_version,
1422: l_api_name,
1423: G_PKG_NAME)
1769: END IF;
1770: Debug('Batch created batch_id=['||l_batch_id||']',l_mod_name,1);
1771:
1772: wsh_picking_batches_pub.Release_Batch (
1773: -- Standard parameters
1774: p_api_version => 1.0,
1775: p_init_msg_list => Fnd_API.G_False,
1776: p_commit => Fnd_API.G_False,
1777: x_return_status => x_Return_Status,
2274: END IF; -- end of all actions
2275:
2276: -- Api body ends here
2277:
2278: -- Standard check of p_commit.
2279: IF Fnd_Api.To_Boolean(p_commit)
2280: THEN
2281: COMMIT WORK;
2282: END IF;
2280: THEN
2281: COMMIT WORK;
2282: END IF;
2283:
2284: -- Standard call to get message count and IF count is get message info.
2285: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2286: p_data => x_msg_data);
2287:
2288: EXCEPTION
2473: BEGIN
2474: -- Debug message
2475: Debug('At the Beginning of create_product_txn', l_mod_name, 1);
2476:
2477: -- Standard Start of API savepoint
2478: SAVEPOINT create_product_txn;
2479:
2480: -- Initialize API return status to success
2481: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2479:
2480: -- Initialize API return status to success
2481: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2482:
2483: -- Standard call to check for call compatibility.
2484: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2485: p_api_version,
2486: l_api_name,
2487: G_PKG_NAME)
4002: END IF; --end of all process
4003:
4004: -- Api body ends here
4005:
4006: -- Standard check of p_commit.
4007: IF Fnd_Api.To_Boolean(p_commit)
4008: THEN
4009: COMMIT WORK;
4010: END IF;
4008: THEN
4009: COMMIT WORK;
4010: END IF;
4011:
4012: -- Standard call to get message count and IF count is get message info.
4013: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4014: p_data => x_msg_data);
4015: EXCEPTION
4016: WHEN CREATE_ORDER THEN
4176: AND order_line_id IS NULL
4177: AND line_category_code = 'ORDER';
4178:
4179: BEGIN
4180: -- Standard Start of API savepoint
4181: SAVEPOINT create_product_txn;
4182:
4183: -- Standard call to check for call compatibility.
4184: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
4179: BEGIN
4180: -- Standard Start of API savepoint
4181: SAVEPOINT create_product_txn;
4182:
4183: -- Standard call to check for call compatibility.
4184: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
4185: p_api_version,
4186: l_api_name,
4187: G_PKG_NAME)
4613: END IF;
4614:
4615: -- Api body ends here
4616:
4617: -- Standard check of p_commit.
4618: IF Fnd_Api.To_Boolean(p_commit)
4619: THEN
4620: COMMIT WORK;
4621: END IF;
4619: THEN
4620: COMMIT WORK;
4621: END IF;
4622:
4623: -- Standard call to get message count and IF count is get message info.
4624: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4625: p_data => x_msg_data);
4626: EXCEPTION
4627: WHEN Fnd_Api.G_EXC_ERROR THEN
4906: END IF; --end of process txn
4907:
4908: -- Api body ends here
4909:
4910: -- Standard check of p_commit.
4911: IF Fnd_Api.To_Boolean(p_commit)
4912: THEN
4913: COMMIT WORK;
4914: END IF;
4912: THEN
4913: COMMIT WORK;
4914: END IF;
4915:
4916: -- Standard call to get message count and IF count is get message info.
4917: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4918: p_data => x_msg_data);
4919: EXCEPTION
4920: WHEN CREATE_ORDER THEN
5055: l_est_detail_id NUMBER;
5056: l_delete_allow VARCHAR2(1);
5057:
5058: BEGIN
5059: -- Standard Start of API savepoint
5060: SAVEPOINT delete_product_txn;
5061:
5062: -- Standard call to check for call compatibility.
5063: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5058: BEGIN
5059: -- Standard Start of API savepoint
5060: SAVEPOINT delete_product_txn;
5061:
5062: -- Standard call to check for call compatibility.
5063: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5064: p_api_version,
5065: l_api_name,
5066: G_PKG_NAME)
5177: END IF; --end of delete
5178:
5179: -- Api body ends here
5180:
5181: -- Standard check of p_commit.
5182: IF Fnd_Api.To_Boolean(p_commit)
5183: THEN
5184: COMMIT WORK;
5185: END IF;
5183: THEN
5184: COMMIT WORK;
5185: END IF;
5186:
5187: -- Standard call to get message count and IF count is get message info.
5188: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5189: p_data => x_msg_data);
5190: EXCEPTION
5191: WHEN Fnd_Api.G_EXC_ERROR THEN
5245: l_add_ship_to_id NUMBER;
5246:
5247:
5248: BEGIN
5249: -- Standard Start of API savepoint
5250: SAVEPOINT create_default_prod_txn;
5251:
5252: --
5253: -- MOAC initialization
5253: -- MOAC initialization
5254: --
5255: MO_GLOBAL.init('CS_CHARGES');
5256:
5257: -- Standard call to check for call compatibility.
5258: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5259: p_api_version,
5260: l_api_name,
5261: G_PKG_NAME)
5435: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);
5436: Fnd_Msg_Pub.ADD;
5437: END IF;
5438:
5439: -- Standard check of p_commit.
5440: IF Fnd_Api.To_Boolean(p_commit)
5441: THEN
5442: COMMIT WORK;
5443: END IF;
5441: THEN
5442: COMMIT WORK;
5443: END IF;
5444:
5445: -- Standard call to get message count and IF count is get message info.
5446: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5447: p_data => x_msg_data);
5448:
5449: EXCEPTION
5604: BEGIN
5605: -- -----------------
5606: -- Begin create task
5607: -- -----------------
5608: -- Standard Start of API savepoint
5609: SAVEPOINT create_task;
5610: -- Standard call to check for call compatibility.
5611: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5612: p_api_version,
5606: -- Begin create task
5607: -- -----------------
5608: -- Standard Start of API savepoint
5609: SAVEPOINT create_task;
5610: -- Standard call to check for call compatibility.
5611: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5612: p_api_version,
5613: l_api_name,
5614: G_PKG_NAME)
5701:
5702: -- -------------------
5703: -- Api body ends here
5704: -- -------------------
5705: -- Standard check of p_commit.
5706: IF Fnd_Api.To_Boolean(p_commit)
5707: THEN
5708: COMMIT WORK;
5709: END IF;
5706: IF Fnd_Api.To_Boolean(p_commit)
5707: THEN
5708: COMMIT WORK;
5709: END IF;
5710: -- Standard call to get message count and IF count is get message info.
5711: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5712: p_data => x_msg_data);
5713: EXCEPTION
5714: WHEN Fnd_Api.G_EXC_ERROR THEN
5773: BEGIN
5774: -- -----------------
5775: -- Begin update task
5776: -- -----------------
5777: -- Standard Start of API savepoint
5778: SAVEPOINT update_task;
5779: -- Standard call to check for call compatibility.
5780: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5781: p_api_version,
5775: -- Begin update task
5776: -- -----------------
5777: -- Standard Start of API savepoint
5778: SAVEPOINT update_task;
5779: -- Standard call to check for call compatibility.
5780: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
5781: p_api_version,
5782: l_api_name,
5783: G_PKG_NAME)
5871:
5872: -- -------------------
5873: -- Api body ends here
5874: -- -------------------
5875: -- Standard check of p_commit.
5876: IF Fnd_Api.To_Boolean(p_commit)
5877: THEN
5878: COMMIT WORK;
5879: END IF;
5876: IF Fnd_Api.To_Boolean(p_commit)
5877: THEN
5878: COMMIT WORK;
5879: END IF;
5880: -- Standard call to get message count and IF count is get message info.
5881: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5882: p_data => x_msg_data);
5883: EXCEPTION
5884: WHEN Fnd_Api.G_EXC_ERROR THEN
6139: -- History : assignee_id --> assigned_by_id
6140: -- assignee_type --> null
6141: -- assignee_name --> null
6142:
6143: -- Standard Start of API savepoint
6144: SAVEPOINT Create_repair_task_hist;
6145: -- Standard call to check for call compatibility.
6146: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6147: p_api_version,
6141: -- assignee_name --> null
6142:
6143: -- Standard Start of API savepoint
6144: SAVEPOINT Create_repair_task_hist;
6145: -- Standard call to check for call compatibility.
6146: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6147: p_api_version,
6148: l_api_name,
6149: G_PKG_NAME)
6248:
6249: -- -------------------
6250: -- Api body ends here
6251: -- -------------------
6252: -- Standard check of p_commit.
6253: IF Fnd_Api.To_Boolean(p_commit)
6254: THEN
6255: COMMIT WORK;
6256: END IF;
6254: THEN
6255: COMMIT WORK;
6256: END IF;
6257:
6258: -- Standard call to get message count and IF count is get message info.
6259: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6260: p_data => x_msg_data);
6261: END IF;
6262: EXCEPTION
6458: IF (l_event_code IN ('TOC', 'TSC')) THEN
6459: -- --------------------------------
6460: -- Begin create repair task history
6461: -- --------------------------------
6462: -- Standard Start of API savepoint
6463: SAVEPOINT Update_repair_task_hist;
6464: -- Standard call to check for call compatibility.
6465: IF NOT FND_API.Compatible_API_Call (l_api_version,
6466: p_api_version,
6460: -- Begin create repair task history
6461: -- --------------------------------
6462: -- Standard Start of API savepoint
6463: SAVEPOINT Update_repair_task_hist;
6464: -- Standard call to check for call compatibility.
6465: IF NOT FND_API.Compatible_API_Call (l_api_version,
6466: p_api_version,
6467: l_api_name ,
6468: G_PKG_NAME )
6566:
6567: -- -------------------
6568: -- Api body ends here
6569: -- -------------------
6570: -- Standard check of p_commit.
6571: IF FND_API.To_Boolean( p_commit ) THEN
6572: COMMIT WORK;
6573: END IF;
6574: -- Standard call to get message count and IF count is get message info.
6570: -- Standard check of p_commit.
6571: IF FND_API.To_Boolean( p_commit ) THEN
6572: COMMIT WORK;
6573: END IF;
6574: -- Standard call to get message count and IF count is get message info.
6575: FND_MSG_PUB.Count_And_Get
6576: (p_count => x_msg_count,
6577: p_data => x_msg_data );
6578: END IF;
6744: -- --------------------------------
6745: -- Begin create repair task history
6746: -- --------------------------------
6747:
6748: -- Standard Start of API savepoint
6749: SAVEPOINT Create_repair_task_hist;
6750: -- Standard call to check for call compatibility.
6751: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6752: p_api_version,
6746: -- --------------------------------
6747:
6748: -- Standard Start of API savepoint
6749: SAVEPOINT Create_repair_task_hist;
6750: -- Standard call to check for call compatibility.
6751: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6752: p_api_version,
6753: l_api_name,
6754: G_PKG_NAME)
6853:
6854: -- -------------------
6855: -- Api body ends here
6856: -- -------------------
6857: -- Standard check of p_commit.
6858: IF Fnd_Api.To_Boolean(p_commit)
6859: THEN
6860: COMMIT WORK;
6861: END IF;
6859: THEN
6860: COMMIT WORK;
6861: END IF;
6862:
6863: -- Standard call to get message count and IF count is get message info.
6864: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6865: p_data => x_msg_data);
6866: END IF;
6867: EXCEPTION
6978: BEGIN
6979: -- --------------------------------
6980: -- Begin create repair task history
6981: -- --------------------------------
6982: -- Standard Start of API savepoint
6983: SAVEPOINT Update_repair_task_hist;
6984: -- Standard call to check for call compatibility.
6985: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6986: p_api_version,
6980: -- Begin create repair task history
6981: -- --------------------------------
6982: -- Standard Start of API savepoint
6983: SAVEPOINT Update_repair_task_hist;
6984: -- Standard call to check for call compatibility.
6985: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6986: p_api_version,
6987: l_api_name,
6988: G_PKG_NAME)
7273:
7274: -- -------------------
7275: -- Api body ends here
7276: -- -------------------
7277: -- Standard check of p_commit.
7278: IF Fnd_Api.To_Boolean(p_commit)
7279: THEN
7280: COMMIT WORK;
7281: END IF;
7278: IF Fnd_Api.To_Boolean(p_commit)
7279: THEN
7280: COMMIT WORK;
7281: END IF;
7282: -- Standard call to get message count and IF count is get message info.
7283: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7284: p_data => x_msg_data);
7285: --END IF;
7286: -- ---------------------------------------------------------
7363: WHERE repair_group_id = p_repair_group_id;
7364:
7365: BEGIN
7366: --------------------------------------
7367: -- Standard Start of API savepoint
7368: --------------------------------------
7369: SAVEPOINT Close_Status;
7370:
7371: -- Standard call to check for call compatibility.
7367: -- Standard Start of API savepoint
7368: --------------------------------------
7369: SAVEPOINT Close_Status;
7370:
7371: -- Standard call to check for call compatibility.
7372: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7373: p_api_version,
7374: l_api_name,
7375: G_PKG_NAME)
8157: /* procedure name: Update_iro_product_txn */
8158: /* Description: procedure used to update the product transaction */
8159: /* table and process pick release and shipping */
8160: /* transactions for internal ROs. */
8161: /* p_api_version Standard in parameter */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8158: /* Description: procedure used to update the product transaction */
8159: /* table and process pick release and shipping */
8160: /* transactions for internal ROs. */
8161: /* p_api_version Standard in parameter */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8159: /* table and process pick release and shipping */
8160: /* transactions for internal ROs. */
8161: /* p_api_version Standard in parameter */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8160: /* transactions for internal ROs. */
8161: /* p_api_version Standard in parameter */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8168: /* x_product_txn_rec in out record variable of type */
8161: /* p_api_version Standard in parameter */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8168: /* x_product_txn_rec in out record variable of type */
8169: /* csd_process_pvt.product_txn_rec ) ; */
8162: /* p_commit Standard in parameter */
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8168: /* x_product_txn_rec in out record variable of type */
8169: /* csd_process_pvt.product_txn_rec ) ; */
8170: /*---------------------------------------------------------------------------------*/
8163: /* p_init_msg_list Standard in parameter */
8164: /* p_validation_level Standard in parameter */
8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8168: /* x_product_txn_rec in out record variable of type */
8169: /* csd_process_pvt.product_txn_rec ) ; */
8170: /*---------------------------------------------------------------------------------*/
8171: PROCEDURE update_iro_product_txn(p_api_version IN NUMBER,
8300: IF l_statement_level >= l_debug_level
8301: THEN
8302: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
8303: END IF;
8304: -- standard start of api savepoint
8305: SAVEPOINT update_iro_product_txn;
8306: IF l_statement_level >= l_debug_level
8307: THEN
8308: Fnd_Log.string(l_statement_level,
8308: Fnd_Log.string(l_statement_level,
8309: l_module_name,
8310: 'checking api compatibility');
8311: END IF;
8312: -- standard call to check for call compatibility.
8313: IF NOT Fnd_Api.compatible_api_call(l_api_version,
8314: p_api_version,
8315: l_api_name,
8316: g_pkg_name)
9053: END IF; -- if l_order_to_be_shipped
9054: END IF; -- end of ship sales order
9055: END IF; --end of process txn
9056: END IF; -- Action Type = MOVE_OUt
9057: -- standard check of p_commit.
9058: IF Fnd_Api.to_boolean(p_commit)
9059: THEN
9060: COMMIT WORK;
9061: END IF;
9064: -- Set return status to unexpected error
9065: x_return_status := Fnd_Api.g_ret_sts_success;
9066: -- If there is any error then rollback
9067: ROLLBACK TO release_sales_order;
9068: -- Standard procedure to get error message count and error message is also returned
9069: -- if error message count is 1
9070: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
9071: p_data => x_msg_data);
9072: WHEN ship_order_excep THEN
9073: -- Set return status to unexpected error
9074: x_return_status := Fnd_Api.g_ret_sts_success;
9075: -- If there is any error then rollback
9076: ROLLBACK TO ship_sales_order;
9077: -- Standard procedure to get error message count and error message is also returned
9078: -- if error message count is 1
9079: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
9080: p_data => x_msg_data);
9081: WHEN Fnd_Api.g_exc_error THEN
9082: -- Set return status to unexpected error
9083: x_return_status := Fnd_Api.g_ret_sts_error;
9084: -- If there is any error then rollback
9085: ROLLBACK TO update_iro_product_txn;
9086: -- Standard procedure to get error message count and error message is also returned
9087: -- if error message count is 1
9088: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
9089: p_data => x_msg_data);
9090: WHEN Fnd_Api.g_exc_unexpected_error THEN
9091: -- Set return status to unexpected error
9092: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
9093: -- If there is any error then rollback
9094: ROLLBACK TO update_iro_product_txn;
9095: -- Standard procedure to get error message count and error message is also returned
9096: -- if error message count is 1
9097: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
9098: p_data => x_msg_data);
9099: WHEN OTHERS THEN
9102: -- If there is any error then rollback
9103: ROLLBACK TO update_iro_product_txn;
9104: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
9105: THEN
9106: -- Standard way to add sql error message to stack
9107: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
9108: END IF;
9109: -- Standard procedure to get error message count and error message is also returned
9110: -- if error message count is 1
9105: THEN
9106: -- Standard way to add sql error message to stack
9107: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
9108: END IF;
9109: -- Standard procedure to get error message count and error message is also returned
9110: -- if error message count is 1
9111: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
9112: p_data => x_msg_data);
9113: END update_iro_product_txn;
9148: l_Service_Valdn_Org_Name VARCHAR2(240);
9149: l_Item_Name VARCHAR2(240);
9150: -- Define Constants here
9151: C_RO_Status_Open VARCHAR2(30) := 'O';
9152: C_Repair_Type_Ref_Standard VARCHAR2(10) := 'SR';
9153:
9154: i BINARY_INTEGER; -- loop variable
9155:
9156: -- Define Cursor to get all product transaction lines rec information for a repair order
9162: FROM csd_product_Transactions cpt, cs_estimate_Details ced
9163: WHERE cpt.repair_line_id = p_Repair_Line_Id
9164: AND cpt.estimate_detail_id = ced.estimate_detail_id;
9165: BEGIN
9166: -- Standard call to check for call compatibility.
9167: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
9168: p_api_version,
9169: l_api_name,
9170: G_PKG_NAME)
9237: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9238: Fnd_Msg_Pub.ADD;
9239: RAISE Fnd_Api.G_EXC_ERROR;
9240: END IF;
9241: -- Check if repair Type Ref is Standard
9242: IF l_RO_Repair_Type_Ref = C_Repair_TYpe_Ref_Standard
9243: THEN
9244: -- Display message: Default product transaction lines are not created for standard repair type ref
9245: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9238: Fnd_Msg_Pub.ADD;
9239: RAISE Fnd_Api.G_EXC_ERROR;
9240: END IF;
9241: -- Check if repair Type Ref is Standard
9242: IF l_RO_Repair_Type_Ref = C_Repair_TYpe_Ref_Standard
9243: THEN
9244: -- Display message: Default product transaction lines are not created for standard repair type ref
9245: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9246: Fnd_Message.SET_NAME('CSD',
9240: END IF;
9241: -- Check if repair Type Ref is Standard
9242: IF l_RO_Repair_Type_Ref = C_Repair_TYpe_Ref_Standard
9243: THEN
9244: -- Display message: Default product transaction lines are not created for standard repair type ref
9245: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9246: Fnd_Message.SET_NAME('CSD',
9247: 'CSD_STD_REPTYPE_NO_PRODTXN_LNS');
9248: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9439: -- -----------------
9440: -- Begin create repair task
9441: -- -----------------
9442:
9443: -- Standard Start of API savepoint
9444: IF l_statement_level >= l_debug_level
9445: THEN
9446: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9447: END IF;
9446: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9447: END IF;
9448: SAVEPOINT create_repair_task;
9449:
9450: -- Standard call to check for call compatibility.
9451: IF l_statement_level >= l_debug_level
9452: THEN
9453: Fnd_Log.string(l_statement_level,
9454: l_module_name,
9555:
9556: -- -------------------
9557: -- Api body ends here
9558: -- -------------------
9559: -- Standard check of p_commit.
9560: IF Fnd_Api.To_Boolean(p_commit)
9561: THEN
9562: COMMIT WORK;
9563: END IF;
9560: IF Fnd_Api.To_Boolean(p_commit)
9561: THEN
9562: COMMIT WORK;
9563: END IF;
9564: -- Standard call to get message count and IF count is get message info.
9565: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
9566: p_data => x_msg_data);
9567: EXCEPTION
9568: WHEN Fnd_Api.G_EXC_ERROR THEN
9649: -- -----------------
9650: -- Begin update repair task
9651: -- -----------------
9652:
9653: -- Standard Start of API savepoint
9654: IF l_statement_level >= l_debug_level
9655: THEN
9656: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9657: END IF;
9656: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9657: END IF;
9658: SAVEPOINT update_repair_task;
9659:
9660: -- Standard call to check for call compatibility.
9661: IF l_statement_level >= l_debug_level
9662: THEN
9663: Fnd_Log.string(l_statement_level,
9664: l_module_name,
9772:
9773: -- -------------------
9774: -- Api body ends here
9775: -- -------------------
9776: -- Standard check of p_commit.
9777: IF Fnd_Api.To_Boolean(p_commit)
9778: THEN
9779: COMMIT WORK;
9780: END IF;
9777: IF Fnd_Api.To_Boolean(p_commit)
9778: THEN
9779: COMMIT WORK;
9780: END IF;
9781: -- Standard call to get message count and IF count is get message info.
9782: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
9783: p_data => x_msg_data);
9784: EXCEPTION
9785: WHEN Fnd_Api.G_EXC_ERROR THEN