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_ADJVALIDATE_PVT dependencies on FND_API

Line 11: G_caching_done varchar2(1) := FND_API.G_FALSE;

7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
9: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
10:
11: G_caching_done varchar2(1) := FND_API.G_FALSE;
12: G_cache_date date := NULL ;
13: G_receivables_name ar_receivables_trx.name%type := NULL;
14: G_cache_org_id ar_receivables_trx.org_id%TYPE;
15:

Line 178: p_return_status := FND_API.G_RET_STS_SUCCESS;

174: g_context_rec.override_activity_option :=
175: rtrim(FND_PROFILE.VALUE( 'AR_OVERRIDE_ADJUSTMENT_ACTIVITY_ACCOUNT'));
176:
177:
178: p_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: IF PG_DEBUG in ('Y', 'C') THEN
181: arp_util.debug('Init_Context_Rec()-' , G_MSG_HIGH);
182: END IF;

Line 195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

191: G_PKG_NAME,
192: 'Init_Context_Rec'
193: );
194:
195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: RETURN;
197:
198: END Init_Context_Rec;
199:

Line 250: p_return_status := FND_API.G_RET_STS_SUCCESS;

246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_util.debug('Cache_Gl_Periods()+' , G_MSG_HIGH);
248: END IF;
249:
250: p_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: BEGIN
253: SELECT set_of_books_id
254: INTO l_set_of_books_id

Line 268: p_return_status := FND_API.G_RET_STS_ERROR;

264: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_OPEN_FUTURE_PERIOD');
265: FND_MESSAGE.SET_TOKEN ( 'SET_OF_BOOKS_ID', to_char(arp_global.set_of_books_id)) ;
266: FND_MSG_PUB.ADD ;
267:
268: p_return_status := FND_API.G_RET_STS_ERROR;
269:
270: WHEN OTHERS THEN
271: IF PG_DEBUG in ('Y', 'C') THEN
272: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);

Line 278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

274: /*-----------------------------------------------+
275: | Set unexpected error message and status |
276: +-----------------------------------------------*/
277: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');
278: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: END;
280:
281: l_index := 0 ;
282: FOR l_temp_rec IN l_periods_csr LOOP

Line 310: p_return_status := FND_API.G_RET_STS_ERROR;

306: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_OPEN_FUTURE_PERIOD');
307: FND_MESSAGE.SET_TOKEN ( 'SET_OF_BOOKS_ID', to_char(arp_global.set_of_books_id)) ;
308: FND_MSG_PUB.ADD ;
309:
310: p_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);
314: END IF;

Line 319: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

315: /*-----------------------------------------------+
316: | Set unexpected error message and status |
317: +-----------------------------------------------*/
318: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');
319: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: RETURN;
321:
322: END Cache_Gl_Periods;
323:

Line 360: p_return_status := FND_API.G_RET_STS_SUCCESS;

356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_util.debug('Cache_Approval_Type()+' , G_MSG_HIGH);
358: END IF;
359:
360: p_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: FOR l_temp_rec IN l_lookup_csr('APPROVAL_TYPE') LOOP
363: l_index := l_index + 1;
364: G_APPROVAL_TBL(l_index) := l_temp_rec;

Line 386: p_return_status := FND_API.G_RET_STS_ERROR ;

382:
383: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_APPROVAL_CODES');
384: FND_MSG_PUB.ADD ;
385:
386: p_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: WHEN OTHERS THEN
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_util.debug('EXCEPTION: Cache_Approval_Type()', G_MSG_UERROR);

Line 396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

392: /*-----------------------------------------------+
393: | Set unexpected error message and status |
394: +-----------------------------------------------*/
395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Approval_Type');
396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: RETURN;
398:
399: END Cache_Approval_Type;
400:

Line 436: p_return_status := FND_API.G_RET_STS_SUCCESS;

432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_util.debug('Cache_Adjustment_Type()+' , G_MSG_HIGH);
434: END IF;
435:
436: p_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: FOR l_temp_rec IN l_lookup_csr('ADJUSTMENT_TYPE') LOOP
439: l_index := l_index + 1;
440: G_ADJTYPE_TBL(l_index) := l_temp_rec;

Line 461: p_return_status := FND_API.G_RET_STS_ERROR ;

457: +-----------------------------------------------*/
458: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_TYPE_CODES');
459: FND_MSG_PUB.ADD ;
460:
461: p_return_status := FND_API.G_RET_STS_ERROR ;
462:
463: WHEN OTHERS THEN
464: IF PG_DEBUG in ('Y', 'C') THEN
465: arp_util.debug('EXCEPTION: Cache_Adjustment_Type()', G_MSG_UERROR);

Line 471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

467: /*-----------------------------------------------+
468: | Set unexpected error message and status |
469: +-----------------------------------------------*/
470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Type');
471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: RETURN;
473:
474: END Cache_Adjustment_Type;
475:

Line 511: p_return_status := FND_API.G_RET_STS_SUCCESS;

507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_util.debug('Cache_Adjustment_Reason()+' , G_MSG_HIGH);
509: END IF;
510:
511: p_return_status := FND_API.G_RET_STS_SUCCESS;
512:
513: FOR l_temp_rec IN l_lookup_csr('ADJUST_REASON') LOOP
514: l_index := l_index + 1;
515: G_REASON_TBL(l_index) := l_temp_rec;

Line 536: p_return_status := FND_API.G_RET_STS_ERROR ;

532: +-----------------------------------------------*/
533: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_REASON_CODES');
534: FND_MSG_PUB.ADD ;
535:
536: p_return_status := FND_API.G_RET_STS_ERROR ;
537:
538: WHEN OTHERS THEN
539: IF PG_DEBUG in ('Y', 'C') THEN
540: arp_util.debug('EXCEPTION: Cache_Adjustment_Reason()', G_MSG_UERROR);

Line 546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

542: /*-----------------------------------------------+
543: | Set unexpected error message and status |
544: +-----------------------------------------------*/
545: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Reason');
546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547: RETURN;
548:
549: END Cache_Adjustment_Reason;
550:

Line 609: p_return_status := FND_API.G_RET_STS_SUCCESS;

605: IF PG_DEBUG in ('Y', 'C') THEN
606: arp_util.debug('Cache_Receivables_Trx()+' , G_MSG_HIGH);
607: END IF;
608:
609: p_return_status := FND_API.G_RET_STS_SUCCESS;
610:
611: FOR l_temp_rec IN l_receivables_csr LOOP
612: l_index := l_index + 1;
613: G_RCVTRX_TBL(l_index) := l_temp_rec;

Line 635: p_return_status := FND_API.G_RET_STS_ERROR ;

631:
632: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_RECEIVABLES_TRX');
633: FND_MSG_PUB.ADD ;
634:
635: p_return_status := FND_API.G_RET_STS_ERROR ;
636:
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN
639: arp_util.debug('EXCEPTION: Cache_Receivables_Trx()', G_MSG_UERROR);

Line 645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

641: /*-----------------------------------------------+
642: | Set unexpected error message and status |
643: +-----------------------------------------------*/
644: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Receivables_Trx');
645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RETURN;
647:
648: END Cache_Receivables_Trx;
649:

Line 694: p_return_status := FND_API.G_RET_STS_SUCCESS;

690: IF PG_DEBUG in ('Y', 'C') THEN
691: arp_util.debug('Cache_Ussgl_Code()+' , G_MSG_HIGH);
692: END IF;
693:
694: p_return_status := FND_API.G_RET_STS_SUCCESS;
695:
696: /*-----------------------------------------------+
697: | Load the USSGL based on profile option |
698: +-----------------------------------------------*/

Line 729: p_return_status := FND_API.G_RET_STS_SUCCESS ;

725:
726: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_USSGL_CODES');
727: FND_MSG_PUB.ADD ;
728:
729: p_return_status := FND_API.G_RET_STS_SUCCESS ;
730:
731: WHEN OTHERS THEN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug('EXCEPTION: Cache_Ussgl_Code()', G_MSG_UERROR);

Line 739: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

735: /*-----------------------------------------------+
736: | Set unexpected error message and status |
737: +-----------------------------------------------*/
738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Ussgl_Code');
739: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: RETURN;
741:
742: END Cache_Ussgl_code;
743:

Line 795: p_return_status := FND_API.G_RET_STS_SUCCESS;

791: IF PG_DEBUG in ('Y', 'C') THEN
792: arp_util.debug('Cache_Code_Combination()+' , G_MSG_HIGH);
793: END IF;
794:
795: p_return_status := FND_API.G_RET_STS_SUCCESS;
796:
797: FOR l_ccid_rec IN l_ccid_csr LOOP
798: l_index := l_index + 1 ;
799: IF ( l_index > G_CCID_CACHE_SIZE )

Line 803: G_CCID_TBL(l_ccid_rec.code_combination_id).dummy := FND_API.G_TRUE;

799: IF ( l_index > G_CCID_CACHE_SIZE )
800: THEN
801: EXIT;
802: END IF;
803: G_CCID_TBL(l_ccid_rec.code_combination_id).dummy := FND_API.G_TRUE;
804: END LOOP;
805:
806: IF PG_DEBUG in ('Y', 'C') THEN
807: arp_util.debug ('Cache_Code_Combination: ' || 'G_CCID_TBL count = '|| to_char(G_CCID_TBL.count), G_MSG_HIGH);

Line 825: p_return_status := FND_API.G_RET_STS_ERROR ;

821:
822: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CCID');
823: FND_MSG_PUB.ADD ;
824:
825: p_return_status := FND_API.G_RET_STS_ERROR ;
826:
827: WHEN OTHERS THEN
828: IF PG_DEBUG in ('Y', 'C') THEN
829: arp_util.debug('EXCEPTION: Cache_Code_Combination()', G_MSG_UERROR);

Line 835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

831: /*-----------------------------------------------+
832: | Set unexpected error message and status |
833: +-----------------------------------------------*/
834: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Code_Combination');
835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
836: RETURN;
837:
838: END Cache_Code_Combination;
839:

Line 903: l_tobe_cached_flag := FND_API.G_FALSE ;

899: | Check if caching is needed. Caching is needed if|
900: | g_caching_done is FALSE or sysdate > cache_date |
901: +--------------------------------------------------*/
902:
903: l_tobe_cached_flag := FND_API.G_FALSE ;
904:
905: IF PG_DEBUG in ('Y', 'C') THEN
906: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);
907: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),

Line 912: IF ( G_caching_done = FND_API.G_FALSE )

908: G_MSG_HIGH);
909: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);
910: END IF;
911:
912: IF ( G_caching_done = FND_API.G_FALSE )
913: THEN
914: l_tobe_cached_flag := FND_API.G_TRUE ;
915: G_cache_date := trunc(sysdate) ;
916: ELSE

Line 914: l_tobe_cached_flag := FND_API.G_TRUE ;

910: END IF;
911:
912: IF ( G_caching_done = FND_API.G_FALSE )
913: THEN
914: l_tobe_cached_flag := FND_API.G_TRUE ;
915: G_cache_date := trunc(sysdate) ;
916: ELSE
917: IF ( G_cache_date < trunc(sysdate) )
918: THEN

Line 919: l_tobe_cached_flag := FND_API.G_TRUE ;

915: G_cache_date := trunc(sysdate) ;
916: ELSE
917: IF ( G_cache_date < trunc(sysdate) )
918: THEN
919: l_tobe_cached_flag := FND_API.G_TRUE ;
920: G_cache_date := trunc(sysdate) ;
921: END IF;
922: END IF;
923:

Line 929: l_tobe_cached_flag := FND_API.G_TRUE;

925: -- Bug 4038942 : re-cache the data only if org_id has changed
926: l_current_org_id := fnd_global.org_id;
927: IF NVL(l_current_org_id,-88888) <> NVL(G_cache_org_id,-88888) THEN
928: G_cache_org_id := l_current_org_id;
929: l_tobe_cached_flag := FND_API.G_TRUE;
930: END IF;
931:
932: IF PG_DEBUG in ('Y', 'C') THEN
933: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);

Line 936: IF ( l_tobe_cached_flag = FND_API.G_FALSE )

932: IF PG_DEBUG in ('Y', 'C') THEN
933: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);
934: END IF;
935:
936: IF ( l_tobe_cached_flag = FND_API.G_FALSE )
937: THEN
938: p_return_status := FND_API.G_RET_STS_SUCCESS;
939: RETURN ;
940: ELSE

Line 938: p_return_status := FND_API.G_RET_STS_SUCCESS;

934: END IF;
935:
936: IF ( l_tobe_cached_flag = FND_API.G_FALSE )
937: THEN
938: p_return_status := FND_API.G_RET_STS_SUCCESS;
939: RETURN ;
940: ELSE
941: /*-------------------------------------------------+
942: | Initialise the PL/SQL cache tables |

Line 956: p_return_status := FND_API.G_RET_STS_SUCCESS;

952:
953: /*-------------------------------------------------+
954: | Initialize return status to SUCCESS |
955: +-------------------------------------------------*/
956: p_return_status := FND_API.G_RET_STS_SUCCESS;
957:
958:
959: /*-------------------------------------------------+
960: | Cache Approval type. To be used for validation |

Line 966: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

962: +-------------------------------------------------*/
963:
964: AR_ADJVALIDATE_PVT.cache_approval_type (l_return_status);
965:
966: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
967: THEN
968: p_return_status := l_return_status;
969: IF PG_DEBUG in ('Y', 'C') THEN
970: arp_util.debug('Cache_Details: ' || ' failed to cache approval_type');

Line 979: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

975: | for validation of adjustment reason codes |
976: +-------------------------------------------------*/
977:
978: AR_ADJVALIDATE_PVT.cache_adjustment_reason (l_return_status);
979: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
980: THEN
981: p_return_status := l_return_status;
982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_reason');

Line 993: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

989: | To be used for validation of type |
990: +-------------------------------------------------*/
991:
992: AR_ADJVALIDATE_PVT.cache_adjustment_type (l_return_status);
993: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
994: THEN
995: p_return_status := l_return_status;
996: IF PG_DEBUG in ('Y', 'C') THEN
997: arp_util.debug ('Cache_Details: ' || ' failed to cache adjustment_type');

Line 1008: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1004: +-------------------------------------------------*/
1005:
1006: AR_ADJVALIDATE_PVT.cache_receivables_trx (l_return_status) ;
1007:
1008: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1009: THEN
1010: p_return_status := l_return_status;
1011: IF PG_DEBUG in ('Y', 'C') THEN
1012: arp_util.debug ('Cache_Details: ' || ' failed to cache receivables_trx');

Line 1022: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1018: | for validation of USSGL transaction code |
1019: +-------------------------------------------------*/
1020:
1021: AR_ADJVALIDATE_PVT.cache_ussgl_code (l_return_status);
1022: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1023: THEN
1024: p_return_status := l_return_status;
1025: IF PG_DEBUG in ('Y', 'C') THEN
1026: arp_util.debug ('Cache_Details: ' || ' failed to cache ussgl_code');

Line 1036: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1032: | dates lie within open or future enterable period|
1033: +--------------------------------------------------*/
1034:
1035: AR_ADJVALIDATE_PVT.cache_gl_periods(l_return_status);
1036: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1037: THEN
1038: p_return_status := l_return_status;
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_util.debug ('Cache_Details: ' || ' failed to cache gl_periods');

Line 1050: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1046: | validate input provided by user |
1047: +--------------------------------------------------*/
1048:
1049: AR_ADJVALIDATE_PVT.cache_code_combination (l_return_status);
1050: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1051: THEN
1052: p_return_status := l_return_status;
1053: IF PG_DEBUG in ('Y', 'C') THEN
1054: arp_util.debug ('Cache_Details: ' || ' failed to cache code_combination');

Line 1058: G_caching_done := FND_API.G_TRUE ;

1054: arp_util.debug ('Cache_Details: ' || ' failed to cache code_combination');
1055: END IF;
1056: END IF;
1057:
1058: G_caching_done := FND_API.G_TRUE ;
1059:
1060: IF PG_DEBUG in ('Y', 'C') THEN
1061: arp_util.debug('Cache_Details ()-' , G_MSG_HIGH);
1062: END IF;

Line 1071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1067: arp_util.debug('EXCEPTION: Cache_Details() ', G_MSG_UERROR);
1068: END IF;
1069:
1070: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Details');
1071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1072: RETURN;
1073:
1074: END Cache_Details;
1075:

Line 1090: | fnd_api.g_exc_unexpected_error |

1086: | |
1087: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1088: | arp_util.disable_debug |
1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |
1094: | fnd_api.to_boolean |

Line 1091: | fnd_api.g_ret_sts_error |

1087: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1088: | arp_util.disable_debug |
1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |
1094: | fnd_api.to_boolean |
1095: | |

Line 1092: | fnd_api.g_ret_sts_error |

1088: | arp_util.disable_debug |
1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |
1094: | fnd_api.to_boolean |
1095: | |
1096: | ARGUMENTS : IN: |

Line 1093: | fnd_api.g_ret_sts_success |

1089: | arp_util.enable_debug |
1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |
1094: | fnd_api.to_boolean |
1095: | |
1096: | ARGUMENTS : IN: |
1097: | p_adj_rec |

Line 1094: | fnd_api.to_boolean |

1090: | fnd_api.g_exc_unexpected_error |
1091: | fnd_api.g_ret_sts_error |
1092: | fnd_api.g_ret_sts_error |
1093: | fnd_api.g_ret_sts_success |
1094: | fnd_api.to_boolean |
1095: | |
1096: | ARGUMENTS : IN: |
1097: | p_adj_rec |
1098: | p_inv_curr_code |

Line 1135: p_return_status := FND_API.G_RET_STS_SUCCESS;

1131: /*------------------------------------------+
1132: | Initialize the return status to SUCCESS |
1133: +------------------------------------------*/
1134:
1135: p_return_status := FND_API.G_RET_STS_SUCCESS;
1136:
1137: p_approved_flag := FND_API.G_TRUE ;
1138:
1139: /*------------------------------------------+

Line 1137: p_approved_flag := FND_API.G_TRUE ;

1133: +------------------------------------------*/
1134:
1135: p_return_status := FND_API.G_RET_STS_SUCCESS;
1136:
1137: p_approved_flag := FND_API.G_TRUE ;
1138:
1139: /*------------------------------------------+
1140: | Get the user Id |
1141: +------------------------------------------*/

Line 1169: p_approved_flag := FND_API.G_FALSE;

1165:
1166: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_USER_LIMIT');
1167: FND_MESSAGE.SET_TOKEN ( 'CURRENCY', p_inv_curr_code ) ;
1168: FND_MSG_PUB.ADD ;
1169: p_approved_flag := FND_API.G_FALSE;
1170:
1171: WHEN OTHERS THEN
1172:
1173: IF PG_DEBUG in ('Y', 'C') THEN

Line 1181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1177: /*-------------------------------------------------+
1178: | Set unexpected error message, status and return |
1179: +-------------------------------------------------*/
1180: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits');
1181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182: END;
1183:
1184: /*-----------------------------------------------+
1185: | Ensure that approval data has been selected |

Line 1188: IF ( p_approved_flag = FND_API.G_TRUE )

1184: /*-----------------------------------------------+
1185: | Ensure that approval data has been selected |
1186: +-----------------------------------------------*/
1187:
1188: IF ( p_approved_flag = FND_API.G_TRUE )
1189: THEN
1190:
1191: /*--------------------------------------------+
1192: | Perform actual check of approval limits. |

Line 1212: p_approved_flag := FND_API.G_FALSE;

1208:
1209: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
1210: FND_MSG_PUB.ADD ;
1211:
1212: p_approved_flag := FND_API.G_FALSE;
1213:
1214: END IF;
1215:
1216: END IF;

Line 1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1230: | Set unexpected error message and status |
1231: +-----------------------------------------------*/
1232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits'
1233: );
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235: RETURN;
1236:
1237: END Within_approval_limits;
1238:

Line 1251: | fnd_api.g_exc_unexpected_error |

1247: | |
1248: | SCOPE - PRIVATE |
1249: | |
1250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1251: | fnd_api.g_exc_unexpected_error |
1252: | fnd_api.g_ret_sts_error |
1253: | fnd_api.g_ret_sts_success |
1254: | |
1255: | ARGUMENTS : IN: |

Line 1252: | fnd_api.g_ret_sts_error |

1248: | SCOPE - PRIVATE |
1249: | |
1250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1251: | fnd_api.g_exc_unexpected_error |
1252: | fnd_api.g_ret_sts_error |
1253: | fnd_api.g_ret_sts_success |
1254: | |
1255: | ARGUMENTS : IN: |
1256: | OUT: |

Line 1253: | fnd_api.g_ret_sts_success |

1249: | |
1250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1251: | fnd_api.g_exc_unexpected_error |
1252: | fnd_api.g_ret_sts_error |
1253: | fnd_api.g_ret_sts_success |
1254: | |
1255: | ARGUMENTS : IN: |
1256: | OUT: |
1257: | |

Line 1284: p_return_status := FND_API.G_RET_STS_SUCCESS;

1280: /*------------------------------------------+
1281: | Initialize the return status to SUCCESS |
1282: +------------------------------------------*/
1283:
1284: p_return_status := FND_API.G_RET_STS_SUCCESS;
1285:
1286: /*Verify the data in other buckets if they have been entered by the user.
1287: If data is entered for any of the bucket while invoking the API, then
1288: it must be validated for all the buckets.

Line 1305: p_return_status := FND_API.G_RET_STS_ERROR;

1301: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1302: FND_MESSAGE.SET_TOKEN('BUCKET','LINE');
1303: FND_MSG_PUB.ADD;
1304:
1305: p_return_status := FND_API.G_RET_STS_ERROR;
1306: ELSIF (p_adj_rec.line_adjusted + p_ps_rec.amount_line_items_remaining <> 0)
1307: THEN
1308: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1309: FND_MESSAGE.SET_TOKEN('BUCKET','LINE');

Line 1312: p_return_status := FND_API.G_RET_STS_ERROR;

1308: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1309: FND_MESSAGE.SET_TOKEN('BUCKET','LINE');
1310: FND_MSG_PUB.ADD;
1311:
1312: p_return_status := FND_API.G_RET_STS_ERROR;
1313: END IF;
1314:
1315: /*Check tax bucket*/
1316:

Line 1324: p_return_status := FND_API.G_RET_STS_ERROR;

1320: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1321: FND_MESSAGE.SET_TOKEN('BUCKET','TAX');
1322: FND_MSG_PUB.ADD;
1323:
1324: p_return_status := FND_API.G_RET_STS_ERROR;
1325: ELSIF (p_adj_rec.tax_adjusted + p_ps_rec.tax_remaining <> 0)
1326: THEN
1327: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1328: FND_MESSAGE.SET_TOKEN('BUCKET','TAX');

Line 1331: p_return_status := FND_API.G_RET_STS_ERROR;

1327: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1328: FND_MESSAGE.SET_TOKEN('BUCKET','TAX');
1329: FND_MSG_PUB.ADD;
1330:
1331: p_return_status := FND_API.G_RET_STS_ERROR;
1332: END IF;
1333:
1334: /*Check freight bucket*/
1335:

Line 1343: p_return_status := FND_API.G_RET_STS_ERROR;

1339: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1340: FND_MESSAGE.SET_TOKEN('BUCKET','FREIGHT');
1341: FND_MSG_PUB.ADD;
1342:
1343: p_return_status := FND_API.G_RET_STS_ERROR;
1344: ELSIF (p_adj_rec.freight_adjusted + p_ps_rec.freight_remaining <> 0)
1345: THEN
1346: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1347: FND_MESSAGE.SET_TOKEN('BUCKET','FREIGHT');

Line 1350: p_return_status := FND_API.G_RET_STS_ERROR;

1346: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1347: FND_MESSAGE.SET_TOKEN('BUCKET','FREIGHT');
1348: FND_MSG_PUB.ADD;
1349:
1350: p_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352:
1353: /*Check charges bucket*/
1354:

Line 1362: p_return_status := FND_API.G_RET_STS_ERROR;

1358: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_INC_BUCKET');
1359: FND_MESSAGE.SET_TOKEN('BUCKET','CHARGES');
1360: FND_MSG_PUB.ADD;
1361:
1362: p_return_status := FND_API.G_RET_STS_ERROR;
1363: ELSIF (p_adj_rec.receivables_charges_adjusted + p_ps_rec.receivables_charges_remaining <> 0)
1364: THEN
1365: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1366: FND_MESSAGE.SET_TOKEN('BUCKET','CHARGES');

Line 1369: p_return_status := FND_API.G_RET_STS_ERROR;

1365: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_BUCKETS');
1366: FND_MESSAGE.SET_TOKEN('BUCKET','CHARGES');
1367: FND_MSG_PUB.ADD;
1368:
1369: p_return_status := FND_API.G_RET_STS_ERROR;
1370: END IF;
1371: END IF;
1372:
1373: IF PG_DEBUG in ('Y', 'C') THEN

Line 1390: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1386: | Set unexpected error message and status |
1387: +-----------------------------------------------*/
1388: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_buckets'
1389: );
1390: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391: RETURN;
1392:
1393: END Validate_buckets;
1394:

Line 1410: | fnd_api.g_exc_unexpected_error |

1406: | |
1407: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1408: | arp_util.disable_debug |
1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |
1414: | fnd_api.to_boolean |

Line 1411: | fnd_api.g_ret_sts_error |

1407: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1408: | arp_util.disable_debug |
1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |
1414: | fnd_api.to_boolean |
1415: | |

Line 1412: | fnd_api.g_ret_sts_error |

1408: | arp_util.disable_debug |
1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |
1414: | fnd_api.to_boolean |
1415: | |
1416: | ARGUMENTS : IN: |

Line 1413: | fnd_api.g_ret_sts_success |

1409: | arp_util.enable_debug |
1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |
1414: | fnd_api.to_boolean |
1415: | |
1416: | ARGUMENTS : IN: |
1417: | p_adj_rec |

Line 1414: | fnd_api.to_boolean |

1410: | fnd_api.g_exc_unexpected_error |
1411: | fnd_api.g_ret_sts_error |
1412: | fnd_api.g_ret_sts_error |
1413: | fnd_api.g_ret_sts_success |
1414: | fnd_api.to_boolean |
1415: | |
1416: | ARGUMENTS : IN: |
1417: | p_adj_rec |
1418: | |

Line 1449: p_return_status := FND_API.G_RET_STS_ERROR;

1445: /*------------------------------------------+
1446: | Initialize the return status to ERROR |
1447: +------------------------------------------*/
1448:
1449: p_return_status := FND_API.G_RET_STS_ERROR;
1450:
1451: FOR l_index IN 1..G_ADJTYPE_TBL.COUNT LOOP
1452:
1453: IF (p_adj_rec.type = G_ADJTYPE_TBL(l_index).lookup_code)

Line 1455: p_return_status := FND_API.G_RET_STS_SUCCESS;

1451: FOR l_index IN 1..G_ADJTYPE_TBL.COUNT LOOP
1452:
1453: IF (p_adj_rec.type = G_ADJTYPE_TBL(l_index).lookup_code)
1454: THEN
1455: p_return_status := FND_API.G_RET_STS_SUCCESS;
1456: EXIT ;
1457: END IF;
1458:
1459: END LOOP;

Line 1461: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )

1457: END IF;
1458:
1459: END LOOP;
1460:
1461: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1462: THEN
1463: /*-----------------------------------------------+
1464: | Set the message |
1465: +-----------------------------------------------*/

Line 1491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1487: | Set unexpected error message and status |
1488: +-----------------------------------------------*/
1489: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Type' );
1490:
1491: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1492:
1493: RETURN;
1494:
1495: END Validate_Type;

Line 1511: | fnd_api.g_exc_unexpected_error |

1507: | |
1508: | SCOPE - PUBLIC |
1509: | |
1510: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1511: | fnd_api.g_exc_unexpected_error |
1512: | fnd_api.g_ret_sts_error |
1513: | fnd_api.g_ret_sts_success |
1514: | |
1515: | ARGUMENTS : IN: |

Line 1512: | fnd_api.g_ret_sts_error |

1508: | SCOPE - PUBLIC |
1509: | |
1510: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1511: | fnd_api.g_exc_unexpected_error |
1512: | fnd_api.g_ret_sts_error |
1513: | fnd_api.g_ret_sts_success |
1514: | |
1515: | ARGUMENTS : IN: |
1516: | |

Line 1513: | fnd_api.g_ret_sts_success |

1509: | |
1510: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1511: | fnd_api.g_exc_unexpected_error |
1512: | fnd_api.g_ret_sts_error |
1513: | fnd_api.g_ret_sts_success |
1514: | |
1515: | ARGUMENTS : IN: |
1516: | |
1517: | OUT: |

Line 1564: p_return_status := FND_API.G_RET_STS_SUCCESS;

1560: /*------------------------------------------+
1561: | Initialize the return status to SUCCESS |
1562: +------------------------------------------*/
1563:
1564: p_return_status := FND_API.G_RET_STS_SUCCESS;
1565:
1566: -- Initialize Line Level Adjustment
1567: l_customer_trx_id := p_adj_rec.customer_trx_id;
1568: l_customer_trx_line_id := p_adj_rec.customer_trx_line_id;

Line 1588: p_return_status := FND_API.G_RET_STS_ERROR;

1584: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYSCHD');
1585: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_adj_rec.payment_schedule_id)) ;
1586: FND_MSG_PUB.ADD ;
1587:
1588: p_return_status := FND_API.G_RET_STS_ERROR;
1589:
1590: IF PG_DEBUG in ('Y', 'C') THEN
1591: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');
1592: END IF;

Line 1619: p_return_status := FND_API.G_RET_STS_ERROR;

1615:
1616: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYSCHD');
1617: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id)) ;
1618: FND_MSG_PUB.ADD ;
1619: p_return_status := FND_API.G_RET_STS_ERROR;
1620: IF PG_DEBUG in ('Y', 'C') THEN
1621: arp_util.debug('Validate_Payschd: ' || 'payment schedule id is invalid');
1622: END IF;
1623: END ;

Line 1639: p_return_status := FND_API.G_RET_STS_ERROR;

1635: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_TRX_CLASS');
1636: FND_MESSAGE.SET_TOKEN ( 'CLASS', p_ps_rec.class ) ;
1637: FND_MSG_PUB.ADD ;
1638:
1639: p_return_status := FND_API.G_RET_STS_ERROR;
1640: IF PG_DEBUG in ('Y', 'C') THEN
1641: arp_util.debug('Validate_Payschd: ' || 'class of transaction is invalid');
1642: END IF;
1643: END IF;

Line 1660: p_return_status := FND_API.G_RET_STS_ERROR;

1656:
1657: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_TRX_ID');
1658: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id));
1659: FND_MSG_PUB.ADD ;
1660: p_return_status := FND_API.G_RET_STS_ERROR;
1661: IF PG_DEBUG in ('Y', 'C') THEN
1662: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer trx id for the paysch id');
1663: END IF;
1664:

Line 1683: p_return_status := FND_API.G_RET_STS_ERROR;

1679: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CUSTOMER_ID');
1680: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_adj_rec.payment_schedule_id));
1681: FND_MSG_PUB.ADD ;
1682:
1683: p_return_status := FND_API.G_RET_STS_ERROR;
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('Validate_Payschd: ' || 'there is no valid customer id for the paysch id');
1686: END IF;
1687:

Line 1727: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1723: | Set unexpected error message and status |
1724: +-----------------------------------------------*/
1725: IF p_from_llca_call <> 'Y' THEN
1726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Payschd');
1727: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1728: RETURN;
1729: ELSE
1730: insert into ar_llca_adj_trx_errors_gt
1731: (

Line 1746: p_return_status := FND_API.G_RET_STS_ERROR;

1742: l_receivables_trx_id,
1743: 'Validate_Payschd',
1744: 'payment_sch_id'
1745: );
1746: p_return_status := FND_API.G_RET_STS_ERROR;
1747: END IF;
1748:
1749: END ;
1750:

Line 1761: p_return_status := FND_API.G_RET_STS_ERROR;

1757: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',to_char(p_adj_rec.customer_trx_line_id) ) ;
1758: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',to_char(p_adj_rec.customer_trx_id));
1759: FND_MSG_PUB.ADD ;
1760:
1761: p_return_status := FND_API.G_RET_STS_ERROR;
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is invalid');
1764: END IF;
1765:

Line 1783: p_return_status := FND_API.G_RET_STS_ERROR;

1779: l_receivables_trx_id,
1780: 'AR_AAPI_NO_CUSTOMER_TRX_LINEID',
1781: 'payment_sch_id'
1782: );
1783: p_return_status := FND_API.G_RET_STS_ERROR;
1784: END IF;
1785:
1786: END IF ;
1787: -- Bug 1395396 - IF customer trx line id is null then do not raise error message

Line 1805: p_return_status := FND_API.G_RET_STS_ERROR;

1801: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',to_char(p_adj_rec.customer_trx_line_id) ) ;
1802: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',to_char(p_adj_rec.customer_trx_id));
1803: FND_MSG_PUB.ADD ;
1804:
1805: p_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF PG_DEBUG in ('Y', 'C') THEN
1808: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is missing for adj type = LINE');
1809: END IF;

Line 1828: p_return_status := FND_API.G_RET_STS_ERROR;

1824: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', to_char(p_adj_rec.customer_trx_line_id) ) ;
1825: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_ps_rec.class ) ;
1826: FND_MSG_PUB.ADD ;
1827:
1828: p_return_status := FND_API.G_RET_STS_ERROR;
1829: IF PG_DEBUG in ('Y', 'C') THEN
1830: arp_util.debug('Validate_Payschd: ' || 'customer trx line id is not required for adj type ');
1831: END IF;
1832: END IF;

Line 1856: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1852: /*-----------------------------------------------+
1853: | Set unexpected error message and status |
1854: +-----------------------------------------------*/
1855: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Validate_Payschd' );
1856: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1857: RETURN;
1858:
1859: END Validate_Payschd;
1860:

Line 1877: | fnd_api.g_exc_unexpected_error |

1873: | |
1874: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1875: | arp_util.disable_debug |
1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |
1881: | fnd_api.to_boolean |

Line 1878: | fnd_api.g_ret_sts_error |

1874: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1875: | arp_util.disable_debug |
1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |
1881: | fnd_api.to_boolean |
1882: | |

Line 1879: | fnd_api.g_ret_sts_error |

1875: | arp_util.disable_debug |
1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |
1881: | fnd_api.to_boolean |
1882: | |
1883: | ARGUMENTS : IN: |

Line 1880: | fnd_api.g_ret_sts_success |

1876: | arp_util.enable_debug |
1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |
1881: | fnd_api.to_boolean |
1882: | |
1883: | ARGUMENTS : IN: |
1884: | p_ps_rec |

Line 1881: | fnd_api.to_boolean |

1877: | fnd_api.g_exc_unexpected_error |
1878: | fnd_api.g_ret_sts_error |
1879: | fnd_api.g_ret_sts_error |
1880: | fnd_api.g_ret_sts_success |
1881: | fnd_api.to_boolean |
1882: | |
1883: | ARGUMENTS : IN: |
1884: | p_ps_rec |
1885: | OUT: |

Line 1948: p_return_status := FND_API.G_RET_STS_SUCCESS;

1944: /*------------------------------------------+
1945: | Initialize the return status to SUCCESS |
1946: +------------------------------------------*/
1947:
1948: p_return_status := FND_API.G_RET_STS_SUCCESS;
1949: Begin
1950: select invoice_currency_code into l_currency_code
1951: from ra_customer_trx
1952: where customer_trx_id=p_adj_rec.customer_trx_id;

Line 1963: p_return_status := FND_API.G_RET_STS_ERROR;

1959: --Raise Validateion
1960: FND_MESSAGE.SET_NAME ('AR','ARTA_ARTADESM_INVALID_AMOUNT');
1961: FND_MSG_PUB.ADD ;
1962:
1963: p_return_status := FND_API.G_RET_STS_ERROR;
1964:
1965:
1966: END If;
1967: exception

Line 1969: p_return_status := FND_API.G_RET_STS_ERROR;

