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 721: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

717:
718: -- Api body starts
719: IF (g_debug > 0)
720: THEN
721: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
722: p_api_name => l_api_name);
723: END IF;
724:
725: IF (g_debug > 0)

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

723: END IF;
724:
725: IF (g_debug > 0)
726: THEN
727: Csd_Gen_Utility_Pvt.ADD('Validate the incident id');
728: Csd_Gen_Utility_Pvt.ADD('p_incident_id =' || p_incident_id);
729: END IF;
730:
731: IF NOT (Csd_Process_Util.VALIDATE_INCIDENT_ID(p_incident_id))

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

724:
725: IF (g_debug > 0)
726: THEN
727: Csd_Gen_Utility_Pvt.ADD('Validate the incident id');
728: Csd_Gen_Utility_Pvt.ADD('p_incident_id =' || p_incident_id);
729: END IF;
730:
731: IF NOT (Csd_Process_Util.VALIDATE_INCIDENT_ID(p_incident_id))
732: THEN

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

734: END IF;
735:
736: IF (g_debug > 0)
737: THEN
738: Csd_Gen_Utility_Pvt.ADD('Applying contract on charge lines');
739: END IF;
740:
741: -- Commented
742: -- signature change to be discussed.

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

908: -- fnd_global.apps_initialize(1000200,52284,512,0);
909:
910: IF (g_debug > 0)
911: THEN
912: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
913: p_api_name => l_api_name);
914: END IF;
915: -- If action is SHIP, then call shipping api to
916: -- ship the sales order

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

915: -- If action is SHIP, then call shipping api to
916: -- ship the sales order
917: IF (g_debug > 0)
918: THEN
919: Csd_Gen_Utility_Pvt.ADD('Shipping the Sales Order');
920: Csd_Gen_Utility_Pvt.ADD('p_delivery_id =' || p_delivery_id);
921: END IF;
922:
923: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM

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

916: -- ship the sales order
917: IF (g_debug > 0)
918: THEN
919: Csd_Gen_Utility_Pvt.ADD('Shipping the Sales Order');
920: Csd_Gen_Utility_Pvt.ADD('p_delivery_id =' || p_delivery_id);
921: END IF;
922:
923: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
924: THEN

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

926: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
927: Fnd_Msg_Pub.ADD;
928: IF (g_debug > 0)
929: THEN
930: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
931: END IF;
932: RAISE Fnd_Api.G_EXC_ERROR;
933: ELSE
934:

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

943: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
944: Fnd_Msg_Pub.ADD;
945: IF (g_debug > 0)
946: THEN
947: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
948: END IF;
949: RAISE Fnd_Api.G_EXC_ERROR;
950: END;
951: END IF;

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

968: changed_attributes(1).serial_number := i.serial_number;
969: changed_attributes(1).shipped_quantity := i.requested_quantity;
970: IF (g_debug > 0)
971: THEN
972: Csd_Gen_Utility_Pvt.ADD('delivery_detail_id =' ||
973: changed_attributes(1)
974: .delivery_detail_id);
975: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
976: changed_attributes(1)

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

971: THEN
972: Csd_Gen_Utility_Pvt.ADD('delivery_detail_id =' ||
973: changed_attributes(1)
974: .delivery_detail_id);
975: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
976: changed_attributes(1)
977: .serial_number);
978: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
979: changed_attributes(1)

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

974: .delivery_detail_id);
975: Csd_Gen_Utility_Pvt.ADD('serial_number =' ||
976: changed_attributes(1)
977: .serial_number);
978: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
979: changed_attributes(1)
980: .shipped_quantity);
981: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
982: END IF;

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

977: .serial_number);
978: Csd_Gen_Utility_Pvt.ADD('shipped_quantity =' ||
979: changed_attributes(1)
980: .shipped_quantity);
981: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
982: END IF;
983: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
984: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
985: p_init_msg_list => p_init_msg_list,

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

990: p_changed_attributes => changed_attributes,
991: p_source_code => source_code);
992: IF (g_debug > 0)
993: THEN
994: Csd_Gen_Utility_Pvt.ADD('x_return_status(Update_Shipping_Attributes )=' ||
995: x_return_status);
996: END IF;
997: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
998: THEN

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

997: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
998: THEN
999: IF (g_debug > 0)
1000: THEN
1001: Csd_Gen_Utility_Pvt.ADD('Update_Shipping_Attributes failed');
1002: END IF;
1003: RAISE fail_api;
1004: END IF;
1005: EXCEPTION

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

1015: x_msg_data := x_msg_summary;
1016: END IF;
1017: IF (g_debug > 0)
1018: THEN
1019: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1020: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1021: x_msg_data);
1022: END IF;
1023: Fnd_Message.SET_NAME('CSD',

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

1016: END IF;
1017: IF (g_debug > 0)
1018: THEN
1019: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1020: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1021: x_msg_data);
1022: END IF;
1023: Fnd_Message.SET_NAME('CSD',
1024: 'CSD_UPDATE_SHIPPING_FAILED');

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

1034: BEGIN
1035:
1036: IF (g_debug > 0)
1037: THEN
1038: Csd_Gen_Utility_Pvt.ADD('p_delivery_id=' || p_delivery_id);
1039: END IF;
1040:
1041: -- Values for Ship Confirming the delivery.
1042: p_action_code := 'CONFIRM'; -- The action code for ship confirm

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

1053: -- p_sc_report_set_id := 6; -- check if it is seeded
1054:
1055: IF (g_debug > 0)
1056: THEN
1057: Csd_Gen_Utility_Pvt.ADD('Calling Delivery_Action ');
1058: END IF;
1059:
1060: -- Call to WSH_DELIVERIES_PUB.Delivery_Action.
1061: Wsh_Deliveries_Pub.Delivery_Action(p_api_version_number => 1.0,

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

1093: x_trip_name => x_trip_name);
1094:
1095: IF (g_debug > 0)
1096: THEN
1097: Csd_Gen_Utility_Pvt.ADD('x_return_status(Delivery_Action )=' ||
1098: x_return_status);
1099: END IF;
1100:
1101: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)

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

1101: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_SUCCESS)
1102: THEN
1103: IF (g_debug > 0)
1104: THEN
1105: Csd_Gen_Utility_Pvt.ADD('Delivery_Action failed');
1106: END IF;
1107: RAISE fail_api;
1108: END IF;
1109: EXCEPTION

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

1119: x_msg_data := x_msg_summary;
1120: END IF;
1121: IF (g_debug > 0)
1122: THEN
1123: Csd_Gen_Utility_Pvt.ADD('Error Msg from Delivery_Action');
1124: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' || x_msg_data);
1125: END IF;
1126:
1127: -- Ignore if it is a warning

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

1120: END IF;
1121: IF (g_debug > 0)
1122: THEN
1123: Csd_Gen_Utility_Pvt.ADD('Error Msg from Delivery_Action');
1124: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' || x_msg_data);
1125: END IF;
1126:
1127: -- Ignore if it is a warning
1128: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)

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

1884: changed_attributes(1).serial_number := p_order_rec.serial_number;
1885: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
1886:
1887: IF (g_debug > 0 ) THEN
1888: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1889: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1890: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1891: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1892: END IF;

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

1885: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
1886:
1887: IF (g_debug > 0 ) THEN
1888: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1889: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1890: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1891: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1892: END IF;
1893:

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

1886:
1887: IF (g_debug > 0 ) THEN
1888: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1889: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1890: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1891: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1892: END IF;
1893:
1894:

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

1887: IF (g_debug > 0 ) THEN
1888: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
1889: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
1890: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
1891: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1892: END IF;
1893:
1894:
1895: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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

1903: p_changed_attributes => changed_attributes,
1904: p_source_code => source_code);
1905:
1906: IF (g_debug > 0 ) THEN
1907: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);
1908: END IF;
1909:
1910: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1911: IF (g_debug > 0 ) THEN

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

1908: END IF;
1909:
1910: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1911: IF (g_debug > 0 ) THEN
1912: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');
1913: END IF;
1914: RAISE fail_api;
1915: END IF;
1916: END IF; /* end if of Serial control at sales order and reservable item */

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

2030: changed_attributes(1).subinventory := l_sub_inventory;
2031: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
2032:
2033: IF (g_debug > 0 ) THEN
2034: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );

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

2031: changed_attributes(1).shipped_quantity := p_order_rec.shipped_quantity;
2032:
2033: IF (g_debug > 0 ) THEN
2034: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );

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

2032:
2033: IF (g_debug > 0 ) THEN
2034: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');

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

2033: IF (g_debug > 0 ) THEN
2034: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2041: END IF;

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

2034: csd_gen_utility_pvt.ADD('delivery_detail_id ='||changed_attributes(1).delivery_detail_id);
2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2041: END IF;
2042:

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

2035: csd_gen_utility_pvt.ADD('serial_number ='||changed_attributes(1).serial_number );
2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2041: END IF;
2042:
2043: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

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

2036: csd_gen_utility_pvt.ADD('Revision ='||changed_attributes(1).revision );
2037: csd_gen_utility_pvt.ADD('Lot number ='||changed_attributes(1).lot_number );
2038: csd_gen_utility_pvt.ADD('sub_inventory ='||changed_attributes(1).subinventory );
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2041: END IF;
2042:
2043: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
2044: p_api_version_number => 1.0,

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

2050: p_changed_attributes => changed_attributes,
2051: p_source_code => source_code);
2052:
2053: IF (g_debug > 0 ) THEN
2054: csd_gen_utility_pvt.ADD('x_return_status(Update_Shipping_Attributes )='||x_return_status);
2055: END IF;
2056:
2057: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2058: IF (g_debug > 0 ) THEN

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

2055: END IF;
2056:
2057: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2058: IF (g_debug > 0 ) THEN
2059: csd_gen_utility_pvt.ADD('Update_Shipping_Attributes failed');
2060: END IF;
2061: RAISE fail_api;
2062: END IF;
2063:

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

2417: -- Dump the IN parameters in the log file
2418: -- if the debug level > 5
2419: IF (g_debug > 5)
2420: THEN
2421: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);
2422: END IF;
2423:
2424: Debug('********* Check reqd parameter ***************',
2425: l_mod_name,

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

4104:
4105: -- Api body starts
4106:
4107: -- Dump the API in the log file
4108: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
4109: p_api_name => l_api_name);
4110:
4111: -- Dump the IN parameters in the log file
4112: -- if the debug level > 5

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

4111: -- Dump the IN parameters in the log file
4112: -- if the debug level > 5
4113: IF Fnd_Profile.value('CSD_DEBUG_LEVEL') > 5
4114: THEN
4115: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);
4116: END IF;
4117:
4118: IF (g_debug > 0)
4119: THEN

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

4116: END IF;
4117:
4118: IF (g_debug > 0)
4119: THEN
4120: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4121: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4122: x_product_txn_rec.repair_line_id);
4123: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4124: x_product_txn_rec.action_code);

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

4117:
4118: IF (g_debug > 0)
4119: THEN
4120: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4121: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4122: x_product_txn_rec.repair_line_id);
4123: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4124: x_product_txn_rec.action_code);
4125: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||

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

4119: THEN
4120: Csd_Gen_Utility_Pvt.ADD('********* Check reqd parameter ***************');
4121: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4122: x_product_txn_rec.repair_line_id);
4123: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4124: x_product_txn_rec.action_code);
4125: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4126: x_product_txn_rec.action_type);
4127: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||

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

4121: Csd_Gen_Utility_Pvt.ADD('Repair Line ID =' ||
4122: x_product_txn_rec.repair_line_id);
4123: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4124: x_product_txn_rec.action_code);
4125: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4126: x_product_txn_rec.action_type);
4127: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||
4128: x_product_txn_rec.txn_billing_type_id);
4129: END IF;

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

4123: Csd_Gen_Utility_Pvt.ADD('Action Code =' ||
4124: x_product_txn_rec.action_code);
4125: Csd_Gen_Utility_Pvt.ADD('Action Type =' ||
4126: x_product_txn_rec.action_type);
4127: Csd_Gen_Utility_Pvt.ADD('Txn_billing_type_id =' ||
4128: x_product_txn_rec.txn_billing_type_id);
4129: END IF;
4130:
4131: -- Check the required parameter(txn_billing_type_id)

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

4154: p_api_name => l_api_name);
4155:
4156: IF (g_debug > 0)
4157: THEN
4158: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
4159: END IF;
4160:
4161: -- Validate the repair line ID if it exists in csd_repairs
4162: IF NOT

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

4166: END IF;
4167:
4168: IF (g_debug > 0)
4169: THEN
4170: Csd_Gen_Utility_Pvt.ADD('Validate action type');
4171: END IF;
4172:
4173: -- Validate the Action Type if it exists in fnd_lookups
4174: IF NOT

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

4178: END IF;
4179:
4180: IF (g_debug > 0)
4181: THEN
4182: Csd_Gen_Utility_Pvt.ADD('Validate action code');
4183: END IF;
4184:
4185: -- Validate the repair line ID if it exists in fnd_lookups
4186: IF NOT

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

4190: END IF;
4191:
4192: IF (g_debug > 0)
4193: THEN
4194: Csd_Gen_Utility_Pvt.ADD('Validate product txn qty');
4195: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.quantity =' ||
4196: x_product_txn_rec.quantity);
4197: END IF;
4198:

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

4191:
4192: IF (g_debug > 0)
4193: THEN
4194: Csd_Gen_Utility_Pvt.ADD('Validate product txn qty');
4195: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.quantity =' ||
4196: x_product_txn_rec.quantity);
4197: END IF;
4198:
4199: -- Validate if the product txn quantity (customer product only)

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

4211: IF NOT (x_return_status = Fnd_Api.G_RET_STS_SUCCESS)
4212: THEN
4213: IF (g_debug > 0)
4214: THEN
4215: Csd_Gen_Utility_Pvt.ADD('Validate_Quantity failed ');
4216: END IF;
4217: RAISE Fnd_Api.G_EXC_ERROR;
4218: END IF;
4219: END IF;

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

4219: END IF;
4220:
4221: IF (g_debug > 0)
4222: THEN
4223: Csd_Gen_Utility_Pvt.ADD('Validate product txn status');
4224: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4225: x_product_txn_rec.PROD_TXN_STATUS);
4226: END IF;
4227:

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

4220:
4221: IF (g_debug > 0)
4222: THEN
4223: Csd_Gen_Utility_Pvt.ADD('Validate product txn status');
4224: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4225: x_product_txn_rec.PROD_TXN_STATUS);
4226: END IF;
4227:
4228: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups

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

4260: END;
4261:
4262: IF (g_debug > 0)
4263: THEN
4264: Csd_Gen_Utility_Pvt.ADD('l_incident_id =' || l_incident_id);
4265: END IF;
4266:
4267: -- Get the business process id
4268: -- Forward port bug fix# 2756313

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

4271: l_bus_process_id := Csd_Process_Util.GET_BUS_PROCESS(x_product_txn_rec.repair_line_id);
4272:
4273: IF (g_debug > 0)
4274: THEN
4275: Csd_Gen_Utility_Pvt.ADD('l_bus_process_id =' ||
4276: l_bus_process_id);
4277: END IF;
4278:
4279: IF l_bus_process_id < 0

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

4284: l_bus_process_id := x_product_txn_rec.business_process_id;
4285: ELSE
4286: IF (g_debug > 0)
4287: THEN
4288: Csd_Gen_Utility_Pvt.ADD('Business process Id does not exist ');
4289: END IF;
4290: RAISE Fnd_Api.G_EXC_ERROR;
4291: END IF;
4292: END IF;

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

4292: END IF;
4293:
4294: IF (g_debug > 0)
4295: THEN
4296: Csd_Gen_Utility_Pvt.ADD('Getting the Coverage and txn Group Id');
4297: Csd_Gen_Utility_Pvt.ADD('contract_line_id =' ||
4298: x_product_txn_rec.contract_id);
4299: END IF;
4300:

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

4293:
4294: IF (g_debug > 0)
4295: THEN
4296: Csd_Gen_Utility_Pvt.ADD('Getting the Coverage and txn Group Id');
4297: Csd_Gen_Utility_Pvt.ADD('contract_line_id =' ||
4298: x_product_txn_rec.contract_id);
4299: END IF;
4300:
4301: IF l_incident_id IS NOT NULL

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

4317: END IF;
4318:
4319: IF (g_debug > 0)
4320: THEN
4321: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4322: l_party_id);
4323: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4324: l_account_id);
4325: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||

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

4319: IF (g_debug > 0)
4320: THEN
4321: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4322: l_party_id);
4323: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4324: l_account_id);
4325: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4326: x_product_txn_rec.txn_billing_type_id);
4327: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||

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

4321: Csd_Gen_Utility_Pvt.ADD('l_party_id =' ||
4322: l_party_id);
4323: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4324: l_account_id);
4325: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4326: x_product_txn_rec.txn_billing_type_id);
4327: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||
4328: x_product_txn_rec.organization_id);
4329: END IF;

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

4323: Csd_Gen_Utility_Pvt.ADD('l_account_id =' ||
4324: l_account_id);
4325: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.txn_billing_type_id =' ||
4326: x_product_txn_rec.txn_billing_type_id);
4327: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.organization_id =' ||
4328: x_product_txn_rec.organization_id);
4329: END IF;
4330:
4331: -- Derive the line type and line category code

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

4342: END IF;
4343:
4344: IF (g_debug > 0)
4345: THEN
4346: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4347: l_line_type_id);
4348: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4349: l_line_category_code);
4350: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||

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

4344: IF (g_debug > 0)
4345: THEN
4346: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4347: l_line_type_id);
4348: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4349: l_line_category_code);
4350: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||
4351: x_product_txn_rec.price_list_id);
4352: END IF;

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

4346: Csd_Gen_Utility_Pvt.ADD('l_line_type_id =' ||
4347: l_line_type_id);
4348: Csd_Gen_Utility_Pvt.ADD('l_line_category_code =' ||
4349: l_line_category_code);
4350: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.price_list_id =' ||
4351: x_product_txn_rec.price_list_id);
4352: END IF;
4353:
4354: -- If line_type_id Or line_category_code is null

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

4381: RAISE Fnd_Api.G_EXC_ERROR;
4382: WHEN TOO_MANY_ROWS THEN
4383: IF (g_debug > 0)
4384: THEN
4385: Csd_Gen_Utility_Pvt.ADD('Too many currency_codes');
4386: END IF;
4387: END;
4388: END IF;
4389:

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

4388: END IF;
4389:
4390: IF (g_debug > 0)
4391: THEN
4392: Csd_Gen_Utility_Pvt.ADD('l_curr_code =' ||
4393: l_curr_code);
4394: END IF;
4395:
4396: -- If l_curr_code is null then raise error

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

4426: x_product_txn_rec.inventory_item_id);
4427: Fnd_Msg_Pub.ADD;
4428: IF (g_debug > 0)
4429: THEN
4430: Csd_Gen_Utility_Pvt.ADD('Serial Number missing for inventory_item_id =' ||
4431: x_product_txn_rec.inventory_item_id);
4432: END IF;
4433: RAISE Fnd_Api.G_EXC_ERROR;
4434: END IF;

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

4441: x_product_txn_rec.currency_code := l_curr_code;
4442: x_product_txn_rec.line_category_code := l_line_category_code;
4443: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4444:
4445: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4446:
4447: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4448: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4449: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,

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

4498: P_UNIT_NUMBER => x_product_txn_rec.unit_number,
4499: P_INTERNAL_PO_HEADER_ID => x_product_txn_rec.internal_po_header_id); -- swai: bug 6148019
4500:
4501:
4502: Csd_Gen_Utility_Pvt.ADD('PRODUCT_TRANSACTION_ID =' ||
4503: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4504: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4505: x_product_txn_rec.repair_line_id);
4506:

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

4500:
4501:
4502: Csd_Gen_Utility_Pvt.ADD('PRODUCT_TRANSACTION_ID =' ||
4503: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4504: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4505: x_product_txn_rec.repair_line_id);
4506:
4507: UPDATE csd_repairs
4508: SET ro_txn_status = 'OM_SUBMITTED'

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

4936:
4937: -- Api body starts
4938: IF (g_debug > 0)
4939: THEN
4940: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
4941: p_api_name => l_api_name);
4942: END IF;
4943: IF (g_debug > 0)
4944: THEN

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

4941: p_api_name => l_api_name);
4942: END IF;
4943: IF (g_debug > 0)
4944: THEN
4945: Csd_Gen_Utility_Pvt.ADD('Check reqd parameter :prod txn Id ');
4946: Csd_Gen_Utility_Pvt.ADD('product txn Id = ' ||
4947: p_product_txn_id);
4948: END IF;
4949:

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

4942: END IF;
4943: IF (g_debug > 0)
4944: THEN
4945: Csd_Gen_Utility_Pvt.ADD('Check reqd parameter :prod txn Id ');
4946: Csd_Gen_Utility_Pvt.ADD('product txn Id = ' ||
4947: p_product_txn_id);
4948: END IF;
4949:
4950: -- Check the required parameter

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

4953: p_api_name => l_api_name);
4954:
4955: IF (g_debug > 0)
4956: THEN
4957: Csd_Gen_Utility_Pvt.ADD('Validate product txn id');
4958: END IF;
4959:
4960: -- Validate the repair line ID
4961: IF NOT

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

4982: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
4983: Fnd_Msg_Pub.ADD;
4984: IF (g_debug > 0)
4985: THEN
4986: Csd_Gen_Utility_Pvt.ADD('Product txn is interfaced,so it cannot be deleted');
4987: END IF;
4988: RAISE Fnd_Api.G_EXC_ERROR;
4989: WHEN TOO_MANY_ROWS THEN
4990: IF (g_debug > 0)

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

4988: RAISE Fnd_Api.G_EXC_ERROR;
4989: WHEN TOO_MANY_ROWS THEN
4990: IF (g_debug > 0)
4991: THEN
4992: Csd_Gen_Utility_Pvt.ADD('Too many from Product txn line is allowed to delete');
4993: END IF;
4994: END;
4995:
4996: IF (g_debug > 0)

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

4994: END;
4995:
4996: IF (g_debug > 0)
4997: THEN
4998: Csd_Gen_Utility_Pvt.ADD('l_delete_allow =' ||
4999: l_delete_allow);
5000: Csd_Gen_Utility_Pvt.ADD('Estimate Detail Id =' ||
5001: l_est_detail_id);
5002: END IF;

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

4996: IF (g_debug > 0)
4997: THEN
4998: Csd_Gen_Utility_Pvt.ADD('l_delete_allow =' ||
4999: l_delete_allow);
5000: Csd_Gen_Utility_Pvt.ADD('Estimate Detail Id =' ||
5001: l_est_detail_id);
5002: END IF;
5003:
5004: IF l_delete_allow = 'Y'

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

5005: THEN
5006: l_Charges_Rec.estimate_detail_id := l_est_detail_id;
5007: IF (g_debug > 0)
5008: THEN
5009: Csd_Gen_Utility_Pvt.ADD('Call process_charge_lines to delete');
5010: END IF;
5011:
5012: PROCESS_CHARGE_LINES(p_api_version => 1.0,
5013: p_commit => Fnd_Api.g_false,

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

5026: END IF;
5027:
5028: IF (g_debug > 0)
5029: THEN
5030: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5031: END IF;
5032:
5033: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5034: END IF; --end of delete

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

5122:
5123: -- Api body starts
5124: IF (g_debug > 0)
5125: THEN
5126: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
5127: p_api_name => l_api_name);
5128: END IF;
5129: IF (g_debug > 0)
5130: THEN

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

5127: p_api_name => l_api_name);
5128: END IF;
5129: IF (g_debug > 0)
5130: THEN
5131: Csd_Gen_Utility_Pvt.ADD('Check the required parameter:(repair_line_id)');
5132: Csd_Gen_Utility_Pvt.ADD('Repair line id =' || p_repair_line_id);
5133: END IF;
5134:
5135: -- Check the required parameter

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

5128: END IF;
5129: IF (g_debug > 0)
5130: THEN
5131: Csd_Gen_Utility_Pvt.ADD('Check the required parameter:(repair_line_id)');
5132: Csd_Gen_Utility_Pvt.ADD('Repair line id =' || p_repair_line_id);
5133: END IF;
5134:
5135: -- Check the required parameter
5136: Csd_Process_Util.Check_Reqd_Param(p_param_value => p_repair_line_id,

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

5138: p_api_name => l_api_name);
5139:
5140: IF (g_debug > 0)
5141: THEN
5142: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
5143: END IF;
5144:
5145: -- Validate the repair line ID
5146: IF NOT

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

5150: END IF;
5151:
5152: IF (g_debug > 0)
5153: THEN
5154: Csd_Gen_Utility_Pvt.ADD('Build the product txn table');
5155: END IF;
5156:
5157: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
5158: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');

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

5170: END IF;
5171:
5172: IF (g_debug > 0)
5173: THEN
5174: Csd_Gen_Utility_Pvt.ADD('x_prod_txn_tbl.count =' ||
5175: x_prod_txn_tbl.COUNT);
5176: END IF;
5177:
5178: IF x_prod_txn_tbl.COUNT > 0 THEN

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

5179: FOR i IN x_prod_txn_tbl.first..1
5180: LOOP
5181:
5182: IF (g_debug > 0 ) THEN
5183: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop');
5184: END IF;
5185:
5186: CREATE_PRODUCT_TXN
5187: (p_api_version => 1.0 ,

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

5205: p_data => x_msg_data,
5206: p_msg_index_out => x_msg_index_out );
5207: l_msg_text := x_msg_data;
5208: IF (g_debug > 0 ) THEN
5209: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);
5210: END IF;
5211: End LOOP;
5212: END LOOP;
5213:

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

5214: FOR i IN 2..x_prod_txn_tbl.last
5215: LOOP
5216:
5217: IF (g_debug > 0 ) THEN
5218: csd_gen_utility_pvt.ADD('Call create_product_txn in a loop 2');
5219: END IF;
5220:
5221: If ((i = 2) and (x_prod_txn_tbl(i).interface_to_om_flag = 'Y') and
5222: (x_prod_txn_tbl(i).new_order_flag = 'Y' or x_prod_txn_tbl(i).new_order_flag is null) and

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

5266: p_data => x_msg_data,
5267: p_msg_index_out => x_msg_index_out );
5268: l_msg_text := x_msg_data;
5269: IF (g_debug > 0 ) THEN
5270: csd_gen_utility_pvt.ADD('message data after create_prod_txn ='||x_msg_data);
5271: END IF;
5272: End LOOP;
5273: END LOOP;
5274: END IF;

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

5471: -- Api body starts
5472: -- ---------------
5473: IF (g_debug > 0)
5474: THEN
5475: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task before jtf_tasks_pub.CREATE_TASK');
5476: END IF;
5477:
5478: -- ----------------------------------------
5479: -- Calling Public JTF API to create a Task

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

5539: X_TASK_ID => x_task_id);
5540:
5541: IF (g_debug > 0)
5542: THEN
5543: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task after jtf_tasks_pub.CREATE_TASK x_return_status' ||
5544: x_return_status);
5545: END IF;
5546:
5547: -- -------------------

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

5640: -- Api body starts
5641: -- ---------------
5642: IF (g_debug > 0)
5643: THEN
5644: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task before jtf_tasks_pub.UPDATE_TASK');
5645: END IF;
5646:
5647: -- ----------------------------------------
5648: -- Calling Public JTF API to Update a Task

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

5709: X_MSG_DATA => x_msg_data);
5710:
5711: IF (g_debug > 0)
5712: THEN
5713: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task after jtf_tasks_pub.UPDATE_TASK x_return_status' ||
5714: x_return_status);
5715: END IF;
5716:
5717: -- -------------------

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

5950: IF (l_check_task > 0)
5951: THEN
5952: IF (g_debug > 0)
5953: THEN
5954: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');
5955: END IF;
5956:
5957: ELSE
5958: -- call the pub after assigning the required variable values

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

6006: -- Api body starts
6007: -- ---------------
6008: IF (g_debug > 0)
6009: THEN
6010: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');
6011: END IF;
6012:
6013: -- travi 020502 OBJECT_VERSION_NUMBER validation
6014:

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

6086: X_Msg_Data => x_msg_data);
6087: --
6088: IF (g_debug > 0)
6089: THEN
6090: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||
6091: x_return_status);
6092: END IF;
6093:
6094: -- -------------------

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

6265: -- add the update TOC/TSC line to Repair history
6266: -- ----------------------------------------------
6267: IF (l_check_id >= 1) THEN
6268: IF (g_debug > 0 ) THEN
6269: csd_gen_utility_pvt.ADD('TC and/or TOC/TSC Exists in Repair History');
6270: END IF;
6271:
6272: -- pick latest row from Repair history
6273: OPEN c_task_hist(p_task_id, p_repair_line_id);

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

6323: -- ---------------
6324: -- Api body starts
6325: -- ---------------
6326: IF (g_debug > 0 ) THEN
6327: csd_gen_utility_pvt.ADD('Before Task to Update Repair History');
6328: END IF;
6329:
6330:
6331: -- travi 020502 OBJECT_VERSION_NUMBER validation

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

6405: X_Msg_Data => x_msg_data
6406: );
6407: --
6408: IF (g_debug > 0 ) THEN
6409: csd_gen_utility_pvt.ADD('After Task to Update Repair History : '||x_return_status);
6410: END IF;
6411:
6412: -- -------------------
6413: -- Api body ends here

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

6543: IF (l_check_task > 0)
6544: THEN
6545: IF (g_debug > 0)
6546: THEN
6547: Csd_Gen_Utility_Pvt.ADD('Task Exists in Repair History');
6548: END IF;
6549:
6550: ELSE
6551: -- call the pub after assigning the required variable values

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

6611: -- Api body starts
6612: -- ---------------
6613: IF (g_debug > 0)
6614: THEN
6615: Csd_Gen_Utility_Pvt.ADD('Before Task to Repair History API call');
6616: END IF;
6617:
6618: -- travi 020502 OBJECT_VERSION_NUMBER validation
6619:

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

6691: X_Msg_Data => x_msg_data);
6692: --
6693: IF (g_debug > 0)
6694: THEN
6695: Csd_Gen_Utility_Pvt.ADD('After Task to Repair History : ' ||
6696: x_return_status);
6697: END IF;
6698:
6699: -- -------------------

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

7111: END IF; -- most outer if
7112: --
7113: IF (g_debug > 0)
7114: THEN
7115: Csd_Gen_Utility_Pvt.ADD('After Task to Update Repair History : ' ||
7116: x_return_status);
7117: END IF;
7118:
7119: -- -------------------

Line 7242: Csd_Gen_Utility_Pvt.dump_api_info

7238: -- Api body starts
7239: --------------------
7240: IF (g_debug > 0)
7241: THEN
7242: Csd_Gen_Utility_Pvt.dump_api_info
7243:
7244: (p_pkg_name => G_PKG_NAME, p_api_name => l_api_name);
7245: END IF;
7246:

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

7256: -- Validate the incident_id
7257:
7258: IF (g_debug > 0)
7259: THEN
7260: Csd_Gen_Utility_Pvt.ADD('Incident Id =' || p_incident_id);
7261: END IF;
7262:
7263: l_validate_flag := Csd_Process_Util.validate_incident_id(p_incident_id);
7264:

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

7265: IF NOT (l_validate_flag)
7266: THEN
7267: IF (g_debug > 0)
7268: THEN
7269: Csd_Gen_Utility_Pvt.ADD('The Incident Id is invalid ');
7270: END IF;
7271:
7272: RAISE Fnd_Api.G_EXC_ERROR;
7273: END IF;

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

7278: LOOP
7279:
7280: IF (g_debug > 0)
7281: THEN
7282: Csd_Gen_Utility_Pvt.ADD('grp.repair_type_ref =' ||
7283: grp.repair_type_ref);
7284: END IF;
7285:
7286: IF grp.repair_type_ref IN ('AE', 'AL')

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

7307: l_ro_rec.status := 'C';
7308:
7309: IF (g_debug > 0)
7310: THEN
7311: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7312: ro.repair_line_id);
7313: END IF;
7314:
7315: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

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

7349: l_grp_rec.repair_group_id := grp.repair_group_id;
7350:
7351: IF (g_debug > 0)
7352: THEN
7353: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7354: grp.repair_group_id);
7355: END IF;
7356:
7357: -- Update Group

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

7401: l_ro_rec.status := 'C';
7402:
7403: IF (g_debug > 0)
7404: THEN
7405: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7406: ro.repair_line_id);
7407: END IF;
7408:
7409: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

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

7443: l_grp_rec.repair_group_id := grp.repair_group_id;
7444:
7445: IF (g_debug > 0)
7446: THEN
7447: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7448: grp.repair_group_id);
7449: END IF;
7450:
7451: -- Update the Group

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

7492: THEN
7493:
7494: IF (g_debug > 0)
7495: THEN
7496: Csd_Gen_Utility_Pvt.ADD('Update Incident Id =' ||
7497: p_incident_id);
7498: END IF;
7499:
7500: BEGIN

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

7593: -- Validate the repair_line_id
7594:
7595: IF (g_debug > 0)
7596: THEN
7597: Csd_Gen_Utility_Pvt.ADD('Update Repair Line ID =' ||
7598: p_repair_line_id);
7599: END IF;
7600:
7601: l_validate_flag := Csd_Process_Util.validate_rep_line_id(p_repair_line_id);

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

7603: IF NOT (l_validate_flag)
7604: THEN
7605: IF (g_debug > 0)
7606: THEN
7607: Csd_Gen_Utility_Pvt.ADD('Repair Line Id is invalid ');
7608: END IF;
7609:
7610: RAISE Fnd_Api.G_EXC_ERROR;
7611: END IF;

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

7669: THEN
7670:
7671: IF (g_debug > 0)
7672: THEN
7673: Csd_Gen_Utility_Pvt.ADD('Update Repair Group Id =' ||
7674: l_repair_group_id);
7675: END IF;
7676:
7677: BEGIN

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

7726: THEN
7727:
7728: IF (g_debug > 0)
7729: THEN
7730: Csd_Gen_Utility_Pvt.ADD('Update Service Request = ' ||
7731: l_incident_id);
7732: END IF;
7733:
7734: -- Update the Service Request

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

7896: BEGIN
7897:
7898: IF (g_debug > 0)
7899: THEN
7900: Csd_Gen_Utility_Pvt.ADD('In Check_Service_Request API');
7901: END IF;
7902:
7903: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7904:

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

7909: FOR rma_so_rec IN RMA_SO_CUR(p_incident_Id)
7910: LOOP
7911: IF (g_debug > 0)
7912: THEN
7913: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
7914: Csd_Gen_Utility_Pvt.ADD('Category[' ||
7915: rma_so_Rec.Line_Category_Code || ']');
7916: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
7917: END IF;

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

7910: LOOP
7911: IF (g_debug > 0)
7912: THEN
7913: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
7914: Csd_Gen_Utility_Pvt.ADD('Category[' ||
7915: rma_so_Rec.Line_Category_Code || ']');
7916: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
7917: END IF;
7918:

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

7912: THEN
7913: Csd_Gen_Utility_Pvt.ADD('Unlinked RMA/SO found ');
7914: Csd_Gen_Utility_Pvt.ADD('Category[' ||
7915: rma_so_Rec.Line_Category_Code || ']');
7916: Csd_Gen_Utility_Pvt.ADD('count[' || rma_so_Rec.line_Count || ']');
7917: END IF;
7918:
7919: IF (rma_so_Rec.Line_Category_Code = 'RETURN')
7920: THEN

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

7957: END IF;
7958:
7959: IF (g_debug > 0)
7960: THEN
7961: Csd_Gen_Utility_Pvt.ADD('Leaving checkService_Request link mode[' ||
7962: TO_CHAR(x_link_mode) || ']');
7963: END IF;
7964:
7965: EXCEPTION

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

8446: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8447: Fnd_Msg_Pub.ADD;
8448: IF (g_debug > 0)
8449: THEN
8450: Csd_Gen_Utility_Pvt.ADD('incident id missing ');
8451: END IF;
8452: RAISE Fnd_Api.g_exc_error;
8453: END IF;
8454:

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

9028:
9029: -- Api body starts
9030: IF (g_debug > 0)
9031: THEN
9032: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,
9033: p_api_name => l_api_name);
9034: END IF;
9035: IF (g_debug > 0)
9036: THEN

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

9033: p_api_name => l_api_name);
9034: END IF;
9035: IF (g_debug > 0)
9036: THEN
9037: Csd_Gen_Utility_Pvt.ADD('Checking required parameter:(repair_line_id)');
9038: END IF;
9039: -- Check the required parameter
9040: Csd_Process_Util.Check_Reqd_Param(p_param_value => p_Repair_Line_id,
9041: p_param_name => 'Repair_Line_Id',

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

9042: p_api_name => l_api_name);
9043: -- Validate Repair_Line_id and check RO status
9044: IF (g_debug > 0)
9045: THEN
9046: Csd_Gen_Utility_Pvt.ADD('Required parameter:(repair_line_id) has value' ||
9047: p_Repair_Line_id);
9048: END IF;
9049: BEGIN
9050: IF (g_debug > 0)

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

9048: END IF;
9049: BEGIN
9050: IF (g_debug > 0)
9051: THEN
9052: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');
9053: END IF;
9054: SELECT dra.status,
9055: dra.Quantity,
9056: dra.Inventory_Item_Id,