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.AHL_PRD_NONROUTINE_PUB dependencies on FND_API

Line 46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

42: ------------------------------------------------------------------------------------------------------------------
43: PROCEDURE CREATE_NON_ROUTINE
44: (
45: p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_user_id IN VARCHAR2:=NULL,

Line 47: p_commit IN VARCHAR2 := FND_API.G_FALSE,

43: PROCEDURE CREATE_NON_ROUTINE
44: (
45: p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_user_id IN VARCHAR2:=NULL,
51: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,

Line 48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

44: (
45: p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: p_module_type IN VARCHAR2,
50: p_user_id IN VARCHAR2:=NULL,
51: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,
52: p_matrl_reqrs_for_nr_tbl IN MATERIAL_REQUIREMENTS_TBL,

Line 82: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN

78: SAVEPOINT CREATE_NON_ROUTINE_SP;
79:
80: IF(p_module_type = 'BPEL') THEN
81: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_user_id);
82: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: END IF;
86:

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79:
80: IF(p_module_type = 'BPEL') THEN
81: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_user_id);
82: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: END IF;
86:
87:

Line 89: x_return_status:= FND_API.G_RET_STS_SUCCESS;

85: END IF;
86:
87:
88: -- Initialize return status to success before any code logic/validation
89: x_return_status:= FND_API.G_RET_STS_SUCCESS;
90:
91: -- Standard call to check for call compatibility
92: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
93: THEN

Line 92: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

88: -- Initialize return status to success before any code logic/validation
89: x_return_status:= FND_API.G_RET_STS_SUCCESS;
90:
91: -- Standard call to check for call compatibility
92: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90:
91: -- Standard call to check for call compatibility
92: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
98: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 97: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
98: IF FND_API.TO_BOOLEAN(p_init_msg_list)
99: THEN
100: FND_MSG_PUB.INITIALIZE;
101: END IF;

Line 98: IF FND_API.TO_BOOLEAN(p_init_msg_list)

94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
98: IF FND_API.TO_BOOLEAN(p_init_msg_list)
99: THEN
100: FND_MSG_PUB.INITIALIZE;
101: END IF;
102:

Line 112: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)

108: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
109: END IF;
110:
111: -- If the originator wo id is present
112: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)
113: OR
114: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
115: )
116: THEN

Line 114: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)

110:
111: -- If the originator wo id is present
112: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)
113: OR
114: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
115: )
116: THEN
117: -- populate the record to be passed to AHL_PRD_NONROUTINE_PVT
118: POPULATE_CREATE_SR_INPUT_REC(p_create_nr_input_rec,x_sr_task_rec);

Line 127: FND_API.G_TRUE,

