DBA Data[Home] [Help]

APPS.AHL_DI_PRO_TYPE_ASO_PVT dependencies on AHL_DI_PRO_TYPE_ASO_PVT

Line 1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PVT AS

1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PVT AS
2: /* $Header: AHLVPTAB.pls 115.28 2003/08/26 12:15:44 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_PRO_TYPE_ASO_PVT';
5: -- Validates the Doc Type associations

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_PRO_TYPE_ASO_PVT';

1: PACKAGE BODY AHL_DI_PRO_TYPE_ASO_PVT AS
2: /* $Header: AHLVPTAB.pls 115.28 2003/08/26 12:15:44 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_PRO_TYPE_ASO_PVT';
5: -- Validates the Doc Type associations
6:
7: /*-----------------------------------------------------------*/
8: /* procedure name: validate_doc_type_assoc(private procedure)*/

Line 223: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');

219: END IF;
220: -- Debug info.
221: IF G_DEBUG='Y' THEN
222: IF G_DEBUG='Y' THEN
223: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');
224:
225: END IF;
226: END IF;
227: -- Standard call to check for call compatibility.

Line 332: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');

328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: IF G_DEBUG='Y' THEN
331: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
332: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');
333:
334:
335: -- Check if API is called in debug mode. If yes, disable debug.
336: AHL_DEBUG_PUB.disable_debug;

Line 349: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');

345: p_data => X_msg_data);
346: -- Debug info.
347: IF G_DEBUG='Y' THEN
348: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
349: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');
350:
351:
352: -- Check if API is called in debug mode. If yes, disable debug.
353: AHL_DEBUG_PUB.disable_debug;

Line 362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

358: ROLLBACK TO delete_doc_type_assoc;
359: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
363: p_procedure_name => 'DELETE_DOC_TYPE_ASSOC',
364: p_error_text => SUBSTR(SQLERRM,1,240));
365: END IF;
366: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 373: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');

369:
370: -- Debug info.
371: IF G_DEBUG='Y' THEN
372: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
373: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');
374:
375:
376: -- Check if API is called in debug mode. If yes, disable debug.
377: AHL_DEBUG_PUB.disable_debug;

Line 440: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');

436: END IF;
437: -- Debug info.
438: IF G_DEBUG='Y' THEN
439: IF G_DEBUG='Y' THEN
440: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');
441:
442: END IF;
443: END IF;
444: -- Standard call to check for call compatibility.

Line 611: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');

607: p_count => x_msg_count,
608: p_data => x_msg_data);
609: IF G_DEBUG='Y' THEN
610: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
611: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');
612:
613:
614: -- Check if API is called in debug mode. If yes, disable debug.
615: AHL_DEBUG_PUB.disable_debug;

Line 628: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');

624: p_data => X_msg_data);
625: -- Debug info.
626: IF G_DEBUG='Y' THEN
627: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
628: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');
629:
630:
631: -- Check if API is called in debug mode. If yes, disable debug.
632: AHL_DEBUG_PUB.disable_debug;

Line 641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

637: ROLLBACK TO create_doc_type_assoc;
638: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
642: p_procedure_name => 'CREATE_DOC_TYPE_ASSOC',
643: p_error_text => SUBSTR(SQLERRM,1,240));
644: END IF;
645: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 652: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');

648:
649: -- Debug info.
650: IF G_DEBUG='Y' THEN
651: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
652: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');
653:
654:
655: -- Check if API is called in debug mode. If yes, disable debug.
656: AHL_DEBUG_PUB.disable_debug;

Line 766: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');

762: END IF;
763: -- Debug info.
764: IF G_DEBUG='Y' THEN
765: IF G_DEBUG='Y' THEN
766: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');
767:
768: END IF;
769: END IF;
770: -- Standard call to check for call compatibility.

Line 1025: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');

1021: p_count => x_msg_count,
1022: p_data => x_msg_data);
1023: IF G_DEBUG='Y' THEN
1024: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1025: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');
1026:
1027:
1028: -- Check if API is called in debug mode. If yes, disable debug.
1029: AHL_DEBUG_PUB.disable_debug;

Line 1042: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');

1038: p_data => X_msg_data);
1039: -- Debug info.
1040: IF G_DEBUG='Y' THEN
1041: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1042: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');
1043:
1044:
1045: -- Check if API is called in debug mode. If yes, disable debug.
1046: AHL_DEBUG_PUB.disable_debug;

Line 1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',

1051: ROLLBACK TO modify_doc_type_assoc;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_PRO_TYPE_ASO_PVT',
1056: p_procedure_name => 'MODIFY_DOC_TYPE_ASSOC',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1065: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');

1061: p_data => X_msg_data);
1062: -- Debug info.
1063: IF G_DEBUG='Y' THEN
1064: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1065: AHL_DEBUG_PUB.debug( 'ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');
1066:
1067:
1068: -- Check if API is called in debug mode. If yes, disable debug.
1069: AHL_DEBUG_PUB.disable_debug;

Line 1075: END AHL_DI_PRO_TYPE_ASO_PVT;

1071: END IF;
1072:
1073: END MODIFY_DOC_TYPE_ASSOC;
1074: --
1075: END AHL_DI_PRO_TYPE_ASO_PVT;
1076: