11: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12:
13: /*Bg 7367350 Added new parameter for internal comment handling*/
14: PROCEDURE create_request (
15: -- standard API parameters
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: arp_util.debug ( 'p_gl_date :'||p_gl_date); /*Bug 9536019*/
92: END IF;
93:
94: /*------------------------------------+
95: | Standard start of API savepoint |
96: +------------------------------------*/
97:
98: SAVEPOINT Create_request_pvt;
99:
97:
98: SAVEPOINT Create_request_pvt;
99:
100: /*--------------------------------------------------+
101: | Standard call to check for call compatibility |
102: +--------------------------------------------------*/
103: IF PG_DEBUG in ('Y', 'C') THEN
104: arp_util.debug( 'Checking call compatibility');
105: END IF;
254: END IF;
255: END IF;
256:
257: /*--------------------------------+
258: | Standard check of p_commit |
259: +--------------------------------*/
260:
261: IF FND_API.To_Boolean( p_commit ) THEN
262: IF PG_DEBUG in ('Y', 'C') THEN
709: END IF;
710: END validate_request_parameters;
711:
712: PROCEDURE get_request_status (
713: -- standard API parameters
714: p_api_version IN NUMBER,
715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716: x_msg_count OUT NOCOPY NUMBER,
717: x_msg_data OUT NOCOPY VARCHAR2,
811: arp_util.debug ('get_request_status: ' || 'p_request_id :'||p_request_id);
812: END IF;
813:
814: /*--------------------------------------------------+
815: | Standard call to check for call compatibility |
816: +--------------------------------------------------*/
817: IF PG_DEBUG in ('Y', 'C') THEN
818: arp_util.debug ('get_request_status: ' || 'Standard call to check for call compatibility');
819: END IF;
814: /*--------------------------------------------------+
815: | Standard call to check for call compatibility |
816: +--------------------------------------------------*/
817: IF PG_DEBUG in ('Y', 'C') THEN
818: arp_util.debug ('get_request_status: ' || 'Standard call to check for call compatibility');
819: END IF;
820: IF NOT FND_API.Compatible_API_Call( l_api_version,
821: p_api_version,
822: l_api_name,