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

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: , 'Update_Blanket_Qty'
211: );
212: END IF;
213: G_DEBUG_MSG := G_DEBUG_MSG || 'E1,';
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END Update_Blanket_Qty;
216:
217:
218: /*

Line 247: Return FND_API.G_TRUE;

243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( 'Yes, part of fulfillment set ' , 5 ) ;
245: END IF;
246:
247: Return FND_API.G_TRUE;
248:
249: EXCEPTION
250:
251: WHEN NO_DATA_FOUND THEN

Line 252: Return FND_API.G_FALSE;

248:
249: EXCEPTION
250:
251: WHEN NO_DATA_FOUND THEN
252: Return FND_API.G_FALSE;
253: WHEN TOO_MANY_ROWS THEN
254: Return FND_API.G_TRUE;
255: WHEN OTHERS THEN
256: Return FND_API.G_FALSE;

Line 254: Return FND_API.G_TRUE;

250:
251: WHEN NO_DATA_FOUND THEN
252: Return FND_API.G_FALSE;
253: WHEN TOO_MANY_ROWS THEN
254: Return FND_API.G_TRUE;
255: WHEN OTHERS THEN
256: Return FND_API.G_FALSE;
257:
258: END Is_Part_Of_Fulfillment_Set;

Line 256: Return FND_API.G_FALSE;

252: Return FND_API.G_FALSE;
253: WHEN TOO_MANY_ROWS THEN
254: Return FND_API.G_TRUE;
255: WHEN OTHERS THEN
256: Return FND_API.G_FALSE;
257:
258: END Is_Part_Of_Fulfillment_Set;
259:
260: PROCEDURE Get_service_lines

Line 309: p_header_id = FND_API.G_MISS_NUM THEN

305: END IF;
306:
307:
308: IF p_header_id IS NULL OR -- This IF introduced for 1717444
309: p_header_id = FND_API.G_MISS_NUM THEN
310: SELECT header_id
311: INTO l_header_id
312: FROM oe_order_lines
313: WHERE line_id = p_line_id;

Line 350: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
348: END IF;
349:
350: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
353: l_activity_status <> 'NOTIFIED' THEN
354: IF l_debug_level > 0 THEN

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
348: END IF;
349:
350: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
353: l_activity_status <> 'NOTIFIED' THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'SERVICE LINE IS NOT AT FULFILL LINE : '||TO_CHAR ( L_SERVICE_LINES.LINE_ID ) , 3 ) ;

Line 352: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR

348: END IF;
349:
350: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
353: l_activity_status <> 'NOTIFIED' THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'SERVICE LINE IS NOT AT FULFILL LINE : '||TO_CHAR ( L_SERVICE_LINES.LINE_ID ) , 3 ) ;
356: END IF;

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: END LOOP;
381:
382:
383: IF l_service_index = 0 THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: ELSE
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387: END IF;
388:

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382:
383: IF l_service_index = 0 THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: ELSE
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387: END IF;
388:
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: END IF;
392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
400: END IF;

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

407: END IF;
408: G_DEBUG_MSG := G_DEBUG_MSG || '5,';
409:
410: WHEN OTHERS THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
414: END IF;
415: IF l_debug_level > 0 THEN

Line 469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

465: x_line_tbl => l_service_tbl
466: );
467:
468:
469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: GOTO END_SERVICE_LOOP;
473: END IF;

Line 470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

466: );
467:
468:
469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: GOTO END_SERVICE_LOOP;
473: END IF;
474:

Line 471: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

467:
468:
469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: GOTO END_SERVICE_LOOP;
473: END IF;
474:
475: --5699215

Line 537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL LINE : '||L_RETURN_STATUS , 3 ) ;
535: END IF;
536:
537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('raising unexpected error '||sqlerrm,1);
540: END IF;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('raising unexpected error '||sqlerrm,1);
540: END IF;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add('raising exc error '||sqlerrm,1);
545: END IF;

Line 542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('raising unexpected error '||sqlerrm,1);
540: END IF;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add('raising exc error '||sqlerrm,1);
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;

Line 546: RAISE FND_API.G_EXC_ERROR;

542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add('raising exc error '||sqlerrm,1);
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: END IF;
549:
550: /* Complete the work flow activity for the service lines */

Line 570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

566: IF l_debug_level > 0 THEN
567: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
568: END IF;
569:
570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add('after update of flow status code - error '||sqlerrm,1);
573: END IF;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add('after update of flow status code - error '||sqlerrm,1);
573: END IF;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add('after update of flow status code - exc error '||sqlerrm,1);
578: END IF;

Line 575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

571: IF l_debug_level > 0 THEN
572: oe_debug_pub.add('after update of flow status code - error '||sqlerrm,1);
573: END IF;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add('after update of flow status code - exc error '||sqlerrm,1);
578: END IF;
579: RAISE FND_API.G_EXC_ERROR;

Line 579: RAISE FND_API.G_EXC_ERROR;

575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add('after update of flow status code - exc error '||sqlerrm,1);
578: END IF;
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( L_LINE_ID ) , 3 ) ;
583: END IF;

Line 594: x_return_status := FND_API.G_RET_STS_SUCCESS;

590:
591:
592: << END_SERVICE_LOOP >>
593:
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| X_RETURN_STATUS , 1 ) ;
598: END IF;

Line 602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

598: END IF;
599:
600: EXCEPTION
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604:
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

599:
600: EXCEPTION
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604:
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
607: END IF;

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

614: END IF;
615: G_DEBUG_MSG := G_DEBUG_MSG || 'E4,';
616:
617: WHEN OTHERS THEN
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
621: END IF;
622: IF l_debug_level > 0 THEN

Line 657: p_line_rec.service_start_date = FND_API.G_MISS_DATE

653: END IF;
654:
655:
656: IF p_line_rec.service_start_date IS NULL OR
657: p_line_rec.service_start_date = FND_API.G_MISS_DATE
658: THEN
659: l_line_rec := p_line_rec; -- 2897505 start
660: l_line_rec.service_start_date := NULL;
661: l_line_rec.service_reference_type_code := 'GET_SVC_START';

Line 689: p_line_rec.service_end_date = FND_API.G_MISS_DATE

685: );
686: END IF;
687:
688: ELSIF p_line_rec.service_end_date IS NULL OR
689: p_line_rec.service_end_date = FND_API.G_MISS_DATE
690: THEN
691:
692: OE_SERVICE_UTIL.Get_Service_Duration(
693: p_x_line_rec => p_line_rec,

Line 717: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

713: p_line_rec IN OE_Order_Pub.Line_Rec_Type DEFAULT OE_Order_Pub.G_MISS_LINE_REC
714: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type DEFAULT OE_Order_Pub.G_MISS_LINE_TBL
715: ,p_mode IN VARCHAR2
716: ,p_fulfillment_type IN VARCHAR2
717: ,p_fulfillment_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
718: ,x_return_status OUT NOCOPY VARCHAR2
719: )
720: IS
721: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 866: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

862: );
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add('Returned from lock row : '||l_return_status,3) ;
865: END IF;
866: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
869: END IF;
870: RAISE CAN_NOT_LOCK_MODEL;

Line 871: --RAISE FND_API.G_EXC_ERROR;

867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
869: END IF;
870: RAISE CAN_NOT_LOCK_MODEL;
871: --RAISE FND_API.G_EXC_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
875: END IF;

Line 872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

868: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
869: END IF;
870: RAISE CAN_NOT_LOCK_MODEL;
871: --RAISE FND_API.G_EXC_ERROR;
872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
875: END IF;
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
875: END IF;
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879:
880: l_line_tbl := l_old_line_tbl;

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

917: IF l_debug_level > 0 THEN
918: oe_debug_pub.add('Update_global return status from oe_line_fullfill.fullfill_line is: '|| l_return_status ) ;
919: oe_debug_pub.add('Global picture index is: '||l_notify_index,1) ;
920: END IF;
921: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924: IF l_notify_index IS NOT NULL THEN
925: --update Global Picture directly

Line 922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

918: oe_debug_pub.add('Update_global return status from oe_line_fullfill.fullfill_line is: '|| l_return_status ) ;
919: oe_debug_pub.add('Global picture index is: '||l_notify_index,1) ;
920: END IF;
921: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924: IF l_notify_index IS NOT NULL THEN
925: --update Global Picture directly
926: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);

Line 998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

994: p_Service_Order_Lines => l_Service_Order_Lines,
995: x_Return_Status => l_return_status,
996: x_Error_Message => l_msg_data);
997:
998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1000: oe_debug_pub.add('l_msg_data' || l_msg_data);
1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');

995: x_Return_Status => l_return_status,
996: x_Error_Message => l_msg_data);
997:
998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1000: oe_debug_pub.add('l_msg_data' || l_msg_data);
1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');

Line 1001: RAISE FND_API.G_EXC_ERROR;

997:
998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1000: oe_debug_pub.add('l_msg_data' || l_msg_data);
1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1004: oe_debug_pub.add('l_msg_data' || l_msg_data);
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1000: oe_debug_pub.add('l_msg_data' || l_msg_data);
1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1004: oe_debug_pub.add('l_msg_data' || l_msg_data);
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;

Line 1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');

999: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1000: oe_debug_pub.add('l_msg_data' || l_msg_data);
1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1004: oe_debug_pub.add('l_msg_data' || l_msg_data);
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: /* End Improved OM,IB,OKS changes */

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: RAISE FND_API.G_EXC_ERROR;
1002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1003: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1004: oe_debug_pub.add('l_msg_data' || l_msg_data);
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: /* End Improved OM,IB,OKS changes */
1008: END IF;
1009:

Line 1033: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1029: x_error_code => l_error_code,
1030: x_error_message => l_error_message);
1031: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1032:
1033: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1034: IF l_debug_level > 0 THEN
1035: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1036: END IF;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1034: IF l_debug_level > 0 THEN
1035: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1036: END IF;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: IF l_debug_level > 0 THEN
1040: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1041: END IF;

Line 1038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1034: IF l_debug_level > 0 THEN
1035: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1036: END IF;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: IF l_debug_level > 0 THEN
1040: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1041: END IF;
1042: RAISE FND_API.G_EXC_ERROR;

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: IF l_debug_level > 0 THEN
1040: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1041: END IF;
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044: END IF;
1045:
1046: ELSE

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: IF p_line_tbl.count = 0 THEN -- this IF added for 2231594
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add('Exiting fulfill_line() - no lines to update',3) ;
1054: END IF;
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: RETURN;
1057: END IF;
1058:
1059: -- CHANGES for AFD

Line 1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add('Returned from lock row : '||l_return_status,3) ;
1085: END IF;
1086:
1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
1090: END IF;
1091: RAISE CAN_NOT_LOCK_MODEL;

Line 1092: --RAISE FND_API.G_EXC_ERROR;

1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
1090: END IF;
1091: RAISE CAN_NOT_LOCK_MODEL;
1092: --RAISE FND_API.G_EXC_ERROR;
1093: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
1096: END IF;

Line 1093: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1089: oe_debug_pub.add('STS error while locking row '||sqlerrm,1);
1090: END IF;
1091: RAISE CAN_NOT_LOCK_MODEL;
1092: --RAISE FND_API.G_EXC_ERROR;
1093: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
1096: END IF;
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1093: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add('EXC error while locking row '||sqlerrm,1);
1096: END IF;
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099:
1100: l_line_tbl(l_index) := l_old_line_tbl(1);
1101: l_aso_line_tbl(l_index) := l_old_line_tbl(1);

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

1140: END IF;
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
1143: END IF;
1144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;
1147: IF l_notify_index IS NOT NULL THEN
1148: --update Global Picture directly

Line 1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
1143: END IF;
1144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;
1147: IF l_notify_index IS NOT NULL THEN
1148: --update Global Picture directly
1149: -- Fix for the bug2635911

Line 1179: OR p_line_tbl(l_index).item_type_code = FND_API.G_MISS_CHAR THEN -- 2417601

1175: END IF; --code_release_level
1176: -- notification framework end
1177: ELSIF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE /* 2292133 */
1178: OR p_line_tbl(l_index).item_type_code IS NULL -- 2417601
1179: OR p_line_tbl(l_index).item_type_code = FND_API.G_MISS_CHAR THEN -- 2417601
1180: l_line_rec := p_line_tbl(l_index);
1181: open srv_lines;
1182: fetch srv_lines into
1183: l_line_rec.service_start_date,

Line 1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1237: p_Service_Order_Lines => l_Service_Order_Lines,
1238: x_Return_Status => l_return_status,
1239: x_Error_Message => l_msg_data);
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1243: oe_debug_pub.add('l_msg_data' || l_msg_data);
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');

1238: x_Return_Status => l_return_status,
1239: x_Error_Message => l_msg_data);
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1243: oe_debug_pub.add('l_msg_data' || l_msg_data);
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1243: oe_debug_pub.add('l_msg_data' || l_msg_data);
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1247: oe_debug_pub.add('l_msg_data' || l_msg_data);
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1243: oe_debug_pub.add('l_msg_data' || l_msg_data);
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1247: oe_debug_pub.add('l_msg_data' || l_msg_data);
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;

Line 1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');

1242: oe_debug_pub.add('FND_API.G_RET_STS_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1243: oe_debug_pub.add('l_msg_data' || l_msg_data);
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1247: oe_debug_pub.add('l_msg_data' || l_msg_data);
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250: /* End Improved OM,IB,OKS changes */

Line 1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: oe_debug_pub.add('FND_API.G_RET_STS_UNEXP_ERROR after call to OKS_OMINT_PUB.Interface_Service');
1247: oe_debug_pub.add('l_msg_data' || l_msg_data);
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250: /* End Improved OM,IB,OKS changes */
1251:
1252:

Line 1298: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1294: x_error_code => l_error_code,
1295: x_error_message => l_error_message);
1296: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1297:
1298: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: IF l_debug_level > 0 THEN
1300: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1301: END IF;
1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1298: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: IF l_debug_level > 0 THEN
1300: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1301: END IF;
1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1303: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1306: END IF;

Line 1303: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1299: IF l_debug_level > 0 THEN
1300: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1301: END IF;
1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1303: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1306: END IF;
1307: RAISE FND_API.G_EXC_ERROR;

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1306: END IF;
1307: RAISE FND_API.G_EXC_ERROR;
1308: END IF;
1309: END IF;
1310:
1311: END LOOP;

Line 1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1326: OE_GLOBALS.G_RECURSION_MODE := 'N';
1327:
1328: oe_debug_pub.add('Return Status from Process Order : '||l_return_status,2);
1329:
1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327:
1328: oe_debug_pub.add('Return Status from Process Order : '||l_return_status,2);
1329:
1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: */

Line 1332: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1328: oe_debug_pub.add('Return Status from Process Order : '||l_return_status,2);
1329:
1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: */
1336: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN

Line 1333: RAISE FND_API.G_EXC_ERROR;

1329:
1330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335: */
1336: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
1337: IF (OE_GLOBALS.G_ASO_INSTALLED = 'Y') THEN

Line 1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1357:
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1362: RAISE FND_API.G_EXC_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;

Line 1362: RAISE FND_API.G_EXC_ERROR;

1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1362: RAISE FND_API.G_EXC_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366: END IF; /* ASO installed */

Line 1363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1359: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1362: RAISE FND_API.G_EXC_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366: END IF; /* ASO installed */
1367:

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1362: RAISE FND_API.G_EXC_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366: END IF; /* ASO installed */
1367:
1368:

Line 1387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add('returned from process request and notify : '||l_return_status,3) ;
1385: END IF;
1386:
1387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;

Line 1388: RAISE FND_API.G_EXC_ERROR;

1384: oe_debug_pub.add('returned from process request and notify : '||l_return_status,3) ;
1385: END IF;
1386:
1387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:

Line 1389: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1385: END IF;
1386:
1387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:
1393:

Line 1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1386:
1387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:
1393:
1394: END IF; /* ASO and DBI check for Pack H and higher */

Line 1400: x_return_status := FND_API.G_RET_STS_SUCCESS;

1396: END IF; --code_release_level
1397: IF l_debug_level > 0 THEN
1398: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_line()',1) ;
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: EXCEPTION
1403: WHEN CAN_NOT_LOCK_MODEL THEN
1404: IF l_debug_level > 0 THEN

Line 1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1405: oe_debug_pub.add( 'OEXVFULB.pls:Fulfill_line API- MODEL LOCKING EXCEPTION' , 1 ) ;
1406: END IF;
1407: x_return_status := 'D';
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: IF l_debug_level > 0 THEN
1411: oe_debug_pub.add('Unexp Error'||sqlerrm,1);
1412: END IF;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: IF l_debug_level > 0 THEN
1411: oe_debug_pub.add('Unexp Error'||sqlerrm,1);
1412: END IF;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Fulfill_Line');
1416: END IF;
1417: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';

Line 1418: WHEN FND_API.G_EXC_ERROR THEN

1414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Fulfill_Line');
1416: END IF;
1417: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';
1418: WHEN FND_API.G_EXC_ERROR THEN
1419: IF l_debug_level > 0 THEN
1420: oe_debug_pub.add('EXC Error '||sqlerrm,1);
1421: END IF;
1422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1422: x_return_status := FND_API.G_RET_STS_ERROR;

1418: WHEN FND_API.G_EXC_ERROR THEN
1419: IF l_debug_level > 0 THEN
1420: oe_debug_pub.add('EXC Error '||sqlerrm,1);
1421: END IF;
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423: WHEN OTHERS THEN
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add('Error '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1426: END IF;

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1423: WHEN OTHERS THEN
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add('Error '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1426: END IF;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1429: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Fulfill_Line');
1430: END IF;
1431: G_DEBUG_MSG := G_DEBUG_MSG || 'E7,';

Line 1461: x_return_status := FND_API.G_RET_STS_SUCCESS;

1457: --
1458: BEGIN
1459: x_attribute_value := wf_engine.GetActivityAttrText(p_item_type,p_item_key,p_activity_id,p_fulfill_attr_name);
1460:
1461: x_return_status := FND_API.G_RET_STS_SUCCESS;
1462:
1463: EXCEPTION
1464: WHEN OTHERS THEN
1465: IF l_debug_level > 0 THEN

Line 1474: x_return_status := FND_API.G_RET_STS_SUCCESS;

1470: IF l_debug_level > 0 THEN
1471: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
1472: END IF;
1473: x_attribute_value := 'NONE';
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475: ELSE
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: END IF;
1478:

Line 1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1472: END IF;
1473: x_attribute_value := 'NONE';
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475: ELSE
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: END IF;
1478:
1479: END Get_Activity_Attribute;
1480:

Line 1519: x_return_status := FND_API.G_RET_STS_SUCCESS;

1515: AND wias.ITEM_TYPE = p_item_type
1516: AND wpa.ACTIVITY_NAME = p_activity_name
1517: AND wias.PROCESS_ACTIVITY = wpa.INSTANCE_ID;
1518:
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520:
1521: IF l_debug_level > 0 THEN
1522: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;
1523: END IF;

Line 1536: x_return_status := FND_API.G_RET_STS_ERROR;

1532: FROM oe_order_lines
1533: WHERE line_id = to_number(p_item_key);
1534:
1535: IF l_upgraded_flag = 'N' THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: ELSE
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539: END IF;
1540: */

Line 1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

1534:
1535: IF l_upgraded_flag = 'N' THEN
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: ELSE
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539: END IF;
1540: */
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: G_DEBUG_MSG := G_DEBUG_MSG || '34,';

Line 1541: x_return_status := FND_API.G_RET_STS_ERROR;

1537: ELSE
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539: END IF;
1540: */
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: G_DEBUG_MSG := G_DEBUG_MSG || '34,';
1543: WHEN OTHERS THEN
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:

Line 1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1540: */
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: G_DEBUG_MSG := G_DEBUG_MSG || '34,';
1543: WHEN OTHERS THEN
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:
1546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1547: THEN
1548: OE_MSG_PUB.Add_Exc_Msg

Line 1596: l_line_set_exists VARCHAR2(1) := FND_API.G_FALSE;

1592: l_return_status VARCHAR2(1);
1593: l_loop_index NUMBER := 0;
1594: l_temp_index NUMBER := 0;
1595:
1596: l_line_set_exists VARCHAR2(1) := FND_API.G_FALSE;
1597:
1598: --
1599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1600: --

Line 1628: l_line_set_exists := FND_API.G_FALSE;

1624: END IF;
1625:
1626: FOR l_line_set in c_line_set
1627: LOOP
1628: l_line_set_exists := FND_API.G_FALSE;
1629: FOR l_temp_index IN 1..l_temp_tbl.count
1630: LOOP
1631:
1632: IF l_temp_tbl(l_temp_index).line_id = l_line_set.line_id AND

Line 1637: l_line_set_exists := FND_API.G_TRUE;

1633: l_temp_tbl(l_temp_index).set_id = l_set_id THEN
1634: IF l_debug_level > 0 THEN
1635: oe_debug_pub.add( 'LINE EXISTS FOR COMBINATION' , 3 ) ;
1636: END IF;
1637: l_line_set_exists := FND_API.G_TRUE;
1638: GOTO END_LINE_SET;
1639:
1640: END IF;
1641:

Line 1647: IF l_line_set_exists = FND_API.G_FALSE THEN

1643: NULL;
1644: END LOOP;
1645:
1646:
1647: IF l_line_set_exists = FND_API.G_FALSE THEN
1648: l_temp_index := l_temp_tbl.count + 1;
1649: l_temp_tbl(l_temp_index).line_id := l_line_set.line_id;
1650: l_temp_tbl(l_temp_index).set_id := l_line_set.set_id;
1651: IF l_debug_level > 0 THEN

Line 1675: l_line_set_exists := FND_API.G_FALSE;

1671: l_loop_index := 0;
1672: FOR l_loop_index IN l_set_tbl.FIRST .. l_set_tbl.LAST
1673: LOOP
1674:
1675: l_line_set_exists := FND_API.G_FALSE;
1676: FOR l_temp_index IN 1..l_temp_tbl.count
1677: LOOP
1678:
1679: IF l_temp_tbl(l_temp_index).line_id = l_set_tbl(l_loop_index).line_id AND

Line 1684: l_line_set_exists := FND_API.G_TRUE;

1680: l_temp_tbl(l_temp_index).set_id = l_set_tbl(l_loop_index).set_id THEN
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add( 'LINE EXISTS FOR COMBINATION' , 3 ) ;
1683: END IF;
1684: l_line_set_exists := FND_API.G_TRUE;
1685: GOTO END_LINE_SET1;
1686:
1687: END IF;
1688:

Line 1693: IF l_line_set_exists = FND_API.G_FALSE THEN

1689: << END_LINE_SET1 >>
1690: NULL;
1691: END LOOP;
1692:
1693: IF l_line_set_exists = FND_API.G_FALSE THEN
1694: l_temp_index := l_temp_tbl.count + 1;
1695: l_temp_tbl(l_temp_index).line_id := l_set_tbl(l_loop_index).line_id;
1696: l_temp_tbl(l_temp_index).set_id := l_set_tbl(l_loop_index).set_id;
1697: IF l_debug_level > 0 THEN

Line 1730: x_return_status := FND_API.G_RET_STS_SUCCESS;

1726: END IF;
1727:
1728: END LOOP;
1729:
1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731: IF l_debug_level > 0 THEN
1732: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_FULFILLMENT_SET ' , 3 ) ;
1733: END IF;
1734:

Line 1736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1732: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_FULFILLMENT_SET ' , 3 ) ;
1733: END IF;
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1737: IF l_debug_level > 0 THEN
1738: oe_debug_pub.add('Unexp Error '||sqlerrm,1);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1737: IF l_debug_level > 0 THEN
1738: oe_debug_pub.add('Unexp Error '||sqlerrm,1);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1741:
1742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1743: THEN
1744: OE_MSG_PUB.Add_Exc_Msg

Line 1751: WHEN FND_API.G_EXC_ERROR THEN

1747: );
1748: END IF;
1749: G_DEBUG_MSG := G_DEBUG_MSG || 'E10,';
1750:
1751: WHEN FND_API.G_EXC_ERROR THEN
1752: IF l_debug_level > 0 THEN
1753: oe_debug_pub.add('Exc Error '||sqlerrm,1);
1754: END IF;
1755: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1755: x_return_status := FND_API.G_RET_STS_ERROR;

1751: WHEN FND_API.G_EXC_ERROR THEN
1752: IF l_debug_level > 0 THEN
1753: oe_debug_pub.add('Exc Error '||sqlerrm,1);
1754: END IF;
1755: x_return_status := FND_API.G_RET_STS_ERROR;
1756: WHEN OTHERS THEN
1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add('error '||SUBSTR(SQLERRM,1,2000),1);
1759: END IF;

Line 1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1756: WHEN OTHERS THEN
1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add('error '||SUBSTR(SQLERRM,1,2000),1);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1761: IF l_debug_level > 0 THEN
1762: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1763: END IF;
1764:

Line 1839: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1835: x_return_status => l_return_status
1836: );
1837:
1838:
1839: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;

Line 1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1836: );
1837:
1838:
1839: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:

Line 1841: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1837:
1838:
1839: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: IF l_fulfill_activity_name = 'NONE' OR

