eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PROCESS_PVT dependencies on CSD_GEN_UTILITY_PVT

Line 10: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;

6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvintb.pls';
10: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
11:
12: /* R12 Srl reservation changes, begin */
13: C_RESERVABLE CONSTANT NUMBER := 1;
14: C_SERIAL_CONTROL_AT_RECEIPT CONSTANT NUMBER := 5;

Line 92: Csd_Gen_Utility_Pvt.add(p_message);

88: Fnd_Log.STRING(l_unexp_level, p_mod_name, p_message);
89: END IF;
90: END IF;
91:
92: Csd_Gen_Utility_Pvt.add(p_message);
93:
94: END DEBUG;
95: /*--------------------------------------------------*/
96: /* procedure name: process_service_request */

Line 201: Csd_Gen_Utility_Pvt.ADD('dump_sr_rec');

197: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
198:
199: IF (g_debug > 5)
200: THEN
201: Csd_Gen_Utility_Pvt.ADD('dump_sr_rec');
202: Csd_Gen_Utility_Pvt.dump_sr_rec(p_sr_rec => p_service_request_rec);
203: END IF;
204:
205: -- Assign the SR rec values

Line 202: Csd_Gen_Utility_Pvt.dump_sr_rec(p_sr_rec => p_service_request_rec);

198:
199: IF (g_debug > 5)
200: THEN
201: Csd_Gen_Utility_Pvt.ADD('dump_sr_rec');
202: Csd_Gen_Utility_Pvt.dump_sr_rec(p_sr_rec => p_service_request_rec);
203: END IF;
204:
205: -- Assign the SR rec values
206: Cs_Servicerequest_Pub.initialize_rec(r_service_request_rec);

Line 288: Csd_Gen_Utility_Pvt.ADD('GETTING BILL-TO FIELDS');

284: t_contacts_table(1).contact_point_type := p_service_request_rec.contact_point_type;
285: t_contacts_table(1).primary_flag := p_service_request_rec.primary_flag;
286: END IF;
287:
288: Csd_Gen_Utility_Pvt.ADD('GETTING BILL-TO FIELDS');
289: -- Bill-To fields
290: IF (NVL(p_service_request_rec.bill_to_site_use_id,
291: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM)
292: THEN

Line 297: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.bill_to_site_id ' ||

293: OPEN c_party_site_id(p_service_request_rec.bill_to_site_use_id);
294: FETCH c_party_site_id
295: INTO r_service_request_rec.bill_to_site_id;
296: CLOSE c_party_site_id;
297: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.bill_to_site_id ' ||
298: r_service_request_rec.bill_to_site_id);
299: IF (NVL(r_service_request_rec.bill_to_site_id,
300: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM)
301: THEN

Line 306: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.bill_to_party_id ' ||

302: OPEN c_party_id(r_service_request_rec.bill_to_site_id);
303: FETCH c_party_id
304: INTO r_service_request_rec.bill_to_party_id;
305: CLOSE c_party_id;
306: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.bill_to_party_id ' ||
307: r_service_request_rec.bill_to_party_id);
308: END IF;
309: END IF;
310:

Line 312: Csd_Gen_Utility_Pvt.ADD('GETTING SHIP-TO FIELDS');

308: END IF;
309: END IF;
310:
311: -- Ship-To fields
312: Csd_Gen_Utility_Pvt.ADD('GETTING SHIP-TO FIELDS');
313: IF (NVL(p_service_request_rec.ship_to_site_use_id,
314: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM)
315: THEN
316: OPEN c_party_site_id(p_service_request_rec.ship_to_site_use_id);

Line 320: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.ship_to_site_id ' ||

316: OPEN c_party_site_id(p_service_request_rec.ship_to_site_use_id);
317: FETCH c_party_site_id
318: INTO r_service_request_rec.ship_to_site_id;
319: CLOSE c_party_site_id;
320: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.ship_to_site_id ' ||
321: r_service_request_rec.ship_to_site_id);
322: IF (NVL(r_service_request_rec.ship_to_site_id,
323: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM)
324: THEN

Line 329: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.ship_to_party_id ' ||

325: OPEN c_party_id(r_service_request_rec.ship_to_site_id);
326: FETCH c_party_id
327: INTO r_service_request_rec.ship_to_party_id;
328: CLOSE c_party_id;
329: Csd_Gen_Utility_Pvt.ADD('r_service_request_rec.ship_to_party_id ' ||
330: r_service_request_rec.ship_to_party_id);
331: END IF;
332: END IF;
333:

Line 749: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

745:
746: -- Api body starts
747: IF (g_debug > 0)
748: THEN
749: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
750: p_api_name => l_api_name);
751: END IF;
752:
753: IF (g_debug > 0)

Line 755: Csd_Gen_Utility_Pvt.ADD('Validate the incident id');

751: END IF;
752:
753: IF (g_debug > 0)
754: THEN
755: Csd_Gen_Utility_Pvt.ADD('Validate the incident id');
756: Csd_Gen_Utility_Pvt.ADD('p_incident_id =' || p_incident_id);
757: END IF;
758:
759: IF NOT (Csd_Process_Util.VALIDATE_INCIDENT_ID(p_incident_id))

Line 756: Csd_Gen_Utility_Pvt.ADD('p_incident_id =' || p_incident_id);

752:
753: IF (g_debug > 0)
754: THEN
755: Csd_Gen_Utility_Pvt.ADD('Validate the incident id');
756: Csd_Gen_Utility_Pvt.ADD('p_incident_id =' || p_incident_id);
757: END IF;
758:
759: IF NOT (Csd_Process_Util.VALIDATE_INCIDENT_ID(p_incident_id))
760: THEN

Line 766: Csd_Gen_Utility_Pvt.ADD('Applying contract on charge lines');

762: END IF;
763:
764: IF (g_debug > 0)
765: THEN
766: Csd_Gen_Utility_Pvt.ADD('Applying contract on charge lines');
767: END IF;
768:
769: -- Commented
770: -- signature change to be discussed.

