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_REPAIR_ACTUALS_PVT dependencies on CSD_REPAIR_ACTUALS

Line 1: PACKAGE BODY CSD_REPAIR_ACTUALS_PVT as

1: PACKAGE BODY CSD_REPAIR_ACTUALS_PVT as
2: /* $Header: csdvactb.pls 120.1 2008/02/09 01:02:32 takwong ship $ csdvactb.pls*/
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 24: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */

20: /* p_api_version NUMBER Req Api Version number */
21: /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
22: /* p_commit VARCHAR2 Opt Commits in API */
23: /* p_validation_level NUMBER Opt validation steps */
24: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
25: /* Output Parm : */
26: /* x_return_status VARCHAR2 Return status after the call. */
27: /* x_msg_count NUMBER Number of messages in stack */
28: /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */

Line 40: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,

36: P_Api_Version IN NUMBER,
37: P_Commit IN VARCHAR2,
38: P_Init_Msg_List IN VARCHAR2,
39: p_validation_level IN NUMBER,
40: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
41: X_Return_Status OUT NOCOPY VARCHAR2,
42: X_Msg_Count OUT NOCOPY NUMBER,
43: X_Msg_Data OUT NOCOPY VARCHAR2
44: )

Line 54: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.CREATE_REPAIR_ACTUALS';

50: l_event_level number := FND_LOG.LEVEL_EVENT;
51: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
52: l_error_level number := FND_LOG.LEVEL_ERROR;
53: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
54: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.CREATE_REPAIR_ACTUALS';
55:
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REPAIR_ACTUALS';
57: l_api_version CONSTANT NUMBER := 1.0;
58: l_msg_count NUMBER;

Line 98: -- ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);

94: -- if the debug level > 5
95: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
96: -- if (g_debug > 5) then
97: -- csd_gen_utility_pvt.dump_actuals_rec
98: -- ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);
99: -- end if;
100:
101: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
102: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Begin Check reqd parameter');

Line 107: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_line_id,

103: END IF;
104:
105: -- Check the required parameter
106: CSD_PROCESS_UTIL.Check_Reqd_Param
107: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_line_id,
108: p_param_name => 'REPAIR_LINE_ID',
109: p_api_name => l_api_name);
110:
111: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 118: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN

114: END IF;
115:
116: -- Validate the repair line ID
117: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
118: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 130: from csd_repair_actuals

126:
127: Begin
128: select count(*)
129: into l_act_count
130: from csd_repair_actuals
131: where repair_line_id = px_CSD_REPAIR_ACTUALS_REC.repair_line_id;
132: Exception
133: when others then
134: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 131: where repair_line_id = px_CSD_REPAIR_ACTUALS_REC.repair_line_id;

127: Begin
128: select count(*)
129: into l_act_count
130: from csd_repair_actuals
131: where repair_line_id = px_CSD_REPAIR_ACTUALS_REC.repair_line_id;
132: Exception
133: when others then
134: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
135: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception error :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line 141: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Actuals already exists for the repair line Id: '||px_CSD_REPAIR_ACTUALS_REC.repair_line_id);

137: End;
138:
139: IF l_act_count > 0 then
140: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
141: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Actuals already exists for the repair line Id: '||px_CSD_REPAIR_ACTUALS_REC.repair_line_id);
142: END IF;
143:
144: FND_MESSAGE.SET_NAME('CSD','CSD_API_ACTUALS_EXISTS');
145: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',px_CSD_REPAIR_ACTUALS_REC.repair_line_id);

Line 145: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',px_CSD_REPAIR_ACTUALS_REC.repair_line_id);

141: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Actuals already exists for the repair line Id: '||px_CSD_REPAIR_ACTUALS_REC.repair_line_id);
142: END IF;
143:
144: FND_MESSAGE.SET_NAME('CSD','CSD_API_ACTUALS_EXISTS');
145: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',px_CSD_REPAIR_ACTUALS_REC.repair_line_id);
146: FND_MSG_PUB.ADD;
147:
148: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
149: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);

Line 156: px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER := 1;

152: RAISE FND_API.G_EXC_ERROR;
153: End IF;
154:
155: -- Assigning object version number
156: px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER := 1;
157:
158: --
159: -- API body
160: --

Line 162: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Insert_Row');

158: --
159: -- API body
160: --
161: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
162: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Insert_Row');
163: END IF;
164:
165: BEGIN
166:

Line 167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)

163: END IF;
164:
165: BEGIN
166:
167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)
168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(
169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID

Line 168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(

164:
165: BEGIN
166:
167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)
168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(
169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
172: ,p_CREATED_BY => FND_GLOBAL.USER_ID

Line 169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID

165: BEGIN
166:
167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)
168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(
169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
172: ,p_CREATED_BY => FND_GLOBAL.USER_ID
173: ,p_CREATION_DATE => SYSDATE

Line 170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER

166:
167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)
168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(
169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
172: ,p_CREATED_BY => FND_GLOBAL.USER_ID
173: ,p_CREATION_DATE => SYSDATE
174: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID

167: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Insert_Row)
168: CSD_REPAIR_ACTUALS_PKG.Insert_Row(
169: px_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
170: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
171: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
172: ,p_CREATED_BY => FND_GLOBAL.USER_ID
173: ,p_CREATION_DATE => SYSDATE
174: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
175: ,p_LAST_UPDATE_DATE => SYSDATE

Line 177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY

173: ,p_CREATION_DATE => SYSDATE
174: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
175: ,p_LAST_UPDATE_DATE => SYSDATE
176: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4

Line 178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1

174: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
175: ,p_LAST_UPDATE_DATE => SYSDATE
176: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5

Line 179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2

175: ,p_LAST_UPDATE_DATE => SYSDATE
176: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6

Line 180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3

176: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7

Line 181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4

177: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8

Line 182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5

178: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9

Line 183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6

179: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10

Line 184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7

180: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11

Line 185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8

181: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12

Line 186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9

182: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13

Line 187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10

183: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14

Line 188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11

184: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15

Line 189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12

185: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID

Line 190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13

186: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID

Line 191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14

187: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID

Line 192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15

188: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
196: );

Line 193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID

189: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
196: );
197:

Line 194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID

190: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
196: );
197:
198: EXCEPTION

Line 195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID

191: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
192: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
193: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
194: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
195: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
196: );
197:
198: EXCEPTION
199: WHEN OTHERS THEN

Line 201: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception n CSD_REPAIR_ACTUALS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
201: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception n CSD_REPAIR_ACTUALS_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
202: END IF;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END;
205:

Line 275: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */

271: /* p_api_version NUMBER Req Api Version number */
272: /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
273: /* p_commit VARCHAR2 Opt Commits in API */
274: /* p_validation_level NUMBER Opt validation steps */
275: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
276: /* Output Parm : */
277: /* x_return_status VARCHAR2 Return status after the call. */
278: /* x_msg_count NUMBER Number of messages in stack */
279: /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */

Line 291: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,

287: P_Api_Version IN NUMBER,
288: P_Commit IN VARCHAR2,
289: P_Init_Msg_List IN VARCHAR2,
290: p_validation_level IN NUMBER,
291: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
292: X_Return_Status OUT NOCOPY VARCHAR2,
293: X_Msg_Count OUT NOCOPY NUMBER,
294: X_Msg_Data OUT NOCOPY VARCHAR2
295: )

Line 305: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.UPDATE_REPAIR_ACTUALS';

301: l_event_level number := FND_LOG.LEVEL_EVENT;
302: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
303: l_error_level number := FND_LOG.LEVEL_ERROR;
304: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
305: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.UPDATE_REPAIR_ACTUALS';
306:
307: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REPAIR_ACTUALS';
308: l_api_version CONSTANT NUMBER := 1.0;
309: l_msg_count NUMBER;

Line 321: FROM csd_repair_actuals a,

317: CURSOR repair_actual(p_actual_id IN NUMBER) IS
318: SELECT
319: a.repair_actual_id,
320: a.object_version_number
321: FROM csd_repair_actuals a,
322: csd_repairs b
323: WHERE a.repair_line_id = b.repair_line_id
324: and a.repair_actual_id = p_actual_id;
325:

Line 358: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,

354: END IF;
355:
356: -- Check the required parameter
357: CSD_PROCESS_UTIL.Check_Reqd_Param
358: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,
359: p_param_name => 'REPAIR_ACTUAL_ID',
360: p_api_name => l_api_name);
361:
362: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 369: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN

365: END IF;
366:
367: -- Validate the repair line ID
368: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
369: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 377: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

373: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
374: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
375: END IF;
376:
377: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
378:
379: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
380: FETCH repair_actual
381: INTO l_actual_id,