1965:
1966: END If;
1967: exception
1968: when others then
1969: p_return_status := FND_API.G_RET_STS_ERROR;
1970: FND_MESSAGE.SET_NAME ('AR','ARTA_ARTADESM_INVALID_AMOUNT');
1971: FND_MSG_PUB.ADD ;
1972: end;
1973: /*----------------------------------------------------------------------+

Line 1981: p_check_amount = FND_API.G_TRUE)

1977: | flag p_check_amount is 'F'indicating that this is an adjustment |
1978: | reversal at invoice level, then amount_due remaining will not be zero |
1979: +-----------------------------------------------------------------------*/
1980: IF ( p_adj_rec.type = 'INVOICE' AND
1981: p_check_amount = FND_API.G_TRUE)
1982: THEN
1983:
1984: /*-----------------------------------------------+
1985: | If amount is not specified then set it to |

Line 2000: p_return_status := FND_API.G_RET_STS_ERROR ;

1996:
1997: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_ADR_ZERO_INV');
1998: FND_MSG_PUB.ADD ;
1999:
2000: p_return_status := FND_API.G_RET_STS_ERROR ;
2001: END IF;
2002: p_adj_rec.amount := - p_ps_rec.amount_due_remaining ;
2003: /*Bug 4258945*/
2004: validate_buckets(p_adj_rec,

Line 2007: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2003: /*Bug 4258945*/
2004: validate_buckets(p_adj_rec,
2005: p_ps_rec,
2006: l_return_status);
2007: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2008: THEN
2009: p_return_status := l_return_status ;
2010: END IF ;
2011: ELSE

Line 2018: p_return_status := FND_API.G_RET_STS_ERROR;

2014:
2015: FND_MESSAGE.SET_NAME ('AR', 'AR_TW_VAL_AMT_ADJ_INV');
2016: FND_MSG_PUB.ADD ;
2017:
2018: p_return_status := FND_API.G_RET_STS_ERROR;
2019: END IF;
2020: /*Bug 4258945*/
2021: validate_buckets(p_adj_rec,
2022: p_ps_rec,

Line 2024: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2020: /*Bug 4258945*/
2021: validate_buckets(p_adj_rec,
2022: p_ps_rec,
2023: l_return_status);
2024: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2025: THEN
2026: p_return_status := l_return_status ;
2027: END IF ;
2028: END IF;

Line 2054: p_return_status := FND_API.G_RET_STS_ERROR;

2050:
2051: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_ADJ_AMOUNT_ZERO');
2052: FND_MSG_PUB.ADD ;
2053:
2054: p_return_status := FND_API.G_RET_STS_ERROR;
2055: END IF;
2056:
2057: /*------------------------------------------------+
2058: | Verify if amount is within user approval limits|

Line 2066: IF ( p_chk_approval_limits = FND_API.G_FALSE OR

2062: | Special processing for bypassing limit check if |
2063: | p_chk_approval_limits is set to 'F' |
2064: +---------------------------------------------------*/
2065: -- Added OR conditions for bug fix 1773947
2066: IF ( p_chk_approval_limits = FND_API.G_FALSE OR
2067: p_adj_rec.created_from LIKE 'CASH_ENGINE%' OR
2068: p_adj_rec.created_from LIKE 'RECEIPT_REVERSAL%' OR
2069: p_adj_rec.created_from LIKE 'SPLIT_MERGE%' OR
2070: p_adj_rec.created_from LIKE 'DMS_INTERFACE%' OR

Line 2073: l_approved_flag := FND_API.G_TRUE ;

2069: p_adj_rec.created_from LIKE 'SPLIT_MERGE%' OR
2070: p_adj_rec.created_from LIKE 'DMS_INTERFACE%' OR
2071: p_adj_rec.created_from LIKE 'ENHANCED_CASH%' )
2072: THEN
2073: l_approved_flag := FND_API.G_TRUE ;
2074: ELSE
2075: AR_ADJVALIDATE_PVT.Within_approval_limits (
2076: p_adj_rec.amount,
2077: p_ps_rec.invoice_currency_code,

Line 2081: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2077: p_ps_rec.invoice_currency_code,
2078: l_approved_flag,
2079: l_return_status
2080: ) ;
2081: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2082: THEN
2083: p_return_status := l_return_status ;
2084: END IF ;
2085:

Line 2095: IF ( l_approved_flag = FND_API.G_TRUE )

2091: +--------------------------------------------------*/
2092:
2093: IF ( p_adj_rec.status IS NULL or p_adj_rec.status = ' ' )
2094: THEN
2095: IF ( l_approved_flag = FND_API.G_TRUE )
2096: THEN
2097: p_adj_rec.status := 'A' ;
2098: ELSE
2099: p_adj_rec.status := 'W' ;

Line 2114: p_return_status := FND_API.G_RET_STS_ERROR ;

2110: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CREATE_STATUS');
2111: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
2112: FND_MSG_PUB.ADD ;
2113:
2114: p_return_status := FND_API.G_RET_STS_ERROR ;
2115: END IF;
2116:
2117: /*-----------------------------------------------------+
2118: | Handle the case for setting status to W if outside |

Line 2122: IF ( l_approved_flag = FND_API.G_FALSE AND p_adj_rec.status = 'A' )

2118: | Handle the case for setting status to W if outside |
2119: | approval limits during creation of Adjustments |
2120: +-----------------------------------------------------*/
2121:
2122: IF ( l_approved_flag = FND_API.G_FALSE AND p_adj_rec.status = 'A' )
2123: THEN
2124: p_adj_rec.status := 'W' ;
2125: END IF;
2126:

Line 2146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2142: /*-----------------------------------------------+
2143: | Set unexpected error message and status |
2144: +-----------------------------------------------*/
2145: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Amount');
2146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2147: RETURN;
2148:
2149: END Validate_Amount;
2150:

Line 2166: | fnd_api.g_exc_unexpected_error |

2162: | |
2163: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2164: | arp_util.disable_debug |
2165: | arp_util.enable_debug |
2166: | fnd_api.g_exc_unexpected_error |
2167: | fnd_api.g_ret_sts_error |
2168: | fnd_api.g_ret_sts_error |
2169: | fnd_api.g_ret_sts_success |
2170: | fnd_api.to_boolean |

Line 2167: | fnd_api.g_ret_sts_error |

2163: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2164: | arp_util.disable_debug |
2165: | arp_util.enable_debug |
2166: | fnd_api.g_exc_unexpected_error |
2167: | fnd_api.g_ret_sts_error |
2168: | fnd_api.g_ret_sts_error |
2169: | fnd_api.g_ret_sts_success |
2170: | fnd_api.to_boolean |
2171: | |

Line 2168: | fnd_api.g_ret_sts_error |

2164: | arp_util.disable_debug |
2165: | arp_util.enable_debug |
2166: | fnd_api.g_exc_unexpected_error |
2167: | fnd_api.g_ret_sts_error |
2168: | fnd_api.g_ret_sts_error |
2169: | fnd_api.g_ret_sts_success |
2170: | fnd_api.to_boolean |
2171: | |
2172: | ARGUMENTS : IN: |

Line 2169: | fnd_api.g_ret_sts_success |

2165: | arp_util.enable_debug |
2166: | fnd_api.g_exc_unexpected_error |
2167: | fnd_api.g_ret_sts_error |
2168: | fnd_api.g_ret_sts_error |
2169: | fnd_api.g_ret_sts_success |
2170: | fnd_api.to_boolean |
2171: | |
2172: | ARGUMENTS : IN: |
2173: | |

Line 2170: | fnd_api.to_boolean |

2166: | fnd_api.g_exc_unexpected_error |
2167: | fnd_api.g_ret_sts_error |
2168: | fnd_api.g_ret_sts_error |
2169: | fnd_api.g_ret_sts_success |
2170: | fnd_api.to_boolean |
2171: | |
2172: | ARGUMENTS : IN: |
2173: | |
2174: | OUT: |

Line 2230: p_return_status := FND_API.G_RET_STS_SUCCESS;

2226: /*------------------------------------------+
2227: | Initialize the return status to SUCCESS |
2228: +------------------------------------------*/
2229:
2230: p_return_status := FND_API.G_RET_STS_SUCCESS;
2231:
2232: -- Initialize Line Level Adjustment
2233: l_customer_trx_id := p_adj_rec.customer_trx_id;
2234: l_customer_trx_line_id := p_adj_rec.customer_trx_line_id;

Line 2275: p_return_status := FND_API.G_RET_STS_ERROR;

2271: IF p_from_llca_call <> 'Y' THEN
2272: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RCVABLE_TRX_ID');
2273: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2274: FND_MSG_PUB.ADD ;
2275: p_return_status := FND_API.G_RET_STS_ERROR;
2276: ELSE
2277: insert into ar_llca_adj_trx_errors_gt
2278: (
2279: customer_trx_id,

Line 2293: p_return_status := FND_API.G_RET_STS_ERROR;

2289: l_receivables_trx_id,
2290: 'AR_AAPI_INVALID_RCVABLE_TRX_ID',
2291: 'receivables_trx_id'
2292: );
2293: p_return_status := FND_API.G_RET_STS_ERROR;
2294: END IF;
2295:
2296:
2297: END IF;

Line 2322: p_return_status := FND_API.G_RET_STS_ERROR;

2318:
2319: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RCVABLE_TRX_ID');
2320: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2321: FND_MSG_PUB.ADD ;
2322: p_return_status := FND_API.G_RET_STS_ERROR;
2323:
2324: ELSE
2325: insert into ar_llca_adj_trx_errors_gt
2326: (

Line 2341: p_return_status := FND_API.G_RET_STS_ERROR;

2337: l_receivables_trx_id,
2338: 'AR_AAPI_INVALID_RCVABLE_TRX_ID',
2339: 'receivables_trx_id'
2340: );
2341: p_return_status := FND_API.G_RET_STS_ERROR;
2342: END IF;
2343: END IF;
2344:
2345: /*--------------------------------------------------------------------------+

Line 2380: p_return_status := FND_API.G_RET_STS_ERROR;

2376: IF p_from_llca_call <> 'Y' THEN
2377: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CCID_FOR_ACTIVITY');
2378: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', to_char(p_adj_rec.receivables_trx_id) ) ;
2379: FND_MSG_PUB.ADD ;
2380: p_return_status := FND_API.G_RET_STS_ERROR;
2381: ELSE
2382: insert into ar_llca_adj_trx_errors_gt
2383: (
2384: customer_trx_id,

Line 2398: p_return_status := FND_API.G_RET_STS_ERROR;

2394: l_receivables_trx_id,
2395: 'AR_AAPI_NO_CCID_FOR_ACTIVITY',
2396: 'receivables_trx_id'
2397: );
2398: p_return_status := FND_API.G_RET_STS_ERROR;
2399: END IF;
2400:
2401: END IF ;
2402:

Line 2450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2446: /*---------------------------------------------+
2447: |Set unexpected error message and status |
2448: +---------------------------------------------*/
2449: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2451: END ;
2452:
2453: IF ( l_count <> 1 )
2454: THEN

Line 2462: p_return_status := FND_API.G_RET_STS_ERROR;

2458: IF p_from_llca_call <> 'Y' THEN
2459: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CCID');
2460: FND_MESSAGE.SET_TOKEN ( 'CCID', p_adj_rec.code_combination_id ) ;
2461: FND_MSG_PUB.ADD ;
2462: p_return_status := FND_API.G_RET_STS_ERROR;
2463: ELSE
2464: insert into ar_llca_adj_trx_errors_gt
2465: (
2466: customer_trx_id,

Line 2480: p_return_status := FND_API.G_RET_STS_ERROR;

2476: l_receivables_trx_id,
2477: 'AR_AAPI_INVALID_CCID',
2478: 'receivables_trx_id'
2479: );
2480: p_return_status := FND_API.G_RET_STS_ERROR;
2481: END IF;
2482:
2483: END IF;
2484:

Line 2501: p_return_status := FND_API.G_RET_STS_ERROR;

2497: THEN
2498: IF p_from_llca_call <> 'Y' THEN
2499: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_OVERRIDE_CCID_DISALLOW');
2500: FND_MSG_PUB.ADD ;
2501: p_return_status := FND_API.G_RET_STS_ERROR;
2502: ELSE
2503: insert into ar_llca_adj_trx_errors_gt
2504: (
2505: customer_trx_id,

Line 2519: p_return_status := FND_API.G_RET_STS_ERROR;

2515: l_receivables_trx_id,
2516: 'AR_AAPI_OVERRIDE_CCID_DISALLOW',
2517: 'receivables_trx_id'
2518: );
2519: p_return_status := FND_API.G_RET_STS_ERROR;
2520: END IF;
2521: END IF;
2522: END IF;
2523:

Line 2546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2542: /*-----------------------------------------------+
2543: | Set unexpected error message and status |
2544: +-----------------------------------------------*/
2545: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2546: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2547:
2548: RETURN;
2549:
2550: END Validate_Rcvtrxccid;

Line 2600: p_return_status := FND_API.G_RET_STS_SUCCESS;

2596: /*------------------------------------------+
2597: | Initialize the return status to SUCCESS |
2598: +------------------------------------------*/
2599:
2600: p_return_status := FND_API.G_RET_STS_SUCCESS;
2601:
2602: /*------------------------------------------+
2603: | The dates should not be null |
2604: +-----------------------------------------*/

Line 2611: p_return_status := FND_API.G_RET_STS_ERROR;

2607: THEN
2608:
2609: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_APPLY_DATE');
2610: FND_MSG_PUB.ADD ;
2611: p_return_status := FND_API.G_RET_STS_ERROR;
2612: END IF;
2613:
2614: IF ( p_gl_date IS NULL )
2615: THEN

Line 2619: p_return_status := FND_API.G_RET_STS_ERROR;

2615: THEN
2616:
2617: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_GL_DATE');
2618: FND_MSG_PUB.ADD ;
2619: p_return_status := FND_API.G_RET_STS_ERROR;
2620: END IF;
2621:
2622: /*------------------------------------------+
2623: | Validate from GL date from period cache |

Line 2690: p_return_status := FND_API.G_RET_STS_ERROR;

2686: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_GLDATE_INVALID_PERIOD');
2687: --Int'l Calendar Project
2688: FND_MESSAGE.SET_TOKEN ( 'GL_DATE', fnd_date.date_to_chardate(p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt) ) ;
2689: FND_MSG_PUB.ADD ;
2690: p_return_status := FND_API.G_RET_STS_ERROR;
2691: END IF;
2692:
2693: /*---------------------------------------+
2694: | Check that apply date should be equal |

Line 2705: p_return_status := FND_API.G_RET_STS_ERROR;

2701: --Int'l Calendar Project
2702: FND_MESSAGE.SET_TOKEN ( 'APPLY_DATE', fnd_date.date_to_chardate(p_apply_date, calendar_aware=> FND_DATE.calendar_aware_alt) ) ;
2703: FND_MESSAGE.SET_TOKEN ( 'TRX_DATE', fnd_date.date_to_chardate(p_ps_rec.trx_date, calendar_aware=> FND_DATE.calendar_aware_alt) ) ;
2704: FND_MSG_PUB.ADD ;
2705: p_return_status := FND_API.G_RET_STS_ERROR;
2706:
2707: END IF;
2708:
2709: /*---------------------------------------+

Line 2721: p_return_status := FND_API.G_RET_STS_ERROR;

2717: --Int'l Calendar Project
2718: FND_MESSAGE.SET_TOKEN ( 'GL_DATE', fnd_date.date_to_chardate(p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt) ) ;
2719: FND_MESSAGE.SET_TOKEN ( 'TRX_GL_DATE', fnd_date.date_to_chardate(p_ps_rec.gl_date, calendar_aware=> FND_DATE.calendar_aware_alt) ) ;
2720: FND_MSG_PUB.ADD ;
2721: p_return_status := FND_API.G_RET_STS_ERROR;
2722: END IF;
2723:
2724: IF PG_DEBUG in ('Y', 'C') THEN
2725: arp_util.debug('Validate_dates()-', G_MSG_MEDIUM);

Line 2740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2736: /*-----------------------------------------------+
2737: | Set unexpected error message and status |
2738: +-----------------------------------------------*/
2739: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_dates' );
2740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2741:
2742: RETURN;
2743:
2744: END Validate_dates;

Line 2761: | fnd_api.g_exc_unexpected_error |

2757: | |
2758: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2759: | arp_util.disable_debug |
2760: | arp_util.enable_debug |
2761: | fnd_api.g_exc_unexpected_error |
2762: | fnd_api.g_ret_sts_error |
2763: | fnd_api.g_ret_sts_error |
2764: | fnd_api.g_ret_sts_success |
2765: | fnd_api.to_boolean |

Line 2762: | fnd_api.g_ret_sts_error |

2758: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2759: | arp_util.disable_debug |
2760: | arp_util.enable_debug |
2761: | fnd_api.g_exc_unexpected_error |
2762: | fnd_api.g_ret_sts_error |
2763: | fnd_api.g_ret_sts_error |
2764: | fnd_api.g_ret_sts_success |
2765: | fnd_api.to_boolean |
2766: | |

Line 2763: | fnd_api.g_ret_sts_error |

2759: | arp_util.disable_debug |
2760: | arp_util.enable_debug |
2761: | fnd_api.g_exc_unexpected_error |
2762: | fnd_api.g_ret_sts_error |
2763: | fnd_api.g_ret_sts_error |
2764: | fnd_api.g_ret_sts_success |
2765: | fnd_api.to_boolean |
2766: | |
2767: | ARGUMENTS : IN: |

Line 2764: | fnd_api.g_ret_sts_success |

2760: | arp_util.enable_debug |
2761: | fnd_api.g_exc_unexpected_error |
2762: | fnd_api.g_ret_sts_error |
2763: | fnd_api.g_ret_sts_error |
2764: | fnd_api.g_ret_sts_success |
2765: | fnd_api.to_boolean |
2766: | |
2767: | ARGUMENTS : IN: |
2768: | OUT: |

Line 2765: | fnd_api.to_boolean |

2761: | fnd_api.g_exc_unexpected_error |
2762: | fnd_api.g_ret_sts_error |
2763: | fnd_api.g_ret_sts_error |
2764: | fnd_api.g_ret_sts_success |
2765: | fnd_api.to_boolean |
2766: | |
2767: | ARGUMENTS : IN: |
2768: | OUT: |
2769: | p_return_status |

Line 2812: p_return_status := FND_API.G_RET_STS_SUCCESS;

2808: /*------------------------------------------+
2809: | Initialize the return status to SUCCESS |
2810: +------------------------------------------*/
2811:
2812: p_return_status := FND_API.G_RET_STS_SUCCESS;
2813:
2814: /*------------------------------------------------+
2815: | Document sequences are only applicable if the |
2816: | unique seq number option is not equal to N |

Line 2833: p_return_status := FND_API.G_RET_STS_ERROR;

2829: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_DOC_SEQ_NOT_REQD');
2830: FND_MESSAGE.SET_TOKEN ( 'DOCUMENT_SEQ',
2831: to_char(nvl(p_adj_rec.doc_sequence_id,p_adj_rec.doc_sequence_value ))) ;
2832: FND_MSG_PUB.ADD ;
2833: p_return_status := FND_API.G_RET_STS_ERROR;
2834: END IF;
2835: ELSE
2836: /*--------------------------------------------------------+
2837: | Get info about whether any doc seq assignment exists. |

Line 2862: p_return_status := FND_API.G_RET_STS_ERROR;

2858: END IF;
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_info');
2862: p_return_status := FND_API.G_RET_STS_ERROR;
2863: END;
2864:
2865:
2866:

Line 2887: p_return_status := FND_API.G_RET_STS_ERROR;

2883: FND_MESSAGE.SET_TOKEN ( 'DOCUMENT_SEQ',
2884: to_char(p_adj_rec.doc_sequence_value) ) ;
2885: FND_MSG_PUB.ADD ;
2886:
2887: p_return_status := FND_API.G_RET_STS_ERROR;
2888: END IF;
2889: END IF;
2890:
2891: /*---------------------------------------------------+

Line 2895: IF ( p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2891: /*---------------------------------------------------+
2892: | Auto Doc Num with doc seq setup exists , |
2893: | so, call the get_seq_val to get next seq value |
2894: +----------------------------------------------------*/
2895: IF ( p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2896:
2897: BEGIN
2898: l_dummy := fnd_seqnum.get_seq_val (
2899: arp_global.G_AR_APP_ID,

Line 2913: p_return_status := FND_API.G_RET_STS_ERROR;

2909: END IF;
2910: EXCEPTION
2911: WHEN OTHERS THEN
2912: arp_util.debug('Validate_doc_seq() : Exception raised by get_seq_val');
2913: p_return_status := FND_API.G_RET_STS_ERROR;
2914: END;
2915:
2916: END IF;
2917: ELSE

Line 2931: p_return_status := FND_API.G_RET_STS_ERROR;

2927:
2928: FND_MESSAGE.SET_NAME ('FND', 'UNIQUE-ALWAYS USED');
2929: FND_MSG_PUB.ADD ;
2930:
2931: p_return_status := FND_API.G_RET_STS_ERROR;
2932: END IF;
2933:
2934: END IF; -- Handled for both cases: when seq assign exists and when it doesn't..
2935:

Line 2958: p_return_status := FND_API.G_RET_STS_ERROR;

2954:
2955: FND_MESSAGE.SET_NAME ('FND', 'UNIQUE-ALWAYS USED');
2956: FND_MSG_PUB.ADD ;
2957:
2958: p_return_status := FND_API.G_RET_STS_ERROR;
2959: ELSE
2960: p_adj_rec.doc_sequence_id := NULL;
2961: p_adj_rec.doc_sequence_value := NULL;
2962: END IF;

Line 2973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2969: /*-----------------------------------------------+
2970: | Set unexpected error message and status |
2971: +-----------------------------------------------*/
2972: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_doc_seq' );
2973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2974: RETURN;
2975:
2976: END Validate_doc_seq;
2977:

Line 2992: | fnd_api.g_exc_unexpected_error |

2988: | |
2989: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2990: | arp_util.disable_debug |
2991: | arp_util.enable_debug |
2992: | fnd_api.g_exc_unexpected_error |
2993: | fnd_api.g_ret_sts_error |
2994: | fnd_api.g_ret_sts_error |
2995: | fnd_api.g_ret_sts_success |
2996: | fnd_api.to_boolean |

Line 2993: | fnd_api.g_ret_sts_error |

2989: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2990: | arp_util.disable_debug |
2991: | arp_util.enable_debug |
2992: | fnd_api.g_exc_unexpected_error |
2993: | fnd_api.g_ret_sts_error |
2994: | fnd_api.g_ret_sts_error |
2995: | fnd_api.g_ret_sts_success |
2996: | fnd_api.to_boolean |
2997: | |

Line 2994: | fnd_api.g_ret_sts_error |

2990: | arp_util.disable_debug |
2991: | arp_util.enable_debug |
2992: | fnd_api.g_exc_unexpected_error |
2993: | fnd_api.g_ret_sts_error |
2994: | fnd_api.g_ret_sts_error |
2995: | fnd_api.g_ret_sts_success |
2996: | fnd_api.to_boolean |
2997: | |
2998: | ARGUMENTS : IN: |

Line 2995: | fnd_api.g_ret_sts_success |

2991: | arp_util.enable_debug |
2992: | fnd_api.g_exc_unexpected_error |
2993: | fnd_api.g_ret_sts_error |
2994: | fnd_api.g_ret_sts_error |
2995: | fnd_api.g_ret_sts_success |
2996: | fnd_api.to_boolean |
2997: | |
2998: | ARGUMENTS : IN: |
2999: | |

Line 2996: | fnd_api.to_boolean |

2992: | fnd_api.g_exc_unexpected_error |
2993: | fnd_api.g_ret_sts_error |
2994: | fnd_api.g_ret_sts_error |
2995: | fnd_api.g_ret_sts_success |
2996: | fnd_api.to_boolean |
2997: | |
2998: | ARGUMENTS : IN: |
2999: | |
3000: | OUT: |

Line 3033: p_return_status := FND_API.G_RET_STS_SUCCESS;

3029: /*------------------------------------------+
3030: | Initialize the return status to SUCCESS |
3031: +------------------------------------------*/
3032:
3033: p_return_status := FND_API.G_RET_STS_SUCCESS;
3034:
3035: /*------------------------------------------+
3036: | Validate only is value is provided |
3037: +------------------------------------------*/

Line 3063: p_return_status := FND_API.G_RET_STS_ERROR;

3059: +-----------------------------------------------*/
3060: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_REASON_CODE');
3061: FND_MESSAGE.SET_TOKEN ( 'REASON_CODE', p_adj_rec.reason_code ) ;
3062: FND_MSG_PUB.ADD ;
3063: p_return_status := FND_API.G_RET_STS_ERROR;
3064:
3065: END IF;
3066:
3067: END IF ;

Line 3085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3081: /*-----------------------------------------------+
3082: | Set unexpected error message and status |
3083: +-----------------------------------------------*/
3084: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Reason_code' );
3085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3086:
3087: RETURN;
3088:
3089: END Validate_Reason_code;

Line 3141: p_return_status := FND_API.G_RET_STS_SUCCESS;

3137: /*------------------------------------------+
3138: | Initialize the return status to SUCCESS |
3139: +------------------------------------------*/
3140:
3141: p_return_status := FND_API.G_RET_STS_SUCCESS;
3142:
3143: /*------------------------------------------+
3144: | Get the flexfield name |
3145: +------------------------------------------*/

Line 3167: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3163: /*-----------------------------------------------+
3164: | Set unexpected error message and status |
3165: +-----------------------------------------------*/
3166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
3167: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3168: RETURN;
3169: END ;
3170:
3171: --Bug 1290698 - Validate and default flex field

Line 3194: IF ( p_return_status <>FND_API.G_RET_STS_SUCCESS)

3190: arp_util.Validate_Desc_Flexfield(p_desc_flex_rec ,
3191: l_flex_name,
3192: p_return_status);
3193:
3194: IF ( p_return_status <>FND_API.G_RET_STS_SUCCESS)
3195: THEN
3196: IF PG_DEBUG in ('Y', 'C') THEN
3197: arp_util.debug('arp_util.Validate_Desc_Flexfield - Failed', G_MSG_UERROR);
3198: END IF;

Line 3201: p_return_status := FND_API.G_RET_STS_ERROR;

3197: arp_util.debug('arp_util.Validate_Desc_Flexfield - Failed', G_MSG_UERROR);
3198: END IF;
3199: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_DESC_FLEX');
3200: FND_MSG_PUB.ADD ;
3201: p_return_status := FND_API.G_RET_STS_ERROR;
3202: END IF;
3203:
3204: p_adj_rec.attribute_category := p_desc_flex_rec.attribute_category;
3205: p_adj_rec.attribute1 := p_desc_flex_rec.attribute1;

Line 3234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3230: /*-----------------------------------------------+
3231: | Set unexpected error message and status |
3232: +-----------------------------------------------*/
3233: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
3234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3235:
3236: RETURN;
3237:
3238: END Validate_Desc_Flexfield;

Line 3253: | fnd_api.g_exc_unexpected_error |

3249: | |
3250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3251: | arp_util.disable_debug |
3252: | arp_util.enable_debug |
3253: | fnd_api.g_exc_unexpected_error |
3254: | fnd_api.g_ret_sts_error |
3255: | fnd_api.g_ret_sts_error |
3256: | fnd_api.g_ret_sts_success |
3257: | fnd_api.to_boolean |

Line 3254: | fnd_api.g_ret_sts_error |

3250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3251: | arp_util.disable_debug |
3252: | arp_util.enable_debug |
3253: | fnd_api.g_exc_unexpected_error |
3254: | fnd_api.g_ret_sts_error |
3255: | fnd_api.g_ret_sts_error |
3256: | fnd_api.g_ret_sts_success |
3257: | fnd_api.to_boolean |
3258: | |

Line 3255: | fnd_api.g_ret_sts_error |

3251: | arp_util.disable_debug |
3252: | arp_util.enable_debug |
3253: | fnd_api.g_exc_unexpected_error |
3254: | fnd_api.g_ret_sts_error |
3255: | fnd_api.g_ret_sts_error |
3256: | fnd_api.g_ret_sts_success |
3257: | fnd_api.to_boolean |
3258: | |
3259: | ARGUMENTS : IN: |

Line 3256: | fnd_api.g_ret_sts_success |

3252: | arp_util.enable_debug |
3253: | fnd_api.g_exc_unexpected_error |
3254: | fnd_api.g_ret_sts_error |
3255: | fnd_api.g_ret_sts_error |
3256: | fnd_api.g_ret_sts_success |
3257: | fnd_api.to_boolean |
3258: | |
3259: | ARGUMENTS : IN: |
3260: | p_adj_rec |

Line 3257: | fnd_api.to_boolean |

3253: | fnd_api.g_exc_unexpected_error |
3254: | fnd_api.g_ret_sts_error |
3255: | fnd_api.g_ret_sts_error |
3256: | fnd_api.g_ret_sts_success |
3257: | fnd_api.to_boolean |
3258: | |
3259: | ARGUMENTS : IN: |
3260: | p_adj_rec |
3261: | OUT: |

Line 3290: p_return_status := FND_API.G_RET_STS_SUCCESS;

3286: /*------------------------------------------+
3287: | Initialize the return status to SUCCESS |
3288: +------------------------------------------*/
3289:
3290: p_return_status := FND_API.G_RET_STS_SUCCESS;
3291:
3292: IF ( p_adj_rec.created_from IS NULL OR
3293: p_adj_rec.created_from = ' ' )
3294: THEN

Line 3300: p_return_status := FND_API.G_RET_STS_ERROR;

3296: | Set the message |
3297: +------------------------------------------*/
3298: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CREATED_FROM');
3299: FND_MSG_PUB.ADD ;
3300: p_return_status := FND_API.G_RET_STS_ERROR;
3301: END IF;
3302:
3303:
3304: IF PG_DEBUG in ('Y', 'C') THEN

Line 3321: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3317: | Set unexpected error message and status |
3318: +-----------------------------------------------*/
3319: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Created_From'
3320: );
3321: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3322: RETURN;
3323:
3324: END Validate_Created_From;
3325:

Line 3340: | fnd_api.g_exc_unexpected_error |

3336: | |
3337: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3338: | arp_util.disable_debug |
3339: | arp_util.enable_debug |
3340: | fnd_api.g_exc_unexpected_error |
3341: | fnd_api.g_ret_sts_error |
3342: | fnd_api.g_ret_sts_error |
3343: | fnd_api.g_ret_sts_success |
3344: | fnd_api.to_boolean |

Line 3341: | fnd_api.g_ret_sts_error |

3337: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3338: | arp_util.disable_debug |
3339: | arp_util.enable_debug |
3340: | fnd_api.g_exc_unexpected_error |
3341: | fnd_api.g_ret_sts_error |
3342: | fnd_api.g_ret_sts_error |
3343: | fnd_api.g_ret_sts_success |
3344: | fnd_api.to_boolean |
3345: | |

Line 3342: | fnd_api.g_ret_sts_error |

3338: | arp_util.disable_debug |
3339: | arp_util.enable_debug |
3340: | fnd_api.g_exc_unexpected_error |
3341: | fnd_api.g_ret_sts_error |
3342: | fnd_api.g_ret_sts_error |
3343: | fnd_api.g_ret_sts_success |
3344: | fnd_api.to_boolean |
3345: | |
3346: | ARGUMENTS : IN: |

Line 3343: | fnd_api.g_ret_sts_success |

3339: | arp_util.enable_debug |
3340: | fnd_api.g_exc_unexpected_error |
3341: | fnd_api.g_ret_sts_error |
3342: | fnd_api.g_ret_sts_error |
3343: | fnd_api.g_ret_sts_success |
3344: | fnd_api.to_boolean |
3345: | |
3346: | ARGUMENTS : IN: |
3347: | OUT: |

Line 3344: | fnd_api.to_boolean |

3340: | fnd_api.g_exc_unexpected_error |
3341: | fnd_api.g_ret_sts_error |
3342: | fnd_api.g_ret_sts_error |
3343: | fnd_api.g_ret_sts_success |
3344: | fnd_api.to_boolean |
3345: | |
3346: | ARGUMENTS : IN: |
3347: | OUT: |
3348: | p_return_status |

Line 3379: p_return_status := FND_API.G_RET_STS_ERROR;

3375: /*------------------------------------------+
3376: | Initialize the return status to ERROR |
3377: +------------------------------------------*/
3378:
3379: p_return_status := FND_API.G_RET_STS_ERROR;
3380:
3381: /*------------------------------------------+
3382: | Validate based on option |
3383: +------------------------------------------*/

Line 3397: p_return_status := FND_API.G_RET_STS_SUCCESS;

3393: G_USSGL_TBL(l_index).ussgl_code)
3394: THEN
3395: p_adj_rec.ussgl_transaction_code_context :=
3396: G_USSGL_TBL(l_index).ussgl_context;
3397: p_return_status := FND_API.G_RET_STS_SUCCESS;
3398: EXIT ;
3399: END IF;
3400:
3401: END LOOP;

Line 3403: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )

3399: END IF;
3400:
3401: END LOOP;
3402:
3403: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
3404: THEN
3405: /*-----------------------------------------------+
3406: | Set the message |
3407: +-----------------------------------------------*/

Line 3427: p_return_status := FND_API.G_RET_STS_SUCCESS;

3423: FND_MESSAGE.SET_TOKEN ( 'USSGL_CODE', p_adj_rec.ussgl_transaction_code ) ;
3424: FND_MSG_PUB.ADD ;
3425:
3426: ELSE
3427: p_return_status := FND_API.G_RET_STS_SUCCESS;
3428: END IF ;
3429: END IF ;
3430:
3431: IF PG_DEBUG in ('Y', 'C') THEN

Line 3447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3443: /*-----------------------------------------------+
3444: | Set unexpected error message and status |
3445: +-----------------------------------------------*/
3446: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Ussgl_code' );
3447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3448:
3449: RETURN;
3450:
3451: END Validate_Ussgl_code;

Line 3466: | fnd_api.g_exc_unexpected_error |

3462: | |
3463: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3464: | arp_util.disable_debug |
3465: | arp_util.enable_debug |
3466: | fnd_api.g_exc_unexpected_error |
3467: | fnd_api.g_ret_sts_error |
3468: | fnd_api.g_ret_sts_error |
3469: | fnd_api.g_ret_sts_success |
3470: | fnd_api.to_boolean |

Line 3467: | fnd_api.g_ret_sts_error |

3463: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3464: | arp_util.disable_debug |
3465: | arp_util.enable_debug |
3466: | fnd_api.g_exc_unexpected_error |
3467: | fnd_api.g_ret_sts_error |
3468: | fnd_api.g_ret_sts_error |
3469: | fnd_api.g_ret_sts_success |
3470: | fnd_api.to_boolean |
3471: | |

Line 3468: | fnd_api.g_ret_sts_error |

3464: | arp_util.disable_debug |
3465: | arp_util.enable_debug |
3466: | fnd_api.g_exc_unexpected_error |
3467: | fnd_api.g_ret_sts_error |
3468: | fnd_api.g_ret_sts_error |
3469: | fnd_api.g_ret_sts_success |
3470: | fnd_api.to_boolean |
3471: | |
3472: | ARGUMENTS : IN: |

Line 3469: | fnd_api.g_ret_sts_success |

3465: | arp_util.enable_debug |
3466: | fnd_api.g_exc_unexpected_error |
3467: | fnd_api.g_ret_sts_error |
3468: | fnd_api.g_ret_sts_error |
3469: | fnd_api.g_ret_sts_success |
3470: | fnd_api.to_boolean |
3471: | |
3472: | ARGUMENTS : IN: |
3473: | p_adj_rec |

Line 3470: | fnd_api.to_boolean |

3466: | fnd_api.g_exc_unexpected_error |
3467: | fnd_api.g_ret_sts_error |
3468: | fnd_api.g_ret_sts_error |
3469: | fnd_api.g_ret_sts_success |
3470: | fnd_api.to_boolean |
3471: | |
3472: | ARGUMENTS : IN: |
3473: | p_adj_rec |
3474: | |

Line 3507: p_return_status := FND_API.G_RET_STS_SUCCESS;

3503: /*------------------------------------------+
3504: | Initialize the return status to SUCCESS |
3505: +------------------------------------------*/
3506:
3507: p_return_status := FND_API.G_RET_STS_SUCCESS;
3508:
3509: IF ( p_adj_rec.associated_cash_receipt_id IS NOT NULL AND
3510: p_adj_rec.associated_cash_receipt_id <> 0 )
3511: THEN

Line 3532: p_return_status := FND_API.G_RET_STS_ERROR;

3528: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_RECEIPT_ID');
3529: FND_MESSAGE.SET_TOKEN ( 'ASSOCIATED_CASH_RECEIPT_ID', to_char(p_adj_rec.associated_cash_receipt_id) ) ;
3530: FND_MSG_PUB.ADD ;
3531:
3532: p_return_status := FND_API.G_RET_STS_ERROR;
3533: END IF;
3534:
3535: END IF ;
3536:

Line 3555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3551: /*-----------------------------------------------+
3552: | Set unexpected error message and status |
3553: +-----------------------------------------------*/
3554: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Associated_Receipt');
3555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3556: RETURN;
3557:
3558: END Validate_Associated_Receipt;
3559:

Line 3694: p_return_status := FND_API.G_RET_STS_SUCCESS;

3690: | IF the line number is filled in |
3691: | THEN validate adjustment is not more than available invoiced |
3692: | line amount |
3693: +----------------------------------------------------------------*/
3694: p_return_status := FND_API.G_RET_STS_SUCCESS;
3695:
3696: IF ( p_adj_rec.customer_trx_line_id IS NOT NULL )
3697: THEN
3698:

Line 3729: p_return_status := FND_API.G_RET_STS_ERROR;

3725: arp_util.debug( 'EXCEPTION: ar_adjvalidate_pvt.' ||
3726: 'validate_inv_line_amount ()');
3727: arp_util.debug( 'Adjustments cannot be more than available ' ||
3728: 'invoiced line amount.');
3729: p_return_status := FND_API.G_RET_STS_ERROR;
3730: FND_MESSAGE.SET_NAME('AR','AR_VAL_ADJ_INV_LINE_AMT');
3731: FND_MSG_PUB.Add;
3732: END IF;
3733: ELSIF (l_line_original < 0) THEN

Line 3743: p_return_status := FND_API.G_RET_STS_ERROR;

3739: arp_util.debug( 'EXCEPTION: ar_adjvalidate_pvt.' ||
3740: 'validate_inv_line_amount ()');
3741: arp_util.debug( 'Adjustments cannot be more than available ' ||
3742: 'invoiced line amount.');
3743: p_return_status := FND_API.G_RET_STS_ERROR;
3744: FND_MESSAGE.SET_NAME('AR','AR_VAL_ADJ_INV_LINE_AMT');
3745: FND_MSG_PUB.Add;
3746: END IF;
3747: END IF;

Line 3759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3755: WHEN OTHERS THEN
3756: arp_util.debug('EXCEPTION: ar_adjvalidate_pvt.' ||
3757: 'validate_inv_line_amount()');
3758: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'validate_inv_line_amount()');
3759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3760: RETURN;
3761:
3762: END validate_inv_line_amount;
3763:

Line 3777: | fnd_api.g_exc_unexpected_error |

3773: | SCOPE - PUBLIC |
3774: | |
3775: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3776: | arp_util.disable_debug |
3777: | fnd_api.g_exc_unexpected_error |
3778: | fnd_api.g_ret_sts_error |
3779: | fnd_api.g_ret_sts_error |
3780: | fnd_api.g_ret_sts_success |
3781: | fnd_api.to_boolean |

Line 3778: | fnd_api.g_ret_sts_error |

3774: | |
3775: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3776: | arp_util.disable_debug |
3777: | fnd_api.g_exc_unexpected_error |
3778: | fnd_api.g_ret_sts_error |
3779: | fnd_api.g_ret_sts_error |
3780: | fnd_api.g_ret_sts_success |
3781: | fnd_api.to_boolean |
3782: | |

Line 3779: | fnd_api.g_ret_sts_error |

3775: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3776: | arp_util.disable_debug |
3777: | fnd_api.g_exc_unexpected_error |
3778: | fnd_api.g_ret_sts_error |
3779: | fnd_api.g_ret_sts_error |
3780: | fnd_api.g_ret_sts_success |
3781: | fnd_api.to_boolean |
3782: | |
3783: | ARGUMENTS : IN: |

Line 3780: | fnd_api.g_ret_sts_success |

3776: | arp_util.disable_debug |
3777: | fnd_api.g_exc_unexpected_error |
3778: | fnd_api.g_ret_sts_error |
3779: | fnd_api.g_ret_sts_error |
3780: | fnd_api.g_ret_sts_success |
3781: | fnd_api.to_boolean |
3782: | |
3783: | ARGUMENTS : IN: |
3784: | p_adj_rec |

Line 3781: | fnd_api.to_boolean |

3777: | fnd_api.g_exc_unexpected_error |
3778: | fnd_api.g_ret_sts_error |
3779: | fnd_api.g_ret_sts_error |
3780: | fnd_api.g_ret_sts_success |
3781: | fnd_api.to_boolean |
3782: | |
3783: | ARGUMENTS : IN: |
3784: | p_adj_rec |
3785: | p_ps_rec |

Line 3820: p_return_status := FND_API.G_RET_STS_SUCCESS;

3816: IF PG_DEBUG in ('Y', 'C') THEN
3817: arp_util.debug('Validate_Over_Application()+', G_MSG_MEDIUM);
3818: END IF;
3819:
3820: p_return_status := FND_API.G_RET_STS_SUCCESS;
3821:
3822:
3823: IF ( p_adj_rec.type = 'CHARGES' )
3824: THEN

Line 3879: p_return_status := FND_API.G_RET_STS_ERROR;