Line 940: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

936: -- fnd_global.apps_initialize(1000200,52284,512,0);
937:
938: IF (g_debug > 0)
939: THEN
940: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
941: p_api_name => l_api_name);
942: END IF;
943: -- If action is SHIP, then call shipping api to
944: -- ship the sales order

Line 947: Csd_Gen_Utility_Pvt.ADD('Shipping the Sales Order');

943: -- If action is SHIP, then call shipping api to
944: -- ship the sales order
945: IF (g_debug > 0)
946: THEN
947: Csd_Gen_Utility_Pvt.ADD('Shipping the Sales Order');
948: Csd_Gen_Utility_Pvt.ADD('p_delivery_id =' || p_delivery_id);
949: END IF;
950:
951: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM

Line 948: Csd_Gen_Utility_Pvt.ADD('p_delivery_id =' || p_delivery_id);

944: -- ship the sales order
945: IF (g_debug > 0)
946: THEN
947: Csd_Gen_Utility_Pvt.ADD('Shipping the Sales Order');
948: Csd_Gen_Utility_Pvt.ADD('p_delivery_id =' || p_delivery_id);
949: END IF;
950:
951: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
952: THEN

Line 958: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');

954: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
955: Fnd_Msg_Pub.ADD;
956: IF (g_debug > 0)
957: THEN
958: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
959: END IF;
960: RAISE Fnd_Api.G_EXC_ERROR;
961: ELSE
962:

Line 975: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');

971: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
972: Fnd_Msg_Pub.ADD;
973: IF (g_debug > 0)
974: THEN
975: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
976: END IF;
977: RAISE Fnd_Api.G_EXC_ERROR;
978: END;
979: END IF;

Line 1000: Csd_Gen_Utility_Pvt.ADD('delivery_detail_id =' ||

996: changed_attributes(1).serial_number := i.serial_number;
997: changed_attributes(1).shipped_quantity := i.requested_quantity;
998: IF (g_debug > 0)
999: THEN
1000: Csd_Gen_Utility_Pvt.ADD('delivery_detail_id =' ||
1001: changed_attributes(1)
1002: .delivery_detail_id);
1003: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
1004: changed_attributes(1)

Line 1003: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||

999: THEN
1000: Csd_Gen_Utility_Pvt.ADD('delivery_detail_id =' ||
1001: changed_attributes(1)
1002: .delivery_detail_id);
1003: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
1004: changed_attributes(1)
1005: .serial_number);
1006: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
1007: changed_attributes(1)

Line 1006: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||

1002: .delivery_detail_id);
1003: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
1004: changed_attributes(1)
1005: .serial_number);
1006: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
1007: changed_attributes(1)
1008: .shipped_quantity);
1009: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
1010: END IF;

Line 1009: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');

1005: .serial_number);
1006: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
1007: changed_attributes(1)
1008: .shipped_quantity);
1009: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
1010: END IF;
1011: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1012: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1013: p_init_msg_list => p_init_msg_list,

Line 1022: Csd_Gen_Utility_Pvt.ADD('x_return_status(Update_Shipping_Attributes )=' ||

1018: p_changed_attributes => changed_attributes,
1019: p_source_code => source_code);
1020: IF (g_debug > 0)
1021: THEN
1022: Csd_Gen_Utility_Pvt.ADD('x_return_status(Update_Shipping_Attributes )=' ||
1023: x_return_status);
1024: END IF;
1025: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
1026: THEN

Line 1029: Csd_Gen_Utility_Pvt.ADD('Update_Shipping_Attributes failed');

1025: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
1026: THEN
1027: IF (g_debug > 0)
1028: THEN
1029: Csd_Gen_Utility_Pvt.ADD('Update_Shipping_Attributes failed');
1030: END IF;
1031: RAISE fail_api;
1032: END IF;
1033: EXCEPTION

Line 1047: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');

1043: x_msg_data := x_msg_summary;
1044: END IF;
1045: IF (g_debug > 0)
1046: THEN
1047: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1048: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1049: x_msg_data);
1050: END IF;
1051: Fnd_Message.SET_NAME('CSD',

Line 1048: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||

1044: END IF;
1045: IF (g_debug > 0)
1046: THEN
1047: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1048: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1049: x_msg_data);
1050: END IF;
1051: Fnd_Message.SET_NAME('CSD',
1052: 'CSD_UPDATE_SHIPPING_FAILED');

Line 1066: Csd_Gen_Utility_Pvt.ADD('p_delivery_id=' || p_delivery_id);

1062: BEGIN
1063:
1064: IF (g_debug > 0)
1065: THEN
1066: Csd_Gen_Utility_Pvt.ADD('p_delivery_id=' || p_delivery_id);
1067: END IF;
1068:
1069: -- Values for Ship Confirming the delivery.
1070: p_action_code := 'CONFIRM'; -- The action code for ship confirm

Line 1085: Csd_Gen_Utility_Pvt.ADD('Calling Delivery_Action ');

1081: -- p_sc_report_set_id := 6; -- check if it is seeded
1082:
1083: IF (g_debug > 0)
1084: THEN
1085: Csd_Gen_Utility_Pvt.ADD('Calling Delivery_Action ');
1086: END IF;
1087:
1088: -- Call to WSH_DELIVERIES_PUB.Delivery_Action.
1089: Wsh_Deliveries_Pub.Delivery_Action(p_api_version_number => 1.0,

Line 1125: Csd_Gen_Utility_Pvt.ADD('x_return_status(Delivery_Action )=' ||

1121: x_trip_name => x_trip_name);
1122:
1123: IF (g_debug > 0)
1124: THEN
1125: Csd_Gen_Utility_Pvt.ADD('x_return_status(Delivery_Action )=' ||
1126: x_return_status);
1127: END IF;
1128:
1129: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)

Line 1133: Csd_Gen_Utility_Pvt.ADD('Delivery_Action failed');

1129: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
1130: THEN
1131: IF (g_debug > 0)
1132: THEN
1133: Csd_Gen_Utility_Pvt.ADD('Delivery_Action failed');
1134: END IF;
1135: RAISE fail_api;
1136: END IF;
1137: EXCEPTION

Line 1151: Csd_Gen_Utility_Pvt.ADD('Error Msg from Delivery_Action');

1147: x_msg_data := x_msg_summary;
1148: END IF;
1149: IF (g_debug > 0)
1150: THEN
1151: Csd_Gen_Utility_Pvt.ADD('Error Msg from Delivery_Action');
1152: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' || x_msg_data);
1153: END IF;
1154:
1155: -- Ignore if it is a warning

Line 1152: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' || x_msg_data);

1148: END IF;
1149: IF (g_debug > 0)
1150: THEN
1151: Csd_Gen_Utility_Pvt.ADD('Error Msg from Delivery_Action');
1152: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' || x_msg_data);
1153: END IF;
1154:
1155: -- Ignore if it is a warning
1156: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)

Line 1933: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);

1929: changed_attributes(1).serial_number := p_order_rec.serial_number;
1930: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
1931:
1932: IF (g_debug > 0 ) THEN
1933: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1934: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1935: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1937: END IF;

Line 1934: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );

1930: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
1931:
1932: IF (g_debug > 0 ) THEN
1933: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1934: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1935: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1937: END IF;
1938:

Line 1935: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );

1931:
1932: IF (g_debug > 0 ) THEN
1933: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1934: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1935: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1937: END IF;
1938:
1939:

Line 1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');

1932: IF (g_debug > 0 ) THEN
1933: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1934: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1935: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1936: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1937: END IF;
1938:
1939:
1940: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

Line 1952: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);

1948: p_changed_attributes => changed_attributes,
1949: p_source_code => source_code);
1950:
1951: IF (g_debug > 0 ) THEN
1952: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);
1953: END IF;
1954:
1955: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1956: IF (g_debug > 0 ) THEN

Line 1957: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');

1953: END IF;
1954:
1955: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1956: IF (g_debug > 0 ) THEN
1957: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');
1958: END IF;
1959: RAISE fail_api;
1960: END IF;
1961: END IF; /* end if of Serial control at sales order and reservable item */

Line 2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);

2079: changed_attributes(1).locator_id := p_product_txn_rec.locator_id;
2080: --- bug#16167687
2081:
2082: IF (g_debug > 0 ) THEN
2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );

Line 2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );

2080: --- bug#16167687
2081:
2082: IF (g_debug > 0 ) THEN
2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );

Line 2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );

2081:
2082: IF (g_debug > 0 ) THEN
2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');

Line 2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );

2082: IF (g_debug > 0 ) THEN
2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2090: END IF;

Line 2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );

2083: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2090: END IF;
2091:

Line 2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );

2084: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2090: END IF;
2091:
2092: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

Line 2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');

2085: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2086: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2087: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2088: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2089: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2090: END IF;
2091:
2092: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
2093: p_api_version_number => 1.0,

Line 2103: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);

2099: p_changed_attributes => changed_attributes,
2100: p_source_code => source_code);
2101:
2102: IF (g_debug > 0 ) THEN
2103: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);
2104: END IF;
2105:
2106: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2107: IF (g_debug > 0 ) THEN

Line 2108: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');

2104: END IF;
2105:
2106: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2107: IF (g_debug > 0 ) THEN
2108: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');
2109: END IF;
2110: RAISE fail_api;
2111: END IF;
2112:

Line 2504: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);

2500: -- Dump the IN parameters in the log file
2501: -- if the debug level > 5
2502: IF (g_debug > 5)
2503: THEN
2504: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);
2505: END IF;
2506:
2507: Debug('********* Check reqd parameter ***************',
2508: l_mod_name,

Line 4204: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

4200:
4201: -- Api body starts
4202:
4203: -- Dump the API in the log file
4204: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
4205: p_api_name => l_api_name);
4206:
4207: -- Dump the IN parameters in the log file
4208: -- if the debug level > 5

Line 4211: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);

4207: -- Dump the IN parameters in the log file
4208: -- if the debug level > 5
4209: IF Fnd_Profile.value('CSD_DEBUG_LEVEL') > 5
4210: THEN
4211: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);
4212: END IF;
4213:
4214: IF (g_debug > 0)
4215: THEN

Line 4216: Csd_Gen_Utility_Pvt.ADD('* Check reqd parameter *******');

4212: END IF;
4213:
4214: IF (g_debug > 0)
4215: THEN
4216: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4217: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4218: x_product_txn_rec.repair_line_id);
4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4220: x_product_txn_rec.action_code);

Line 4217: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||

4213:
4214: IF (g_debug > 0)
4215: THEN
4216: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4217: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4218: x_product_txn_rec.repair_line_id);
4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4220: x_product_txn_rec.action_code);
4221: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||

Line 4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||

4215: THEN
4216: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4217: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4218: x_product_txn_rec.repair_line_id);
4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4220: x_product_txn_rec.action_code);
4221: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4222: x_product_txn_rec.action_type);
4223: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||

Line 4221: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||

4217: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4218: x_product_txn_rec.repair_line_id);
4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4220: x_product_txn_rec.action_code);
4221: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4222: x_product_txn_rec.action_type);
4223: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||
4224: x_product_txn_rec.txn_billing_type_id);
4225: END IF;

Line 4223: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||

4219: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4220: x_product_txn_rec.action_code);
4221: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4222: x_product_txn_rec.action_type);
4223: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||
4224: x_product_txn_rec.txn_billing_type_id);
4225: END IF;
4226:
4227: -- Check the required parameter(txn_billing_type_id)

Line 4254: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');

4250: p_api_name => l_api_name);
4251:
4252: IF (g_debug > 0)
4253: THEN
4254: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
4255: END IF;
4256:
4257: -- Validate the repair line ID if it exists in csd_repairs
4258: IF NOT

Line 4266: Csd_Gen_Utility_Pvt.ADD('Validate action type');