Line 379: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);

375: END IF;
376:
377: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
378:
379: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
380: FETCH repair_actual
381: INTO l_actual_id,
382: l_obj_ver_num;
383:

Line 404: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

400: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
401: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number');
402: END IF;
403:
404: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
405:
406: -- Modified the message name for bugfix 3281321. vkjain.
407: -- FND_MESSAGE.SET_NAME('CSD','CSD_OBJ_VER_MISMATCH');
408: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_OBJ_VER_MISMATCH');

Line 419: px_CSD_REPAIR_ACTUALS_REC.object_version_number := l_obj_ver_num+1;

415: END IF;
416:
417:
418: -- Assigning object version number
419: px_CSD_REPAIR_ACTUALS_REC.object_version_number := l_obj_ver_num+1;
420:
421: --
422: -- API body
423: --

Line 425: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Update_Row');

421: --
422: -- API body
423: --
424: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
425: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Update_Row');
426: END IF;
427:
428: BEGIN
429:

Line 430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)

426: END IF;
427:
428: BEGIN
429:
430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)
431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID

Line 431: CSD_REPAIR_ACTUALS_PKG.Update_Row(

427:
428: BEGIN
429:
430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)
431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM

Line 432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID

428: BEGIN
429:
430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)
431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM
436: ,p_CREATION_DATE => FND_API.G_MISS_DATE

Line 433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER

429:
430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)
431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM
436: ,p_CREATION_DATE => FND_API.G_MISS_DATE
437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID

430: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Update_Row)
431: CSD_REPAIR_ACTUALS_PKG.Update_Row(
432: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
433: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER
434: ,p_REPAIR_LINE_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID
435: ,p_CREATED_BY => FND_API.G_MISS_NUM
436: ,p_CREATION_DATE => FND_API.G_MISS_DATE
437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
438: ,p_LAST_UPDATE_DATE => SYSDATE

Line 440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY

436: ,p_CREATION_DATE => FND_API.G_MISS_DATE
437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
438: ,p_LAST_UPDATE_DATE => SYSDATE
439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4

Line 441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1

437: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
438: ,p_LAST_UPDATE_DATE => SYSDATE
439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5

Line 442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2

438: ,p_LAST_UPDATE_DATE => SYSDATE
439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6

Line 443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3

439: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7

Line 444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4

440: ,p_ATTRIBUTE_CATEGORY => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE_CATEGORY
441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8

Line 445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5

441: ,p_ATTRIBUTE1 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE1
442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9

Line 446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6

442: ,p_ATTRIBUTE2 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE2
443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10

Line 447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7

443: ,p_ATTRIBUTE3 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE3
444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11

Line 448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8

444: ,p_ATTRIBUTE4 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE4
445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12

Line 449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9

445: ,p_ATTRIBUTE5 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE5
446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13

Line 450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10

446: ,p_ATTRIBUTE6 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE6
447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14

Line 451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11

447: ,p_ATTRIBUTE7 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE7
448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15

Line 452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12

448: ,p_ATTRIBUTE8 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE8
449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID

Line 453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13

449: ,p_ATTRIBUTE9 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE9
450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID

Line 454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14

450: ,p_ATTRIBUTE10 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE10
451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID

Line 455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15

451: ,p_ATTRIBUTE11 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE11
452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
459: );

Line 456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID

452: ,p_ATTRIBUTE12 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE12
453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
459: );
460: --

Line 457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID

453: ,p_ATTRIBUTE13 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE13
454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
459: );
460: --
461: -- End of API body.

Line 458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID

454: ,p_ATTRIBUTE14 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE14
455: ,p_ATTRIBUTE15 => px_CSD_REPAIR_ACTUALS_REC.ATTRIBUTE15
456: ,p_BILL_TO_ACCOUNT_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_ACCOUNT_ID
457: ,p_BILL_TO_PARTY_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_ID
458: ,p_BILL_TO_PARTY_SITE_ID => px_CSD_REPAIR_ACTUALS_REC.BILL_TO_PARTY_SITE_ID
459: );
460: --
461: -- End of API body.
462: --

Line 467: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
467: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Update_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
468: END IF;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END;
471:

Line 540: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */

536: /* p_api_version NUMBER Req Api Version number */
537: /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
538: /* p_commit VARCHAR2 Opt Commits in API */
539: /* p_validation_level NUMBER Opt validation steps */
540: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
541: /* Output Parm : */
542: /* x_return_status VARCHAR2 Return status after the call. */
543: /* x_msg_count NUMBER Number of messages in stack */
544: /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */

Line 556: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,

552: P_Api_Version IN NUMBER,
553: P_Commit IN VARCHAR2,
554: P_Init_Msg_List IN VARCHAR2,
555: p_validation_level IN NUMBER,
556: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
557: X_Return_Status OUT NOCOPY VARCHAR2,
558: X_Msg_Count OUT NOCOPY NUMBER,
559: X_Msg_Data OUT NOCOPY VARCHAR2
560: )

Line 570: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.DELETE_REPAIR_ACTUALS';

566: l_event_level number := FND_LOG.LEVEL_EVENT;
567: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
568: l_error_level number := FND_LOG.LEVEL_ERROR;
569: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
570: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.DELETE_REPAIR_ACTUALS';
571:
572: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REPAIR_ACTUALS';
573: l_api_version CONSTANT NUMBER := 1.0;
574: l_msg_count NUMBER;

Line 586: FROM csd_repair_actuals a,

582: CURSOR repair_actual(p_actual_id IN NUMBER) IS
583: SELECT
584: a.repair_actual_id,
585: a.object_version_number
586: FROM csd_repair_actuals a,
587: csd_repairs b
588: WHERE a.repair_line_id = b.repair_line_id
589: and a.repair_actual_id = p_actual_id;
590:

Line 623: ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);

619: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
620: /* TBD
621: if (g_debug > 5) then
622: csd_gen_utility_pvt.dump_actuals_rec
623: ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);
624: end if;
625: */
626: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
627: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Begin Check reqd paramete');

Line 632: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,

628: END IF;
629:
630: -- Check the required parameter
631: CSD_PROCESS_UTIL.Check_Reqd_Param
632: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,
633: p_param_name => 'REPAIR_ACTUAL_ID',
634: p_api_name => l_api_name);
635:
636: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 643: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN

639: END IF;
640:
641: -- Validate the repair line ID
642: IF NOT( CSD_PROCESS_UTIL.Validate_rep_line_id
643: ( p_repair_line_id => px_CSD_REPAIR_ACTUALS_REC.repair_line_id )) THEN
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646:
647: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 651: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

647: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
648: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'End Validate Repair Line id');
649: END IF;
650:
651: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
652:
653: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
654: FETCH repair_actual
655: INTO l_actual_id,

Line 653: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);

649: END IF;
650:
651: IF NVL(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
652:
653: OPEN repair_actual(px_CSD_REPAIR_ACTUALS_REC.repair_actual_id);
654: FETCH repair_actual
655: INTO l_actual_id,
656: l_obj_ver_num;
657:

Line 678: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN

674: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
675: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Validate Object Version Number');
676: END IF;
677:
678: IF NVL(px_CSD_REPAIR_ACTUALS_REC.object_version_number,FND_API.G_MISS_NUM) <>l_obj_ver_num THEN
679: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
680: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Object Version Number does not match'
681: || ' for the Repair Actual ID = ' || l_actual_id);
682: END IF;

Line 714: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID', px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID);

710: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Actual Lines exists for the Repair Order');
711: END IF;
712:
713: FND_MESSAGE.SET_NAME('CSD','CSD_ACTUAL_LINE_EXISTS');
714: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID', px_CSD_REPAIR_ACTUALS_REC.REPAIR_LINE_ID);
715: FND_MSG_PUB.ADD;
716: IF (Fnd_Log.Level_Error >= Fnd_Log.G_Current_Runtime_Level) THEN
717: FND_LOG.MESSAGE(Fnd_Log.Level_Error,l_mod_name, FALSE);
718: END IF;

Line 727: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Delete_Row');

723: --
724: -- API body
725: --
726: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
727: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Delete_Row');
728: END IF;
729:
730: BEGIN
731:

Line 732: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Delete_Row)

728: END IF;
729:
730: BEGIN
731:
732: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Delete_Row)
733: CSD_REPAIR_ACTUALS_PKG.Delete_Row(
734: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
735: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
736:

Line 733: CSD_REPAIR_ACTUALS_PKG.Delete_Row(

729:
730: BEGIN
731:
732: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Delete_Row)
733: CSD_REPAIR_ACTUALS_PKG.Delete_Row(
734: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
735: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
736:
737: EXCEPTION

Line 734: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID

730: BEGIN
731:
732: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Delete_Row)
733: CSD_REPAIR_ACTUALS_PKG.Delete_Row(
734: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
735: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
736:
737: EXCEPTION
738: WHEN OTHERS THEN

Line 735: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);

731:
732: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Delete_Row)
733: CSD_REPAIR_ACTUALS_PKG.Delete_Row(
734: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
735: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 812: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */

808: /* p_api_version NUMBER Req Api Version number */
809: /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
810: /* p_commit VARCHAR2 Opt Commits in API */
811: /* p_validation_level NUMBER Opt validation steps */
812: /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
813: /* Output Parm : */
814: /* x_return_status VARCHAR2 Return status after the call. */
815: /* x_msg_count NUMBER Number of messages in stack */
816: /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */

Line 828: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,

824: P_Api_Version IN NUMBER,
825: P_Commit IN VARCHAR2,
826: P_Init_Msg_List IN VARCHAR2,
827: p_validation_level IN NUMBER,
828: px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
829: X_Return_Status OUT NOCOPY VARCHAR2,
830: X_Msg_Count OUT NOCOPY NUMBER,
831: X_Msg_Data OUT NOCOPY VARCHAR2
832: )

Line 841: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.LOCK_REPAIR_ACTUALS';

837: l_event_level number := FND_LOG.LEVEL_EVENT;
838: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
839: l_error_level number := FND_LOG.LEVEL_ERROR;
840: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
841: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PVT.LOCK_REPAIR_ACTUALS';
842:
843: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_REPAIR_ACTUALS';
844: l_api_version CONSTANT NUMBER := 1.0;
845: l_msg_count NUMBER;

Line 879: -- ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);

875: -- if the debug level > 5
876: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
877: -- if (g_debug > 5) then
878: -- csd_gen_utility_pvt.dump_actuals_rec
879: -- ( p_CSD_REPAIR_ACTUALS_REC => px_CSD_REPAIR_ACTUALS_REC);
880: -- end if;
881:
882: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN
883: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'Begin Check reqd parameter');

Line 888: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,

884: END IF;
885:
886: -- Check the required parameter
887: CSD_PROCESS_UTIL.Check_Reqd_Param
888: ( p_param_value => px_CSD_REPAIR_ACTUALS_REC.repair_actual_id,
889: p_param_name => 'REPAIR_ACTUAL_ID',
890: p_api_name => l_api_name);
891:
892: IF ( Fnd_Log.Level_Statement >= G_debug_level) THEN

Line 900: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Lock_Row');

896: --
897: -- API body
898: --
899: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
900: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUALS_PKG.Lock_Row');
901: END IF;
902:
903: BEGIN
904:

Line 905: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Lock_Row)

901: END IF;
902:
903: BEGIN
904:
905: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Lock_Row)
906: CSD_REPAIR_ACTUALS_PKG.Lock_Row(
907: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
908: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
909:

Line 906: CSD_REPAIR_ACTUALS_PKG.Lock_Row(

902:
903: BEGIN
904:
905: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Lock_Row)
906: CSD_REPAIR_ACTUALS_PKG.Lock_Row(
907: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
908: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
909:
910: EXCEPTION

Line 907: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID

903: BEGIN
904:
905: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Lock_Row)
906: CSD_REPAIR_ACTUALS_PKG.Lock_Row(
907: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
908: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
909:
910: EXCEPTION
911: WHEN OTHERS THEN

Line 908: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);

904:
905: -- Invoke table handler(CSD_REPAIR_ACTUALS_PKG.Lock_Row)
906: CSD_REPAIR_ACTUALS_PKG.Lock_Row(
907: p_REPAIR_ACTUAL_ID => px_CSD_REPAIR_ACTUALS_REC.REPAIR_ACTUAL_ID
908: ,p_OBJECT_VERSION_NUMBER => px_CSD_REPAIR_ACTUALS_REC.OBJECT_VERSION_NUMBER);
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 913: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN
913: FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUALS_PKG.Lock_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
914: END IF;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END;
917:

Line 974: End CSD_REPAIR_ACTUALS_PVT;

970: p_data => x_msg_data );
971:
972: END LOCK_REPAIR_ACTUALS;
973:
974: End CSD_REPAIR_ACTUALS_PVT;