Line 1842: RAISE FND_API.G_EXC_ERROR;

1838:
1839: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: IF l_fulfill_activity_name = 'NONE' OR
1846: l_fulfill_activity_name IS NULL THEN

Line 1870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1866: x_attribute_value => l_completion_result,
1867: x_return_status => l_return_status
1868: );
1869:
1870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;

Line 1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1867: x_return_status => l_return_status
1868: );
1869:
1870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:

Line 1872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1868: );
1869:
1870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1876: IF l_completion_result = 'NONE'OR

Line 1873: RAISE FND_API.G_EXC_ERROR;

1869:
1870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1876: IF l_completion_result = 'NONE'OR
1877: l_completion_result IS NULL THEN

Line 1901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1897: , x_activity_status_code => l_activity_status
1898: , x_activity_id => l_activity_id
1899: );
1900:
1901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1904: SELECT nvl(upgraded_flag,'N') -- Bug 3589692
1905: INTO l_upgraded_flag

Line 1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1898: , x_activity_id => l_activity_id
1899: );
1900:
1901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1904: SELECT nvl(upgraded_flag,'N') -- Bug 3589692
1905: INTO l_upgraded_flag
1906: FROM oe_order_lines

Line 1903: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1899: );
1900:
1901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1904: SELECT nvl(upgraded_flag,'N') -- Bug 3589692
1905: INTO l_upgraded_flag
1906: FROM oe_order_lines
1907: WHERE line_id = to_number(p_item_key);

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: INTO l_upgraded_flag
1906: FROM oe_order_lines
1907: WHERE line_id = to_number(p_item_key);
1908: IF l_upgraded_flag = 'N' THEN
1909: RAISE FND_API.G_EXC_ERROR;
1910: ELSE
1911: l_activity_status := OE_GLOBALS.G_WFR_COMPLETE;
1912: END IF; -- bug 3589692 ends
1913: END IF;

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: END IF; -- bug 3589692 ends
1913: END IF;
1914:
1915: IF l_activity_status <> OE_GLOBALS.G_WFR_COMPLETE THEN
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918:
1919: END IF;
1920:

Line 1932: x_return_status := FND_API.G_RET_STS_SUCCESS;

1928:
1929: END IF;
1930:
1931: x_fulfillment_activity := l_fulfill_activity_name;
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1931: x_fulfillment_activity := l_fulfill_activity_name;
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1937:
1938: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN

Line 1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1937:
1938: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN
1940: OE_MSG_PUB.Add_Exc_Msg

Line 1947: WHEN FND_API.G_EXC_ERROR THEN

1943: );
1944: END IF;
1945: G_DEBUG_MSG := G_DEBUG_MSG || 'E12,';
1946:
1947: WHEN FND_API.G_EXC_ERROR THEN
1948: x_return_status := FND_API.G_RET_STS_ERROR;
1949: WHEN OTHERS THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: IF l_debug_level > 0 THEN

Line 1948: x_return_status := FND_API.G_RET_STS_ERROR;

1944: END IF;
1945: G_DEBUG_MSG := G_DEBUG_MSG || 'E12,';
1946:
1947: WHEN FND_API.G_EXC_ERROR THEN
1948: x_return_status := FND_API.G_RET_STS_ERROR;
1949: WHEN OTHERS THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

Line 1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1946:
1947: WHEN FND_API.G_EXC_ERROR THEN
1948: x_return_status := FND_API.G_RET_STS_ERROR;
1949: WHEN OTHERS THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1953: END IF;
1954:

Line 1992: l_fulfill_status VARCHAR2(1) := FND_API.G_TRUE;

1988: l_activity_id NUMBER;
1989: l_item_key VARCHAR2(240);
1990: l_fulfill_activity VARCHAR2(30) := 'FULFILL_LINE';
1991: l_return_status VARCHAR2(1);
1992: l_fulfill_status VARCHAR2(1) := FND_API.G_TRUE;
1993:
1994: --
1995: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1996: --

Line 2030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2026: IF l_debug_level > 0 THEN
2027: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
2028: END IF;
2029:
2030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2033: l_activity_status <> 'NOTIFIED' THEN
2034: l_fulfill_status := FND_API.G_FALSE;

Line 2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2027: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
2028: END IF;
2029:
2030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2033: l_activity_status <> 'NOTIFIED' THEN
2034: l_fulfill_status := FND_API.G_FALSE;
2035: IF l_debug_level > 0 THEN

Line 2032: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR

2028: END IF;
2029:
2030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2033: l_activity_status <> 'NOTIFIED' THEN
2034: l_fulfill_status := FND_API.G_FALSE;
2035: IF l_debug_level > 0 THEN
2036: oe_debug_pub.add( 'LINE IS NOT FULFILLED : '||TO_CHAR ( L_TOP_LINES.LINE_ID ) , 3 ) ;

Line 2034: l_fulfill_status := FND_API.G_FALSE;

2030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2033: l_activity_status <> 'NOTIFIED' THEN
2034: l_fulfill_status := FND_API.G_FALSE;
2035: IF l_debug_level > 0 THEN
2036: oe_debug_pub.add( 'LINE IS NOT FULFILLED : '||TO_CHAR ( L_TOP_LINES.LINE_ID ) , 3 ) ;
2037: END IF;
2038: GOTO END_CHECK_LOOP;

Line 2047: x_return_status := FND_API.G_RET_STS_SUCCESS;

2043:
2044: << END_CHECK_LOOP >>
2045:
2046: x_fulfill_status := l_fulfill_status;
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048:
2049: IF l_debug_level > 0 THEN
2050: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '||L_FULFILL_STATUS||'/'||X_RETURN_STATUS , 1 ) ;
2051: END IF;

Line 2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2051: END IF;
2052:
2053: EXCEPTION
2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2057:
2058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2059: THEN

Line 2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2052:
2053: EXCEPTION
2054:
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2057:
2058: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2059: THEN
2060: OE_MSG_PUB.Add_Exc_Msg

Line 2067: WHEN FND_API.G_EXC_ERROR THEN

2063: );
2064: END IF;
2065: G_DEBUG_MSG := G_DEBUG_MSG || 'E14-1,';
2066:
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: G_DEBUG_MSG := G_DEBUG_MSG || 'E14-2,';
2070: WHEN OTHERS THEN
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR;

2064: END IF;
2065: G_DEBUG_MSG := G_DEBUG_MSG || 'E14-1,';
2066:
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: G_DEBUG_MSG := G_DEBUG_MSG || 'E14-2,';
2070: WHEN OTHERS THEN
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2072: IF l_debug_level > 0 THEN

Line 2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: G_DEBUG_MSG := G_DEBUG_MSG || 'E14-2,';
2070: WHEN OTHERS THEN
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2072: IF l_debug_level > 0 THEN
2073: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
2074: END IF;
2075:

Line 2130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2126: ,x_line_tbl => l_old_line_tbl
2127: ,x_return_status => l_return_status
2128: );
2129:
2130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2131: RAISE CAN_NOT_LOCK_MODEL;
2132: -- RAISE FND_API.G_EXC_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2132: -- RAISE FND_API.G_EXC_ERROR;

2128: );
2129:
2130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2131: RAISE CAN_NOT_LOCK_MODEL;
2132: -- RAISE FND_API.G_EXC_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136:

Line 2133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2129:
2130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2131: RAISE CAN_NOT_LOCK_MODEL;
2132: -- RAISE FND_API.G_EXC_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136:
2137: l_line_tbl := l_old_line_tbl;

Line 2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2131: RAISE CAN_NOT_LOCK_MODEL;
2132: -- RAISE FND_API.G_EXC_ERROR;
2133: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136:
2137: l_line_tbl := l_old_line_tbl;
2138: l_line_tbl(1).fulfilled_flag := 'Y';

Line 2176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2172: IF l_debug_level > 0 THEN
2173: oe_debug_pub.add('update_global return status for line ID '||L_LINE_TBL(1).LINE_ID||'IS:'||l_return_status,1) ;
2174: oe_debug_pub.add('update_global index in fulfill_pto_kit for line_id '||l_line_tbl(1).LINE_ID ||' is: '||l_index,1);
2175: END IF;
2176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: END IF;

Line 2177: RAISE FND_API.G_EXC_ERROR;

2173: oe_debug_pub.add('update_global return status for line ID '||L_LINE_TBL(1).LINE_ID||'IS:'||l_return_status,1) ;
2174: oe_debug_pub.add('update_global index in fulfill_pto_kit for line_id '||l_line_tbl(1).LINE_ID ||' is: '||l_index,1);
2175: END IF;
2176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: END IF;
2181: IF l_index IS NOT NULL THEN

Line 2178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2174: oe_debug_pub.add('update_global index in fulfill_pto_kit for line_id '||l_line_tbl(1).LINE_ID ||' is: '||l_index,1);
2175: END IF;
2176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: END IF;
2181: IF l_index IS NOT NULL THEN
2182: --update Global Picture directly

Line 2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2175: END IF;
2176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: END IF;
2181: IF l_index IS NOT NULL THEN
2182: --update Global Picture directly
2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);

Line 2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2207: ,x_return_status => l_return_status
2208: ,p_line_tbl => l_line_tbl
2209: ,p_old_line_tbl => l_old_line_tbl
2210: );
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;

Line 2212: RAISE FND_API.G_EXC_ERROR;

2208: ,p_line_tbl => l_line_tbl
2209: ,p_old_line_tbl => l_old_line_tbl
2210: );
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216:

Line 2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2209: ,p_old_line_tbl => l_old_line_tbl
2210: );
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216:
2217: ELSE /*pre-pack H*/

Line 2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2210: );
2211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216:
2217: ELSE /*pre-pack H*/
2218:

Line 2238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2234: , p_old_line_tbl => l_old_line_tbl
2235: );
2236:
2237:
2238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2242: END IF;

Line 2239: RAISE FND_API.G_EXC_ERROR;

2235: );
2236:
2237:
2238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2242: END IF;
2243:

Line 2240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2236:
2237:
2238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2242: END IF;
2243:
2244: END IF; -- code_release_level

Line 2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2237:
2238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2242: END IF;
2243:
2244: END IF; -- code_release_level
2245: END IF;

Line 2256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2252:
2253: IF l_debug_level > 0 THEN
2254: oe_debug_pub.add('Return status from flow status '||l_return_status,3) ;
2255: END IF;
2256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2253: IF l_debug_level > 0 THEN
2254: oe_debug_pub.add('Return status from flow status '||l_return_status,3) ;
2255: END IF;
2256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;
2261: IF l_debug_level > 0 THEN

Line 2258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2254: oe_debug_pub.add('Return status from flow status '||l_return_status,3) ;
2255: END IF;
2256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add('Fulfill associated service lines' , 3 ) ;

Line 2259: RAISE FND_API.G_EXC_ERROR;

2255: END IF;
2256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add('Fulfill associated service lines' , 3 ) ;
2263: END IF;

Line 2276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add('Return status from fulfill service lines '||l_return_status , 3 ) ;
2274: END IF;
2275:
2276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;

Line 2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2273: oe_debug_pub.add('Return status from fulfill service lines '||l_return_status , 3 ) ;
2274: END IF;
2275:
2276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;
2281: IF l_debug_level > 0 THEN

Line 2278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2274: END IF;
2275:
2276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add('Calling wf_engine.completeactivityinternalname '||to_char(l_top_lines.line_id),3) ;

Line 2279: RAISE FND_API.G_EXC_ERROR;

2275:
2276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: END IF;
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add('Calling wf_engine.completeactivityinternalname '||to_char(l_top_lines.line_id),3) ;
2283: END IF;

Line 2291: x_return_status := FND_API.G_RET_STS_SUCCESS;

2287: END IF;
2288:
2289: END LOOP;
2290:
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;
2292:
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_pto_kit '||x_return_status,3) ;
2295: END IF;

Line 2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2301: oe_debug_pub.add( 'OEXVSHPB.pls:Fulfill_PTO_KIT-MODEL LOCKING EXCEPTION', 1 ) ;
2302: END IF;
2303: x_return_status := 'D' ;
2304:
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2308: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Fulfill_PTO_KIT');
2309: END IF;

Line 2306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2302: END IF;
2303: x_return_status := 'D' ;
2304:
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2308: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Fulfill_PTO_KIT');
2309: END IF;
2310: G_DEBUG_MSG := G_DEBUG_MSG || 'E15,';

Line 2311: WHEN FND_API.G_EXC_ERROR THEN

2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2308: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Fulfill_PTO_KIT');
2309: END IF;
2310: G_DEBUG_MSG := G_DEBUG_MSG || 'E15,';
2311: WHEN FND_API.G_EXC_ERROR THEN
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: G_DEBUG_MSG := G_DEBUG_MSG || 'E16,';
2314: WHEN OTHERS THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2312: x_return_status := FND_API.G_RET_STS_ERROR;

2308: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Fulfill_PTO_KIT');
2309: END IF;
2310: G_DEBUG_MSG := G_DEBUG_MSG || 'E15,';
2311: WHEN FND_API.G_EXC_ERROR THEN
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: G_DEBUG_MSG := G_DEBUG_MSG || 'E16,';
2314: WHEN OTHERS THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2316: IF l_debug_level > 0 THEN

Line 2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2311: WHEN FND_API.G_EXC_ERROR THEN
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: G_DEBUG_MSG := G_DEBUG_MSG || 'E16,';
2314: WHEN OTHERS THEN
2315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2316: IF l_debug_level > 0 THEN
2317: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
2318: END IF;
2319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2355: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;

2351: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2352: l_service_index NUMBER;
2353: l_line_index NUMBER;
2354: l_fulfill_index NUMBER := 0 ;
2355: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;
2356: l_return_status VARCHAR2(1);
2357: l_line_id NUMBER;
2358: l_activity_status VARCHAR2(8);
2359: l_activity_result VARCHAR2(30);

Line 2374: line_id NUMBER := FND_API.G_MISS_NUM

2370: l_hold_result_out VARCHAR2(30):= 'TRUE';
2371:
2372: TYPE Fulfill_Service_Rec IS RECORD
2373: (
2374: line_id NUMBER := FND_API.G_MISS_NUM
2375: , header_id NUMBER := FND_API.G_MISS_NUM
2376: );
2377:
2378: TYPE Fulfill_Service_Tbl IS TABLE OF Fulfill_Service_Rec

Line 2375: , header_id NUMBER := FND_API.G_MISS_NUM

2371:
2372: TYPE Fulfill_Service_Rec IS RECORD
2373: (
2374: line_id NUMBER := FND_API.G_MISS_NUM
2375: , header_id NUMBER := FND_API.G_MISS_NUM
2376: );
2377:
2378: TYPE Fulfill_Service_Tbl IS TABLE OF Fulfill_Service_Rec
2379: INDEX BY BINARY_INTEGER;

Line 2437: l_fulfilled_flag := FND_API.G_FALSE;

2433: IF l_debug_level > 0 THEN
2434: oe_debug_pub.add( 'CAN NOT FULFILL MODEL YET!!' , 1 ) ;
2435: END IF;
2436:
2437: l_fulfilled_flag := FND_API.G_FALSE;
2438: GOTO END_PTO_KIT_LOOP;
2439:
2440: END IF;
2441: END IF;

Line 2462: p_process_all = FND_API.G_TRUE THEN

2458: END IF;
2459:
2460:
2461: IF l_pto_kit_lines.line_id <> p_line_id OR
2462: p_process_all = FND_API.G_TRUE THEN
2463: IF l_pto_kit_lines.fulfilled_flag = 'Y' THEN
2464: l_fulfilled_flag := FND_API.G_TRUE;
2465: IF l_debug_level > 0 THEN
2466: oe_debug_pub.add('line '||l_pto_kit_lines.line_id||' is already fulfilled ',5);

Line 2464: l_fulfilled_flag := FND_API.G_TRUE;

2460:
2461: IF l_pto_kit_lines.line_id <> p_line_id OR
2462: p_process_all = FND_API.G_TRUE THEN
2463: IF l_pto_kit_lines.fulfilled_flag = 'Y' THEN
2464: l_fulfilled_flag := FND_API.G_TRUE;
2465: IF l_debug_level > 0 THEN
2466: oe_debug_pub.add('line '||l_pto_kit_lines.line_id||' is already fulfilled ',5);
2467: END IF;
2468: ELSE

Line 2491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2487: IF l_debug_level > 0 THEN
2488: oe_debug_pub.add('return status - '||l_return_status||'/'||l_activity_status,5);
2489: END IF;
2490:
2491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2494: l_activity_status <> 'NOTIFIED' THEN
2495: l_fulfilled_flag := FND_API.G_FALSE;

Line 2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2488: oe_debug_pub.add('return status - '||l_return_status||'/'||l_activity_status,5);
2489: END IF;
2490:
2491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2494: l_activity_status <> 'NOTIFIED' THEN
2495: l_fulfilled_flag := FND_API.G_FALSE;
2496: x_fulfillment_status := FND_API.G_FALSE;

Line 2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR

2489: END IF;
2490:
2491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2494: l_activity_status <> 'NOTIFIED' THEN
2495: l_fulfilled_flag := FND_API.G_FALSE;
2496: x_fulfillment_status := FND_API.G_FALSE;
2497: IF l_debug_level > 0 THEN

Line 2495: l_fulfilled_flag := FND_API.G_FALSE;

2491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2494: l_activity_status <> 'NOTIFIED' THEN
2495: l_fulfilled_flag := FND_API.G_FALSE;
2496: x_fulfillment_status := FND_API.G_FALSE;
2497: IF l_debug_level > 0 THEN
2498: oe_debug_pub.add('line '||l_pto_kit_lines.line_id||' is not fulfilled ',5);
2499: END IF;

Line 2496: x_fulfillment_status := FND_API.G_FALSE;

2492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
2494: l_activity_status <> 'NOTIFIED' THEN
2495: l_fulfilled_flag := FND_API.G_FALSE;
2496: x_fulfillment_status := FND_API.G_FALSE;
2497: IF l_debug_level > 0 THEN
2498: oe_debug_pub.add('line '||l_pto_kit_lines.line_id||' is not fulfilled ',5);
2499: END IF;
2500: GOTO END_PTO_KIT_LOOP;

Line 2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2528: x_msg_data => x_msg_data);
2529:
2530: oe_debug_pub.add('after model check '||l_hold_result_out,1);
2531:
2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2533: IF l_hold_result_out = FND_API.G_TRUE THEN
2534: IF l_debug_level > 0 THEN
2535: oe_debug_pub.add('Model on Hold - CAN NOT FULFILL MODEL YET!!' , 1 ) ;
2536: END IF;

Line 2533: IF l_hold_result_out = FND_API.G_TRUE THEN

2529:
2530: oe_debug_pub.add('after model check '||l_hold_result_out,1);
2531:
2532: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2533: IF l_hold_result_out = FND_API.G_TRUE THEN
2534: IF l_debug_level > 0 THEN
2535: oe_debug_pub.add('Model on Hold - CAN NOT FULFILL MODEL YET!!' , 1 ) ;
2536: END IF;
2537: l_fulfilled_flag := FND_API.G_FALSE;

Line 2537: l_fulfilled_flag := FND_API.G_FALSE;

2533: IF l_hold_result_out = FND_API.G_TRUE THEN
2534: IF l_debug_level > 0 THEN
2535: oe_debug_pub.add('Model on Hold - CAN NOT FULFILL MODEL YET!!' , 1 ) ;
2536: END IF;
2537: l_fulfilled_flag := FND_API.G_FALSE;
2538: GOTO END_PTO_KIT_LOOP;
2539: END IF;
2540: END IF;
2541: END IF;

Line 2549: l_fulfilled_flag := FND_API.G_TRUE;

2545: fulfilled flag is not set it will be a line without fulfillment
2546: activity. So for the purpose of Configuration fulfillment it
2547: will can be considered as fulfilled */
2548:
2549: l_fulfilled_flag := FND_API.G_TRUE;
2550: IF l_debug_level > 0 THEN
2551: oe_debug_pub.add( 'LINE IS FULFILLED : '||TO_CHAR ( L_PTO_KIT_LINES.LINE_ID ) , 3 ) ;
2552: END IF;
2553: END IF;

Line 2559: IF l_fulfilled_flag = FND_API.G_TRUE AND p_part_of_fullfillment_set THEN

2555:
2556: END LOOP;
2557: << END_PTO_KIT_LOOP >>
2558:
2559: IF l_fulfilled_flag = FND_API.G_TRUE AND p_part_of_fullfillment_set THEN
2560:
2561: x_fulfillment_status := l_fulfilled_flag;
2562: x_return_status := FND_API.G_RET_STS_SUCCESS;
2563: IF l_debug_level > 0 THEN

Line 2562: x_return_status := FND_API.G_RET_STS_SUCCESS;

2558:
2559: IF l_fulfilled_flag = FND_API.G_TRUE AND p_part_of_fullfillment_set THEN
2560:
2561: x_fulfillment_status := l_fulfilled_flag;
2562: x_return_status := FND_API.G_RET_STS_SUCCESS;
2563: IF l_debug_level > 0 THEN
2564: oe_debug_pub.add('line is part of fulfillment set',1);
2565: END IF;
2566: RETURN;

Line 2569: IF l_fulfilled_flag = FND_API.G_TRUE THEN

2565: END IF;
2566: RETURN;
2567: END IF;
2568:
2569: IF l_fulfilled_flag = FND_API.G_TRUE THEN
2570:
2571: -- Prepare the table to update the fulfilled quantity and fulfilled
2572: -- flag for derived lines.
2573:

Line 2593: p_process_all = FND_API.G_TRUE) AND

2589: IF l_debug_level > 0 THEN
2590: oe_debug_pub.add('index/line_id/fulfilled :'||l_line_index||'/'||l_line_tbl(l_line_index).line_id||'/'||l_line_tbl(l_line_index).fulfilled_flag,5);
2591: END IF;
2592: IF (l_line_tbl(l_line_index).line_id <> p_line_id OR
2593: p_process_all = FND_API.G_TRUE) AND
2594: nvl(l_line_tbl(l_line_index).fulfilled_flag,'N') <> 'Y' THEN
2595:
2596: l_fulfill_index := l_fulfill_index + 1;
2597: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;

Line 2638: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2634: x_return_status => l_return_status,
2635: x_line_tbl => l_service_tbl
2636: );
2637:
2638: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2641: GOTO END_FULFILL_LOOP;
2642: END IF;

Line 2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2635: x_line_tbl => l_service_tbl
2636: );
2637:
2638: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2641: GOTO END_FULFILL_LOOP;
2642: END IF;
2643:

Line 2640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2636: );
2637:
2638: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2641: GOTO END_FULFILL_LOOP;
2642: END IF;
2643:
2644: /* Add service lines to l_fulfill_tbl for fulfillment */

Line 2715: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2711: IF l_debug_level > 0 THEN
2712: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL LINE : '||L_RETURN_STATUS , 3 ) ;
2713: END IF;
2714:
2715: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;

Line 2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2712: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL LINE : '||L_RETURN_STATUS , 3 ) ;
2713: END IF;
2714:
2715: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;
2720:

Line 2717: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2713: END IF;
2714:
2715: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;
2720:
2721:

Line 2718: RAISE FND_API.G_EXC_ERROR;

2714:
2715: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;
2720:
2721:
2722: -- Complete the FULFILL_LINE activity for the fulfilled lines.

Line 2727: p_process_all = FND_API.G_TRUE THEN

2723:
2724: FOR l_line_index IN 1 .. l_line_tbl.count
2725: LOOP
2726: IF l_line_tbl(l_line_index).line_id <> p_line_id OR
2727: p_process_all = FND_API.G_TRUE THEN
2728: l_line_id := l_line_tbl(l_line_index).line_id;
2729:
2730: IF l_debug_level > 0 THEN
2731: oe_debug_pub.add('update the flow status code on the lines ',5);

Line 2744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2740: IF l_debug_level > 0 THEN
2741: oe_debug_pub.add('after update of flow status '||l_return_status,5);
2742: END IF;
2743:
2744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;

Line 2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2741: oe_debug_pub.add('after update of flow status '||l_return_status,5);
2742: END IF;
2743:
2744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;
2749:

Line 2746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2742: END IF;
2743:
2744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;
2749:
2750: IF l_debug_level > 0 THEN

Line 2747: RAISE FND_API.G_EXC_ERROR;

2743:
2744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;
2749:
2750: IF l_debug_level > 0 THEN
2751: oe_debug_pub.add('** complete the WF activity on this '||l_line_id,1);

Line 2786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2782: IF l_debug_level > 0 THEN
2783: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
2784: END IF;
2785:
2786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;

Line 2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2783: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
2784: END IF;
2785:
2786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;
2791:

Line 2788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2784: END IF;
2785:
2786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;
2791:
2792: IF l_debug_level > 0 THEN

Line 2789: RAISE FND_API.G_EXC_ERROR;

2785:
2786: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2789: RAISE FND_API.G_EXC_ERROR;
2790: END IF;
2791:
2792: IF l_debug_level > 0 THEN
2793: oe_debug_pub.add('call complete WF for this service line - '||l_line_id,5);

Line 2807: x_return_status := FND_API.G_RET_STS_SUCCESS;

2803:
2804: END IF;
2805:
2806: x_fulfillment_status := l_fulfilled_flag;
2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: IF l_debug_level > 0 THEN
2810: oe_debug_pub.add('** complete OE_Line_Fullfill.Process_PTO_Kit() ',1);
2811: END IF;

Line 2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2810: oe_debug_pub.add('** complete OE_Line_Fullfill.Process_PTO_Kit() ',1);
2811: END IF;
2812:
2813: EXCEPTION
2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2815: IF l_debug_level > 0 THEN
2816: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);
2817: END IF;
2818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2815: IF l_debug_level > 0 THEN
2816: oe_debug_pub.add('*** 1. Error - '||SUBSTR(SQLERRM,1,200),1);
2817: END IF;
2818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2819:
2820: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2821: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_PTO_KIT');
2822: END IF;

Line 2824: WHEN FND_API.G_EXC_ERROR THEN

2820: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2821: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_PTO_KIT');
2822: END IF;
2823:
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('*** 2. Error - '||SUBSTR(SQLERRM,1,200),1);
2827: END IF;
2828: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2828: x_return_status := FND_API.G_RET_STS_ERROR;

2824: WHEN FND_API.G_EXC_ERROR THEN
2825: IF l_debug_level > 0 THEN
2826: oe_debug_pub.add('*** 2. Error - '||SUBSTR(SQLERRM,1,200),1);
2827: END IF;
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN OTHERS THEN
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2832: IF l_debug_level > 0 THEN

Line 2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2827: END IF;
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN OTHERS THEN
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add('*** 3. Error - '||SUBSTR(SQLERRM,1,200),1);
2834: END IF;
2835:

Line 2865: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;

2861: IS
2862: l_line_set_index NUMBER := 0;
2863: l_prev_set_id NUMBER := 0;
2864: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
2865: l_fulfilled_flag VARCHAR2(1) := FND_API.G_TRUE;
2866: l_item_key VARCHAR2(240);
2867: l_fulfill_activity VARCHAR2(30) := 'FULFILL_LINE';
2868: l_activity_status VARCHAR2(8);
2869: l_activity_result VARCHAR2(30);

Line 2885: l_process_all VARCHAR2(1) := FND_API.G_TRUE;

2881: l_fulfill_index NUMBER := 0 ;
2882: l_process_tbl Line_Set_Tbl_Type;
2883: l_process_index NUMBER := 0;
2884: l_fulfillment_status VARCHAR2(1);
2885: l_process_all VARCHAR2(1) := FND_API.G_TRUE;
2886: l_top_model_line_id NUMBER;
2887: l_header_id NUMBER;
2888: l_service_tbl OE_Order_Pub.Line_Tbl_Type;
2889: l_service_index NUMBER;

Line 2937: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN

2933:
2934: END IF;
2935:
2936: IF l_line_rec.top_model_line_id IS NOT NULL AND
2937: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
2938: IF l_debug_level > 0 THEN
2939: oe_debug_pub.add( 'LINE IS PART OF A CONFIGURATION : '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||'/'||L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
2940: END IF;
2941:

Line 3001: l_process_all := FND_API.G_FALSE;

2997: IF l_top_model_line_id = nvl(l_process_tbl(l_line_set_index).line_id,0) THEN
2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'DO NOT PROCESS ALL THE LINES ' , 3 ) ;
3000: END IF;
3001: l_process_all := FND_API.G_FALSE;
3002: ELSE
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'PROCESS ALL THE LINES ' , 3 ) ;
3005: END IF;

Line 3006: l_process_all := FND_API.G_TRUE;

3002: ELSE
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.add( 'PROCESS ALL THE LINES ' , 3 ) ;
3005: END IF;
3006: l_process_all := FND_API.G_TRUE;
3007: END IF;
3008:
3009:
3010: IF l_debug_level > 0 THEN

Line 3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3024: IF l_debug_level > 0 THEN
3025: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
3026: END IF;
3027:
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;

Line 3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3025: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
3026: END IF;
3027:
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:

Line 3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3026: END IF;
3027:
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034:

Line 3031: RAISE FND_API.G_EXC_ERROR;

3027:
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034:
3035: IF l_fulfillment_status = FND_API.G_TRUE THEN

Line 3035: IF l_fulfillment_status = FND_API.G_TRUE THEN

3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034:
3035: IF l_fulfillment_status = FND_API.G_TRUE THEN
3036: l_fulfilled_flag := FND_API.G_TRUE;
3037: IF l_debug_level > 0 THEN
3038: oe_debug_pub.add( 'CONFIGURATION IS FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3039: END IF;

Line 3036: l_fulfilled_flag := FND_API.G_TRUE;

3032: END IF;
3033:
3034:
3035: IF l_fulfillment_status = FND_API.G_TRUE THEN
3036: l_fulfilled_flag := FND_API.G_TRUE;
3037: IF l_debug_level > 0 THEN
3038: oe_debug_pub.add( 'CONFIGURATION IS FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3039: END IF;
3040: ELSE

Line 3041: l_fulfilled_flag := FND_API.G_FALSE;

3037: IF l_debug_level > 0 THEN
3038: oe_debug_pub.add( 'CONFIGURATION IS FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3039: END IF;
3040: ELSE
3041: l_fulfilled_flag := FND_API.G_FALSE;
3042: x_fulfillment_status := FND_API.G_FALSE;
3043: IF l_debug_level > 0 THEN
3044: oe_debug_pub.add( 'CONFIGURATION IS NOT FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3045: END IF;

Line 3042: x_fulfillment_status := FND_API.G_FALSE;

3038: oe_debug_pub.add( 'CONFIGURATION IS FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3039: END IF;
3040: ELSE
3041: l_fulfilled_flag := FND_API.G_FALSE;
3042: x_fulfillment_status := FND_API.G_FALSE;
3043: IF l_debug_level > 0 THEN
3044: oe_debug_pub.add( 'CONFIGURATION IS NOT FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3045: END IF;
3046: GOTO END_CHECK_FULFILLMENT;

Line 3054: l_fulfilled_flag := FND_API.G_TRUE;

3050: IF p_line_id <> l_process_tbl(l_line_set_index).line_id AND
3051: l_process_tbl(l_line_set_index).type = 'S' THEN
3052:
3053: IF l_process_tbl(l_line_set_index).fulfilled_flag = 'Y' THEN
3054: l_fulfilled_flag := FND_API.G_TRUE;
3055: IF l_debug_level > 0 THEN
3056: oe_debug_pub.add( 'LINE IS FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3057: END IF;
3058: ELSE

Line 3081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3077: IF l_debug_level > 0 THEN
3078: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||L_ACTIVITY_STATUS , 3 ) ;
3079: END IF;
3080:
3081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
3084: l_activity_status <> 'NOTIFIED' THEN
3085: l_fulfilled_flag := FND_API.G_FALSE;

Line 3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3078: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||L_ACTIVITY_STATUS , 3 ) ;
3079: END IF;
3080:
3081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
3084: l_activity_status <> 'NOTIFIED' THEN
3085: l_fulfilled_flag := FND_API.G_FALSE;
3086: x_fulfillment_status := FND_API.G_FALSE;

Line 3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR

3079: END IF;
3080:
3081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
3084: l_activity_status <> 'NOTIFIED' THEN
3085: l_fulfilled_flag := FND_API.G_FALSE;
3086: x_fulfillment_status := FND_API.G_FALSE;
3087: IF l_debug_level > 0 THEN

Line 3085: l_fulfilled_flag := FND_API.G_FALSE;

3081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
3084: l_activity_status <> 'NOTIFIED' THEN
3085: l_fulfilled_flag := FND_API.G_FALSE;
3086: x_fulfillment_status := FND_API.G_FALSE;
3087: IF l_debug_level > 0 THEN
3088: oe_debug_pub.add( 'LINE IS NOT FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3089: END IF;

Line 3086: x_fulfillment_status := FND_API.G_FALSE;

3082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR OR
3084: l_activity_status <> 'NOTIFIED' THEN
3085: l_fulfilled_flag := FND_API.G_FALSE;
3086: x_fulfillment_status := FND_API.G_FALSE;
3087: IF l_debug_level > 0 THEN
3088: oe_debug_pub.add( 'LINE IS NOT FULFILLED : '||TO_CHAR ( L_PROCESS_TBL ( L_LINE_SET_INDEX ) .LINE_ID ) , 3 ) ;
3089: END IF;
3090: GOTO END_CHECK_FULFILLMENT;

Line 3098: l_fulfilled_flag := FND_API.G_TRUE;

3094: fulfilled flag is not set it will be a line without fulfillment
3095: activity. So for the purpose of fulfillment set fulfillment it will
3096: can be considered as fulfilled */
3097:
3098: l_fulfilled_flag := FND_API.G_TRUE;
3099:
3100: END IF;
3101:
3102: END IF;

Line 3111: IF l_fulfilled_flag = FND_API.G_TRUE THEN

3107:
3108: /* If the fulfilled flag after the above loop is TRUE, complete the
3109: fulfill line work flow for all the lines except the current line */
3110:
3111: IF l_fulfilled_flag = FND_API.G_TRUE THEN
3112:
3113: /* Prepare a table of lines which have not been fulfilled to update
3114: the fulfillment related attributes and comlpete the fulfill line */
3115:

Line 3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3129: x_return_status => l_return_status,
3130: x_line_tbl => l_service_tbl
3131: );
3132:
3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3136: GOTO END_SERVICE_LINE;
3137: END IF;

Line 3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3130: x_line_tbl => l_service_tbl
3131: );
3132:
3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3136: GOTO END_SERVICE_LINE;
3137: END IF;
3138:

Line 3135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3131: );
3132:
3133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3136: GOTO END_SERVICE_LINE;
3137: END IF;
3138:
3139: /* Add service lines to l_fulfill_tbl for fulfillment */

Line 3269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3265: IF l_debug_level > 0 THEN
3266: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL LINE : '||L_RETURN_STATUS , 3 ) ;
3267: END IF;
3268:
3269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;

Line 3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3266: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL LINE : '||L_RETURN_STATUS , 3 ) ;
3267: END IF;
3268:
3269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274:

Line 3271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3267: END IF;
3268:
3269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: END IF;

Line 3272: RAISE FND_API.G_EXC_ERROR;

3268:
3269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3271: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: END IF;
3276:

Line 3303: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3301: END IF;
3302:
3303: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: END IF;

Line 3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3300: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3301: END IF;
3302:
3303: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: END IF;
3308:

Line 3305: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3301: END IF;
3302:
3303: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: END IF;
3308:
3309: IF l_debug_level > 0 THEN

Line 3306: RAISE FND_API.G_EXC_ERROR;

3302:
3303: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: RAISE FND_API.G_EXC_ERROR;
3307: END IF;
3308:
3309: IF l_debug_level > 0 THEN
3310: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( L_LINE_TBL ( L_LINE_TBL_INDEX ) ) , 3 ) ;

Line 3342: x_return_status := FND_API.G_RET_STS_SUCCESS;

3338: END LOOP;
3339:
3340: END IF;
3341:
3342: x_return_status := FND_API.G_RET_STS_SUCCESS;
3343: x_fulfillment_status := l_fulfilled_flag;
3344: IF l_debug_level > 0 THEN
3345: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '||X_RETURN_STATUS||'/'||X_FULFILLMENT_STATUS , 1 ) ;
3346: END IF;

Line 3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3346: END IF;
3347:
3348:
3349: EXCEPTION
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352:
3353: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN

Line 3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3347:
3348:
3349: EXCEPTION
3350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352:
3353: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN
3355: OE_MSG_PUB.Add_Exc_Msg

Line 3362: WHEN FND_API.G_EXC_ERROR THEN

3358: );
3359: END IF;
3360: G_DEBUG_MSG := G_DEBUG_MSG || 'E20,';
3361:
3362: WHEN FND_API.G_EXC_ERROR THEN
3363: x_return_status := FND_API.G_RET_STS_ERROR;
3364: G_DEBUG_MSG := G_DEBUG_MSG || 'E20-1,';
3365: WHEN OTHERS THEN
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3363: x_return_status := FND_API.G_RET_STS_ERROR;

3359: END IF;
3360: G_DEBUG_MSG := G_DEBUG_MSG || 'E20,';
3361:
3362: WHEN FND_API.G_EXC_ERROR THEN
3363: x_return_status := FND_API.G_RET_STS_ERROR;
3364: G_DEBUG_MSG := G_DEBUG_MSG || 'E20-1,';
3365: WHEN OTHERS THEN
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3367: IF l_debug_level > 0 THEN

Line 3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3362: WHEN FND_API.G_EXC_ERROR THEN
3363: x_return_status := FND_API.G_RET_STS_ERROR;
3364: G_DEBUG_MSG := G_DEBUG_MSG || 'E20-1,';
3365: WHEN OTHERS THEN
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3367: IF l_debug_level > 0 THEN
3368: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
3369: END IF;
3370:

Line 3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3486: IF l_debug_level > 0 THEN
3487: oe_debug_pub.add( 'RETURN STATUS FROM GET FULFILLMENT SET : '||L_RETURN_STATUS||'/'||TO_CHAR ( L_SET_TBL.COUNT ) , 3 ) ;
3488: END IF;
3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: IF l_debug_level > 0 THEN
3492: oe_debug_pub.add('unexp error while getting fulfillment set info '||sqlerrm,1);
3493: END IF;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: IF l_debug_level > 0 THEN
3492: oe_debug_pub.add('unexp error while getting fulfillment set info '||sqlerrm,1);
3493: END IF;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('exc error while getting fulfillment set info '||sqlerrm,1);
3498: END IF;

Line 3495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3491: IF l_debug_level > 0 THEN
3492: oe_debug_pub.add('unexp error while getting fulfillment set info '||sqlerrm,1);
3493: END IF;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('exc error while getting fulfillment set info '||sqlerrm,1);
3498: END IF;
3499: RAISE FND_API.G_EXC_ERROR;

Line 3499: RAISE FND_API.G_EXC_ERROR;

3495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('exc error while getting fulfillment set info '||sqlerrm,1);
3498: END IF;
3499: RAISE FND_API.G_EXC_ERROR;
3500: END IF;
3501:
3502: /* Lock the relevent lines */
3503:

Line 3656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3652: );
3653:
3654:
3655:
3656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3659: RAISE FND_API.G_EXC_ERROR;
3660: END IF;

Line 3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3653:
3654:
3655:
3656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3659: RAISE FND_API.G_EXC_ERROR;
3660: END IF;
3661:

Line 3658: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3654:
3655:
3656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3659: RAISE FND_API.G_EXC_ERROR;
3660: END IF;
3661:
3662: IF l_debug_level > 0 THEN

Line 3659: RAISE FND_API.G_EXC_ERROR;

3655:
3656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3659: RAISE FND_API.G_EXC_ERROR;
3660: END IF;
3661:
3662: IF l_debug_level > 0 THEN
3663: oe_debug_pub.add( 'FULFILLMENT ACTIVITY : '|| L_FULFILLMENT_ACTIVITY , 3 ) ;

Line 3694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3690: END IF;
3691:
3692: IF l_return_status = 'D' THEN
3693: RAISE CAN_NOT_LOCK_MODEL;
3694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;

Line 3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3691:
3692: IF l_return_status = 'D' THEN
3693: RAISE CAN_NOT_LOCK_MODEL;
3694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;
3699: ELSE

Line 3696: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3692: IF l_return_status = 'D' THEN
3693: RAISE CAN_NOT_LOCK_MODEL;
3694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;
3699: ELSE
3700: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;

Line 3697: RAISE FND_API.G_EXC_ERROR;

3693: RAISE CAN_NOT_LOCK_MODEL;
3694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;
3699: ELSE
3700: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;
3701: --l_fulfillment_activity := FND_API.G_MISS_CHAR;

Line 3701: --l_fulfillment_activity := FND_API.G_MISS_CHAR;

3697: RAISE FND_API.G_EXC_ERROR;
3698: END IF;
3699: ELSE
3700: l_fulfillment_type := G_FULFILL_NO_ACTIVITY;
3701: --l_fulfillment_activity := FND_API.G_MISS_CHAR;
3702: END IF;
3703:
3704: IF l_set_tbl.count > 0 THEN
3705: -- Processing for Fulfillment set

Line 3726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3722: IF l_debug_level > 0 THEN
3723: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
3724: END IF;
3725:
3726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3729: RAISE FND_API.G_EXC_ERROR;
3730: END IF;

Line 3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3723: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
3724: END IF;
3725:
3726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3729: RAISE FND_API.G_EXC_ERROR;
3730: END IF;
3731:

Line 3728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3724: END IF;
3725:
3726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3729: RAISE FND_API.G_EXC_ERROR;
3730: END IF;
3731:
3732:

Line 3729: RAISE FND_API.G_EXC_ERROR;

3725:
3726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3729: RAISE FND_API.G_EXC_ERROR;
3730: END IF;
3731:
3732:
3733:

Line 3734: IF l_fulfillment_status = FND_API.G_FALSE THEN

3730: END IF;
3731:
3732:
3733:
3734: IF l_fulfillment_status = FND_API.G_FALSE THEN
3735: IF l_debug_level > 0 THEN
3736: oe_debug_pub.add( 'ALL THE LINES OF THE FULFILLMENT SET HAS NOT BEEN FULFILLED' , 3 ) ;
3737: END IF;
3738: x_result_out := 'NOTIFIED:#NULL';

Line 3754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3750: );
3751:
3752: IF l_return_status = 'D' THEN
3753: RAISE CAN_NOT_LOCK_MODEL;
3754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3756: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3757: RAISE FND_API.G_EXC_ERROR;
3758: END IF;

Line 3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3751:
3752: IF l_return_status = 'D' THEN
3753: RAISE CAN_NOT_LOCK_MODEL;
3754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3756: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3757: RAISE FND_API.G_EXC_ERROR;
3758: END IF;
3759: END IF;

Line 3756: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3752: IF l_return_status = 'D' THEN
3753: RAISE CAN_NOT_LOCK_MODEL;
3754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3756: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3757: RAISE FND_API.G_EXC_ERROR;
3758: END IF;
3759: END IF;
3760:

Line 3757: RAISE FND_API.G_EXC_ERROR;

3753: RAISE CAN_NOT_LOCK_MODEL;
3754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3756: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3757: RAISE FND_API.G_EXC_ERROR;
3758: END IF;
3759: END IF;
3760:
3761:

Line 3764: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN

3760:
3761:
3762:
3763: ELSIF l_line_rec.top_model_line_id IS NOT NULL AND
3764: l_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
3765:
3766: -- Processing for PTO/ATO/KIT
3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add( 'IT IS LINE PART OF A PTO' , 3 ) ;

Line 3809: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3805: );
3806:
3807: IF l_return_status = 'D' THEN
3808: RAISE CAN_NOT_LOCK_MODEL;
3809: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;

Line 3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3806:
3807: IF l_return_status = 'D' THEN
3808: RAISE CAN_NOT_LOCK_MODEL;
3809: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:

Line 3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3807: IF l_return_status = 'D' THEN
3808: RAISE CAN_NOT_LOCK_MODEL;
3809: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:
3815: END IF; /* fulfilled _flag */

Line 3812: RAISE FND_API.G_EXC_ERROR;

3808: RAISE CAN_NOT_LOCK_MODEL;
3809: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:
3815: END IF; /* fulfilled _flag */
3816: --bug 6394191 ATO Remnant Model Processing Modified ****Start

Line 3817: IF l_line_rec.ato_line_id IS NOT NULL AND l_line_rec.ato_line_id <> FND_API.G_MISS_NUM then --AND

3813: END IF;
3814:
3815: END IF; /* fulfilled _flag */
3816: --bug 6394191 ATO Remnant Model Processing Modified ****Start
3817: IF l_line_rec.ato_line_id IS NOT NULL AND l_line_rec.ato_line_id <> FND_API.G_MISS_NUM then --AND
3818: --(l_line_rec.item_type_code = 'CONFIG' OR (l_line_rec.item_type_code = 'CLASS' AND
3819: -- l_line_rec.ato_line_id = l_line_rec.line_id)) THEN
3820:
3821: IF l_debug_level > 0 THEN

Line 3864: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3860: IF l_debug_level > 0 THEN
3861: oe_debug_pub.add('return status - '||L_RETURN_STATUS , 3 ) ;
3862: END IF;
3863:
3864: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3867: IF l_debug_level > 0 THEN
3868: oe_debug_pub.add('The ATO line is not at fulfillment '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;

Line 3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3861: oe_debug_pub.add('return status - '||L_RETURN_STATUS , 3 ) ;
3862: END IF;
3863:
3864: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3867: IF l_debug_level > 0 THEN
3868: oe_debug_pub.add('The ATO line is not at fulfillment '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
3869: END IF;

Line 3866: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3862: END IF;
3863:
3864: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3867: IF l_debug_level > 0 THEN
3868: oe_debug_pub.add('The ATO line is not at fulfillment '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
3869: END IF;
3870: x_result_out := 'NOTIFIED:#NULL';

Line 3885: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3881: p_fulfillment_activity => l_fulfillment_activity,
3882: x_return_status => l_return_status
3883: );
3884:
3885: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;

Line 3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3882: x_return_status => l_return_status
3883: );
3884:
3885: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890:

Line 3887: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3883: );
3884:
3885: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890:
3891:

Line 3888: RAISE FND_API.G_EXC_ERROR;

3884:
3885: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890:
3891:
3892: IF l_line_tbl(l_line_index).line_id <> p_line_id THEN

Line 3907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3903: IF l_debug_level > 0 THEN
3904: oe_debug_pub.add('return status - '||L_RETURN_STATUS,5);
3905: END IF;
3906:
3907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;

Line 3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3904: oe_debug_pub.add('return status - '||L_RETURN_STATUS,5);
3905: END IF;
3906:
3907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;
3912:

Line 3909: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3905: END IF;
3906:
3907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;
3912:
3913:

Line 3910: RAISE FND_API.G_EXC_ERROR;

3906:
3907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;
3912:
3913:
3914: IF l_debug_level > 0 THEN

Line 3940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3936: IF l_debug_level > 0 THEN
3937: oe_debug_pub.add('return status - '||L_RETURN_STATUS , 3 ) ;
3938: END IF;
3939:
3940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;

Line 3941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3937: oe_debug_pub.add('return status - '||L_RETURN_STATUS , 3 ) ;
3938: END IF;
3939:
3940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;
3945: END LOOP;

Line 3942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3938: END IF;
3939:
3940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;
3945: END LOOP;
3946: --bug6394191 Remnant ATO Model Processing Modified **End

Line 3943: RAISE FND_API.G_EXC_ERROR;

3939:
3940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3943: RAISE FND_API.G_EXC_ERROR;
3944: END IF;
3945: END LOOP;
3946: --bug6394191 Remnant ATO Model Processing Modified **End
3947:

Line 3950: l_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND

3946: --bug6394191 Remnant ATO Model Processing Modified **End
3947:
3948: --Old Processing Commented Below
3949: /* IF l_line_rec.ato_line_id IS NOT NULL AND
3950: l_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND
3951: fix for bug 2206098
3952: (l_line_rec.item_type_code = 'CONFIG' OR
3953: (l_line_rec.item_type_code = 'CLASS' AND
3954: l_line_rec.ato_line_id = l_line_rec.line_id)) THEN

Line 4009: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4005: IF l_debug_level > 0 THEN
4006: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
4007: END IF;
4008:
4009: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4011: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4012: IF l_debug_level > 0 THEN
4013: oe_debug_pub.add( 'CONFIG LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;

Line 4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4006: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
4007: END IF;
4008:
4009: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4011: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4012: IF l_debug_level > 0 THEN
4013: oe_debug_pub.add( 'CONFIG LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
4014: END IF;

Line 4011: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4007: END IF;
4008:
4009: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4011: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4012: IF l_debug_level > 0 THEN
4013: oe_debug_pub.add( 'CONFIG LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
4014: END IF;
4015: x_result_out := 'NOTIFIED:#NULL';

Line 4041: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4037: IF l_debug_level > 0 THEN
4038: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4039: END IF;
4040:
4041: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF;

Line 4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4038: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4039: END IF;
4040:
4041: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF;
4046: -- end of bug 4460242

Line 4043: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4039: END IF;
4040:
4041: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF;
4046: -- end of bug 4460242
4047:

Line 4044: RAISE FND_API.G_EXC_ERROR;

4040:
4041: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF;
4046: -- end of bug 4460242
4047:
4048: IF l_debug_level > 0 THEN

Line 4075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4071: IF l_debug_level > 0 THEN
4072: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4073: END IF;
4074:
4075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF;

Line 4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4072: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4073: END IF;
4074:
4075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF;
4080:

Line 4077: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4073: END IF;
4074:
4075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF;
4080:
4081:

Line 4078: RAISE FND_API.G_EXC_ERROR;

4074:
4075: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4078: RAISE FND_API.G_EXC_ERROR;
4079: END IF;
4080:
4081:
4082: ELSE

Line 4108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4104: IF l_debug_level > 0 THEN
4105: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
4106: END IF;
4107:
4108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4111: IF l_debug_level > 0 THEN
4112: oe_debug_pub.add( 'MODEL LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;

Line 4109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4105: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS||'/'||L_ACTIVITY_STATUS , 3 ) ;
4106: END IF;
4107:
4108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4111: IF l_debug_level > 0 THEN
4112: oe_debug_pub.add( 'MODEL LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
4113: END IF;

Line 4110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4106: END IF;
4107:
4108: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4111: IF l_debug_level > 0 THEN
4112: oe_debug_pub.add( 'MODEL LINE IS NOT AT FULFILLMENT : '||TO_CHAR ( L_LINE_REC.ATO_LINE_ID ) , 3 ) ;
4113: END IF;
4114: x_result_out := 'NOTIFIED:#NULL';

Line 4138: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4134: IF l_debug_level > 0 THEN
4135: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4136: END IF;
4137:
4138: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4140: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4141: RAISE FND_API.G_EXC_ERROR;
4142: END IF;

Line 4139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4135: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4136: END IF;
4137:
4138: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4140: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4141: RAISE FND_API.G_EXC_ERROR;
4142: END IF;
4143: -- bug 4460242 end

Line 4140: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4136: END IF;
4137:
4138: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4140: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4141: RAISE FND_API.G_EXC_ERROR;
4142: END IF;
4143: -- bug 4460242 end
4144:

Line 4141: RAISE FND_API.G_EXC_ERROR;

4137:
4138: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4140: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4141: RAISE FND_API.G_EXC_ERROR;
4142: END IF;
4143: -- bug 4460242 end
4144:
4145: IF l_debug_level > 0 THEN

Line 4172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4168: IF l_debug_level > 0 THEN
4169: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4170: END IF;
4171:
4172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;

Line 4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4169: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4170: END IF;
4171:
4172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;
4177:

Line 4174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4170: END IF;
4171:
4172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;
4177:
4178: END IF;*/

Line 4175: RAISE FND_API.G_EXC_ERROR;

4171:
4172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;
4177:
4178: END IF;*/
4179:

Line 4201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4197: IF l_debug_level > 0 THEN
4198: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4199: END IF;
4200:
4201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4204: RAISE FND_API.G_EXC_ERROR;
4205: END IF;

Line 4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4198: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4199: END IF;
4200:
4201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4204: RAISE FND_API.G_EXC_ERROR;
4205: END IF;
4206:

Line 4203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4199: END IF;
4200:
4201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4204: RAISE FND_API.G_EXC_ERROR;
4205: END IF;
4206:
4207: END IF;

Line 4204: RAISE FND_API.G_EXC_ERROR;

4200:
4201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4204: RAISE FND_API.G_EXC_ERROR;
4205: END IF;
4206:
4207: END IF;
4208:

Line 4220: p_process_all => FND_API.G_FALSE,

4216: (
4217: p_line_id => l_line_rec.line_id,
4218: p_top_model_line_id => l_line_rec.top_model_line_id,
4219: p_fulfillment_activity => l_fulfillment_activity,
4220: p_process_all => FND_API.G_FALSE,
4221: x_return_status => l_return_status,
4222: x_fulfillment_status => l_fulfillment_status
4223: );
4224:

Line 4230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4226: IF l_debug_level > 0 THEN
4227: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
4228: END IF;
4229:
4230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: END IF;

Line 4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4227: oe_debug_pub.add( 'RETURN STATUS/FULFILLMENT STATUS : '||L_RETURN_STATUS||'/'||L_FULFILLMENT_STATUS , 3 ) ;
4228: END IF;
4229:
4230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: END IF;
4235:

Line 4232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4228: END IF;
4229:
4230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: END IF;
4235:
4236:

Line 4233: RAISE FND_API.G_EXC_ERROR;

4229:
4230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: END IF;
4235:
4236:
4237: IF l_fulfillment_status = FND_API.G_FALSE THEN

Line 4237: IF l_fulfillment_status = FND_API.G_FALSE THEN

4233: RAISE FND_API.G_EXC_ERROR;
4234: END IF;
4235:
4236:
4237: IF l_fulfillment_status = FND_API.G_FALSE THEN
4238: IF l_debug_level > 0 THEN
4239: oe_debug_pub.add( 'ALL THE LINES OF THE FULFILLMENT SET HAS NOT BEEN FULFILLED' , 3 ) ;
4240: END IF;
4241: x_result_out := 'NOTIFIED:#NULL';

Line 4256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4252: );
4253:
4254: IF l_return_status = 'D' THEN
4255: RAISE CAN_NOT_LOCK_MODEL;
4256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: END IF;

Line 4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4253:
4254: IF l_return_status = 'D' THEN
4255: RAISE CAN_NOT_LOCK_MODEL;
4256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: END IF;
4261: END IF;

Line 4258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4254: IF l_return_status = 'D' THEN
4255: RAISE CAN_NOT_LOCK_MODEL;
4256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: END IF;
4261: END IF;
4262: -- END IF;

Line 4259: RAISE FND_API.G_EXC_ERROR;

4255: RAISE CAN_NOT_LOCK_MODEL;
4256: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: END IF;
4261: END IF;
4262: -- END IF;
4263:

Line 4314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4310: END IF;
4311:
4312: IF l_return_status = 'D' THEN
4313: RAISE CAN_NOT_LOCK_MODEL;
4314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4317: RAISE FND_API.G_EXC_ERROR;
4318: END IF;

Line 4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4311:
4312: IF l_return_status = 'D' THEN
4313: RAISE CAN_NOT_LOCK_MODEL;
4314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4317: RAISE FND_API.G_EXC_ERROR;
4318: END IF;
4319:

Line 4316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4312: IF l_return_status = 'D' THEN
4313: RAISE CAN_NOT_LOCK_MODEL;
4314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4317: RAISE FND_API.G_EXC_ERROR;
4318: END IF;
4319:
4320: END IF;

Line 4317: RAISE FND_API.G_EXC_ERROR;

4313: RAISE CAN_NOT_LOCK_MODEL;
4314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4316: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4317: RAISE FND_API.G_EXC_ERROR;
4318: END IF;
4319:
4320: END IF;
4321:

Line 4363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4359: END IF;
4360:
4361: IF l_return_status = 'D' THEN
4362: RAISE CAN_NOT_LOCK_MODEL;
4363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4366: RAISE FND_API.G_EXC_ERROR;
4367: END IF;

Line 4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4360:
4361: IF l_return_status = 'D' THEN
4362: RAISE CAN_NOT_LOCK_MODEL;
4363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4366: RAISE FND_API.G_EXC_ERROR;
4367: END IF;
4368:

Line 4365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4361: IF l_return_status = 'D' THEN
4362: RAISE CAN_NOT_LOCK_MODEL;
4363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4366: RAISE FND_API.G_EXC_ERROR;
4367: END IF;
4368:
4369: IF l_debug_level > 0 THEN

Line 4366: RAISE FND_API.G_EXC_ERROR;

4362: RAISE CAN_NOT_LOCK_MODEL;
4363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4366: RAISE FND_API.G_EXC_ERROR;
4367: END IF;
4368:
4369: IF l_debug_level > 0 THEN
4370: oe_debug_pub.add( 'FULFILL ASSOCIATED SERVICE LINES '||L_LINE_REC.LINE_ID , 3 ) ;

Line 4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4381: IF l_debug_level > 0 THEN
4382: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4383: END IF;
4384:
4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;

Line 4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4382: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4383: END IF;
4384:
4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390:

Line 4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4383: END IF;
4384:
4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390:
4391: ELSE

Line 4388: RAISE FND_API.G_EXC_ERROR;

4384:
4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390:
4391: ELSE
4392: IF l_debug_level > 0 THEN

Line 4408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4404: IF l_debug_level > 0 THEN
4405: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4406: END IF;
4407:
4408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;

Line 4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4405: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
4406: END IF;
4407:
4408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413:

Line 4410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4406: END IF;
4407:
4408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413:
4414:

Line 4411: RAISE FND_API.G_EXC_ERROR;

4407:
4408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4411: RAISE FND_API.G_EXC_ERROR;
4412: END IF;
4413:
4414:
4415: END IF;

Line 4445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4441: IF l_debug_level > 0 THEN
4442: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4443: END IF;
4444:
4445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: END IF;

Line 4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4442: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
4443: END IF;
4444:
4445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: END IF;
4450:

Line 4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4443: END IF;
4444:
4445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: END IF;
4450:
4451: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4448: RAISE FND_API.G_EXC_ERROR;

4444:
4445: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: END IF;
4450:
4451: x_return_status := FND_API.G_RET_STS_SUCCESS;
4452:

Line 4451: x_return_status := FND_API.G_RET_STS_SUCCESS;

4447: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4448: RAISE FND_API.G_EXC_ERROR;
4449: END IF;
4450:
4451: x_return_status := FND_API.G_RET_STS_SUCCESS;
4452:
4453: IF l_debug_level > 0 THEN
4454: oe_debug_pub.add( 'EXITING FROM OE_LINE_FULFILL.PROCESS_FULFILLMENT : '||X_RETURN_STATUS , 1 ) ;
4455: END IF;

Line 4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4461: oe_debug_pub.add('OEXVFULB.pls: Process_fulfillment- MODEL LOCKING EXCEPTION' , 1 ) ;
4462: END IF;
4463: x_return_status := 'DEFERRED';
4464: G_DEBUG_MSG := G_DEBUG_MSG || 'ELOCK2,';
4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: IF l_debug_level > 0 THEN
4467: oe_debug_pub.add( 'PROCESS_FULFILLMENT : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
4468: END IF;
4469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4466: IF l_debug_level > 0 THEN
4467: oe_debug_pub.add( 'PROCESS_FULFILLMENT : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
4468: END IF;
4469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4470: G_DEBUG_MSG := G_DEBUG_MSG || 'E22-1,';
4471:
4472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4473: THEN

Line 4481: WHEN FND_API.G_EXC_ERROR THEN

4477: );
4478: END IF;
4479: G_DEBUG_MSG := G_DEBUG_MSG || 'E22-2,';
4480:
4481: WHEN FND_API.G_EXC_ERROR THEN
4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483: WHEN OTHERS THEN
4484: IF l_debug_level > 0 THEN
4485: oe_debug_pub.add( 'PROCESS_FULFILLMENT : EXITING WITH OTHERS ERROR' , 1 ) ;

Line 4482: x_return_status := FND_API.G_RET_STS_ERROR;

4478: END IF;
4479: G_DEBUG_MSG := G_DEBUG_MSG || 'E22-2,';
4480:
4481: WHEN FND_API.G_EXC_ERROR THEN
4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483: WHEN OTHERS THEN
4484: IF l_debug_level > 0 THEN
4485: oe_debug_pub.add( 'PROCESS_FULFILLMENT : EXITING WITH OTHERS ERROR' , 1 ) ;
4486: END IF;

Line 4490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4486: END IF;
4487: IF l_debug_level > 0 THEN
4488: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
4489: END IF;
4490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4491:
4492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4493: THEN
4494: OE_MSG_PUB.Add_Exc_Msg

Line 4566: line_id NUMBER := FND_API.G_MISS_NUM

4562: l_store_rem VARCHAR2(1);
4563:
4564: TYPE fulfill_set IS RECORD
4565: (
4566: line_id NUMBER := FND_API.G_MISS_NUM
4567: , top_model_line_id NUMBER := FND_API.G_MISS_NUM
4568: , set_id NUMBER := FND_API.G_MISS_NUM
4569: , model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
4570: );

Line 4567: , top_model_line_id NUMBER := FND_API.G_MISS_NUM

4563:
4564: TYPE fulfill_set IS RECORD
4565: (
4566: line_id NUMBER := FND_API.G_MISS_NUM
4567: , top_model_line_id NUMBER := FND_API.G_MISS_NUM
4568: , set_id NUMBER := FND_API.G_MISS_NUM
4569: , model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
4570: );
4571:

Line 4568: , set_id NUMBER := FND_API.G_MISS_NUM

4564: TYPE fulfill_set IS RECORD
4565: (
4566: line_id NUMBER := FND_API.G_MISS_NUM
4567: , top_model_line_id NUMBER := FND_API.G_MISS_NUM
4568: , set_id NUMBER := FND_API.G_MISS_NUM
4569: , model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
4570: );
4571:
4572: TYPE fulfill_set_tbl IS TABLE OF fulfill_set

Line 4569: , model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

4565: (
4566: line_id NUMBER := FND_API.G_MISS_NUM
4567: , top_model_line_id NUMBER := FND_API.G_MISS_NUM
4568: , set_id NUMBER := FND_API.G_MISS_NUM
4569: , model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
4570: );
4571:
4572: TYPE fulfill_set_tbl IS TABLE OF fulfill_set
4573: INDEX BY BINARY_INTEGER;

Line 4720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4716: IF l_debug_level > 0 THEN
4717: oe_debug_pub.add( 'RETURN STATUS FROM GET FULFILLMENT SET : '||L_RETURN_STATUS||'/'||TO_CHAR ( L_SET_TBL.COUNT ) , 3 ) ;
4718: END IF;
4719:
4720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4723: RAISE FND_API.G_EXC_ERROR;
4724: END IF;

Line 4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4717: oe_debug_pub.add( 'RETURN STATUS FROM GET FULFILLMENT SET : '||L_RETURN_STATUS||'/'||TO_CHAR ( L_SET_TBL.COUNT ) , 3 ) ;
4718: END IF;
4719:
4720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4723: RAISE FND_API.G_EXC_ERROR;
4724: END IF;
4725:

Line 4722: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4718: END IF;
4719:
4720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4723: RAISE FND_API.G_EXC_ERROR;
4724: END IF;
4725:
4726: IF l_set_tbl.count > 0 THEN

Line 4723: RAISE FND_API.G_EXC_ERROR;

4719:
4720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4723: RAISE FND_API.G_EXC_ERROR;
4724: END IF;
4725:
4726: IF l_set_tbl.count > 0 THEN
4727: NULL;

Line 4852: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4848:
4849: IF l_debug_level > 0 THEN
4850: oe_debug_pub.add( 'RETURN FROM CHECK_PTO_KIT_FULFILLMENT '||L_RETURN_STATUS||'/'||L_FULFILL_STATUS , 3 ) ;
4851: END IF;
4852: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4854:
4855: END IF;
4856:

Line 4853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4849: IF l_debug_level > 0 THEN
4850: oe_debug_pub.add( 'RETURN FROM CHECK_PTO_KIT_FULFILLMENT '||L_RETURN_STATUS||'/'||L_FULFILL_STATUS , 3 ) ;
4851: END IF;
4852: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4854:
4855: END IF;
4856:
4857: IF l_fulfill_status = FND_API.G_FALSE THEN

Line 4857: IF l_fulfill_status = FND_API.G_FALSE THEN

4853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4854:
4855: END IF;
4856:
4857: IF l_fulfill_status = FND_API.G_FALSE THEN
4858: IF l_ful_set_tbl(l_ful_set_index).line_id = p_line_id THEN
4859: l_process_current_line := FALSE;
4860: IF l_debug_level > 0 THEN
4861: oe_debug_pub.add( '1- DO NOT PROCESS CURRENT LINE '||L_FUL_SET_TBL ( L_FUL_SET_INDEX ) .LINE_ID , 3 ) ;

Line 4906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4902: IF l_debug_level > 0 THEN
4903: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
4904: END IF;
4905:
4906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4908: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR
4909: OR
4910: NVL(l_activity_status, 'COMPLETE') <> 'NOTIFIED' )