4262: END IF;
4263:
4264: IF (g_debug > 0)
4265: THEN
4266: Csd_Gen_Utility_Pvt.ADD('Validate action type');
4267: END IF;
4268:
4269: -- Validate the Action Type if it exists in fnd_lookups
4270: IF NOT

Line 4278: Csd_Gen_Utility_Pvt.ADD('Validate action code');

4274: END IF;
4275:
4276: IF (g_debug > 0)
4277: THEN
4278: Csd_Gen_Utility_Pvt.ADD('Validate action code');
4279: END IF;
4280:
4281: -- Validate the repair line ID if it exists in fnd_lookups
4282: IF NOT

Line 4290: Csd_Gen_Utility_Pvt.ADD('Validate product txn qty');

4286: END IF;
4287:
4288: IF (g_debug > 0)
4289: THEN
4290: Csd_Gen_Utility_Pvt.ADD('Validate product txn qty');
4291: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.quantity =' ||
4292: x_product_txn_rec.quantity);
4293: END IF;
4294:

Line 4291: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.quantity =' ||

4287:
4288: IF (g_debug > 0)
4289: THEN
4290: Csd_Gen_Utility_Pvt.ADD('Validate product txn qty');
4291: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.quantity =' ||
4292: x_product_txn_rec.quantity);
4293: END IF;
4294:
4295: -- Validate if the product txn quantity (customer product only)

Line 4311: Csd_Gen_Utility_Pvt.ADD('Validate_Quantity failed ');

4307: IF NOT (x_return_status = Fnd_Api.G_RET_STS_SUCCESS)
4308: THEN
4309: IF (g_debug > 0)
4310: THEN
4311: Csd_Gen_Utility_Pvt.ADD('Validate_Quantity failed ');
4312: END IF;
4313: RAISE Fnd_Api.G_EXC_ERROR;
4314: END IF;
4315: END IF;

Line 4319: Csd_Gen_Utility_Pvt.ADD('Validate product txn status');

4315: END IF;
4316:
4317: IF (g_debug > 0)
4318: THEN
4319: Csd_Gen_Utility_Pvt.ADD('Validate product txn status');
4320: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4321: x_product_txn_rec.PROD_TXN_STATUS);
4322: END IF;
4323:

Line 4320: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||

4316:
4317: IF (g_debug > 0)
4318: THEN
4319: Csd_Gen_Utility_Pvt.ADD('Validate product txn status');
4320: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4321: x_product_txn_rec.PROD_TXN_STATUS);
4322: END IF;
4323:
4324: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups

Line 4360: Csd_Gen_Utility_Pvt.ADD('l_incident_id =' || l_incident_id);

4356: END;
4357:
4358: IF (g_debug > 0)
4359: THEN
4360: Csd_Gen_Utility_Pvt.ADD('l_incident_id =' || l_incident_id);
4361: END IF;
4362:
4363: -- Get the business process id
4364: -- Forward port bug fix# 2756313

Line 4371: Csd_Gen_Utility_Pvt.ADD('l_bus_process_id =' ||

4367: l_bus_process_id := Csd_Process_Util.GET_BUS_PROCESS(x_product_txn_rec.repair_line_id);
4368:
4369: IF (g_debug > 0)
4370: THEN
4371: Csd_Gen_Utility_Pvt.ADD('l_bus_process_id =' ||
4372: l_bus_process_id);
4373: END IF;
4374:
4375: IF l_bus_process_id < 0

Line 4384: Csd_Gen_Utility_Pvt.ADD('Business process Id does not exist ');

4380: l_bus_process_id := x_product_txn_rec.business_process_id;
4381: ELSE
4382: IF (g_debug > 0)
4383: THEN
4384: Csd_Gen_Utility_Pvt.ADD('Business process Id does not exist ');
4385: END IF;
4386: RAISE Fnd_Api.G_EXC_ERROR;
4387: END IF;
4388: END IF;

Line 4392: Csd_Gen_Utility_Pvt.ADD('Getting the Coverage and txn Group Id');

4388: END IF;
4389:
4390: IF (g_debug > 0)
4391: THEN
4392: Csd_Gen_Utility_Pvt.ADD('Getting the Coverage and txn Group Id');
4393: Csd_Gen_Utility_Pvt.ADD('contract_line_id =' ||
4394: x_product_txn_rec.contract_id);
4395: END IF;
4396:

Line 4393: Csd_Gen_Utility_Pvt.ADD('contract_line_id =' ||

4389:
4390: IF (g_debug > 0)
4391: THEN
4392: Csd_Gen_Utility_Pvt.ADD('Getting the Coverage and txn Group Id');
4393: Csd_Gen_Utility_Pvt.ADD('contract_line_id =' ||
4394: x_product_txn_rec.contract_id);
4395: END IF;
4396:
4397: IF l_incident_id IS NOT NULL

Line 4417: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||

4413: END IF;
4414:
4415: IF (g_debug > 0)
4416: THEN
4417: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4418: l_party_id);
4419: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4420: l_account_id);
4421: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||

Line 4419: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||

4415: IF (g_debug > 0)
4416: THEN
4417: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4418: l_party_id);
4419: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4420: l_account_id);
4421: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4422: x_product_txn_rec.txn_billing_type_id);
4423: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||

Line 4421: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||

4417: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4418: l_party_id);
4419: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4420: l_account_id);
4421: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4422: x_product_txn_rec.txn_billing_type_id);
4423: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||
4424: x_product_txn_rec.organization_id);
4425: END IF;

Line 4423: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||

4419: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4420: l_account_id);
4421: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4422: x_product_txn_rec.txn_billing_type_id);
4423: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||
4424: x_product_txn_rec.organization_id);
4425: END IF;
4426:
4427: -- Derive the line type and line category code

Line 4442: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||

4438: END IF;
4439:
4440: IF (g_debug > 0)
4441: THEN
4442: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4443: l_line_type_id);
4444: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4445: l_line_category_code);
4446: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||

Line 4444: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||

4440: IF (g_debug > 0)
4441: THEN
4442: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4443: l_line_type_id);
4444: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4445: l_line_category_code);
4446: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||
4447: x_product_txn_rec.price_list_id);
4448: END IF;

Line 4446: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||

4442: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4443: l_line_type_id);
4444: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4445: l_line_category_code);
4446: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||
4447: x_product_txn_rec.price_list_id);
4448: END IF;
4449:
4450: -- If line_type_id Or line_category_code is null

Line 4481: Csd_Gen_Utility_Pvt.ADD('Too many currency_codes');

4477: RAISE Fnd_Api.G_EXC_ERROR;
4478: WHEN TOO_MANY_ROWS THEN
4479: IF (g_debug > 0)
4480: THEN
4481: Csd_Gen_Utility_Pvt.ADD('Too many currency_codes');
4482: END IF;
4483: END;
4484: END IF;
4485:

Line 4488: Csd_Gen_Utility_Pvt.ADD('l_curr_code =' ||

4484: END IF;
4485:
4486: IF (g_debug > 0)
4487: THEN
4488: Csd_Gen_Utility_Pvt.ADD('l_curr_code =' ||
4489: l_curr_code);
4490: END IF;
4491:
4492: -- If l_curr_code is null then raise error

Line 4526: Csd_Gen_Utility_Pvt.ADD('Serial Number missing for inventory_item_id =' ||

4522: x_product_txn_rec.inventory_item_id);
4523: Fnd_Msg_Pub.ADD;
4524: IF (g_debug > 0)
4525: THEN
4526: Csd_Gen_Utility_Pvt.ADD('Serial Number missing for inventory_item_id =' ||
4527: x_product_txn_rec.inventory_item_id);
4528: END IF;
4529: RAISE Fnd_Api.G_EXC_ERROR;
4530: END IF;

Line 4541: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');

4537: x_product_txn_rec.currency_code := l_curr_code;
4538: x_product_txn_rec.line_category_code := l_line_category_code;
4539: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4540:
4541: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4542:
4543: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4544: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4545: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,

Line 4598: Csd_Gen_Utility_Pvt.ADD('PRODUCT_TRANSACTION_ID =' ||

4594: P_UNIT_NUMBER => x_product_txn_rec.unit_number,
4595: P_INTERNAL_PO_HEADER_ID => x_product_txn_rec.internal_po_header_id); -- swai: bug 6148019
4596:
4597:
4598: Csd_Gen_Utility_Pvt.ADD('PRODUCT_TRANSACTION_ID =' ||
4599: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4600: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4601: x_product_txn_rec.repair_line_id);
4602:

Line 4600: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||

4596:
4597:
4598: Csd_Gen_Utility_Pvt.ADD('PRODUCT_TRANSACTION_ID =' ||
4599: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4600: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4601: x_product_txn_rec.repair_line_id);
4602:
4603: UPDATE csd_repairs
4604: SET ro_txn_status = 'OM_SUBMITTED'

Line 5083: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

5079:
5080: -- Api body starts
5081: IF (g_debug > 0)
5082: THEN
5083: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
5084: p_api_name => l_api_name);
5085: END IF;
5086: IF (g_debug > 0)
5087: THEN

Line 5088: Csd_Gen_Utility_Pvt.ADD('Check reqd parameter :prod txn Id ');

5084: p_api_name => l_api_name);
5085: END IF;
5086: IF (g_debug > 0)
5087: THEN
5088: Csd_Gen_Utility_Pvt.ADD('Check reqd parameter :prod txn Id ');
5089: Csd_Gen_Utility_Pvt.ADD('product txn Id = ' ||
5090: p_product_txn_id);
5091: END IF;
5092:

Line 5089: Csd_Gen_Utility_Pvt.ADD('product txn Id = ' ||

5085: END IF;
5086: IF (g_debug > 0)
5087: THEN
5088: Csd_Gen_Utility_Pvt.ADD('Check reqd parameter :prod txn Id ');
5089: Csd_Gen_Utility_Pvt.ADD('product txn Id = ' ||
5090: p_product_txn_id);
5091: END IF;
5092:
5093: -- Check the required parameter

Line 5100: Csd_Gen_Utility_Pvt.ADD('Validate product txn id');

5096: p_api_name => l_api_name);
5097:
5098: IF (g_debug > 0)
5099: THEN
5100: Csd_Gen_Utility_Pvt.ADD('Validate product txn id');
5101: END IF;
5102:
5103: -- Validate the repair line ID
5104: IF NOT

Line 5129: Csd_Gen_Utility_Pvt.ADD('Product txn is interfaced,so it cannot be deleted');

5125: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
5126: Fnd_Msg_Pub.ADD;
5127: IF (g_debug > 0)
5128: THEN
5129: Csd_Gen_Utility_Pvt.ADD('Product txn is interfaced,so it cannot be deleted');
5130: END IF;
5131: RAISE Fnd_Api.G_EXC_ERROR;
5132: WHEN TOO_MANY_ROWS THEN
5133: IF (g_debug > 0)

Line 5135: Csd_Gen_Utility_Pvt.ADD('Too many from Product txn line is allowed to delete');

5131: RAISE Fnd_Api.G_EXC_ERROR;
5132: WHEN TOO_MANY_ROWS THEN
5133: IF (g_debug > 0)
5134: THEN
5135: Csd_Gen_Utility_Pvt.ADD('Too many from Product txn line is allowed to delete');
5136: END IF;
5137: END;
5138:
5139: IF (g_debug > 0)

