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

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: x_return_status OUT NOCOPY VARCHAR2
75: )
76: IS
77: BEGIN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: SELECT trxtype.type,
80: trxtype.name,
81: trxtype.allow_overapplication_flag ,
82: trxtype.natural_application_only_flag,

Line 95: x_return_status := FND_API.G_RET_STS_ERROR ;

91: AND trxtype.cust_trx_type_id = header.cust_trx_type_id;
92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: x_return_status := FND_API.G_RET_STS_ERROR ;
96: IF pg_debug = 'Y' THEN
97: trx_debug ('Exception: ar_transaction_grp.fetch_trx_type' ||sqlerrm);
98: END IF;
99: END fetch_trx_type;

Line 181: l_commit := FND_API.G_FALSE;

177: /*-------------------------------------------+
178: | Initialize local variables |
179: +-------------------------------------------*/
180: IF p_commit = NULL THEN
181: l_commit := FND_API.G_FALSE;
182: ELSE
183: l_commit := p_commit;
184: END IF;
185:

Line 187: l_init_msg_list := FND_API.G_FALSE;

183: l_commit := p_commit;
184: END IF;
185:
186: IF p_init_msg_list = NULL THEN
187: l_init_msg_list := FND_API.G_FALSE;
188: ELSE
189: l_init_msg_list := p_init_msg_list;
190: END IF;
191:

Line 193: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

189: l_init_msg_list := p_init_msg_list;
190: END IF;
191:
192: IF p_validation_level = NULL THEN
193: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
194: ELSE
195: l_validation_level := p_validation_level;
196: END IF;
197:

Line 211: IF NOT FND_API.Compatible_API_Call(

207: /*--------------------------------------------------+
208: | Standard call to check for call compatibility |
209: +--------------------------------------------------*/
210:
211: IF NOT FND_API.Compatible_API_Call(
212: l_api_version,
213: p_api_version,
214: l_api_name,
215: G_PKG_NAME) THEN

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: l_api_version,
213: p_api_version,
214: l_api_name,
215: G_PKG_NAME) THEN
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;
218:
219: /*--------------------------------------------------------------+
220: | Initialize message list if l_init_msg_list is set to TRUE |

Line 223: IF FND_API.to_Boolean( l_init_msg_list ) THEN

219: /*--------------------------------------------------------------+
220: | Initialize message list if l_init_msg_list is set to TRUE |
221: +--------------------------------------------------------------*/
222:
223: IF FND_API.to_Boolean( l_init_msg_list ) THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: /*-----------------------------------------+

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226:
227: /*-----------------------------------------+
228: | Initialize return status to SUCCESS |
229: +-----------------------------------------*/
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232:
233: /*-----------------------------------------------------+
234: | Lock and fetch the header record for customer trx id |

Line 254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

250: fetch_trx_type ( l_trx_type_rec,
251: p_customer_trx_id,
252: x_return_status
253: );
254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
255: ROLLBACK to Complete_Transaction;
256: return;
257: END IF;
258:

Line 281: x_return_status := FND_API.G_RET_STS_ERROR ;

277: l_error_count);
278:
279: IF ( l_error_count > 0 ) THEN
280: ROLLBACK to Complete_Transaction;
281: x_return_status := FND_API.G_RET_STS_ERROR ;
282: FND_MESSAGE.Set_Name('AR', 'AR_TW_CANT_COMPLETE');
283: FND_MSG_PUB.Add;
284: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
285: p_data => x_msg_data

Line 312: x_return_status := FND_API.G_RET_STS_ERROR ;

308: l_trx_rec.doc_sequence_id := l_doc_sequence_id;
309: l_trx_rec.doc_sequence_value := l_doc_sequence_value;
310: ELSIF l_unique_seq_number = 'A' THEN
311: ROLLBACK to Complete_Transaction;
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313: FND_MESSAGE.Set_Name('FND', 'UNIQUE-ALWAYS USED');
314: FND_MSG_PUB.Add;
315: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
316: p_data => x_msg_data

Line 343: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

339: l_trx_rec.old_trx_number := l_trx_rec.trx_number;
340: l_trx_rec.trx_number := l_doc_sequence_value;
341: END IF;
342:
343: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
344: l_trx_rec.complete_flag := 'Y';
345: arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);
346: IF pg_debug = 'Y' THEN
347: trx_debug ('Calling ARP_PROCESS_HEADER_POST_COMMIT.post_commit(+)');

Line 371: IF FND_API.To_Boolean( l_commit ) THEN

367:
368: /*-----------------------------------+
369: | Standard check of l_commit. |
370: +------------------------------------*/
371: IF FND_API.To_Boolean( l_commit ) THEN
372: COMMIT;
373: END IF;
374:
375: /*-----------------------------------------------------------------------+

Line 388: WHEN FND_API.G_EXC_ERROR THEN

384: trx_debug ('AR_TRANSACTION_GRP.COMPLETE_TRANSACTION(-)');
385: END IF;
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO Complete_Transaction;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get (
392: p_count => x_msg_count ,

Line 390: x_return_status := FND_API.G_RET_STS_ERROR ;

386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO Complete_Transaction;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get (
392: p_count => x_msg_count ,
393: p_data => x_msg_data
394: );

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: FND_MSG_PUB.Count_And_Get (
392: p_count => x_msg_count ,
393: p_data => x_msg_data
394: );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO Complete_Transaction;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: FND_MSG_PUB.Count_And_Get (
399: p_count => x_msg_count ,

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

393: p_data => x_msg_data
394: );
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO Complete_Transaction;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: FND_MSG_PUB.Count_And_Get (
399: p_count => x_msg_count ,
400: p_data => x_msg_data
401: );

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

400: p_data => x_msg_data
401: );
402: WHEN OTHERS THEN
403: ROLLBACK TO Complete_Transaction;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
406: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,
407: l_api_name
408: );

Line 490: l_commit := FND_API.G_FALSE;

486: /*-------------------------------------------+
487: | Initialize local variables |
488: +-------------------------------------------*/
489: IF p_commit = NULL THEN
490: l_commit := FND_API.G_FALSE;
491: ELSE
492: l_commit := p_commit;
493: END IF;
494:

Line 496: l_init_msg_list := FND_API.G_FALSE;

492: l_commit := p_commit;
493: END IF;
494:
495: IF p_init_msg_list = NULL THEN
496: l_init_msg_list := FND_API.G_FALSE;
497: ELSE
498: l_init_msg_list := p_init_msg_list;
499: END IF;
500:

Line 502: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

498: l_init_msg_list := p_init_msg_list;
499: END IF;
500:
501: IF p_validation_level = NULL THEN
502: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
503: ELSE
504: l_validation_level := p_validation_level;
505: END IF;
506:

Line 516: IF NOT FND_API.Compatible_API_Call(

512: /*--------------------------------------------------+
513: | Standard call to check for call compatibility |
514: +--------------------------------------------------*/
515:
516: IF NOT FND_API.Compatible_API_Call(
517: l_api_version,
518: p_api_version,
519: l_api_name,
520: G_PKG_NAME) THEN

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517: l_api_version,
518: p_api_version,
519: l_api_name,
520: G_PKG_NAME) THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524: /*--------------------------------------------------------------+
525: | Initialize message list if l_init_msg_list is set to TRUE |

Line 528: IF FND_API.to_Boolean( l_init_msg_list ) THEN

524: /*--------------------------------------------------------------+
525: | Initialize message list if l_init_msg_list is set to TRUE |
526: +--------------------------------------------------------------*/
527:
528: IF FND_API.to_Boolean( l_init_msg_list ) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: /*-----------------------------------------+

Line 535: x_return_status := FND_API.G_RET_STS_SUCCESS;

531:
532: /*-----------------------------------------+
533: | Initialize return status to SUCCESS |
534: +-----------------------------------------*/
535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536:
537: /*-----------------------------------------------------+
538: | Lock and fetch the header record for customer trx id |
539: +-----------------------------------------------------*/

Line 559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

555: p_customer_trx_id,
556: x_return_status
557: );
558:
559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
560: ROLLBACK to Incomplete_Transaction;
561: return;
562: END IF;
563:

Line 578: x_return_status := FND_API.G_RET_STS_ERROR ;

574: l_trx_type_rec.post_to_gl,
575: l_trx_rec.complete_flag );
576: IF (l_posted_flag = 'Y') THEN
577: ROLLBACK to Incomplete_Transaction;
578: x_return_status := FND_API.G_RET_STS_ERROR ;
579: FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_POSTED');
580: FND_MSG_PUB.Add;
581: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
582: p_data => x_msg_data

Line 601: x_return_status := FND_API.G_RET_STS_ERROR ;

597: l_trx_rec.previous_customer_trx_id
598: );
599: IF (l_activity_flag = 'Y') THEN
600: ROLLBACK to Incomplete_Transaction;
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: FND_MESSAGE.Set_Name('AR', 'AR_TW_NO_RECREATE_PS');
603: FND_MSG_PUB.Add;
604: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
605: p_data => x_msg_data

Line 610: x_return_status := FND_API.G_RET_STS_ERROR ;

606: );
607: return;
608: ELSIF (l_activity_flag = 'G') THEN
609: ROLLBACK to Incomplete_Transaction;
610: x_return_status := FND_API.G_RET_STS_ERROR ;
611: FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_POSTED');
612: FND_MSG_PUB.Add;
613: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
614: p_data => x_msg_data

Line 624: x_return_status := FND_API.G_RET_STS_ERROR ;

620: END IF;
621:
622: IF ( l_trx_rec.created_from IN ('ARXREV', 'REL9_ARXREV') ) THEN
623: ROLLBACK to Incomplete_Transaction;
624: x_return_status := FND_API.G_RET_STS_ERROR ;
625: FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_DM_REV');
626: FND_MSG_PUB.Add;
627: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
628: p_data => x_msg_data

Line 635: x_return_status := FND_API.G_RET_STS_ERROR ;

631: END IF;
632:
633: IF ( l_trx_type_rec.type = 'CB' ) THEN
634: ROLLBACK to Incomplete_Transaction;
635: x_return_status := FND_API.G_RET_STS_ERROR ;
636: FND_MESSAGE.Set_Name('AR', 'AR_TAPI_CANT_UPDATE_CB');
637: FND_MSG_PUB.Add;
638: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
639: p_data => x_msg_data

Line 644: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

640: );
641: return;
642: END IF;
643:
644: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
645: l_trx_rec.complete_flag := 'N';
646: arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);
647: IF pg_debug = 'Y' THEN
648: trx_debug ('Calling ARP_PROCESS_HEADER_POST_COMMIT.post_commit(+)');

Line 673: IF FND_API.To_Boolean( l_commit ) THEN

669:
670: /*-----------------------------------+
671: | Standard check of l_commit. |
672: +------------------------------------*/
673: IF FND_API.To_Boolean( l_commit ) THEN
674: COMMIT;
675: END IF;
676:
677: /*-----------------------------------------------------------------------+

Line 690: WHEN FND_API.G_EXC_ERROR THEN

686: trx_debug ('AR_TRANSACTION_GRP.INCOMPLETE_TRANSACTION(-)');
687: END IF;
688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO Incomplete_Transaction;
692: x_return_status := FND_API.G_RET_STS_ERROR ;
693: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
694: p_data => x_msg_data

Line 692: x_return_status := FND_API.G_RET_STS_ERROR ;

688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO Incomplete_Transaction;
692: x_return_status := FND_API.G_RET_STS_ERROR ;
693: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
694: p_data => x_msg_data
695: );
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

692: x_return_status := FND_API.G_RET_STS_ERROR ;
693: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
694: p_data => x_msg_data
695: );
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO Incomplete_Transaction;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
700: p_data => x_msg_data

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

694: p_data => x_msg_data
695: );
696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: ROLLBACK TO Incomplete_Transaction;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
700: p_data => x_msg_data
701: );
702: WHEN OTHERS THEN

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

700: p_data => x_msg_data
701: );
702: WHEN OTHERS THEN
703: ROLLBACK TO Incomplete_Transaction;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
706: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,
707: l_api_name
708: );