APPS.GMD_SPECIFICATIONS_PVT dependencies on GMD_API_PUB

Line 635: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');

631: WHERE spec_name = p_specifications.spec_name
632: AND spec_vers = p_specifications.spec_vers
633: ;
634: ELSE
635: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');
636: RETURN FALSE;
637: END IF;
638:
639: RETURN TRUE;

Line 644: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');

640:
641: EXCEPTION
642: WHEN NO_DATA_FOUND
643: THEN
644: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');
645: RETURN FALSE;
646: WHEN OTHERS
647: THEN
648: fnd_msg_pub.add_exc_msg ('GMD_SPECIFICATIONS_PVT', 'FETCH_ROW');

Line 676: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');

672: FROM gmd_specifications_b
673: WHERE spec_name = p_spec_name and spec_vers = p_spec_vers
674: FOR UPDATE OF spec_id NOWAIT ;
675: ELSE
676: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');
677: RETURN FALSE;
678: END IF;
679:
680: RETURN TRUE;

Line 685: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');

681:
682: EXCEPTION
683: WHEN NO_DATA_FOUND
684: THEN
685: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');
686: RETURN FALSE;
687: WHEN OTHERS
688: THEN
689: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 689: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

685: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');
686: RETURN FALSE;
687: WHEN OTHERS
688: THEN
689: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
690: RETURN FALSE;
691: END lock_row;
692:
693: FUNCTION mark_for_delete (

Line 727: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');

723: IF SQL%NOTFOUND THEN
724: RAISE NO_DATA_FOUND ;
725: END IF;
726: ELSE
727: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');
728: RETURN FALSE;
729: END IF;
730:
731: RETURN TRUE;

Line 736: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');

732:
733: EXCEPTION
734: WHEN NO_DATA_FOUND
735: THEN
736: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');
737: RETURN FALSE;
738: WHEN OTHERS
739: THEN
740: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.MARK_FOR_DELETE','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 740: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.MARK_FOR_DELETE','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

736: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPECIFICATIONS');
737: RETURN FALSE;
738: WHEN OTHERS
739: THEN
740: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.MARK_FOR_DELETE','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
741: RETURN FALSE;
742: END mark_for_delete;
743:
744: FUNCTION INSERT_ROW(p_spec IN OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE)

Line 807: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.INSERT_ROW','ERROR',

803:
804: return TRUE;
805:
806: EXCEPTION WHEN OTHERS THEN
807: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPECIFICATIONS_PVT.INSERT_ROW','ERROR',
808: SUBSTR(SQLERRM,1,100),'POSITION','010');
809: RETURN FALSE;
810:
811: END INSERT_ROW;