Line 5141: Csd_Gen_Utility_Pvt.ADD('l_delete_allow =' ||

5137: END;
5138:
5139: IF (g_debug > 0)
5140: THEN
5141: Csd_Gen_Utility_Pvt.ADD('l_delete_allow =' ||
5142: l_delete_allow);
5143: Csd_Gen_Utility_Pvt.ADD('Estimate Detail Id =' ||
5144: l_est_detail_id);
5145: END IF;

Line 5143: Csd_Gen_Utility_Pvt.ADD('Estimate Detail Id =' ||

5139: IF (g_debug > 0)
5140: THEN
5141: Csd_Gen_Utility_Pvt.ADD('l_delete_allow =' ||
5142: l_delete_allow);
5143: Csd_Gen_Utility_Pvt.ADD('Estimate Detail Id =' ||
5144: l_est_detail_id);
5145: END IF;
5146:
5147: IF l_delete_allow = 'Y'

Line 5152: Csd_Gen_Utility_Pvt.ADD('Call process_charge_lines to delete');

5148: THEN
5149: l_Charges_Rec.estimate_detail_id := l_est_detail_id;
5150: IF (g_debug > 0)
5151: THEN
5152: Csd_Gen_Utility_Pvt.ADD('Call process_charge_lines to delete');
5153: END IF;
5154:
5155: PROCESS_CHARGE_LINES(p_api_version => 1.0,
5156: p_commit => Fnd_Api.g_false,

Line 5173: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');

5169: END IF;
5170:
5171: IF (g_debug > 0)
5172: THEN
5173: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5174: END IF;
5175:
5176: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5177: END IF; --end of delete

Line 5278: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

5274:
5275: -- Api body starts
5276: IF (g_debug > 0)
5277: THEN
5278: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
5279: p_api_name => l_api_name);
5280: END IF;
5281: IF (g_debug > 0)
5282: THEN

Line 5283: Csd_Gen_Utility_Pvt.ADD('Check the required parameter:(repair_line_id)');

5279: p_api_name => l_api_name);
5280: END IF;
5281: IF (g_debug > 0)
5282: THEN
5283: Csd_Gen_Utility_Pvt.ADD('Check the required parameter:(repair_line_id)');
5284: Csd_Gen_Utility_Pvt.ADD('Repair line id =' || p_repair_line_id);
5285: END IF;
5286:
5287: -- Check the required parameter

Line 5284: Csd_Gen_Utility_Pvt.ADD('Repair line id =' || p_repair_line_id);

5280: END IF;
5281: IF (g_debug > 0)
5282: THEN
5283: Csd_Gen_Utility_Pvt.ADD('Check the required parameter:(repair_line_id)');
5284: Csd_Gen_Utility_Pvt.ADD('Repair line id =' || p_repair_line_id);
5285: END IF;
5286:
5287: -- Check the required parameter
5288: Csd_Process_Util.Check_Reqd_Param(p_param_value => p_repair_line_id,

Line 5294: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');

5290: p_api_name => l_api_name);
5291:
5292: IF (g_debug > 0)
5293: THEN
5294: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
5295: END IF;
5296:
5297: -- Validate the repair line ID
5298: IF NOT

Line 5306: Csd_Gen_Utility_Pvt.ADD('Build the product txn table');

5302: END IF;
5303:
5304: IF (g_debug > 0)
5305: THEN
5306: Csd_Gen_Utility_Pvt.ADD('Build the product txn table');
5307: END IF;
5308:
5309: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
5310: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');

Line 5330: Csd_Gen_Utility_Pvt.ADD('x_prod_txn_tbl.count =' ||

5326: END IF;
5327:
5328: IF (g_debug > 0)
5329: THEN
5330: Csd_Gen_Utility_Pvt.ADD('x_prod_txn_tbl.count =' ||
5331: x_prod_txn_tbl.COUNT);
5332: END IF;
5333:
5334: IF x_prod_txn_tbl.COUNT > 0 THEN

Line 5339: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop');

5335: FOR i IN x_prod_txn_tbl.first..1
5336: LOOP
5337:
5338: IF (g_debug > 0 ) THEN
5339: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop');
5340: END IF;
5341: CREATE_PRODUCT_TXN
5342: (p_api_version => 1.0 ,
5343: p_commit => fnd_api.g_false,

Line 5364: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);

5360: p_data => x_msg_data,
5361: p_msg_index_out => x_msg_index_out );
5362: l_msg_text := x_msg_data;
5363: IF (g_debug > 0 ) THEN
5364: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);
5365: END IF;
5366: End LOOP;
5367: END LOOP;
5368:

Line 5373: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop 2');

5369: FOR i IN 2..x_prod_txn_tbl.last
5370: LOOP
5371:
5372: IF (g_debug > 0 ) THEN
5373: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop 2');
5374: END IF;
5375:
5376: If ((i = 2) and (x_prod_txn_tbl(i).interface_to_om_flag = 'Y') and
5377: (x_prod_txn_tbl(i).new_order_flag = 'Y' or x_prod_txn_tbl(i).new_order_flag is null) and

Line 5425: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);

5421: p_data => x_msg_data,
5422: p_msg_index_out => x_msg_index_out );
5423: l_msg_text := x_msg_data;
5424: IF (g_debug > 0 ) THEN
5425: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);
5426: END IF;
5427: End LOOP;
5428: END LOOP;
5429: END IF;

Line 5630: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task before jtf_tasks_pub.CREATE_TASK');

5626: -- Api body starts
5627: -- ---------------
5628: IF (g_debug > 0)
5629: THEN
5630: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task before jtf_tasks_pub.CREATE_TASK');
5631: END IF;
5632:
5633: -- ----------------------------------------
5634: -- Calling Public JTF API to create a Task

Line 5698: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task after jtf_tasks_pub.CREATE_TASK x_return_status' ||

5694: X_TASK_ID => x_task_id);
5695:
5696: IF (g_debug > 0)
5697: THEN
5698: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task after jtf_tasks_pub.CREATE_TASK x_return_status' ||
5699: x_return_status);
5700: END IF;
5701:
5702: -- -------------------

Line 5799: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task before jtf_tasks_pub.UPDATE_TASK');

5795: -- Api body starts
5796: -- ---------------
5797: IF (g_debug > 0)
5798: THEN
5799: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task before jtf_tasks_pub.UPDATE_TASK');
5800: END IF;
5801:
5802: -- ----------------------------------------
5803: -- Calling Public JTF API to Update a Task

Line 5868: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task after jtf_tasks_pub.UPDATE_TASK x_return_status' ||

5864: X_MSG_DATA => x_msg_data);
5865:
5866: IF (g_debug > 0)
5867: THEN
5868: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task after jtf_tasks_pub.UPDATE_TASK x_return_status' ||
5869: x_return_status);
5870: END IF;
5871:
5872: -- -------------------

Line 6109: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');

6105: IF (l_check_task > 0)
6106: THEN
6107: IF (g_debug > 0)
6108: THEN
6109: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');
6110: END IF;
6111:
6112: ELSE
6113: -- call the pub after assigning the required variable values

Line 6165: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');

6161: -- Api body starts
6162: -- ---------------
6163: IF (g_debug > 0)
6164: THEN
6165: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');
6166: END IF;
6167:
6168: -- travi 020502 OBJECT_VERSION_NUMBER validation
6169:

Line 6245: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||

6241: X_Msg_Data => x_msg_data);
6242: --
6243: IF (g_debug > 0)
6244: THEN
6245: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||
6246: x_return_status);
6247: END IF;
6248:
6249: -- -------------------

Line 6424: csd_gen_utility_pvt.ADD('TC and/or TOC/TSC Exists in Repair History');

6420: -- add the update TOC/TSC line to Repair history
6421: -- ----------------------------------------------
6422: IF (l_check_id >= 1) THEN
6423: IF (g_debug > 0 ) THEN
6424: csd_gen_utility_pvt.ADD('TC and/or TOC/TSC Exists in Repair History');
6425: END IF;
6426:
6427: -- pick latest row from Repair history
6428: OPEN c_task_hist(p_task_id, p_repair_line_id);

Line 6482: csd_gen_utility_pvt.ADD('Before Task to Update Repair History');

6478: -- ---------------
6479: -- Api body starts
6480: -- ---------------
6481: IF (g_debug > 0 ) THEN
6482: csd_gen_utility_pvt.ADD('Before Task to Update Repair History');
6483: END IF;
6484:
6485:
6486: -- travi 020502 OBJECT_VERSION_NUMBER validation

Line 6564: csd_gen_utility_pvt.ADD('After Task to Update Repair History : '||x_return_status);

6560: X_Msg_Data => x_msg_data
6561: );
6562: --
6563: IF (g_debug > 0 ) THEN
6564: csd_gen_utility_pvt.ADD('After Task to Update Repair History : '||x_return_status);
6565: END IF;
6566:
6567: -- -------------------
6568: -- Api body ends here

Line 6702: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');

6698: IF (l_check_task > 0)
6699: THEN
6700: IF (g_debug > 0)
6701: THEN
6702: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');
6703: END IF;
6704:
6705: ELSE
6706: -- call the pub after assigning the required variable values

Line 6770: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');

6766: -- Api body starts
6767: -- ---------------
6768: IF (g_debug > 0)
6769: THEN
6770: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');
6771: END IF;
6772:
6773: -- travi 020502 OBJECT_VERSION_NUMBER validation
6774:

Line 6850: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||

6846: X_Msg_Data => x_msg_data);
6847: --
6848: IF (g_debug > 0)
6849: THEN
6850: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||
6851: x_return_status);
6852: END IF;
6853:
6854: -- -------------------

Line 7270: Csd_Gen_Utility_Pvt.ADD('After Task to Update Repair History : ' ||

7266: END IF; -- most outer if
7267: --
7268: IF (g_debug > 0)
7269: THEN
7270: Csd_Gen_Utility_Pvt.ADD('After Task to Update Repair History : ' ||
7271: x_return_status);
7272: END IF;
7273:
7274: -- -------------------

Line 7397: Csd_Gen_Utility_Pvt.dump_api_info

7393: -- Api body starts
7394: --------------------
7395: IF (g_debug > 0)
7396: THEN
7397: Csd_Gen_Utility_Pvt.dump_api_info
7398:
7399: (p_pkg_name => G_PKG_NAME, p_api_name => l_api_name);
7400: END IF;
7401:

Line 7415: Csd_Gen_Utility_Pvt.ADD('Incident Id =' || p_incident_id);

7411: -- Validate the incident_id
7412:
7413: IF (g_debug > 0)
7414: THEN
7415: Csd_Gen_Utility_Pvt.ADD('Incident Id =' || p_incident_id);
7416: END IF;
7417:
7418: l_validate_flag := Csd_Process_Util.validate_incident_id(p_incident_id);
7419:

Line 7424: Csd_Gen_Utility_Pvt.ADD('The Incident Id is invalid ');

7420: IF NOT (l_validate_flag)
7421: THEN
7422: IF (g_debug > 0)
7423: THEN
7424: Csd_Gen_Utility_Pvt.ADD('The Incident Id is invalid ');
7425: END IF;
7426:
7427: RAISE Fnd_Api.G_EXC_ERROR;
7428: END IF;

Line 7437: Csd_Gen_Utility_Pvt.ADD('grp.repair_type_ref =' ||

7433: LOOP
7434:
7435: IF (g_debug > 0)
7436: THEN
7437: Csd_Gen_Utility_Pvt.ADD('grp.repair_type_ref =' ||
7438: grp.repair_type_ref);
7439: END IF;
7440:
7441: IF grp.repair_type_ref IN ('AE', 'AL')

Line 7466: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||

7462: l_ro_rec.status := 'C';
7463:
7464: IF (g_debug > 0)
7465: THEN
7466: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7467: ro.repair_line_id);
7468: END IF;
7469:
7470: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

Line 7508: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||

7504: l_grp_rec.repair_group_id := grp.repair_group_id;
7505:
7506: IF (g_debug > 0)
7507: THEN
7508: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7509: grp.repair_group_id);
7510: END IF;
7511:
7512: -- Update Group

Line 7560: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||

