DBA Data[Home] [Help]

APPS.CSD_REFURBISH_IRO_GRP dependencies on CSD_PRODUCT_TRANSACTIONS_PKG

Line 1022: csd_product_transactions_pkg.Insert_Row(

1018: -- Insert into Product Transactions table , Insert a row for Action Type Move-In
1019: l_Product_Trxn_Id := NULL ; -- This is just to make sure that new product trasaction id generated
1020: -- It is better to define a new procedure to handle insertions for internal repair orders in csd_process_pvt
1021: -- Then calling table handler directly in group API.
1022: csd_product_transactions_pkg.Insert_Row(
1023: px_PRODUCT_TRANSACTION_ID => l_Product_Trxn_Id, -- find out if this variable needs to be assigned a value
1024: p_REPAIR_LINE_ID => l_Repair_Line_Id ,
1025: p_ESTIMATE_DETAIL_ID => NULL,
1026: p_ACTION_TYPE => C_ACTION_TYPE_MOVE_IN,

Line 1081: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');

1077: -- Following code will not be raised but once I move above code to pvt file then this check will be required
1078: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1079: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1080: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'Create_InternalRO.Insert_Row',
1081: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');
1082: End If;
1083: Raise FND_API.G_EXC_ERROR ;
1084: Else
1085: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then

Line 1087: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');

1083: Raise FND_API.G_EXC_ERROR ;
1084: Else
1085: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
1086: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || 'Create_InternalRO.Insert_Row',
1087: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');
1088: End If;
1089: End If;
1090:
1091: --- Insert into Product Transactions table , Insert a row for Action Type Move-Out

Line 1093: csd_product_transactions_pkg.Insert_Row(

1089: End If;
1090:
1091: --- Insert into Product Transactions table , Insert a row for Action Type Move-Out
1092: l_Product_Trxn_Id := NULL ; -- This is just to make sure that new product trasaction id generated
1093: csd_product_transactions_pkg.Insert_Row(
1094: px_PRODUCT_TRANSACTION_ID => l_Product_Trxn_Id,
1095: p_REPAIR_LINE_ID => l_Repair_Line_Id ,
1096: p_ESTIMATE_DETAIL_ID => NULL,
1097: p_ACTION_TYPE => C_ACTION_TYPE_MOVE_OUT,

Line 1150: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',

1146: -- Add for R12 pickrule id change.Vijay.
1147:
1148: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1149: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1150: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1151: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');
1152: End If;
1153: Raise FND_API.G_EXC_ERROR ;
1154: Else

Line 1151: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');

1147:
1148: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1149: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1150: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1151: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row for Defectives');
1152: End If;
1153: Raise FND_API.G_EXC_ERROR ;
1154: Else
1155: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then

Line 1157: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row for Usables');

1153: Raise FND_API.G_EXC_ERROR ;
1154: Else
1155: If Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level Then
1156: Fnd_Log.String(Fnd_Log.Level_Statement,C_Module || 'Create_InternalRO.Insert_Row',
1157: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row for Usables');
1158: End If;
1159: End If;
1160:
1161: End Loop ;

Line 1199: csd_product_transactions_pkg.Insert_Row(

1195: End If;
1196: End If;
1197: l_Product_Trxn_Id := NULL ; -- This is just to make sure that new product trasaction id generated
1198: -- Insert into Product Transactions table , Insert a row for Action Type Move-In
1199: csd_product_transactions_pkg.Insert_Row(
1200: px_PRODUCT_TRANSACTION_ID => l_Product_Trxn_Id,
1201: p_REPAIR_LINE_ID => l_Repair_Line_Id ,
1202: p_ESTIMATE_DETAIL_ID => NULL,
1203: p_ACTION_TYPE => C_ACTION_TYPE_MOVE_IN,

Line 1256: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',

1252: -- Add for R12 pickrule id change.Vijay.
1253:
1254: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1255: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1256: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1257: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');
1258: End If;
1259: Raise FND_API.G_EXC_ERROR ;
1260: Else

Line 1257: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');

1253:
1254: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1255: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1256: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1257: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');
1258: End If;
1259: Raise FND_API.G_EXC_ERROR ;
1260: Else
1261: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then

Line 1262: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',

1258: End If;
1259: Raise FND_API.G_EXC_ERROR ;
1260: Else
1261: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1262: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1263: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');
1264: End If;
1265: End If;
1266:

Line 1263: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');

1259: Raise FND_API.G_EXC_ERROR ;
1260: Else
1261: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1262: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1263: 'Success : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Defectives');
1264: End If;
1265: End If;
1266:
1267: -- Insert into Product Transactions table , Insert a row for Action Type Move-Out

Line 1269: csd_product_transactions_pkg.Insert_Row(

1265: End If;
1266:
1267: -- Insert into Product Transactions table , Insert a row for Action Type Move-Out
1268: l_Product_Trxn_Id := NULL ; -- This is just to make sure that new product trasaction id generated
1269: csd_product_transactions_pkg.Insert_Row(
1270: px_PRODUCT_TRANSACTION_ID => l_Product_Trxn_Id,
1271: p_REPAIR_LINE_ID => l_Repair_Line_Id ,
1272: p_ESTIMATE_DETAIL_ID => NULL,
1273: p_ACTION_TYPE => C_ACTION_TYPE_MOVE_OUT,

Line 1326: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',

1322: -- Add for R12 pickrule id change.Vijay.
1323:
1324: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1325: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1326: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1327: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');
1328: End If;
1329: Raise FND_API.G_EXC_ERROR ;
1330: Else

Line 1327: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');

1323:
1324: If l_Return_Status <> FND_API.G_RET_STS_SUCCESS Then
1325: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1326: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1327: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');
1328: End If;
1329: Raise FND_API.G_EXC_ERROR ;
1330: Else
1331: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then

Line 1332: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',

1328: End If;
1329: Raise FND_API.G_EXC_ERROR ;
1330: Else
1331: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1332: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1333: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');
1334: End If;
1335: End If;
1336:

Line 1333: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');

1329: Raise FND_API.G_EXC_ERROR ;
1330: Else
1331: If Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level Then
1332: Fnd_Log.String(Fnd_Log.Level_Error,C_Module || 'csd_product_transactions_pkg.Insert_Row',
1333: 'Error : While calling procedure csd_product_transactions_pkg.Insert_Row 2 for Usables');
1334: End If;
1335: End If;
1336:
1337: