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

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: BEGIN
202:
203: oe_debug_pub.add(' START TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
204:
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207:
208: lStmtNum := 10;
209: DELETE FROM bom_cto_order_lines_gt;

Line 337: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

333: x_return_status => x_return_status,
334: x_msg_count => X_msg_count,
335: x_msg_data => X_msg_data
336: );
337: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
338: --level 1
339: -- IF PG_DEBUG <> 0 THEN
340: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
341: -- END IF;

Line 342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

338: --level 1
339: -- IF PG_DEBUG <> 0 THEN
340: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
341: -- END IF;
342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE fnd_api.g_exc_error;
344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE fnd_api.g_exc_unexpected_error;
346: END IF;

Line 343: RAISE fnd_api.g_exc_error;

339: -- IF PG_DEBUG <> 0 THEN
340: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
341: -- END IF;
342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE fnd_api.g_exc_error;
344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE fnd_api.g_exc_unexpected_error;
346: END IF;
347:

Line 344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

340: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
341: -- END IF;
342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE fnd_api.g_exc_error;
344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE fnd_api.g_exc_unexpected_error;
346: END IF;
347:
348:

Line 345: RAISE fnd_api.g_exc_unexpected_error;

341: -- END IF;
342: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE fnd_api.g_exc_error;
344: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE fnd_api.g_exc_unexpected_error;
346: END IF;
347:
348:
349: IF l_PDS_ODS = 4 THEN --PDS

Line 395: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

391: X_return_status =>x_return_status,
392: X_msg_count =>x_msg_count,
393: X_msg_data =>x_msg_data
394: ) ;
395: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
396: -- IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

395: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
396: -- IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
400: RAISE fnd_api.g_exc_error;
401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;

Line 400: RAISE fnd_api.g_exc_error;

396: -- IF PG_DEBUG <> 0 THEN
397: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
400: RAISE fnd_api.g_exc_error;
401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404: end if; --lReuseProfile = 1 Bugfix 6642016

Line 401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

397: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
400: RAISE fnd_api.g_exc_error;
401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404: end if; --lReuseProfile = 1 Bugfix 6642016
405:

Line 402: RAISE fnd_api.g_exc_unexpected_error;

398: -- END IF;
399: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
400: RAISE fnd_api.g_exc_error;
401: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404: end if; --lReuseProfile = 1 Bugfix 6642016
405:
406: IF l_match_profile = 1 THEN

Line 430: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

426: p_Action => p_Action,
427: p_Source => p_Source ,
428: p_cto_match_rec => p_match_rec_of_tab);
429:
430: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
431: IF PG_DEBUG <> 0 THEN
432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

430: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
431: IF PG_DEBUG <> 0 THEN
432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;

Line 435: RAISE fnd_api.g_exc_error;

431: IF PG_DEBUG <> 0 THEN
432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;
439:

Line 436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

432: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;
439:
440: END IF; -- l_match_pfoile = 1

Line 437: RAISE fnd_api.g_exc_unexpected_error;

433: END IF;
434: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
435: RAISE fnd_api.g_exc_error;
436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;
439:
440: END IF; -- l_match_pfoile = 1
441:

Line 481: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

477: X_MSG_DATA =>X_msg_data,
478: X_MSG_COUNT =>X_msg_count
479: );
480:
481: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
482: --level 1
483: -- IF PG_DEBUG <> 0 THEN
484: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
485: -- END IF;

Line 486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

482: --level 1
483: -- IF PG_DEBUG <> 0 THEN
484: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
485: -- END IF;
486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE fnd_api.g_exc_error;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE fnd_api.g_exc_unexpected_error;
490: END IF;

Line 487: RAISE fnd_api.g_exc_error;

483: -- IF PG_DEBUG <> 0 THEN
484: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
485: -- END IF;
486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE fnd_api.g_exc_error;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE fnd_api.g_exc_unexpected_error;
490: END IF;
491:

Line 488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

484: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
485: -- END IF;
486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE fnd_api.g_exc_error;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE fnd_api.g_exc_unexpected_error;
490: END IF;
491:
492: --make sure floowling sql bring null values too

Line 489: RAISE fnd_api.g_exc_unexpected_error;

485: -- END IF;
486: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE fnd_api.g_exc_error;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE fnd_api.g_exc_unexpected_error;
490: END IF;
491:
492: --make sure floowling sql bring null values too
493: lStmtNum:=90;

Line 670: WHEN fnd_api.g_exc_error THEN

666:
667: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: IF PG_DEBUG <> 0 THEN
672: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
673: || to_char(lStmtNum), 1);
674: END IF;

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: IF PG_DEBUG <> 0 THEN
672: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
673: || to_char(lStmtNum), 1);
674: END IF;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: -- Get message count and data
677: cto_msg_pub.count_and_get
678: ( p_msg_count => x_msg_count
679: , p_msg_data => x_msg_data

Line 681: WHEN fnd_api.g_exc_unexpected_error THEN

677: cto_msg_pub.count_and_get
678: ( p_msg_count => x_msg_count
679: , p_msg_data => x_msg_data
680: );
681: WHEN fnd_api.g_exc_unexpected_error THEN
682: IF PG_DEBUG <> 0 THEN
683: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
684: || to_char(lStmtNum), 1);
685: END IF;

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

682: IF PG_DEBUG <> 0 THEN
683: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
684: || to_char(lStmtNum), 1);
685: END IF;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
687: -- Get message count and data
688: cto_msg_pub.count_and_get
689: ( p_msg_count => x_msg_count
690: , p_msg_data => x_msg_data

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
695: || to_char(lStmtNum), 1);
696: oe_debug_pub.add('error='||sqlerrm);
697: END IF;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: -- Get message count and data
700: cto_msg_pub.count_and_get
701: ( p_msg_count => x_msg_count
702: , p_msg_data => x_msg_data