7556: l_ro_rec.status := 'C';
7557:
7558: IF (g_debug > 0)
7559: THEN
7560: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7561: ro.repair_line_id);
7562: END IF;
7563:
7564: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

Line 7602: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||

7598: l_grp_rec.repair_group_id := grp.repair_group_id;
7599:
7600: IF (g_debug > 0)
7601: THEN
7602: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7603: grp.repair_group_id);
7604: END IF;
7605:
7606: -- Update the Group

Line 7651: Csd_Gen_Utility_Pvt.ADD('Update Incident Id =' ||

7647: THEN
7648:
7649: IF (g_debug > 0)
7650: THEN
7651: Csd_Gen_Utility_Pvt.ADD('Update Incident Id =' ||
7652: p_incident_id);
7653: END IF;
7654:
7655: BEGIN

Line 7752: Csd_Gen_Utility_Pvt.ADD('Update Repair Line ID =' ||

7748: -- Validate the repair_line_id
7749:
7750: IF (g_debug > 0)
7751: THEN
7752: Csd_Gen_Utility_Pvt.ADD('Update Repair Line ID =' ||
7753: p_repair_line_id);
7754: END IF;
7755:
7756: l_validate_flag := Csd_Process_Util.validate_rep_line_id(p_repair_line_id);

Line 7762: Csd_Gen_Utility_Pvt.ADD('Repair Line Id is invalid ');

7758: IF NOT (l_validate_flag)
7759: THEN
7760: IF (g_debug > 0)
7761: THEN
7762: Csd_Gen_Utility_Pvt.ADD('Repair Line Id is invalid ');
7763: END IF;
7764:
7765: RAISE Fnd_Api.G_EXC_ERROR;
7766: END IF;

Line 7828: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||

7824: THEN
7825:
7826: IF (g_debug > 0)
7827: THEN
7828: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7829: l_repair_group_id);
7830: END IF;
7831:
7832: BEGIN

Line 7885: Csd_Gen_Utility_Pvt.ADD('Update Service Request = ' ||

7881: THEN
7882:
7883: IF (g_debug > 0)
7884: THEN
7885: Csd_Gen_Utility_Pvt.ADD('Update Service Request = ' ||
7886: l_incident_id);
7887: END IF;
7888:
7889: -- Update the Service Request

Line 8055: Csd_Gen_Utility_Pvt.ADD('In Check_Service_Request API');

8051: BEGIN
8052:
8053: IF (g_debug > 0)
8054: THEN
8055: Csd_Gen_Utility_Pvt.ADD('In Check_Service_Request API');
8056: END IF;
8057:
8058: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
8059:

Line 8068: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');

8064: FOR rma_so_rec IN RMA_SO_CUR(p_incident_Id)
8065: LOOP
8066: IF (g_debug > 0)
8067: THEN
8068: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
8069: Csd_Gen_Utility_Pvt.ADD('Category[' ||
8070: rma_so_Rec.Line_Category_Code || ']');
8071: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
8072: END IF;

Line 8069: Csd_Gen_Utility_Pvt.ADD('Category[' ||

8065: LOOP
8066: IF (g_debug > 0)
8067: THEN
8068: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
8069: Csd_Gen_Utility_Pvt.ADD('Category[' ||
8070: rma_so_Rec.Line_Category_Code || ']');
8071: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
8072: END IF;
8073:

Line 8071: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');

8067: THEN
8068: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
8069: Csd_Gen_Utility_Pvt.ADD('Category[' ||
8070: rma_so_Rec.Line_Category_Code || ']');
8071: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
8072: END IF;
8073:
8074: IF (rma_so_Rec.Line_Category_Code = 'RETURN')
8075: THEN

Line 8116: Csd_Gen_Utility_Pvt.ADD('Leaving checkService_Request link mode[' ||

8112: END IF;
8113:
8114: IF (g_debug > 0)
8115: THEN
8116: Csd_Gen_Utility_Pvt.ADD('Leaving checkService_Request link mode[' ||
8117: TO_CHAR(x_link_mode) || ']');
8118: END IF;
8119:
8120: EXCEPTION

Line 8605: Csd_Gen_Utility_Pvt.ADD('incident id missing ');

8601: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8602: Fnd_Msg_Pub.ADD;
8603: IF (g_debug > 0)
8604: THEN
8605: Csd_Gen_Utility_Pvt.ADD('incident id missing ');
8606: END IF;
8607: RAISE Fnd_Api.g_exc_error;
8608: END IF;
8609:

Line 9187: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

9183:
9184: -- Api body starts
9185: IF (g_debug > 0)
9186: THEN
9187: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
9188: p_api_name => l_api_name);
9189: END IF;
9190: IF (g_debug > 0)
9191: THEN

Line 9192: Csd_Gen_Utility_Pvt.ADD('Checking required parameter:(repair_line_id)');

9188: p_api_name => l_api_name);
9189: END IF;
9190: IF (g_debug > 0)
9191: THEN
9192: Csd_Gen_Utility_Pvt.ADD('Checking required parameter:(repair_line_id)');
9193: END IF;
9194: -- Check the required parameter
9195: Csd_Process_Util.Check_Reqd_Param(p_param_value => p_Repair_Line_id,
9196: p_param_name => 'Repair_Line_Id',

Line 9201: Csd_Gen_Utility_Pvt.ADD('Required parameter:(repair_line_id) has value' ||

9197: p_api_name => l_api_name);
9198: -- Validate Repair_Line_id and check RO status
9199: IF (g_debug > 0)
9200: THEN
9201: Csd_Gen_Utility_Pvt.ADD('Required parameter:(repair_line_id) has value' ||
9202: p_Repair_Line_id);
9203: END IF;
9204: BEGIN
9205: IF (g_debug > 0)

Line 9207: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');

9203: END IF;
9204: BEGIN
9205: IF (g_debug > 0)
9206: THEN
9207: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');
9208: END IF;
9209: SELECT dra.status,
9210: dra.Quantity,
9211: dra.Inventory_Item_Id,