3875: NULL;
3876: /*
3877: IF ( l_type_adr + p_adj_rec.amount <> 0 )
3878: THEN
3879: p_return_status := FND_API.G_RET_STS_ERROR;
3880: FND_MESSAGE.SET_NAME('AR','AR_TW_VAL_AMT_ADJ_INV');
3881: FND_MSG_PUB.Add;
3882: END IF;*/
3883:

Line 3907: p_return_status := FND_API.G_RET_STS_ERROR;

3903:
3904:
3905: IF ( l_message_name IS NOT NULL)
3906: THEN
3907: p_return_status := FND_API.G_RET_STS_ERROR;
3908: FND_MESSAGE.SET_NAME('AR',l_message_name);
3909: FND_MSG_PUB.Add;
3910: END IF;
3911:

Line 3934: p_return_status := FND_API.G_RET_STS_ERROR;

3930: p_message_name => l_message_name);
3931:
3932: IF ( l_message_name IS NOT NULL)
3933: THEN
3934: p_return_status := FND_API.G_RET_STS_ERROR;
3935: FND_MESSAGE.SET_NAME('AR',l_message_name);
3936: FND_MSG_PUB.Add;
3937: END IF;
3938:

Line 3956: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3952: /*-----------------------------------------------+
3953: | Set unexpected error message and status |
3954: +-----------------------------------------------*/
3955: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application');
3956: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3957: RETURN;
3958: END Validate_Over_Application;
3959:
3960:

Line 3974: | fnd_api.g_exc_unexpected_error |

3970: | SCOPE - PUBLIC |
3971: | |
3972: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3973: | arp_util.disable_debug |
3974: | fnd_api.g_exc_unexpected_error |
3975: | fnd_api.g_ret_sts_error |
3976: | fnd_api.g_ret_sts_error |
3977: | fnd_api.g_ret_sts_success |
3978: | fnd_api.to_boolean |

Line 3975: | fnd_api.g_ret_sts_error |

3971: | |
3972: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3973: | arp_util.disable_debug |
3974: | fnd_api.g_exc_unexpected_error |
3975: | fnd_api.g_ret_sts_error |
3976: | fnd_api.g_ret_sts_error |
3977: | fnd_api.g_ret_sts_success |
3978: | fnd_api.to_boolean |
3979: | |

Line 3976: | fnd_api.g_ret_sts_error |

3972: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3973: | arp_util.disable_debug |
3974: | fnd_api.g_exc_unexpected_error |
3975: | fnd_api.g_ret_sts_error |
3976: | fnd_api.g_ret_sts_error |
3977: | fnd_api.g_ret_sts_success |
3978: | fnd_api.to_boolean |
3979: | |
3980: | ARGUMENTS : IN: |

Line 3977: | fnd_api.g_ret_sts_success |

3973: | arp_util.disable_debug |
3974: | fnd_api.g_exc_unexpected_error |
3975: | fnd_api.g_ret_sts_error |
3976: | fnd_api.g_ret_sts_error |
3977: | fnd_api.g_ret_sts_success |
3978: | fnd_api.to_boolean |
3979: | |
3980: | ARGUMENTS : IN: |
3981: | p_adj_rec |

Line 3978: | fnd_api.to_boolean |

3974: | fnd_api.g_exc_unexpected_error |
3975: | fnd_api.g_ret_sts_error |
3976: | fnd_api.g_ret_sts_error |
3977: | fnd_api.g_ret_sts_success |
3978: | fnd_api.to_boolean |
3979: | |
3980: | ARGUMENTS : IN: |
3981: | p_adj_rec |
3982: | |

Line 4025: p_return_status := FND_API.G_RET_STS_SUCCESS;

4021: IF PG_DEBUG in ('Y', 'C') THEN
4022: arp_util.debug('Validate_Over_Application_llca()+', G_MSG_MEDIUM);
4023: END IF;
4024:
4025: p_return_status := FND_API.G_RET_STS_SUCCESS;
4026:
4027: l_type_adj_amount := p_adj_rec.amount;
4028: l_customer_trx_id := p_adj_rec.customer_trx_id;
4029: l_customer_trx_line_id := p_adj_rec.customer_trx_line_id;

Line 4172: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4168: /*-----------------------------------------------+
4169: | Set unexpected error message and status |
4170: +-----------------------------------------------*/
4171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Over_Application_llca');
4172: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4173: RETURN;
4174: END Validate_Over_Application_llca;
4175:
4176: BEGIN