Line 4907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4903: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
4904: END IF;
4905:
4906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4908: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR
4909: OR
4910: NVL(l_activity_status, 'COMPLETE') <> 'NOTIFIED' )
4911: THEN

Line 4908: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR

4904: END IF;
4905:
4906: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4908: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR
4909: OR
4910: NVL(l_activity_status, 'COMPLETE') <> 'NOTIFIED' )
4911: THEN
4912: IF l_ful_set_tbl(l_ful_set_index).line_id = p_line_id THEN

Line 5036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5032: IF l_debug_level > 0 THEN
5033: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL_PTO_KIT API '||L_RETURN_STATUS , 3 ) ;
5034: END IF;
5035:
5036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5039: RAISE FND_API.G_EXC_ERROR;
5040: END IF;

Line 5037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5033: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL_PTO_KIT API '||L_RETURN_STATUS , 3 ) ;
5034: END IF;
5035:
5036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5039: RAISE FND_API.G_EXC_ERROR;
5040: END IF;
5041:

Line 5038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5034: END IF;
5035:
5036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5039: RAISE FND_API.G_EXC_ERROR;
5040: END IF;
5041:
5042: ELSE

Line 5039: RAISE FND_API.G_EXC_ERROR;

5035:
5036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5039: RAISE FND_API.G_EXC_ERROR;
5040: END IF;
5041:
5042: ELSE
5043: /* Fix for 2560644 */

Line 5073: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5069: p_fulfillment_activity => l_fulfillment_activity,
5070: x_return_status => l_return_status
5071: );
5072:
5073: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;

Line 5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5070: x_return_status => l_return_status
5071: );
5072:
5073: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;
5078:

Line 5075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5071: );
5072:
5073: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;
5078:
5079: --END IF; /* Commented for bug 2965878 */

Line 5076: RAISE FND_API.G_EXC_ERROR;

5072:
5073: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5076: RAISE FND_API.G_EXC_ERROR;
5077: END IF;
5078:
5079: --END IF; /* Commented for bug 2965878 */
5080:

Line 5117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5113: IF l_debug_level > 0 THEN
5114: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5115: END IF;
5116:
5117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: END IF;

Line 5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5114: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5115: END IF;
5116:
5117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: END IF;
5122:

Line 5119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5115: END IF;
5116:
5117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: END IF;
5122:
5123: IF l_debug_level > 0 THEN

Line 5120: RAISE FND_API.G_EXC_ERROR;

5116:
5117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: END IF;
5122:
5123: IF l_debug_level > 0 THEN
5124: oe_debug_pub.add( 'FULFILL ASSOCIATED SERVICE LINES ' , 3 ) ;

Line 5137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5133: IF l_debug_level > 0 THEN
5134: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
5135: END IF;
5136:
5137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: END IF;

Line 5138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5134: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
5135: END IF;
5136:
5137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: END IF;
5142:

Line 5139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5135: END IF;
5136:
5137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: END IF;
5142:
5143: IF l_debug_level > 0 THEN

Line 5140: RAISE FND_API.G_EXC_ERROR;

5136:
5137: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5139: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5140: RAISE FND_API.G_EXC_ERROR;
5141: END IF;
5142:
5143: IF l_debug_level > 0 THEN
5144: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( L_FUL_SET_TBL ( L_FUL_SET_INDEX ) .LINE_ID ) , 3 ) ;

Line 5218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5214: IF l_debug_level > 0 THEN
5215: oe_debug_pub.add( 'RETURN FROM CHECK_PTO_KIT_FULFILLMENT '||L_RETURN_STATUS||'/'||L_FULFILL_STATUS , 3 ) ;
5216: END IF;
5217:
5218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5220:
5221: END IF;
5222:

Line 5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5215: oe_debug_pub.add( 'RETURN FROM CHECK_PTO_KIT_FULFILLMENT '||L_RETURN_STATUS||'/'||L_FULFILL_STATUS , 3 ) ;
5216: END IF;
5217:
5218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5220:
5221: END IF;
5222:
5223: IF l_fulfill_status = FND_API.G_FALSE THEN

Line 5223: IF l_fulfill_status = FND_API.G_FALSE THEN

5219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5220:
5221: END IF;
5222:
5223: IF l_fulfill_status = FND_API.G_FALSE THEN
5224:
5225: IF l_debug_level > 0 THEN
5226: oe_debug_pub.add( 'LINE CAN NOT BE FULFILLED ' , 3 ) ;
5227: END IF;

Line 5246: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5242: IF l_debug_level > 0 THEN
5243: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL_PTO_KIT API '||L_RETURN_STATUS , 3 ) ;
5244: END IF;
5245:
5246: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: END IF;

Line 5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5243: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL_PTO_KIT API '||L_RETURN_STATUS , 3 ) ;
5244: END IF;
5245:
5246: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: END IF;
5251:

Line 5248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5244: END IF;
5245:
5246: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: END IF;
5251:
5252: END IF;

Line 5249: RAISE FND_API.G_EXC_ERROR;

5245:
5246: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: END IF;
5251:
5252: END IF;
5253:

Line 5271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5267: IF l_debug_level > 0 THEN
5268: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
5269: END IF;
5270:
5271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5274: IF l_debug_level > 0 THEN
5275: oe_debug_pub.add( 'DO NOT PROCESS CURRENT LINE ' , 3 ) ;

Line 5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5268: oe_debug_pub.add( 'RETURN STATUS FROM GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
5269: END IF;
5270:
5271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5274: IF l_debug_level > 0 THEN
5275: oe_debug_pub.add( 'DO NOT PROCESS CURRENT LINE ' , 3 ) ;
5276: END IF;

Line 5273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5269: END IF;
5270:
5271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5274: IF l_debug_level > 0 THEN
5275: oe_debug_pub.add( 'DO NOT PROCESS CURRENT LINE ' , 3 ) ;
5276: END IF;
5277: GOTO LINE_NOT_IN_SET;

Line 5310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5306: p_fulfillment_activity => l_fulfillment_activity,
5307: x_return_status => l_return_status
5308: );
5309:
5310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5313: RAISE FND_API.G_EXC_ERROR;
5314: END IF;

Line 5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5307: x_return_status => l_return_status
5308: );
5309:
5310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5313: RAISE FND_API.G_EXC_ERROR;
5314: END IF;
5315:

Line 5312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5308: );
5309:
5310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5313: RAISE FND_API.G_EXC_ERROR;
5314: END IF;
5315:
5316: END IF;

Line 5313: RAISE FND_API.G_EXC_ERROR;

5309:
5310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5313: RAISE FND_API.G_EXC_ERROR;
5314: END IF;
5315:
5316: END IF;
5317:

Line 5340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5336: IF l_debug_level > 0 THEN
5337: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5338: END IF;
5339:
5340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;

Line 5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5337: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5338: END IF;
5339:
5340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;
5345:

Line 5342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5338: END IF;
5339:
5340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;
5345:
5346: IF l_debug_level > 0 THEN

Line 5343: RAISE FND_API.G_EXC_ERROR;

5339:
5340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5343: RAISE FND_API.G_EXC_ERROR;
5344: END IF;
5345:
5346: IF l_debug_level > 0 THEN
5347: oe_debug_pub.add( 'FULFILL ASSOCIATED SERVICE LINES ' , 3 ) ;

Line 5361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5357: IF l_debug_level > 0 THEN
5358: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
5359: END IF;
5360:
5361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;

Line 5362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5358: oe_debug_pub.add( 'RETURN STATUS FROM FULFILL SERVICE LINES API '||L_RETURN_STATUS , 3 ) ;
5359: END IF;
5360:
5361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366:

Line 5363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5359: END IF;
5360:
5361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366:
5367: IF l_debug_level > 0 THEN

Line 5364: RAISE FND_API.G_EXC_ERROR;

5360:
5361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366:
5367: IF l_debug_level > 0 THEN
5368: oe_debug_pub.add( 'CALLING WF_ENGINE.COMPLETEACTIVITYINTERNALNAME '|| TO_CHAR ( P_LINE_ID ) , 3 ) ;

Line 5382: x_return_status := FND_API.G_RET_STS_SUCCESS;

5378:
5379:
5380: << LINE_NOT_IN_SET >>
5381:
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: IF l_debug_level > 0 THEN
5384: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CANCEL_LINE : '||X_RETURN_STATUS , 1 ) ;
5385: END IF;
5386:

Line 5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5384: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CANCEL_LINE : '||X_RETURN_STATUS , 1 ) ;
5385: END IF;
5386:
5387: EXCEPTION
5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add( 'CANCEL_LINE : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
5391: END IF;
5392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add( 'CANCEL_LINE : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
5391: END IF;
5392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5393:
5394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5395: THEN
5396: OE_MSG_PUB.Add_Exc_Msg

Line 5403: WHEN FND_API.G_EXC_ERROR THEN

5399: );
5400: END IF;
5401: G_DEBUG_MSG := G_DEBUG_MSG || 'E24,';
5402:
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: x_return_status := FND_API.G_RET_STS_ERROR;
5405:
5406: WHEN OTHERS THEN
5407: IF l_debug_level > 0 THEN

Line 5404: x_return_status := FND_API.G_RET_STS_ERROR;

5400: END IF;
5401: G_DEBUG_MSG := G_DEBUG_MSG || 'E24,';
5402:
5403: WHEN FND_API.G_EXC_ERROR THEN
5404: x_return_status := FND_API.G_RET_STS_ERROR;
5405:
5406: WHEN OTHERS THEN
5407: IF l_debug_level > 0 THEN
5408: oe_debug_pub.add( 'CANCEL_LINE : EXITING WITH OTHERS ERROR' , 1 ) ;

Line 5413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5409: END IF;
5410: IF l_debug_level > 0 THEN
5411: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
5412: END IF;
5413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5414:
5415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5416: THEN
5417: OE_MSG_PUB.Add_Exc_Msg