DBA Data[Home] [Help]

APPS.AHL_WARRANTY_ENTL_PVT dependencies on FND_API

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

70: -- End of Comments
71:
72: PROCEDURE Process_Warranty_Entitlements (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_module_type IN VARCHAR2 := NULL,
78: p_user_role IN VARCHAR2,

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

71:
72: PROCEDURE Process_Warranty_Entitlements (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_module_type IN VARCHAR2 := NULL,
78: p_user_role IN VARCHAR2,
79: p_appr_action IN VARCHAR2 := NULL,

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

72: PROCEDURE Process_Warranty_Entitlements (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_module_type IN VARCHAR2 := NULL,
78: p_user_role IN VARCHAR2,
79: p_appr_action IN VARCHAR2 := NULL,
80: p_x_warranty_entl_tbl IN OUT NOCOPY Warranty_Entl_Tbl_Type,

Line 104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

100: -- Standard start of API savepoint
101: SAVEPOINT Process_Warranty_Entl_Pub;
102:
103: -- Standard call to check for call compatibility
104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
105: l_api_name, G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102:
103: -- Standard call to check for call compatibility
104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
105: l_api_name, G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: -- Initialize message list if p_init_msg_list is set to TRUE
110: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 110: IF FND_API.To_Boolean( p_init_msg_list) THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: -- Initialize message list if p_init_msg_list is set to TRUE
110: IF FND_API.To_Boolean( p_init_msg_list) THEN
111: FND_MSG_PUB.Initialize;
112: END IF;
113:
114: -- Initialize Procedure return status to success

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: FND_MSG_PUB.Initialize;
112: END IF;
113:
114: -- Initialize Procedure return status to success
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: IF (l_log_statement >= l_log_current_level) THEN
118: FND_LOG.string(l_log_statement, l_full_name, 'l_warranty_entl_tbl.COUNT = '|| l_warranty_entl_tbl.COUNT);
119: END IF;

Line 172: RAISE FND_API.G_EXC_ERROR;

168: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN
169: IF (l_log_statement >= l_log_current_level) THEN
170: FND_LOG.string(l_log_statement, l_full_name, 'Process_Warranty_Entitlements errored out');
171: END IF;
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: -- Standard check of p_commit
176: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 176: IF FND_API.TO_BOOLEAN(p_commit) THEN

172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: -- Standard check of p_commit
176: IF FND_API.TO_BOOLEAN(p_commit) THEN
177: COMMIT WORK;
178: END IF;
179:
180: IF (l_log_procedure >= l_log_current_level) THEN

Line 185: WHEN FND_API.G_EXC_ERROR THEN

181: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
182: END IF;
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: ROLLBACK TO Process_Warranty_Entl_Pub;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
189: p_data => x_msg_data,

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: ROLLBACK TO Process_Warranty_Entl_Pub;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
189: p_data => x_msg_data,
190: p_encoded => FND_API.G_FALSE);
191: IF (l_log_exception >= l_log_current_level) THEN

Line 190: p_encoded => FND_API.G_FALSE);

186: ROLLBACK TO Process_Warranty_Entl_Pub;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
189: p_data => x_msg_data,
190: p_encoded => FND_API.G_FALSE);
191: IF (l_log_exception >= l_log_current_level) THEN
192: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
193: END IF;
194:

Line 195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

191: IF (l_log_exception >= l_log_current_level) THEN
192: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
193: END IF;
194:
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196: ROLLBACK TO Process_Warranty_Entl_Pub;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
199: p_data => x_msg_data,

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

193: END IF;
194:
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196: ROLLBACK TO Process_Warranty_Entl_Pub;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => FND_API.G_FALSE);
201: IF (l_log_unexpected >= l_log_current_level) THEN

Line 200: p_encoded => FND_API.G_FALSE);

196: ROLLBACK TO Process_Warranty_Entl_Pub;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => FND_API.G_FALSE);
201: IF (l_log_unexpected >= l_log_current_level) THEN
202: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
203: END IF;
204:

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: END IF;
204:
205: WHEN OTHERS THEN
206: ROLLBACK TO Process_Warranty_Entl_Pub;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
209: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
210: p_procedure_name => l_api_name,
211: p_error_text => SUBSTR(SQLERRM,1,500));

Line 215: p_encoded => fnd_api.G_FALSE);

211: p_error_text => SUBSTR(SQLERRM,1,500));
212: END IF;
213: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
214: p_data => x_msg_data,
215: p_encoded => fnd_api.G_FALSE);
216: IF (l_log_unexpected >= l_log_current_level) THEN
217: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
218: END IF;
219:

Line 303: -- passed as FND_API.G_FALSE

299: --
300: -- Launch_Entl_Notification Parameters:
301: -- p_entitlement_id IN Entitlement id Required
302: -- p_commit IN Commit flag. Workflow won't launch if this is Required
303: -- passed as FND_API.G_FALSE
304: -- x_item_key OUT Item key of the launched notification Required
305: -- x_return_status OUT Return status. Item key to be used only if Required
306: -- this status is FND_API.G_RET_STS_SUCCESS.
307: --

Line 306: -- this status is FND_API.G_RET_STS_SUCCESS.

302: -- p_commit IN Commit flag. Workflow won't launch if this is Required
303: -- passed as FND_API.G_FALSE
304: -- x_item_key OUT Item key of the launched notification Required
305: -- x_return_status OUT Return status. Item key to be used only if Required
306: -- this status is FND_API.G_RET_STS_SUCCESS.
307: --
308: -- End of Comments
309:
310: PROCEDURE Launch_Entl_Notification (

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

308: -- End of Comments
309:
310: PROCEDURE Launch_Entl_Notification (
311: p_entitlement_id IN NUMBER,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: x_item_key OUT NOCOPY VARCHAR2,
314: x_return_status OUT NOCOPY VARCHAR2
315: ) IS
316:

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
332: END IF;
333:
334: -- initialize procedure return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: IF (l_log_statement >= l_log_current_level) THEN
338: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
339: ' p_entitlement_id > '||p_entitlement_id||

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: END IF;
342:
343: -- check for the entitlement id
344: IF (p_entitlement_id IS NULL) THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_WARRANTY_ENTL_ID_INVLD'); -- Warranty entitlement id ENTL_ID is invalid.
347: FND_MESSAGE.Set_Token('ENTL_ID', p_entitlement_id);
348: FND_MSG_PUB.ADD;
349: RETURN;

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

367: ', x_return_status > '||x_return_status);
368: END IF;
369:
370: -- if returned with error, don't proceed any further
371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: RETURN;
373: END IF;
374:
375: -- if the mapping is active, call the notification API

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

408: ', x_return_status > '||x_return_status);
409: END IF;
410:
411: -- if returned with error, don't proceed any further
412: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
413: RETURN;
414: END IF;
415: END IF;
416:

Line 418: IF FND_API.TO_BOOLEAN(p_commit) THEN

414: END IF;
415: END IF;
416:
417: -- Standard check of p_commit
418: IF FND_API.TO_BOOLEAN(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421:
422: IF (l_log_procedure >= l_log_current_level) THEN

Line 468: l_return_status := FND_API.G_RET_STS_SUCCESS;

464: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
465:
466: -- initialize return status to success
467: retcode := 0;
468: l_return_status := FND_API.G_RET_STS_SUCCESS;
469:
470: -- initialize error message stack
471: FND_MSG_PUB.Initialize;
472:

Line 491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

487: ', l_return_status > '||l_return_status);
488: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
489:
490: -- if returned with error, don't proceed any further
491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
492: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occurred > '||l_msg_data);
493: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: -- if returned with error, don't proceed any further
491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
492: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occurred > '||l_msg_data);
493: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: -- if returned without any errors and if the mapping is active, call the notification API
498: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN

Line 498: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN

494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: -- if returned without any errors and if the mapping is active, call the notification API
498: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN
499: -- get the subject text
500: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_WARRANTY_EXPR_SBJ);
501:
502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||

Line 526: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

522: ', l_return_status > '||l_return_status);
523: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
524:
525: -- if returned with error, don't proceed any further
526: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Errors occurred, as given below: ');
528: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
529:
530: -- put all the errors in the log file

Line 535: p_encoded => FND_API.G_FALSE,

531: l_msg_count := FND_MSG_PUB.count_msg;
532: FOR i IN 1..l_msg_count LOOP
533: FND_MSG_PUB.get(
534: p_msg_index => i,
535: p_encoded => FND_API.G_FALSE,
536: p_data => l_msg_data,
537: p_msg_index_out => l_dummy);
538:
539: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error '||i||': > '||l_msg_data);

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
541: END LOOP;
542:
543: -- raise the exception
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547: -- set the output
548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Workflow notification launched with item key > '||l_item_key);

Line 562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

558: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End time: '||TO_CHAR(SYSDATE, 'Month DD, YYYY HH24:MI:SS'));
560:
561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: retcode := 2;
564: errbuf := FND_MSG_PUB.Get;
565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Process failed. View program logs for details.');
566:

Line 615: l_return_status := FND_API.G_RET_STS_SUCCESS;

611: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
612:
613: -- initialize return status to success
614: retcode := 0;
615: l_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: -- initialize error message stack
618: FND_MSG_PUB.Initialize;
619:

Line 638: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

634: ', l_return_status > '||l_return_status);
635: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
636:
637: -- if returned with error, don't proceed any further
638: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occurred > '||l_msg_data);
640: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: -- if returned with error, don't proceed any further
638: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occurred > '||l_msg_data);
640: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: -- if returned without any errors and if the mapping is active, call the notification API
645: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN

Line 645: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN

641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: -- if returned without any errors and if the mapping is active, call the notification API
645: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND l_active_flag = 'Y') THEN
646: -- get the subject text
647: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_WARRANTY_WOCL_SBJ);
648:
649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||

Line 673: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

669: ', l_return_status > '||l_return_status);
670: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
671:
672: -- if returned with error, don't proceed any further
673: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
674: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Errors occurred, as given below: ');
675: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
676:
677: -- put all the errors in the log file

Line 682: p_encoded => FND_API.G_FALSE,

678: l_msg_count := FND_MSG_PUB.count_msg;
679: FOR i IN 1..l_msg_count LOOP
680: FND_MSG_PUB.get(
681: p_msg_index => i,
682: p_encoded => FND_API.G_FALSE,
683: p_data => l_msg_data,
684: p_msg_index_out => l_dummy);
685:
686: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error '||i||': > '||l_msg_data);