123: END IF;
124: -- Call the API to create the SR and workorder
125: AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job (
126: 1.0,
127: FND_API.G_TRUE,
128: FND_API.G_FALSE,
129: FND_API.G_VALID_LEVEL_FULL,
130: 'JSP',
131: x_return_status,

Line 128: FND_API.G_FALSE,

124: -- Call the API to create the SR and workorder
125: AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job (
126: 1.0,
127: FND_API.G_TRUE,
128: FND_API.G_FALSE,
129: FND_API.G_VALID_LEVEL_FULL,
130: 'JSP',
131: x_return_status,
132: x_msg_count,

Line 129: FND_API.G_VALID_LEVEL_FULL,

125: AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job (
126: 1.0,
127: FND_API.G_TRUE,
128: FND_API.G_FALSE,
129: FND_API.G_VALID_LEVEL_FULL,
130: 'JSP',
131: x_return_status,
132: x_msg_count,
133: x_msg_data,

Line 142: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

138: IF (l_log_statement >= l_log_current_level) THEN
139: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job');
140: END IF;
141:
142: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
143: IF (l_log_statement >= l_log_current_level) THEN
144: fnd_log.string(fnd_log.level_statement,l_debug_module,'Call to AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job, Not Success');
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;

Line 146: RAISE FND_API.G_EXC_ERROR;

142: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
143: IF (l_log_statement >= l_log_current_level) THEN
144: fnd_log.string(fnd_log.level_statement,l_debug_module,'Call to AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job, Not Success');
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149: -- Get the params for output
150: p_sr_task_rec := p_x_sr_task_tbl(1);

Line 158: IF ( (p_material_req_rec.INVENTORY_ITEM_ID IS NOT NULL AND p_material_req_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM )

154:
155: IF (p_matrl_reqrs_for_nr_tbl.count > 0) THEN
156: p_material_req_rec := p_matrl_reqrs_for_nr_tbl(p_matrl_reqrs_for_nr_tbl.FIRST);
157: -- Material Requirements are considered only atleast one of id or name is present
158: IF ( (p_material_req_rec.INVENTORY_ITEM_ID IS NOT NULL AND p_material_req_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM )
159: OR
160: (p_material_req_rec.ITEM_NUMBER IS NOT NULL AND p_material_req_rec.ITEM_NUMBER <> FND_API.G_MISS_CHAR )
161: )
162: THEN

Line 160: (p_material_req_rec.ITEM_NUMBER IS NOT NULL AND p_material_req_rec.ITEM_NUMBER <> FND_API.G_MISS_CHAR )

156: p_material_req_rec := p_matrl_reqrs_for_nr_tbl(p_matrl_reqrs_for_nr_tbl.FIRST);
157: -- Material Requirements are considered only atleast one of id or name is present
158: IF ( (p_material_req_rec.INVENTORY_ITEM_ID IS NOT NULL AND p_material_req_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM )
159: OR
160: (p_material_req_rec.ITEM_NUMBER IS NOT NULL AND p_material_req_rec.ITEM_NUMBER <> FND_API.G_MISS_CHAR )
161: )
162: THEN
163: IF (l_log_statement >= l_log_current_level) THEN
164: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling POPULATE_CREATE_MTRL_INPUT_REC');

Line 179: FND_API.G_TRUE,

175:
176: -- MANESING::NR Analysis, 03-Jun-2011, added p_module_type (null) in the API signature
177: AHL_PP_MATERIALS_PVT.Create_Material_Reqst (
178: 1.0,
179: FND_API.G_TRUE,
180: Fnd_Api.G_FALSE,
181: FND_API.G_VALID_LEVEL_FULL,
182: null,
183: 'Y',

Line 180: Fnd_Api.G_FALSE,

176: -- MANESING::NR Analysis, 03-Jun-2011, added p_module_type (null) in the API signature
177: AHL_PP_MATERIALS_PVT.Create_Material_Reqst (
178: 1.0,
179: FND_API.G_TRUE,
180: Fnd_Api.G_FALSE,
181: FND_API.G_VALID_LEVEL_FULL,
182: null,
183: 'Y',
184: x_req_material_tbl,

Line 181: FND_API.G_VALID_LEVEL_FULL,

177: AHL_PP_MATERIALS_PVT.Create_Material_Reqst (
178: 1.0,
179: FND_API.G_TRUE,
180: Fnd_Api.G_FALSE,
181: FND_API.G_VALID_LEVEL_FULL,
182: null,
183: 'Y',
184: x_req_material_tbl,
185: x_job_return_status,

Line 191: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

187: x_msg_count,
188: x_msg_data
189: );
190:
191: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
192: IF (l_log_statement >= l_log_current_level) THEN
193: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
194: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
195: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');

Line 198: -- RAISE FND_API.G_EXC_ERROR;

194: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
195: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');
196: FND_MSG_PUB.ADD;
197: END IF;
198: -- RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201:
202: ELSE

Line 215: FND_API.G_TRUE,

211: POPULATE_CREATE_NR_INPUT_REC(p_create_nr_input_rec,x_nr_task_rec);
212: AHL_UMP_NONROUTINES_PVT.Create_SR
213: (
214: 1.0,
215: FND_API.G_TRUE,
216: FND_API.G_FALSE,
217: FND_API.G_VALID_LEVEL_FULL,
218: FND_API.G_FALSE,
219: 'JSP',

Line 216: FND_API.G_FALSE,

212: AHL_UMP_NONROUTINES_PVT.Create_SR
213: (
214: 1.0,
215: FND_API.G_TRUE,
216: FND_API.G_FALSE,
217: FND_API.G_VALID_LEVEL_FULL,
218: FND_API.G_FALSE,
219: 'JSP',
220: x_return_status,

Line 217: FND_API.G_VALID_LEVEL_FULL,

213: (
214: 1.0,
215: FND_API.G_TRUE,
216: FND_API.G_FALSE,
217: FND_API.G_VALID_LEVEL_FULL,
218: FND_API.G_FALSE,
219: 'JSP',
220: x_return_status,
221: x_msg_count,

Line 218: FND_API.G_FALSE,

214: 1.0,
215: FND_API.G_TRUE,
216: FND_API.G_FALSE,
217: FND_API.G_VALID_LEVEL_FULL,
218: FND_API.G_FALSE,
219: 'JSP',
220: x_return_status,
221: x_msg_count,
222: x_msg_data,

Line 229: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

225: IF (l_log_statement >= l_log_current_level) THEN
226: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_UMP_NONROUTINES_PVT.Create_SR');
227: END IF;
228:
229: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
230: IF (l_log_statement >= l_log_current_level) THEN
231: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_UMP_NONROUTINES_PVT.Create_SR');
232: END IF;
233: RAISE FND_API.G_EXC_ERROR;

Line 233: RAISE FND_API.G_EXC_ERROR;

229: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
230: IF (l_log_statement >= l_log_current_level) THEN
231: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_UMP_NONROUTINES_PVT.Create_SR');
232: END IF;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: POPULATE_CREATE_NR_OUTPUT_REC(x_create_nr_output_rec,x_nr_task_rec);
236:
237: -- Added

Line 238: IF FND_API.TO_BOOLEAN(p_commit) THEN

234: END IF;
235: POPULATE_CREATE_NR_OUTPUT_REC(x_create_nr_output_rec,x_nr_task_rec);
236:
237: -- Added
238: IF FND_API.TO_BOOLEAN(p_commit) THEN
239: COMMIT WORK;
240: END IF;
241: END IF;
242:

Line 244: IF FND_API.TO_BOOLEAN(p_commit) THEN

240: END IF;
241: END IF;
242:
243: -- Standard check of p_commit
244: IF FND_API.TO_BOOLEAN(p_commit) THEN
245: COMMIT WORK;
246: END IF;
247:
248: IF (G_DEBUG = 'Y') THEN

Line 254: ( p_encoded => fnd_api.g_false,

250: END IF;
251:
252: -- Count and Get messages
253: FND_MSG_PUB.count_and_get
254: ( p_encoded => fnd_api.g_false,
255: p_count => x_msg_count,
256: p_data => x_msg_data
257: );
258:

Line 265: WHEN FND_API.G_EXC_ERROR THEN

261: AHL_DEBUG_PUB.disable_debug;
262: END IF;
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: ROLLBACK TO CREATE_NON_ROUTINE_SP;
268: x_msg_count := FND_MSG_PUB.Count_Msg;
269: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: END IF;
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: ROLLBACK TO CREATE_NON_ROUTINE_SP;
268: x_msg_count := FND_MSG_PUB.Count_Msg;
269: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: x_return_status := FND_API.G_RET_STS_ERROR;
267: ROLLBACK TO CREATE_NON_ROUTINE_SP;
268: x_msg_count := FND_MSG_PUB.Count_Msg;
269: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO CREATE_NON_ROUTINE_SP;
274: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: x_msg_count := FND_MSG_PUB.Count_Msg;
269: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO CREATE_NON_ROUTINE_SP;
274: x_msg_count := FND_MSG_PUB.Count_Msg;
275: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
276:

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

274: x_msg_count := FND_MSG_PUB.Count_Msg;
275: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
276:
277: WHEN OTHERS THEN
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: ROLLBACK TO CREATE_NON_ROUTINE_SP;
280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.add_exc_msg

Line 318: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)

314: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
315: END IF;
316:
317: -- If Workorder ID as well Workorder number are present, honour the id
318: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)
319: and
320: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
321: )
322: THEN

Line 320: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)

316:
317: -- If Workorder ID as well Workorder number are present, honour the id
318: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)
319: and
320: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
321: )
322: THEN
323: x_sr_task_rec.Originating_wo_id := p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
324: BEGIN

Line 339: RAISE FND_API.G_EXC_ERROR;

335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
338: FND_MSG_PUB.ADD;
339: RAISE FND_API.G_EXC_ERROR;
340: WHEN TOO_MANY_ROWS THEN
341: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;

Line 343: RAISE FND_API.G_EXC_ERROR;

339: RAISE FND_API.G_EXC_ERROR;
340: WHEN TOO_MANY_ROWS THEN
341: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END;
345: ELSIF
346: ( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NULL OR p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID = FND_API.G_MISS_NUM )
347: and

Line 346: ( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NULL OR p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID = FND_API.G_MISS_NUM )

342: FND_MSG_PUB.ADD;
343: RAISE FND_API.G_EXC_ERROR;
344: END;
345: ELSIF
346: ( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NULL OR p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID = FND_API.G_MISS_NUM )
347: and
348: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
349: )
350: THEN

Line 348: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)

344: END;
345: ELSIF
346: ( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NULL OR p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID = FND_API.G_MISS_NUM )
347: and
348: (p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER <> FND_API.G_MISS_CHAR)
349: )
350: THEN
351: BEGIN
352: SELECT CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id

Line 366: RAISE FND_API.G_EXC_ERROR;

362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
365: FND_MSG_PUB.ADD;
366: RAISE FND_API.G_EXC_ERROR;
367: WHEN TOO_MANY_ROWS THEN
368: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: RAISE FND_API.G_EXC_ERROR;
367: WHEN TOO_MANY_ROWS THEN
368: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END;
372: ELSE
373: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
374: FND_MSG_PUB.ADD;

Line 375: RAISE FND_API.G_EXC_ERROR;

371: END;
372: ELSE
373: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
374: FND_MSG_PUB.ADD;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: -- populate the request date
379: x_sr_task_rec.request_date := p_create_nr_input_rec.service_request_date;

Line 387: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

383:
384: -- populate the operation type
385: x_sr_task_rec.operation_type := 'CREATE';
386:
387: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
388: x_sr_task_rec.Type_name := p_create_nr_input_rec.service_request_type;
389: END IF;
390:
391: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

Line 391: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

387: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
388: x_sr_task_rec.Type_name := p_create_nr_input_rec.service_request_type;
389: END IF;
390:
391: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
392: x_sr_task_rec.Status_name := p_create_nr_input_rec.service_request_status;
393: END IF;
394:
395: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN

Line 395: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN

391: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
392: x_sr_task_rec.Status_name := p_create_nr_input_rec.service_request_status;
393: END IF;
394:
395: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN
396: x_sr_task_rec.Problem_code := p_create_nr_input_rec.problem_code;
397: END IF;
398:
399: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN

Line 399: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN

395: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN
396: x_sr_task_rec.Problem_code := p_create_nr_input_rec.problem_code;
397: END IF;
398:
399: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN
400: x_sr_task_rec.Severity_name := p_create_nr_input_rec.severity_name;
401: END IF;
402:
403: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN

Line 403: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN

399: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN
400: x_sr_task_rec.Severity_name := p_create_nr_input_rec.severity_name;
401: END IF;
402:
403: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN
404: x_sr_task_rec.Contact_type := p_create_nr_input_rec.contact_type;
405: END IF;
406:
407: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN

Line 407: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN

403: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN
404: x_sr_task_rec.Contact_type := p_create_nr_input_rec.contact_type;
405: END IF;
406:
407: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN
408: x_sr_task_rec.contact_name := p_create_nr_input_rec.contact_name;
409: END IF;
410:
411: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN

Line 411: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN

407: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN
408: x_sr_task_rec.contact_name := p_create_nr_input_rec.contact_name;
409: END IF;
410:
411: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN
412: x_sr_task_rec.resolution_meaning := p_create_nr_input_rec.resolution_code_meaning;
413: END IF;
414:
415: IF p_create_nr_input_rec.estimated_duration <> fnd_api.g_miss_num AND p_create_nr_input_rec.estimated_duration IS NOT NULL THEN

Line 415: IF p_create_nr_input_rec.estimated_duration <> fnd_api.g_miss_num AND p_create_nr_input_rec.estimated_duration IS NOT NULL THEN

411: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN
412: x_sr_task_rec.resolution_meaning := p_create_nr_input_rec.resolution_code_meaning;
413: END IF;
414:
415: IF p_create_nr_input_rec.estimated_duration <> fnd_api.g_miss_num AND p_create_nr_input_rec.estimated_duration IS NOT NULL THEN
416: x_sr_task_rec.duration := p_create_nr_input_rec.estimated_duration;
417: END IF;
418:
419:

Line 518: RAISE FND_API.G_EXC_ERROR;

514: CLOSE get_instance_details;
515: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');
516: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520: CLOSE get_instance_details;
521:
522: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

Line 522: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520: CLOSE get_instance_details;
521:
522: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
523: x_nr_task_rec.TYPE_NAME := p_create_nr_input_rec.service_request_type;
524: END IF;
525:
526: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

Line 526: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN

522: IF p_create_nr_input_rec.service_request_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
523: x_nr_task_rec.TYPE_NAME := p_create_nr_input_rec.service_request_type;
524: END IF;
525:
526: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
527: x_nr_task_rec.status_name := p_create_nr_input_rec.service_request_status;
528: END IF;
529:
530: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN

Line 530: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN

526: IF p_create_nr_input_rec.service_request_status <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.service_request_type IS NOT NULL THEN
527: x_nr_task_rec.status_name := p_create_nr_input_rec.service_request_status;
528: END IF;
529:
530: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN
531: x_nr_task_rec.problem_code := p_create_nr_input_rec.problem_code;
532: END IF;
533:
534: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN

Line 534: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN

530: IF p_create_nr_input_rec.problem_code <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.problem_code IS NOT NULL THEN
531: x_nr_task_rec.problem_code := p_create_nr_input_rec.problem_code;
532: END IF;
533:
534: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN
535: x_nr_task_rec.severity_name := p_create_nr_input_rec.severity_name;
536: END IF;
537:
538: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN

Line 538: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN

534: IF p_create_nr_input_rec.severity_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.severity_name IS NOT NULL THEN
535: x_nr_task_rec.severity_name := p_create_nr_input_rec.severity_name;
536: END IF;
537:
538: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN
539: x_nr_task_rec.contact_type := p_create_nr_input_rec.contact_type;
540: END IF;
541:
542: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN

Line 542: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN

538: IF p_create_nr_input_rec.contact_type <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_type IS NOT NULL THEN
539: x_nr_task_rec.contact_type := p_create_nr_input_rec.contact_type;
540: END IF;
541:
542: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN
543: x_nr_task_rec.contact_name := p_create_nr_input_rec.contact_name;
544: END IF;
545:
546: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN

Line 546: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN

542: IF p_create_nr_input_rec.contact_name <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.contact_name IS NOT NULL THEN
543: x_nr_task_rec.contact_name := p_create_nr_input_rec.contact_name;
544: END IF;
545:
546: IF p_create_nr_input_rec.resolution_code_meaning <> FND_API.G_MISS_CHAR AND p_create_nr_input_rec.resolution_code_meaning IS NOT NULL THEN
547: x_nr_task_rec.resolution_meaning := p_create_nr_input_rec.resolution_code_meaning;
548: END IF;
549:
550: -- Log API exit point

Line 898: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

894:
895: /*PROCEDURE CREATE_NON_ROUTINE_AUTOTXNS
896: (
897: p_api_version IN NUMBER := 1.0,
898: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900: p_module_type IN VARCHAR2,
901: p_user_id IN VARCHAR2:=NULL,
902: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,

Line 899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

895: /*PROCEDURE CREATE_NON_ROUTINE_AUTOTXNS
896: (
897: p_api_version IN NUMBER := 1.0,
898: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
899: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900: p_module_type IN VARCHAR2,
901: p_user_id IN VARCHAR2:=NULL,
902: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,
903: p_matrl_reqrs_for_nr_tbl IN MATERIAL_REQUIREMENTS_TBL,

Line 918: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

914:
915: BEGIN
916:
917: -- Standard call to check for call compatibility
918: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
922: CREATE_NON_ROUTINE_NONAUTOTXNS

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

915: BEGIN
916:
917: -- Standard call to check for call compatibility
918: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
922: CREATE_NON_ROUTINE_NONAUTOTXNS
923: (

Line 926: p_commit => FND_API.G_FALSE,

922: CREATE_NON_ROUTINE_NONAUTOTXNS
923: (
924: p_api_version => p_api_version,
925: p_init_msg_list => p_init_msg_list,
926: p_commit => FND_API.G_FALSE,
927: p_validation_level => p_validation_level,
928: p_module_type => p_module_type,
929: p_user_id => p_user_id,
930: p_create_nr_input_rec => p_create_nr_input_rec,

Line 937: IF(x_return_status = Fnd_Api.G_RET_STS_SUCCESS)THEN

933: x_return_status => x_return_status,
934: x_msg_count => x_msg_count,
935: x_msg_data => x_msg_data
936: );
937: IF(x_return_status = Fnd_Api.G_RET_STS_SUCCESS)THEN
938: COMMIT;
939: ELSE
940: ROLLBACK;
941: END IF;

Line 945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

941: END IF;
942:
943:
944: EXCEPTION
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: ROLLBACK;
947: WHEN OTHERS THEN
948: ROLLBACK;
949: END CREATE_NON_ROUTINE_AUTOTXNS;*/

Line 967: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

963: ------------------------------------------------------------------------------------------------------------------
964: /*PROCEDURE CREATE_NON_ROUTINE
965: (
966: p_api_version IN NUMBER := 1.0,
967: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
968: p_commit IN VARCHAR2 := FND_API.G_FALSE,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: p_module_type IN VARCHAR2,
971: p_user_id IN VARCHAR2:=NULL,

Line 968: p_commit IN VARCHAR2 := FND_API.G_FALSE,

964: /*PROCEDURE CREATE_NON_ROUTINE
965: (
966: p_api_version IN NUMBER := 1.0,
967: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
968: p_commit IN VARCHAR2 := FND_API.G_FALSE,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: p_module_type IN VARCHAR2,
971: p_user_id IN VARCHAR2:=NULL,
972: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,

Line 969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

965: (
966: p_api_version IN NUMBER := 1.0,
967: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
968: p_commit IN VARCHAR2 := FND_API.G_FALSE,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: p_module_type IN VARCHAR2,
971: p_user_id IN VARCHAR2:=NULL,
972: p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,
973: p_matrl_reqrs_for_nr_tbl IN MATERIAL_REQUIREMENTS_TBL,

Line 981: IF(p_module_type = 'BPEL' AND p_commit = FND_API.G_TRUE)THEN

977: x_msg_data OUT NOCOPY VARCHAR2
978: )
979: IS
980: BEGIN
981: IF(p_module_type = 'BPEL' AND p_commit = FND_API.G_TRUE)THEN
982:
983: CREATE_NON_ROUTINE_AUTOTXNS
984: (
985: p_api_version => p_api_version,