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

Line 18: -- Default = FND_API.G_FALSE

14: -- Pre-reqs :
15: -- Parameters :
16: -- IN : p_api_version IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 20: -- Default = FND_API.G_FALSE

16: -- IN : p_api_version IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL
23: -- p_source_type IN VARCHAR2 Required
24: -- Valid values : "RECEIVING", "RETROPRICE"

Line 22: -- Default = FND_API.G_VALID_LEVEL_FULL

18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL
23: -- p_source_type IN VARCHAR2 Required
24: -- Valid values : "RECEIVING", "RETROPRICE"
25: --
26: -- The following parameters are required for a source type

Line 123: l_return_status := fnd_api.g_ret_sts_success;

119: l_sLog constant boolean := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
120:
121:
122: BEGIN
123: l_return_status := fnd_api.g_ret_sts_success;
124:
125: -- Standard start of API savepoint
126: SAVEPOINT Create_AccountingEvents_GRP;
127:

Line 138: IF NOT FND_API.Compatible_API_Call (

134: END IF;
135: END IF;
136:
137: -- Standard call to check for call compatibility
138: IF NOT FND_API.Compatible_API_Call (
139: l_api_version,
140: p_api_version,
141: l_api_name,
142: G_PKG_NAME ) THEN

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: l_api_version,
140: p_api_version,
141: l_api_name,
142: G_PKG_NAME ) THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE
147: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 147: IF FND_API.to_Boolean(p_init_msg_list) THEN

143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: -- Initialize message list if p_init_msg_list is set to TRUE
147: IF FND_API.to_Boolean(p_init_msg_list) THEN
148: FND_MSG_PUB.initialize;
149: END IF;
150:
151: -- Initialize API return status to success

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: FND_MSG_PUB.initialize;
149: END IF;
150:
151: -- Initialize API return status to success
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: FND_PROFILE.get('USER_ID',l_user_id);
155: FND_PROFILE.get('ORG_ID',l_org_id);
156: FND_PROFILE.get('RESP_ID',l_resp_id);

Line 223: RAISE FND_API.g_exc_error;

219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
220: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
221: END IF;
222: END IF;
223: RAISE FND_API.g_exc_error;
224: END IF;
225:
226: IF UPPER(p_source_type) = 'RECEIVING' THEN
227: l_stmt_num := 100;

Line 257: RAISE FND_API.g_exc_unexpected_error;

253: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
254: ,'Create_AccountingEvents : '||l_stmt_num||' : '||l_api_message);
255: END IF;
256: END IF;
257: RAISE FND_API.g_exc_unexpected_error;
258: END IF;
259:
260: l_stmt_num := 120;
261: RCV_AccEvents_PVT.Create_ReceivingEvents(

Line 289: RAISE FND_API.g_exc_error;

285: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
286: FND_LOG.message(FND_LOG.LEVEL_ERROR,l_module,FALSE);
287: END IF;
288: END IF;
289: RAISE FND_API.g_exc_error;
290:
291: END IF;
292:
293: l_stmt_num := 200;

Line 332: RAISE FND_API.g_exc_error;

328: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
329: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
330: END IF;
331: END IF;
332: RAISE FND_API.g_exc_error;
333: END IF;
334:
335: IF l_return_status <> FND_API.g_ret_sts_success THEN
336: l_api_message := 'Error creating event';

Line 335: IF l_return_status <> FND_API.g_ret_sts_success THEN

331: END IF;
332: RAISE FND_API.g_exc_error;
333: END IF;
334:
335: IF l_return_status <> FND_API.g_ret_sts_success THEN
336: l_api_message := 'Error creating event';
337: IF l_uLog THEN
338: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
339: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 343: RAISE FND_API.g_exc_unexpected_error;

339: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
340: ,'Create_AccountingEvents : '||l_stmt_num||' : '||l_api_message);
341: END IF;
342: END IF;
343: RAISE FND_API.g_exc_unexpected_error;
344: END IF;
345:
346: --- Standard check of p_commit
347: IF FND_API.to_Boolean(p_commit) THEN

Line 347: IF FND_API.to_Boolean(p_commit) THEN

343: RAISE FND_API.g_exc_unexpected_error;
344: END IF;
345:
346: --- Standard check of p_commit
347: IF FND_API.to_Boolean(p_commit) THEN
348: COMMIT WORK;
349: END IF;
350:
351: -- Standard Call to get message count and if count = 1, get message info

Line 365: WHEN FND_API.g_exc_error THEN

361: END IF;
362:
363:
364: EXCEPTION
365: WHEN FND_API.g_exc_error THEN
366: ROLLBACK TO Create_AccountingEvents_GRP;
367: x_return_status := FND_API.g_ret_sts_error;
368: FND_MSG_PUB.count_and_get
369: ( p_count => x_msg_count

Line 367: x_return_status := FND_API.g_ret_sts_error;

363:
364: EXCEPTION
365: WHEN FND_API.g_exc_error THEN
366: ROLLBACK TO Create_AccountingEvents_GRP;
367: x_return_status := FND_API.g_ret_sts_error;
368: FND_MSG_PUB.count_and_get
369: ( p_count => x_msg_count
370: , p_data => x_msg_data
371: );

Line 373: WHEN FND_API.g_exc_unexpected_error THEN

369: ( p_count => x_msg_count
370: , p_data => x_msg_data
371: );
372:
373: WHEN FND_API.g_exc_unexpected_error THEN
374: ROLLBACK TO Create_AccountingEvents_GRP;
375: x_return_status := FND_API.g_ret_sts_unexp_error ;
376: FND_MSG_PUB.count_and_get
377: ( p_count => x_msg_count

Line 375: x_return_status := FND_API.g_ret_sts_unexp_error ;

371: );
372:
373: WHEN FND_API.g_exc_unexpected_error THEN
374: ROLLBACK TO Create_AccountingEvents_GRP;
375: x_return_status := FND_API.g_ret_sts_unexp_error ;
376: FND_MSG_PUB.count_and_get
377: ( p_count => x_msg_count
378: , p_data => x_msg_data
379: );

Line 383: x_return_status := fnd_api.g_ret_sts_unexp_error ;

379: );
380:
381: WHEN OTHERS THEN
382: ROLLBACK TO Create_AccountingEvents_GRP;
383: x_return_status := fnd_api.g_ret_sts_unexp_error ;
384:
385: IF l_uLog THEN
386: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
387: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 470: -- Default = FND_API.G_FALSE

466: -- Pre-reqs :
467: -- Parameters :
468: -- IN : p_api_version IN NUMBER Required
469: -- p_init_msg_list IN VARCHAR2 Optional
470: -- Default = FND_API.G_FALSE
471: -- p_commit IN VARCHAR2 Optional
472: -- Default = FND_API.G_FALSE
473: -- p_validation_level IN NUMBER Optional
474: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 472: -- Default = FND_API.G_FALSE

468: -- IN : p_api_version IN NUMBER Required
469: -- p_init_msg_list IN VARCHAR2 Optional
470: -- Default = FND_API.G_FALSE
471: -- p_commit IN VARCHAR2 Optional
472: -- Default = FND_API.G_FALSE
473: -- p_validation_level IN NUMBER Optional
474: -- Default = FND_API.G_VALID_LEVEL_FULL
475: --
476: -- p_invoice_dist_id_tbl IN NUMBER_TBL Required

Line 474: -- Default = FND_API.G_VALID_LEVEL_FULL

470: -- Default = FND_API.G_FALSE
471: -- p_commit IN VARCHAR2 Optional
472: -- Default = FND_API.G_FALSE
473: -- p_validation_level IN NUMBER Optional
474: -- Default = FND_API.G_VALID_LEVEL_FULL
475: --
476: -- p_invoice_dist_id_tbl IN NUMBER_TBL Required
477: --
478: -- OUT : x_return_status OUT VARCHAR2(1)

Line 497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

493: -- end accruals.
494: -- Start of comments
495: PROCEDURE Create_InterCompanyEvents(
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,

Line 498: p_commit IN VARCHAR2 := FND_API.G_FALSE,

494: -- Start of comments
495: PROCEDURE Create_InterCompanyEvents(
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,

Line 499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

495: PROCEDURE Create_InterCompanyEvents(
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,
503:

Line 531: l_return_status := fnd_api.g_ret_sts_success;

527: --BUG#6167988
528: l_cnt NUMBER := 0;
529:
530: BEGIN
531: l_return_status := fnd_api.g_ret_sts_success;
532: -- Standard start of API savepoint
533: SAVEPOINT Create_InterCompanyEvents_GRP;
534:
535: l_stmt_num := 0;

Line 545: IF NOT FND_API.Compatible_API_Call (

541: END IF;
542: END IF;
543:
544: -- Standard call to check for call compatibility
545: IF NOT FND_API.Compatible_API_Call (
546: l_api_version,
547: p_api_version,
548: l_api_name,
549: G_PKG_NAME ) THEN

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: l_api_version,
547: p_api_version,
548: l_api_name,
549: G_PKG_NAME ) THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: -- Initialize message list if p_init_msg_list is set to TRUE
554: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 554: IF FND_API.to_Boolean(p_init_msg_list) THEN

550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: -- Initialize message list if p_init_msg_list is set to TRUE
554: IF FND_API.to_Boolean(p_init_msg_list) THEN
555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: -- Initialize API return status to success

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: -- Initialize API return status to success
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: l_stmt_num := 10;
562: IF l_eventLog THEN
563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EVENT) THEN

Line 599: IF l_return_status <> FND_API.g_ret_sts_success THEN

595: x_return_status => l_return_status,
596: x_msg_count => l_msg_count,
597: x_msg_data => l_msg_data,
598: p_invoice_distribution_id => l_inv_dist_id);
599: IF l_return_status <> FND_API.g_ret_sts_success THEN
600: l_api_message := 'Error creating IC event';
601: IF l_uLog THEN
602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
603: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 607: RAISE FND_API.g_exc_unexpected_error;

603: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
604: ,'Create_InterCompanyEvents : '||l_stmt_num||' : '||l_api_message);
605: END IF;
606: END IF;
607: RAISE FND_API.g_exc_unexpected_error;
608: END IF;
609: END LOOP;
610:
611: END IF;

Line 614: IF FND_API.to_Boolean(p_commit) THEN

610:
611: END IF;
612:
613: --- Standard check of p_commit
614: IF FND_API.to_Boolean(p_commit) THEN
615: COMMIT WORK;
616: END IF;
617:
618:

Line 633: WHEN FND_API.g_exc_error THEN

629: END IF;
630:
631:
632: EXCEPTION
633: WHEN FND_API.g_exc_error THEN
634: ROLLBACK TO Create_InterCompanyEvents_GRP;
635: x_return_status := FND_API.g_ret_sts_error;
636: FND_MSG_PUB.count_and_get
637: ( p_count => x_msg_count

Line 635: x_return_status := FND_API.g_ret_sts_error;

631:
632: EXCEPTION
633: WHEN FND_API.g_exc_error THEN
634: ROLLBACK TO Create_InterCompanyEvents_GRP;
635: x_return_status := FND_API.g_ret_sts_error;
636: FND_MSG_PUB.count_and_get
637: ( p_count => x_msg_count
638: , p_data => x_msg_data
639: );

Line 641: WHEN FND_API.g_exc_unexpected_error THEN

637: ( p_count => x_msg_count
638: , p_data => x_msg_data
639: );
640:
641: WHEN FND_API.g_exc_unexpected_error THEN
642: ROLLBACK TO Create_InterCompanyEvents_GRP;
643: x_return_status := FND_API.g_ret_sts_unexp_error ;
644: FND_MSG_PUB.count_and_get
645: ( p_count => x_msg_count

Line 643: x_return_status := FND_API.g_ret_sts_unexp_error ;

639: );
640:
641: WHEN FND_API.g_exc_unexpected_error THEN
642: ROLLBACK TO Create_InterCompanyEvents_GRP;
643: x_return_status := FND_API.g_ret_sts_unexp_error ;
644: FND_MSG_PUB.count_and_get
645: ( p_count => x_msg_count
646: , p_data => x_msg_data
647: );

Line 651: x_return_status := fnd_api.g_ret_sts_unexp_error ;

647: );
648:
649: WHEN OTHERS THEN
650: ROLLBACK TO Create_InterCompanyEvents_GRP;
651: x_return_status := fnd_api.g_ret_sts_unexp_error ;
652:
653: IF l_uLog THEN
654: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
655: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 682: -- Default = FND_API.G_FALSE

678: -- global procurement and drop shipment scenarios.
679: -- Parameters :
680: -- IN : p_api_version IN NUMBER Required
681: -- p_init_msg_list IN VARCHAR2 Optional
682: -- Default = FND_API.G_FALSE
683: -- p_commit IN VARCHAR2 Optional
684: -- Default = FND_API.G_FALSE
685: -- p_validation_level IN NUMBER Optional
686: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 684: -- Default = FND_API.G_FALSE

680: -- IN : p_api_version IN NUMBER Required
681: -- p_init_msg_list IN VARCHAR2 Optional
682: -- Default = FND_API.G_FALSE
683: -- p_commit IN VARCHAR2 Optional
684: -- Default = FND_API.G_FALSE
685: -- p_validation_level IN NUMBER Optional
686: -- Default = FND_API.G_VALID_LEVEL_FULL
687: -- p_rcv_transaction_id IN NUMBER Required
688: --

Line 686: -- Default = FND_API.G_VALID_LEVEL_FULL

682: -- Default = FND_API.G_FALSE
683: -- p_commit IN VARCHAR2 Optional
684: -- Default = FND_API.G_FALSE
685: -- p_validation_level IN NUMBER Optional
686: -- Default = FND_API.G_VALID_LEVEL_FULL
687: -- p_rcv_transaction_id IN NUMBER Required
688: --
689: -- OUT : x_return_status OUT VARCHAR2(1)
690: -- x_msg_count OUT NUMBER

Line 757: l_return_status := fnd_api.g_ret_sts_success;

753: fnd_log.TEST(fnd_log.level_unexpected, l_module);
754: l_pLog constant boolean := l_uLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
755:
756: BEGIN
757: l_return_status := fnd_api.g_ret_sts_success;
758: -- Standard start of API savepoint
759: SAVEPOINT Get_InvTransactionInfo_GRP;
760:
761: l_stmt_num := 0;

Line 771: IF NOT FND_API.Compatible_API_Call (

767: END IF;
768: END IF;
769:
770: -- Standard call to check for call compatibility
771: IF NOT FND_API.Compatible_API_Call (
772: l_api_version,
773: p_api_version,
774: l_api_name,
775: G_PKG_NAME ) THEN

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

772: l_api_version,
773: p_api_version,
774: l_api_name,
775: G_PKG_NAME ) THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:
779: -- Initialize message list if p_init_msg_list is set to TRUE
780: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 780: IF FND_API.to_Boolean(p_init_msg_list) THEN

776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:
779: -- Initialize message list if p_init_msg_list is set to TRUE
780: IF FND_API.to_Boolean(p_init_msg_list) THEN
781: FND_MSG_PUB.initialize;
782: END IF;
783:
784: -- Initialize API return status to success

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781: FND_MSG_PUB.initialize;
782: END IF;
783:
784: -- Initialize API return status to success
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: --- Initialize Output Variables
788: x_intercompany_pricing_option := 1;
789: x_distribution_acct_id := -1;

Line 807: IF FND_API.to_Boolean(p_commit) THEN

803: x_currency_conversion_type => x_currency_conversion_type,
804: x_distribution_acct_id => x_distribution_acct_id);
805:
806: --- Standard check of p_commit
807: IF FND_API.to_Boolean(p_commit) THEN
808: COMMIT WORK;
809: END IF;
810:
811: -- Standard Call to get message count and if count = 1, get message info

Line 824: WHEN FND_API.g_exc_error THEN

820: END IF;
821: END IF;
822:
823: EXCEPTION
824: WHEN FND_API.g_exc_error THEN
825: ROLLBACK TO Get_InvTransactionInfo_GRP;
826: x_return_status := FND_API.g_ret_sts_error;
827: FND_MSG_PUB.count_and_get
828: ( p_count => x_msg_count

Line 826: x_return_status := FND_API.g_ret_sts_error;

822:
823: EXCEPTION
824: WHEN FND_API.g_exc_error THEN
825: ROLLBACK TO Get_InvTransactionInfo_GRP;
826: x_return_status := FND_API.g_ret_sts_error;
827: FND_MSG_PUB.count_and_get
828: ( p_count => x_msg_count
829: , p_data => x_msg_data
830: );

Line 832: WHEN FND_API.g_exc_unexpected_error THEN

828: ( p_count => x_msg_count
829: , p_data => x_msg_data
830: );
831:
832: WHEN FND_API.g_exc_unexpected_error THEN
833: ROLLBACK TO Get_InvTransactionInfo_GRP;
834: x_return_status := FND_API.g_ret_sts_unexp_error ;
835: FND_MSG_PUB.count_and_get
836: ( p_count => x_msg_count

Line 834: x_return_status := FND_API.g_ret_sts_unexp_error ;

830: );
831:
832: WHEN FND_API.g_exc_unexpected_error THEN
833: ROLLBACK TO Get_InvTransactionInfo_GRP;
834: x_return_status := FND_API.g_ret_sts_unexp_error ;
835: FND_MSG_PUB.count_and_get
836: ( p_count => x_msg_count
837: , p_data => x_msg_data
838: );

Line 842: x_return_status := fnd_api.g_ret_sts_unexp_error ;

838: );
839:
840: WHEN OTHERS THEN
841: ROLLBACK TO Get_InvTransactionInfo_GRP;
842: x_return_status := fnd_api.g_ret_sts_unexp_error ;
843:
844: IF l_uLog THEN
845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
846: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num