Line 691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
688: END LOOP;
689:
690: -- raise the exception
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: -- set the output
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Workflow notification launched with item key > '||l_item_key);

Line 709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

705: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
706: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End time: '||TO_CHAR(SYSDATE, 'Month DD, YYYY HH24:MI:SS'));
707:
708: EXCEPTION
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: retcode := 2;
711: errbuf := FND_MSG_PUB.Get;
712: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Process failed. View program logs for details.');
713:

Line 1022: IF (p_x_warranty_entl_rec.warranty_contract_id = FND_API.G_MISS_NUM) THEN

1018: END IF;
1019:
1020: -- module type check commented for present requirements. can be used in future
1021: -- IF (p_module_type = 'JSP') THEN
1022: IF (p_x_warranty_entl_rec.warranty_contract_id = FND_API.G_MISS_NUM) THEN
1023: p_x_warranty_entl_rec.warranty_contract_id := NULL;
1024: END IF;
1025: IF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN
1026: p_x_warranty_entl_rec.entitlement_status_code := NULL;

Line 1025: IF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN

1021: -- IF (p_module_type = 'JSP') THEN
1022: IF (p_x_warranty_entl_rec.warranty_contract_id = FND_API.G_MISS_NUM) THEN
1023: p_x_warranty_entl_rec.warranty_contract_id := NULL;
1024: END IF;
1025: IF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN
1026: p_x_warranty_entl_rec.entitlement_status_code := NULL;
1027: END IF;
1028: IF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN
1029: p_x_warranty_entl_rec.warranty_claim_id := NULL;

Line 1028: IF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN

1024: END IF;
1025: IF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN
1026: p_x_warranty_entl_rec.entitlement_status_code := NULL;
1027: END IF;
1028: IF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN
1029: p_x_warranty_entl_rec.warranty_claim_id := NULL;
1030: END IF;
1031: IF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN
1032: p_x_warranty_entl_rec.po_header_id := NULL;

Line 1031: IF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN

1027: END IF;
1028: IF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN
1029: p_x_warranty_entl_rec.warranty_claim_id := NULL;
1030: END IF;
1031: IF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN
1032: p_x_warranty_entl_rec.po_header_id := NULL;
1033: END IF;
1034: IF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN
1035: p_x_warranty_entl_rec.sr_incident_id := NULL;

Line 1034: IF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN

1030: END IF;
1031: IF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN
1032: p_x_warranty_entl_rec.po_header_id := NULL;
1033: END IF;
1034: IF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN
1035: p_x_warranty_entl_rec.sr_incident_id := NULL;
1036: END IF;
1037: IF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1038: p_x_warranty_entl_rec.visit_task_id := NULL;

Line 1037: IF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN

1033: END IF;
1034: IF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN
1035: p_x_warranty_entl_rec.sr_incident_id := NULL;
1036: END IF;
1037: IF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1038: p_x_warranty_entl_rec.visit_task_id := NULL;
1039: END IF;
1040: IF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN
1041: p_x_warranty_entl_rec.workorder_id := NULL;

Line 1040: IF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN

1036: END IF;
1037: IF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1038: p_x_warranty_entl_rec.visit_task_id := NULL;
1039: END IF;
1040: IF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN
1041: p_x_warranty_entl_rec.workorder_id := NULL;
1042: END IF;
1043: IF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN
1044: p_x_warranty_entl_rec.osp_order_line_id := NULL;

Line 1043: IF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN

1039: END IF;
1040: IF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN
1041: p_x_warranty_entl_rec.workorder_id := NULL;
1042: END IF;
1043: IF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN
1044: p_x_warranty_entl_rec.osp_order_line_id := NULL;
1045: END IF;
1046: IF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN
1047: p_x_warranty_entl_rec.warranty_labour_capture := NULL;

Line 1046: IF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN

1042: END IF;
1043: IF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN
1044: p_x_warranty_entl_rec.osp_order_line_id := NULL;
1045: END IF;
1046: IF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN
1047: p_x_warranty_entl_rec.warranty_labour_capture := NULL;
1048: END IF;
1049: IF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN
1050: p_x_warranty_entl_rec.warranty_mtl_capture := NULL;

Line 1049: IF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN

1045: END IF;
1046: IF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN
1047: p_x_warranty_entl_rec.warranty_labour_capture := NULL;
1048: END IF;
1049: IF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN
1050: p_x_warranty_entl_rec.warranty_mtl_capture := NULL;
1051: END IF;
1052: IF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN
1053: p_x_warranty_entl_rec.order_claim_amount := NULL;

Line 1052: IF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN

1048: END IF;
1049: IF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN
1050: p_x_warranty_entl_rec.warranty_mtl_capture := NULL;
1051: END IF;
1052: IF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN
1053: p_x_warranty_entl_rec.order_claim_amount := NULL;
1054: END IF;
1055: IF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1056: p_x_warranty_entl_rec.attribute_category := NULL;

Line 1055: IF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN

1051: END IF;
1052: IF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN
1053: p_x_warranty_entl_rec.order_claim_amount := NULL;
1054: END IF;
1055: IF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1056: p_x_warranty_entl_rec.attribute_category := NULL;
1057: END IF;
1058: IF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1059: p_x_warranty_entl_rec.attribute1 := NULL;

Line 1058: IF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN

1054: END IF;
1055: IF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1056: p_x_warranty_entl_rec.attribute_category := NULL;
1057: END IF;
1058: IF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1059: p_x_warranty_entl_rec.attribute1 := NULL;
1060: END IF;
1061: IF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1062: p_x_warranty_entl_rec.attribute2 := NULL;

Line 1061: IF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN

1057: END IF;
1058: IF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1059: p_x_warranty_entl_rec.attribute1 := NULL;
1060: END IF;
1061: IF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1062: p_x_warranty_entl_rec.attribute2 := NULL;
1063: END IF;
1064: IF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1065: p_x_warranty_entl_rec.attribute3 := NULL;

Line 1064: IF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN

1060: END IF;
1061: IF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1062: p_x_warranty_entl_rec.attribute2 := NULL;
1063: END IF;
1064: IF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1065: p_x_warranty_entl_rec.attribute3 := NULL;
1066: END IF;
1067: IF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1068: p_x_warranty_entl_rec.attribute4 := NULL;

Line 1067: IF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN

1063: END IF;
1064: IF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1065: p_x_warranty_entl_rec.attribute3 := NULL;
1066: END IF;
1067: IF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1068: p_x_warranty_entl_rec.attribute4 := NULL;
1069: END IF;
1070: IF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1071: p_x_warranty_entl_rec.attribute5 := NULL;

Line 1070: IF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN

1066: END IF;
1067: IF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1068: p_x_warranty_entl_rec.attribute4 := NULL;
1069: END IF;
1070: IF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1071: p_x_warranty_entl_rec.attribute5 := NULL;
1072: END IF;
1073: IF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1074: p_x_warranty_entl_rec.attribute6 := NULL;

Line 1073: IF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN

1069: END IF;
1070: IF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1071: p_x_warranty_entl_rec.attribute5 := NULL;
1072: END IF;
1073: IF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1074: p_x_warranty_entl_rec.attribute6 := NULL;
1075: END IF;
1076: IF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1077: p_x_warranty_entl_rec.attribute7 := NULL;

Line 1076: IF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN

1072: END IF;
1073: IF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1074: p_x_warranty_entl_rec.attribute6 := NULL;
1075: END IF;
1076: IF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1077: p_x_warranty_entl_rec.attribute7 := NULL;
1078: END IF;
1079: IF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1080: p_x_warranty_entl_rec.attribute8 := NULL;

Line 1079: IF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN

1075: END IF;
1076: IF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1077: p_x_warranty_entl_rec.attribute7 := NULL;
1078: END IF;
1079: IF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1080: p_x_warranty_entl_rec.attribute8 := NULL;
1081: END IF;
1082: IF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1083: p_x_warranty_entl_rec.attribute9 := NULL;

Line 1082: IF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN

1078: END IF;
1079: IF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1080: p_x_warranty_entl_rec.attribute8 := NULL;
1081: END IF;
1082: IF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1083: p_x_warranty_entl_rec.attribute9 := NULL;
1084: END IF;
1085: IF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1086: p_x_warranty_entl_rec.attribute10 := NULL;

Line 1085: IF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN

1081: END IF;
1082: IF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1083: p_x_warranty_entl_rec.attribute9 := NULL;
1084: END IF;
1085: IF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1086: p_x_warranty_entl_rec.attribute10 := NULL;
1087: END IF;
1088: IF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1089: p_x_warranty_entl_rec.attribute11 := NULL;

Line 1088: IF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN

1084: END IF;
1085: IF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1086: p_x_warranty_entl_rec.attribute10 := NULL;
1087: END IF;
1088: IF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1089: p_x_warranty_entl_rec.attribute11 := NULL;
1090: END IF;
1091: IF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1092: p_x_warranty_entl_rec.attribute12 := NULL;

Line 1091: IF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN

1087: END IF;
1088: IF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1089: p_x_warranty_entl_rec.attribute11 := NULL;
1090: END IF;
1091: IF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1092: p_x_warranty_entl_rec.attribute12 := NULL;
1093: END IF;
1094: IF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1095: p_x_warranty_entl_rec.attribute13 := NULL;

Line 1094: IF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN

1090: END IF;
1091: IF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1092: p_x_warranty_entl_rec.attribute12 := NULL;
1093: END IF;
1094: IF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1095: p_x_warranty_entl_rec.attribute13 := NULL;
1096: END IF;
1097: IF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1098: p_x_warranty_entl_rec.attribute14 := NULL;

Line 1097: IF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN

1093: END IF;
1094: IF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1095: p_x_warranty_entl_rec.attribute13 := NULL;
1096: END IF;
1097: IF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1098: p_x_warranty_entl_rec.attribute14 := NULL;
1099: END IF;
1100: IF (p_x_warranty_entl_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1101: p_x_warranty_entl_rec.attribute15 := NULL;

Line 1100: IF (p_x_warranty_entl_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

1096: END IF;
1097: IF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1098: p_x_warranty_entl_rec.attribute14 := NULL;
1099: END IF;
1100: IF (p_x_warranty_entl_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1101: p_x_warranty_entl_rec.attribute15 := NULL;
1102: END IF;
1103: -- END IF; -- module type check
1104:

Line 1200: p_commit => FND_API.G_FALSE,

1196: -- call Launch_Entl_Notification
1197: -- NOTE: the OUT parameters are not used in this flow as the notification is sent as part of a create
1198: Launch_Entl_Notification(
1199: p_entitlement_id => p_x_warranty_entl_rec.warranty_entitlement_id,
1200: p_commit => FND_API.G_FALSE,
1201: x_item_key => l_item_key,
1202: x_return_status => l_return_status);
1203:
1204: IF (l_log_statement >= l_log_current_level) THEN

Line 1274: ELSIF (p_x_warranty_entl_rec.warranty_contract_id = FND_API.G_MISS_NUM) THEN

1270: -- module type check commented for present requirements. can be used in future
1271: -- IF (p_module_type = 'JSP') THEN
1272: IF (p_x_warranty_entl_rec.warranty_contract_id IS NULL) THEN
1273: p_x_warranty_entl_rec.warranty_contract_id := l_warranty_entl_rec.warranty_contract_id;
1274: ELSIF (p_x_warranty_entl_rec.warranty_contract_id = FND_API.G_MISS_NUM) THEN
1275: p_x_warranty_entl_rec.warranty_contract_id := NULL;
1276: END IF;
1277: IF (p_x_warranty_entl_rec.entitlement_status_code IS NULL) THEN
1278: p_x_warranty_entl_rec.entitlement_status_code := l_warranty_entl_rec.entitlement_status_code;

Line 1279: ELSIF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN

1275: p_x_warranty_entl_rec.warranty_contract_id := NULL;
1276: END IF;
1277: IF (p_x_warranty_entl_rec.entitlement_status_code IS NULL) THEN
1278: p_x_warranty_entl_rec.entitlement_status_code := l_warranty_entl_rec.entitlement_status_code;
1279: ELSIF (p_x_warranty_entl_rec.entitlement_status_code = FND_API.G_MISS_CHAR) THEN
1280: p_x_warranty_entl_rec.entitlement_status_code := NULL;
1281: END IF;
1282: IF (p_x_warranty_entl_rec.warranty_claim_id IS NULL) THEN
1283: p_x_warranty_entl_rec.warranty_claim_id := l_warranty_entl_rec.warranty_claim_id;

Line 1284: ELSIF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN

1280: p_x_warranty_entl_rec.entitlement_status_code := NULL;
1281: END IF;
1282: IF (p_x_warranty_entl_rec.warranty_claim_id IS NULL) THEN
1283: p_x_warranty_entl_rec.warranty_claim_id := l_warranty_entl_rec.warranty_claim_id;
1284: ELSIF (p_x_warranty_entl_rec.warranty_claim_id = FND_API.G_MISS_NUM) THEN
1285: p_x_warranty_entl_rec.warranty_claim_id := NULL;
1286: END IF;
1287: IF (p_x_warranty_entl_rec.po_header_id IS NULL) THEN
1288: p_x_warranty_entl_rec.po_header_id := l_warranty_entl_rec.po_header_id;

Line 1289: ELSIF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN

1285: p_x_warranty_entl_rec.warranty_claim_id := NULL;
1286: END IF;
1287: IF (p_x_warranty_entl_rec.po_header_id IS NULL) THEN
1288: p_x_warranty_entl_rec.po_header_id := l_warranty_entl_rec.po_header_id;
1289: ELSIF (p_x_warranty_entl_rec.po_header_id = FND_API.G_MISS_NUM) THEN
1290: p_x_warranty_entl_rec.po_header_id := NULL;
1291: END IF;
1292: IF (p_x_warranty_entl_rec.sr_incident_id IS NULL) THEN
1293: p_x_warranty_entl_rec.sr_incident_id := l_warranty_entl_rec.sr_incident_id;

Line 1294: ELSIF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN

1290: p_x_warranty_entl_rec.po_header_id := NULL;
1291: END IF;
1292: IF (p_x_warranty_entl_rec.sr_incident_id IS NULL) THEN
1293: p_x_warranty_entl_rec.sr_incident_id := l_warranty_entl_rec.sr_incident_id;
1294: ELSIF (p_x_warranty_entl_rec.sr_incident_id = FND_API.G_MISS_NUM) THEN
1295: p_x_warranty_entl_rec.sr_incident_id := NULL;
1296: END IF;
1297: IF (p_x_warranty_entl_rec.visit_task_id IS NULL) THEN
1298: p_x_warranty_entl_rec.visit_task_id := l_warranty_entl_rec.visit_task_id;

Line 1299: ELSIF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN

1295: p_x_warranty_entl_rec.sr_incident_id := NULL;
1296: END IF;
1297: IF (p_x_warranty_entl_rec.visit_task_id IS NULL) THEN
1298: p_x_warranty_entl_rec.visit_task_id := l_warranty_entl_rec.visit_task_id;
1299: ELSIF (p_x_warranty_entl_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1300: p_x_warranty_entl_rec.visit_task_id := NULL;
1301: END IF;
1302: IF (p_x_warranty_entl_rec.workorder_id IS NULL) THEN
1303: p_x_warranty_entl_rec.workorder_id := l_warranty_entl_rec.workorder_id;

Line 1304: ELSIF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN

1300: p_x_warranty_entl_rec.visit_task_id := NULL;
1301: END IF;
1302: IF (p_x_warranty_entl_rec.workorder_id IS NULL) THEN
1303: p_x_warranty_entl_rec.workorder_id := l_warranty_entl_rec.workorder_id;
1304: ELSIF (p_x_warranty_entl_rec.workorder_id = FND_API.G_MISS_NUM) THEN
1305: p_x_warranty_entl_rec.workorder_id := NULL;
1306: END IF;
1307: IF (p_x_warranty_entl_rec.osp_order_line_id IS NULL) THEN
1308: p_x_warranty_entl_rec.osp_order_line_id := l_warranty_entl_rec.osp_order_line_id;

Line 1309: ELSIF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN

1305: p_x_warranty_entl_rec.workorder_id := NULL;
1306: END IF;
1307: IF (p_x_warranty_entl_rec.osp_order_line_id IS NULL) THEN
1308: p_x_warranty_entl_rec.osp_order_line_id := l_warranty_entl_rec.osp_order_line_id;
1309: ELSIF (p_x_warranty_entl_rec.osp_order_line_id = FND_API.G_MISS_NUM) THEN
1310: p_x_warranty_entl_rec.osp_order_line_id := NULL;
1311: END IF;
1312: IF (p_x_warranty_entl_rec.warranty_labour_capture IS NULL) THEN
1313: p_x_warranty_entl_rec.warranty_labour_capture := l_warranty_entl_rec.warranty_labour_capture;

Line 1314: ELSIF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN

1310: p_x_warranty_entl_rec.osp_order_line_id := NULL;
1311: END IF;
1312: IF (p_x_warranty_entl_rec.warranty_labour_capture IS NULL) THEN
1313: p_x_warranty_entl_rec.warranty_labour_capture := l_warranty_entl_rec.warranty_labour_capture;
1314: ELSIF (p_x_warranty_entl_rec.warranty_labour_capture = FND_API.G_MISS_CHAR) THEN
1315: p_x_warranty_entl_rec.warranty_labour_capture := NULL;
1316: END IF;
1317: IF (p_x_warranty_entl_rec.warranty_mtl_capture IS NULL) THEN
1318: p_x_warranty_entl_rec.warranty_mtl_capture := l_warranty_entl_rec.warranty_mtl_capture;

Line 1319: ELSIF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN

1315: p_x_warranty_entl_rec.warranty_labour_capture := NULL;
1316: END IF;
1317: IF (p_x_warranty_entl_rec.warranty_mtl_capture IS NULL) THEN
1318: p_x_warranty_entl_rec.warranty_mtl_capture := l_warranty_entl_rec.warranty_mtl_capture;
1319: ELSIF (p_x_warranty_entl_rec.warranty_mtl_capture = FND_API.G_MISS_CHAR) THEN
1320: p_x_warranty_entl_rec.warranty_mtl_capture := NULL;
1321: END IF;
1322: IF (p_x_warranty_entl_rec.order_claim_amount IS NULL) THEN
1323: p_x_warranty_entl_rec.order_claim_amount := l_warranty_entl_rec.order_claim_amount;

Line 1324: ELSIF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN

1320: p_x_warranty_entl_rec.warranty_mtl_capture := NULL;
1321: END IF;
1322: IF (p_x_warranty_entl_rec.order_claim_amount IS NULL) THEN
1323: p_x_warranty_entl_rec.order_claim_amount := l_warranty_entl_rec.order_claim_amount;
1324: ELSIF (p_x_warranty_entl_rec.order_claim_amount = FND_API.G_MISS_NUM) THEN
1325: p_x_warranty_entl_rec.order_claim_amount := NULL;
1326: END IF;
1327: IF (p_x_warranty_entl_rec.attribute_category IS NULL) THEN
1328: p_x_warranty_entl_rec.attribute_category := l_warranty_entl_rec.attribute_category;

Line 1329: ELSIF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN

1325: p_x_warranty_entl_rec.order_claim_amount := NULL;
1326: END IF;
1327: IF (p_x_warranty_entl_rec.attribute_category IS NULL) THEN
1328: p_x_warranty_entl_rec.attribute_category := l_warranty_entl_rec.attribute_category;
1329: ELSIF (p_x_warranty_entl_rec.attribute_category = FND_API.G_MISS_CHAR) THEN
1330: p_x_warranty_entl_rec.attribute_category := NULL;
1331: END IF;
1332: IF (p_x_warranty_entl_rec.attribute1 IS NULL) THEN
1333: p_x_warranty_entl_rec.attribute1 := l_warranty_entl_rec.attribute1;

Line 1334: ELSIF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN

1330: p_x_warranty_entl_rec.attribute_category := NULL;
1331: END IF;
1332: IF (p_x_warranty_entl_rec.attribute1 IS NULL) THEN
1333: p_x_warranty_entl_rec.attribute1 := l_warranty_entl_rec.attribute1;
1334: ELSIF (p_x_warranty_entl_rec.attribute1 = FND_API.G_MISS_CHAR) THEN
1335: p_x_warranty_entl_rec.attribute1 := NULL;
1336: END IF;
1337: IF (p_x_warranty_entl_rec.attribute2 IS NULL) THEN
1338: p_x_warranty_entl_rec.attribute2 := l_warranty_entl_rec.attribute2;

Line 1339: ELSIF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN

1335: p_x_warranty_entl_rec.attribute1 := NULL;
1336: END IF;
1337: IF (p_x_warranty_entl_rec.attribute2 IS NULL) THEN
1338: p_x_warranty_entl_rec.attribute2 := l_warranty_entl_rec.attribute2;
1339: ELSIF (p_x_warranty_entl_rec.attribute2 = FND_API.G_MISS_CHAR) THEN
1340: p_x_warranty_entl_rec.attribute2 := NULL;
1341: END IF;
1342: IF (p_x_warranty_entl_rec.attribute3 IS NULL) THEN
1343: p_x_warranty_entl_rec.attribute3 := l_warranty_entl_rec.attribute3;

Line 1344: ELSIF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN

1340: p_x_warranty_entl_rec.attribute2 := NULL;
1341: END IF;
1342: IF (p_x_warranty_entl_rec.attribute3 IS NULL) THEN
1343: p_x_warranty_entl_rec.attribute3 := l_warranty_entl_rec.attribute3;
1344: ELSIF (p_x_warranty_entl_rec.attribute3 = FND_API.G_MISS_CHAR) THEN
1345: p_x_warranty_entl_rec.attribute3 := NULL;
1346: END IF;
1347: IF (p_x_warranty_entl_rec.attribute4 IS NULL) THEN
1348: p_x_warranty_entl_rec.attribute4 := l_warranty_entl_rec.attribute4;

Line 1349: ELSIF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN

1345: p_x_warranty_entl_rec.attribute3 := NULL;
1346: END IF;
1347: IF (p_x_warranty_entl_rec.attribute4 IS NULL) THEN
1348: p_x_warranty_entl_rec.attribute4 := l_warranty_entl_rec.attribute4;
1349: ELSIF (p_x_warranty_entl_rec.attribute4 = FND_API.G_MISS_CHAR) THEN
1350: p_x_warranty_entl_rec.attribute4 := NULL;
1351: END IF;
1352: IF (p_x_warranty_entl_rec.attribute5 IS NULL) THEN
1353: p_x_warranty_entl_rec.attribute5 := l_warranty_entl_rec.attribute5;

Line 1354: ELSIF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN

1350: p_x_warranty_entl_rec.attribute4 := NULL;
1351: END IF;
1352: IF (p_x_warranty_entl_rec.attribute5 IS NULL) THEN
1353: p_x_warranty_entl_rec.attribute5 := l_warranty_entl_rec.attribute5;
1354: ELSIF (p_x_warranty_entl_rec.attribute5 = FND_API.G_MISS_CHAR) THEN
1355: p_x_warranty_entl_rec.attribute5 := NULL;
1356: END IF;
1357: IF (p_x_warranty_entl_rec.attribute6 IS NULL) THEN
1358: p_x_warranty_entl_rec.attribute6 := l_warranty_entl_rec.attribute6;

Line 1359: ELSIF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN

1355: p_x_warranty_entl_rec.attribute5 := NULL;
1356: END IF;
1357: IF (p_x_warranty_entl_rec.attribute6 IS NULL) THEN
1358: p_x_warranty_entl_rec.attribute6 := l_warranty_entl_rec.attribute6;
1359: ELSIF (p_x_warranty_entl_rec.attribute6 = FND_API.G_MISS_CHAR) THEN
1360: p_x_warranty_entl_rec.attribute6 := NULL;
1361: END IF;
1362: IF (p_x_warranty_entl_rec.attribute7 IS NULL) THEN
1363: p_x_warranty_entl_rec.attribute7 := l_warranty_entl_rec.attribute7;

Line 1364: ELSIF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN

1360: p_x_warranty_entl_rec.attribute6 := NULL;
1361: END IF;
1362: IF (p_x_warranty_entl_rec.attribute7 IS NULL) THEN
1363: p_x_warranty_entl_rec.attribute7 := l_warranty_entl_rec.attribute7;
1364: ELSIF (p_x_warranty_entl_rec.attribute7 = FND_API.G_MISS_CHAR) THEN
1365: p_x_warranty_entl_rec.attribute7 := NULL;
1366: END IF;
1367: IF (p_x_warranty_entl_rec.attribute8 IS NULL) THEN
1368: p_x_warranty_entl_rec.attribute8 := l_warranty_entl_rec.attribute8;

Line 1369: ELSIF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN

1365: p_x_warranty_entl_rec.attribute7 := NULL;
1366: END IF;
1367: IF (p_x_warranty_entl_rec.attribute8 IS NULL) THEN
1368: p_x_warranty_entl_rec.attribute8 := l_warranty_entl_rec.attribute8;
1369: ELSIF (p_x_warranty_entl_rec.attribute8 = FND_API.G_MISS_CHAR) THEN
1370: p_x_warranty_entl_rec.attribute8 := NULL;
1371: END IF;
1372: IF (p_x_warranty_entl_rec.attribute9 IS NULL) THEN
1373: p_x_warranty_entl_rec.attribute9 := l_warranty_entl_rec.attribute9;

Line 1374: ELSIF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN

1370: p_x_warranty_entl_rec.attribute8 := NULL;
1371: END IF;
1372: IF (p_x_warranty_entl_rec.attribute9 IS NULL) THEN
1373: p_x_warranty_entl_rec.attribute9 := l_warranty_entl_rec.attribute9;
1374: ELSIF (p_x_warranty_entl_rec.attribute9 = FND_API.G_MISS_CHAR) THEN
1375: p_x_warranty_entl_rec.attribute9 := NULL;
1376: END IF;
1377: IF (p_x_warranty_entl_rec.attribute10 IS NULL) THEN
1378: p_x_warranty_entl_rec.attribute10 := l_warranty_entl_rec.attribute10;

Line 1379: ELSIF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN

1375: p_x_warranty_entl_rec.attribute9 := NULL;
1376: END IF;
1377: IF (p_x_warranty_entl_rec.attribute10 IS NULL) THEN
1378: p_x_warranty_entl_rec.attribute10 := l_warranty_entl_rec.attribute10;
1379: ELSIF (p_x_warranty_entl_rec.attribute10 = FND_API.G_MISS_CHAR) THEN
1380: p_x_warranty_entl_rec.attribute10 := NULL;
1381: END IF;
1382: IF (p_x_warranty_entl_rec.attribute11 IS NULL) THEN
1383: p_x_warranty_entl_rec.attribute11 := l_warranty_entl_rec.attribute11;

Line 1384: ELSIF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN

1380: p_x_warranty_entl_rec.attribute10 := NULL;
1381: END IF;
1382: IF (p_x_warranty_entl_rec.attribute11 IS NULL) THEN
1383: p_x_warranty_entl_rec.attribute11 := l_warranty_entl_rec.attribute11;
1384: ELSIF (p_x_warranty_entl_rec.attribute11 = FND_API.G_MISS_CHAR) THEN
1385: p_x_warranty_entl_rec.attribute11 := NULL;
1386: END IF;
1387: IF (p_x_warranty_entl_rec.attribute12 IS NULL) THEN
1388: p_x_warranty_entl_rec.attribute12 := l_warranty_entl_rec.attribute12;

Line 1389: ELSIF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN

1385: p_x_warranty_entl_rec.attribute11 := NULL;
1386: END IF;
1387: IF (p_x_warranty_entl_rec.attribute12 IS NULL) THEN
1388: p_x_warranty_entl_rec.attribute12 := l_warranty_entl_rec.attribute12;
1389: ELSIF (p_x_warranty_entl_rec.attribute12 = FND_API.G_MISS_CHAR) THEN
1390: p_x_warranty_entl_rec.attribute12 := NULL;
1391: END IF;
1392: IF (p_x_warranty_entl_rec.attribute13 IS NULL) THEN
1393: p_x_warranty_entl_rec.attribute13 := l_warranty_entl_rec.attribute13;

Line 1394: ELSIF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN

1390: p_x_warranty_entl_rec.attribute12 := NULL;
1391: END IF;
1392: IF (p_x_warranty_entl_rec.attribute13 IS NULL) THEN
1393: p_x_warranty_entl_rec.attribute13 := l_warranty_entl_rec.attribute13;
1394: ELSIF (p_x_warranty_entl_rec.attribute13 = FND_API.G_MISS_CHAR) THEN
1395: p_x_warranty_entl_rec.attribute13 := NULL;
1396: END IF;
1397: IF (p_x_warranty_entl_rec.attribute14 IS NULL) THEN
1398: p_x_warranty_entl_rec.attribute14 := l_warranty_entl_rec.attribute14;

Line 1399: ELSIF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN

1395: p_x_warranty_entl_rec.attribute13 := NULL;
1396: END IF;
1397: IF (p_x_warranty_entl_rec.attribute14 IS NULL) THEN
1398: p_x_warranty_entl_rec.attribute14 := l_warranty_entl_rec.attribute14;
1399: ELSIF (p_x_warranty_entl_rec.attribute14 = FND_API.G_MISS_CHAR) THEN
1400: p_x_warranty_entl_rec.attribute14 := NULL;
1401: END IF;
1402: IF (p_x_warranty_entl_rec.attribute15 IS NULL) THEN
1403: p_x_warranty_entl_rec.attribute15 := l_warranty_entl_rec.attribute15;

Line 1404: ELSIF (p_x_warranty_entl_rec.attribute15 = FND_API.G_MISS_CHAR) THEN

1400: p_x_warranty_entl_rec.attribute14 := NULL;
1401: END IF;
1402: IF (p_x_warranty_entl_rec.attribute15 IS NULL) THEN
1403: p_x_warranty_entl_rec.attribute15 := l_warranty_entl_rec.attribute15;
1404: ELSIF (p_x_warranty_entl_rec.attribute15 = FND_API.G_MISS_CHAR) THEN
1405: p_x_warranty_entl_rec.attribute15 := NULL;
1406: END IF;
1407: -- END IF; -- module type check
1408:

Line 1497: p_commit => FND_API.G_FALSE,

1493: -- call Launch_Entl_Notification
1494: -- NOTE: the OUT parameters are not used in this flow as the notification is sent as part of an update
1495: Launch_Entl_Notification(
1496: p_entitlement_id => p_x_warranty_entl_rec.warranty_entitlement_id,
1497: p_commit => FND_API.G_FALSE,
1498: x_item_key => l_item_key,
1499: x_return_status => l_return_status);
1500:
1501: IF (l_log_statement >= l_log_current_level) THEN