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_PUB 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:
15: TYPE Context_Rec_Type IS RECORD

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169: | Set unexpected error message and status |
170: +-----------------------------------------------*/
171: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'aapi_message');
172:
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174:
175: END aapi_message;
176:
177: /*===========================================================================+

Line 239: p_return_status := FND_API.G_RET_STS_SUCCESS;

235: g_context_rec.override_activity_option :=
236: rtrim(FND_PROFILE.VALUE( 'AR_OVERRIDE_ADJUSTMENT_ACTIVITY_ACCOUNT'));
237:
238:
239: p_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: IF PG_DEBUG in ('Y', 'C') THEN
242: arp_util.debug('Init_Context_Rec()-' , G_MSG_HIGH);
243: END IF;

Line 255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

251: FND_MSG_PUB.Add_Exc_Msg (
252: G_PKG_NAME,
253: 'Init_Context_Rec'
254: );
255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: RETURN;
257:
258: END Init_Context_Rec;
259:

Line 310: p_return_status := FND_API.G_RET_STS_SUCCESS;

306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug('Cache_Gl_Periods()+' , G_MSG_HIGH);
308: END IF;
309:
310: p_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: SELECT set_of_books_id
313: INTO l_set_of_books_id
314: FROM ar_system_parameters ;

Line 347: p_return_status := FND_API.G_RET_STS_ERROR;

343: p_message_name => 'AR_AAPI_NO_OPEN_FUTURE_PERIOD',
344: p_token1_name => 'SET_OF_BOOKS_ID',
345: p_token1_value => to_char(arp_global.set_of_books_id)
346: ) ;
347: p_return_status := FND_API.G_RET_STS_ERROR;
348: RETURN;
349: WHEN OTHERS THEN
350: IF PG_DEBUG in ('Y', 'C') THEN
351: arp_util.debug('EXCEPTION: Cache_Gl_Periods()', G_MSG_UERROR);

Line 357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

353: /*-----------------------------------------------+
354: | Set unexpected error message and status |
355: +-----------------------------------------------*/
356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Gl_Periods');
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: RETURN;
359:
360: END Cache_Gl_Periods;
361:

Line 406: p_return_status := FND_API.G_RET_STS_SUCCESS;

402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_util.debug('Cache_Approval_Type()+' , G_MSG_HIGH);
404: END IF;
405:
406: p_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: FOR l_temp_rec IN l_lookup_csr LOOP
409: l_index := l_index + 1;
410: G_APPROVAL_TBL(l_index) := l_temp_rec;

Line 432: p_return_status := FND_API.G_RET_STS_ERROR ;

428: aapi_message(
429: p_application_name =>'AR',
430: p_message_name => 'AR_AAPI_NO_APPROVAL_CODES'
431: ) ;
432: p_return_status := FND_API.G_RET_STS_ERROR ;
433: RETURN;
434:
435: WHEN OTHERS THEN
436: IF PG_DEBUG in ('Y', 'C') THEN

Line 443: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

439: /*-----------------------------------------------+
440: | Set unexpected error message and status |
441: +-----------------------------------------------*/
442: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Approval_Type');
443: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: RETURN;
445:
446: END Cache_Approval_Type;
447:

Line 492: p_return_status := FND_API.G_RET_STS_SUCCESS;

488: IF PG_DEBUG in ('Y', 'C') THEN
489: arp_util.debug('Cache_Adjustment_Type()+' , G_MSG_HIGH);
490: END IF;
491:
492: p_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494: FOR l_temp_rec IN l_lookup_csr LOOP
495: l_index := l_index + 1;
496: G_ADJTYPE_TBL(l_index) := l_temp_rec;

Line 518: p_return_status := FND_API.G_RET_STS_ERROR ;

514: aapi_message(
515: p_application_name =>'AR',
516: p_message_name => 'AR_AAPI_NO_TYPE_CODES'
517: ) ;
518: p_return_status := FND_API.G_RET_STS_ERROR ;
519: RETURN;
520:
521: WHEN OTHERS THEN
522: IF PG_DEBUG in ('Y', 'C') THEN

Line 529: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

525: /*-----------------------------------------------+
526: | Set unexpected error message and status |
527: +-----------------------------------------------*/
528: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Type');
529: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: RETURN;
531:
532: END Cache_Adjustment_Type;
533:

Line 578: p_return_status := FND_API.G_RET_STS_SUCCESS;

574: IF PG_DEBUG in ('Y', 'C') THEN
575: arp_util.debug('Cache_Adjustment_Reason()+' , G_MSG_HIGH);
576: END IF;
577:
578: p_return_status := FND_API.G_RET_STS_SUCCESS;
579:
580: FOR l_temp_rec IN l_lookup_csr LOOP
581: l_index := l_index + 1;
582: G_REASON_TBL(l_index) := l_temp_rec;

Line 604: p_return_status := FND_API.G_RET_STS_ERROR ;

600: aapi_message(
601: p_application_name =>'AR',
602: p_message_name => 'AR_AAPI_NO_REASON_CODES'
603: ) ;
604: p_return_status := FND_API.G_RET_STS_ERROR ;
605: RETURN;
606:
607: WHEN OTHERS THEN
608: IF PG_DEBUG in ('Y', 'C') THEN

Line 615: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

611: /*-----------------------------------------------+
612: | Set unexpected error message and status |
613: +-----------------------------------------------*/
614: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Adjustment_Reason');
615: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616: RETURN;
617:
618: END Cache_Adjustment_Reason;
619:

Line 669: p_return_status := FND_API.G_RET_STS_SUCCESS;

665: IF PG_DEBUG in ('Y', 'C') THEN
666: arp_util.debug('Cache_Receivables_Trx()+' , G_MSG_HIGH);
667: END IF;
668:
669: p_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: FOR l_temp_rec IN l_receivables_csr LOOP
672: l_index := l_index + 1;
673: G_RCVTRX_TBL(l_index) := l_temp_rec;

Line 695: p_return_status := FND_API.G_RET_STS_ERROR ;

691: aapi_message(
692: p_application_name =>'AR',
693: p_message_name => 'AR_AAPI_NO_RECEIVABLES_TRX'
694: ) ;
695: p_return_status := FND_API.G_RET_STS_ERROR ;
696: RETURN;
697:
698: WHEN OTHERS THEN
699: IF PG_DEBUG in ('Y', 'C') THEN

Line 706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

702: /*-----------------------------------------------+
703: | Set unexpected error message and status |
704: +-----------------------------------------------*/
705: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Receivables_Trx');
706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
707: RETURN;
708:
709: END Cache_Receivables_Trx;
710:

Line 755: p_return_status := FND_API.G_RET_STS_SUCCESS;

751: IF PG_DEBUG in ('Y', 'C') THEN
752: arp_util.debug('Cache_Ussgl_Code()+' , G_MSG_HIGH);
753: END IF;
754:
755: p_return_status := FND_API.G_RET_STS_SUCCESS;
756:
757: /*-----------------------------------------------+
758: | Load the USSGL based on profile option |
759: +-----------------------------------------------*/

Line 790: p_return_status := FND_API.G_RET_STS_SUCCESS ;

786: aapi_message(
787: p_application_name =>'AR',
788: p_message_name => 'AR_AAPI_NO_USSGL_CODES'
789: ) ;
790: p_return_status := FND_API.G_RET_STS_SUCCESS ;
791: RETURN;
792:
793: WHEN OTHERS THEN
794: IF PG_DEBUG in ('Y', 'C') THEN

Line 801: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

797: /*-----------------------------------------------+
798: | Set unexpected error message and status |
799: +-----------------------------------------------*/
800: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Ussgl_Code');
801: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
802: RETURN;
803:
804: END Cache_Ussgl_code;
805:

Line 857: p_return_status := FND_API.G_RET_STS_SUCCESS;

853: IF PG_DEBUG in ('Y', 'C') THEN
854: arp_util.debug('Cache_Code_Combination()+' , G_MSG_HIGH);
855: END IF;
856:
857: p_return_status := FND_API.G_RET_STS_SUCCESS;
858:
859: FOR l_ccid_rec IN l_ccid_csr LOOP
860: l_index := l_index + 1 ;
861: IF ( l_index > G_CCID_CACHE_SIZE )

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

861: IF ( l_index > G_CCID_CACHE_SIZE )
862: THEN
863: EXIT;
864: END IF;
865: G_CCID_TBL(l_ccid_rec.code_combination_id).dummy := FND_API.G_TRUE;
866: END LOOP;
867:
868: IF PG_DEBUG in ('Y', 'C') THEN
869: arp_util.debug ('Cache_Code_Combination: ' || 'G_CCID_TBL count = '|| to_char(G_CCID_TBL.count), G_MSG_HIGH);

Line 887: p_return_status := FND_API.G_RET_STS_ERROR ;

883: aapi_message(
884: p_application_name =>'AR',
885: p_message_name => 'AR_AAPI_NO_CCID'
886: ) ;
887: p_return_status := FND_API.G_RET_STS_ERROR ;
888: RETURN;
889:
890: WHEN OTHERS THEN
891: IF PG_DEBUG in ('Y', 'C') THEN

Line 898: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

894: /*-----------------------------------------------+
895: | Set unexpected error message and status |
896: +-----------------------------------------------*/
897: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Code_Combination');
898: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899: RETURN;
900:
901: END Cache_Code_Combination;
902:

Line 964: l_tobe_cached_flag := FND_API.G_FALSE ;

960: | Check if caching is needed. Caching is needed if|
961: | g_caching_done is FALSE or sysdate > cache_date |
962: +--------------------------------------------------*/
963:
964: l_tobe_cached_flag := FND_API.G_FALSE ;
965:
966: IF PG_DEBUG in ('Y', 'C') THEN
967: arp_util.debug ('Cache_Details: ' || 'G_Caching done = ' || G_caching_done, G_MSG_HIGH);
968: arp_util.debug ('Cache_Details: ' || 'G_Cache_date = ' || to_char(G_cache_date,'DD-MON-YY'),

Line 973: IF ( G_caching_done = FND_API.G_FALSE )

969: G_MSG_HIGH);
970: arp_util.debug ('Cache_Details: ' || 'Sysdate = ' || to_char(sysdate,'DD-MON-YY'),G_MSG_HIGH);
971: END IF;
972:
973: IF ( G_caching_done = FND_API.G_FALSE )
974: THEN
975: l_tobe_cached_flag := FND_API.G_TRUE ;
976: G_cache_date := trunc(sysdate) ;
977: ELSE

Line 975: l_tobe_cached_flag := FND_API.G_TRUE ;

971: END IF;
972:
973: IF ( G_caching_done = FND_API.G_FALSE )
974: THEN
975: l_tobe_cached_flag := FND_API.G_TRUE ;
976: G_cache_date := trunc(sysdate) ;
977: ELSE
978: IF ( G_cache_date < trunc(sysdate) )
979: THEN

Line 980: l_tobe_cached_flag := FND_API.G_TRUE ;

976: G_cache_date := trunc(sysdate) ;
977: ELSE
978: IF ( G_cache_date < trunc(sysdate) )
979: THEN
980: l_tobe_cached_flag := FND_API.G_TRUE ;
981: G_cache_date := trunc(sysdate) ;
982: END IF;
983: END IF;
984:

Line 985: l_tobe_cached_flag := FND_API.G_TRUE;

981: G_cache_date := trunc(sysdate) ;
982: END IF;
983: END IF;
984:
985: l_tobe_cached_flag := FND_API.G_TRUE;
986: IF PG_DEBUG in ('Y', 'C') THEN
987: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);
988: END IF;
989:

Line 990: IF ( l_tobe_cached_flag = FND_API.G_FALSE )

986: IF PG_DEBUG in ('Y', 'C') THEN
987: arp_util.debug ('Cache_Details: ' || 'Caching Flag : '|| l_tobe_cached_flag,G_MSG_HIGH);
988: END IF;
989:
990: IF ( l_tobe_cached_flag = FND_API.G_FALSE )
991: THEN
992: p_return_status := FND_API.G_RET_STS_SUCCESS;
993: RETURN ;
994: ELSE

Line 992: p_return_status := FND_API.G_RET_STS_SUCCESS;

988: END IF;
989:
990: IF ( l_tobe_cached_flag = FND_API.G_FALSE )
991: THEN
992: p_return_status := FND_API.G_RET_STS_SUCCESS;
993: RETURN ;
994: ELSE
995: /*-------------------------------------------------+
996: | Initialise the PL/SQL cache tables |

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

1010: +-------------------------------------------------*/
1011:
1012: ar_adjvalidate_pub.cache_approval_type (p_return_status);
1013:
1014: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1015: THEN
1016: RETURN ;
1017: END IF;
1018: /*-------------------------------------------------+

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

1020: | for validation of adjustment reason codes |
1021: +-------------------------------------------------*/
1022:
1023: ar_adjvalidate_pub.cache_adjustment_reason (p_return_status);
1024: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1025: THEN
1026: RETURN ;
1027: END IF;
1028:

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

1031: | To be used for validation of type |
1032: +-------------------------------------------------*/
1033:
1034: ar_adjvalidate_pub.cache_adjustment_type (p_return_status);
1035: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1036: THEN
1037: RETURN ;
1038: END IF;
1039:

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

1043: +-------------------------------------------------*/
1044:
1045: ar_adjvalidate_pub.cache_receivables_trx (p_return_status) ;
1046:
1047: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1048: THEN
1049: RETURN ;
1050: END IF;
1051:

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

1054: | for validation of USSGL transaction code |
1055: +-------------------------------------------------*/
1056:
1057: ar_adjvalidate_pub.cache_ussgl_code (p_return_status);
1058: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1059: THEN
1060: RETURN ;
1061: END IF;
1062:

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

1065: | dates lie within open or future enterable period|
1066: +--------------------------------------------------*/
1067:
1068: ar_adjvalidate_pub.cache_gl_periods(p_return_status);
1069: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1070: THEN
1071: RETURN ;
1072: END IF;
1073:

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

1076: | validate input provided by user |
1077: +--------------------------------------------------*/
1078:
1079: ar_adjvalidate_pub.cache_code_combination (p_return_status);
1080: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1081: THEN
1082: RETURN ;
1083: END IF;
1084:

Line 1085: G_caching_done := FND_API.G_TRUE ;

1081: THEN
1082: RETURN ;
1083: END IF;
1084:
1085: G_caching_done := FND_API.G_TRUE ;
1086:
1087: IF PG_DEBUG in ('Y', 'C') THEN
1088: arp_util.debug('Cache_Details ()-' , G_MSG_HIGH);
1089: END IF;

Line 1098: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1094: arp_util.debug('EXCEPTION: Cache_Details() ', G_MSG_UERROR);
1095: END IF;
1096:
1097: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Cache_Details');
1098: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: RETURN;
1100:
1101: END Cache_Details;
1102:

Line 1117: | fnd_api.g_exc_unexpected_error |

1113: | |
1114: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1115: | arp_util.disable_debug |
1116: | arp_util.enable_debug |
1117: | fnd_api.g_exc_unexpected_error |
1118: | fnd_api.g_ret_sts_error |
1119: | fnd_api.g_ret_sts_error |
1120: | fnd_api.g_ret_sts_success |
1121: | fnd_api.to_boolean |

Line 1118: | fnd_api.g_ret_sts_error |

1114: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1115: | arp_util.disable_debug |
1116: | arp_util.enable_debug |
1117: | fnd_api.g_exc_unexpected_error |
1118: | fnd_api.g_ret_sts_error |
1119: | fnd_api.g_ret_sts_error |
1120: | fnd_api.g_ret_sts_success |
1121: | fnd_api.to_boolean |
1122: | |

Line 1119: | fnd_api.g_ret_sts_error |

1115: | arp_util.disable_debug |
1116: | arp_util.enable_debug |
1117: | fnd_api.g_exc_unexpected_error |
1118: | fnd_api.g_ret_sts_error |
1119: | fnd_api.g_ret_sts_error |
1120: | fnd_api.g_ret_sts_success |
1121: | fnd_api.to_boolean |
1122: | |
1123: | ARGUMENTS : IN: |

Line 1120: | fnd_api.g_ret_sts_success |

1116: | arp_util.enable_debug |
1117: | fnd_api.g_exc_unexpected_error |
1118: | fnd_api.g_ret_sts_error |
1119: | fnd_api.g_ret_sts_error |
1120: | fnd_api.g_ret_sts_success |
1121: | fnd_api.to_boolean |
1122: | |
1123: | ARGUMENTS : IN: |
1124: | p_adj_rec |

Line 1121: | fnd_api.to_boolean |

1117: | fnd_api.g_exc_unexpected_error |
1118: | fnd_api.g_ret_sts_error |
1119: | fnd_api.g_ret_sts_error |
1120: | fnd_api.g_ret_sts_success |
1121: | fnd_api.to_boolean |
1122: | |
1123: | ARGUMENTS : IN: |
1124: | p_adj_rec |
1125: | p_inv_curr_code |

Line 1162: p_return_status := FND_API.G_RET_STS_SUCCESS;

1158: /*------------------------------------------+
1159: | Initialize the return status to SUCCESS |
1160: +------------------------------------------*/
1161:
1162: p_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: p_approved_flag := FND_API.G_TRUE ;
1165:
1166: /*------------------------------------------+

Line 1164: p_approved_flag := FND_API.G_TRUE ;

1160: +------------------------------------------*/
1161:
1162: p_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: p_approved_flag := FND_API.G_TRUE ;
1165:
1166: /*------------------------------------------+
1167: | Get the user Id |
1168: +------------------------------------------*/

Line 1196: p_approved_flag := FND_API.G_FALSE;

1192: p_message_name => 'AR_VAL_USER_LIMIT',
1193: p_token1_name => 'CURRENCY',
1194: p_token1_value => p_inv_curr_code
1195: ) ;
1196: p_approved_flag := FND_API.G_FALSE;
1197:
1198: WHEN OTHERS THEN
1199:
1200: IF PG_DEBUG in ('Y', 'C') THEN

Line 1208: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1204: /*-------------------------------------------------+
1205: | Set unexpected error message, status and return |
1206: +-------------------------------------------------*/
1207: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits');
1208: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: RETURN;
1210: END;
1211:
1212: /*-----------------------------------------------+

Line 1216: IF ( p_approved_flag = FND_API.G_TRUE )

1212: /*-----------------------------------------------+
1213: | Ensure that approval data has been selected |
1214: +-----------------------------------------------*/
1215:
1216: IF ( p_approved_flag = FND_API.G_TRUE )
1217: THEN
1218:
1219: /*--------------------------------------------+
1220: | Perform actual check of approval limits. |

Line 1241: p_approved_flag := FND_API.G_FALSE;

1237: aapi_message(
1238: p_application_name =>'AR',
1239: p_message_name => 'AR_VAL_AMT_APPROVAL_LIMIT'
1240: ) ;
1241: p_approved_flag := FND_API.G_FALSE;
1242:
1243: END IF;
1244:
1245: END IF;

Line 1263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: | Set unexpected error message and status |
1260: +-----------------------------------------------*/
1261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Within_approval_limits'
1262: );
1263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: RETURN;
1265:
1266: END Within_approval_limits;
1267:

Line 1282: | fnd_api.g_exc_unexpected_error |

1278: | |
1279: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1280: | arp_util.disable_debug |
1281: | arp_util.enable_debug |
1282: | fnd_api.g_exc_unexpected_error |
1283: | fnd_api.g_ret_sts_error |
1284: | fnd_api.g_ret_sts_error |
1285: | fnd_api.g_ret_sts_success |
1286: | fnd_api.to_boolean |

Line 1283: | fnd_api.g_ret_sts_error |

1279: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1280: | arp_util.disable_debug |
1281: | arp_util.enable_debug |
1282: | fnd_api.g_exc_unexpected_error |
1283: | fnd_api.g_ret_sts_error |
1284: | fnd_api.g_ret_sts_error |
1285: | fnd_api.g_ret_sts_success |
1286: | fnd_api.to_boolean |
1287: | |

Line 1284: | fnd_api.g_ret_sts_error |

1280: | arp_util.disable_debug |
1281: | arp_util.enable_debug |
1282: | fnd_api.g_exc_unexpected_error |
1283: | fnd_api.g_ret_sts_error |
1284: | fnd_api.g_ret_sts_error |
1285: | fnd_api.g_ret_sts_success |
1286: | fnd_api.to_boolean |
1287: | |
1288: | ARGUMENTS : IN: |

Line 1285: | fnd_api.g_ret_sts_success |

1281: | arp_util.enable_debug |
1282: | fnd_api.g_exc_unexpected_error |
1283: | fnd_api.g_ret_sts_error |
1284: | fnd_api.g_ret_sts_error |
1285: | fnd_api.g_ret_sts_success |
1286: | fnd_api.to_boolean |
1287: | |
1288: | ARGUMENTS : IN: |
1289: | p_adj_rec |

Line 1286: | fnd_api.to_boolean |

1282: | fnd_api.g_exc_unexpected_error |
1283: | fnd_api.g_ret_sts_error |
1284: | fnd_api.g_ret_sts_error |
1285: | fnd_api.g_ret_sts_success |
1286: | fnd_api.to_boolean |
1287: | |
1288: | ARGUMENTS : IN: |
1289: | p_adj_rec |
1290: | |

Line 1322: p_return_status := FND_API.G_RET_STS_ERROR;

1318: /*------------------------------------------+
1319: | Initialize the return status to ERROR |
1320: +------------------------------------------*/
1321:
1322: p_return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: FOR l_index IN 1..G_ADJTYPE_TBL.COUNT LOOP
1325:
1326: IF (p_adj_rec.type = G_ADJTYPE_TBL(l_index).lookup_code)

Line 1328: p_return_status := FND_API.G_RET_STS_SUCCESS;

1324: FOR l_index IN 1..G_ADJTYPE_TBL.COUNT LOOP
1325:
1326: IF (p_adj_rec.type = G_ADJTYPE_TBL(l_index).lookup_code)
1327: THEN
1328: p_return_status := FND_API.G_RET_STS_SUCCESS;
1329: EXIT ;
1330: END IF;
1331:
1332: END LOOP;

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

1330: END IF;
1331:
1332: END LOOP;
1333:
1334: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
1335: THEN
1336: /*-----------------------------------------------+
1337: | Set the message |
1338: +-----------------------------------------------*/

Line 1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1364: | Set unexpected error message and status |
1365: +-----------------------------------------------*/
1366: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Type' );
1367:
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1369:
1370: RETURN;
1371:
1372: END Validate_Type;

Line 1388: | fnd_api.g_exc_unexpected_error |

1384: | |
1385: | SCOPE - PUBLIC |
1386: | |
1387: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1388: | fnd_api.g_exc_unexpected_error |
1389: | fnd_api.g_ret_sts_error |
1390: | fnd_api.g_ret_sts_success |
1391: | |
1392: | ARGUMENTS : IN: |

Line 1389: | fnd_api.g_ret_sts_error |

1385: | SCOPE - PUBLIC |
1386: | |
1387: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1388: | fnd_api.g_exc_unexpected_error |
1389: | fnd_api.g_ret_sts_error |
1390: | fnd_api.g_ret_sts_success |
1391: | |
1392: | ARGUMENTS : IN: |
1393: | |

Line 1390: | fnd_api.g_ret_sts_success |

1386: | |
1387: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1388: | fnd_api.g_exc_unexpected_error |
1389: | fnd_api.g_ret_sts_error |
1390: | fnd_api.g_ret_sts_success |
1391: | |
1392: | ARGUMENTS : IN: |
1393: | |
1394: | OUT: |

Line 1432: p_return_status := FND_API.G_RET_STS_SUCCESS;

1428: /*------------------------------------------+
1429: | Initialize the return status to SUCCESS |
1430: +------------------------------------------*/
1431:
1432: p_return_status := FND_API.G_RET_STS_SUCCESS;
1433:
1434: /*-----------------------------------------------+
1435: | Check if the payment schedule Id is 0 or null |
1436: | If so return with failure |

Line 1452: p_return_status := FND_API.G_RET_STS_ERROR;

1448: p_message_name => 'AR_AAPI_INVALID_PAYSCHD',
1449: p_token1_name => 'PAYMENT_SCHEDULE_ID',
1450: p_token1_value => to_char(p_adj_rec.payment_schedule_id)
1451: ) ;
1452: p_return_status := FND_API.G_RET_STS_ERROR;
1453: RETURN;
1454:
1455: END IF ;
1456:

Line 1482: p_return_status := FND_API.G_RET_STS_ERROR;

1478: p_message_name => 'AR_AAPI_INVALID_PAYSCHD',
1479: p_token1_name => 'PAYMENT_SCHEDULE_ID',
1480: p_token1_value => to_char(p_adj_rec.payment_schedule_id)
1481: ) ;
1482: p_return_status := FND_API.G_RET_STS_ERROR;
1483: RETURN ;
1484: END ;
1485:
1486: /*-----------------------------------------------+

Line 1500: p_return_status := FND_API.G_RET_STS_ERROR;

1496: p_message_name => 'AR_AAPI_INVALID_TRX_CLASS',
1497: p_token1_name => 'CLASS',
1498: p_token1_value => p_ps_rec.class
1499: ) ;
1500: p_return_status := FND_API.G_RET_STS_ERROR;
1501: RETURN;
1502: END IF;
1503:
1504: /*-----------------------------------------------+

Line 1521: p_return_status := FND_API.G_RET_STS_ERROR;

1517: p_message_name => 'AR_AAPI_NO_CUSTOMER_TRX_ID',
1518: p_token1_name => 'PAYMENT_SCHEDULE_ID',
1519: p_token1_value => to_char(p_adj_rec.payment_schedule_id)
1520: ) ;
1521: p_return_status := FND_API.G_RET_STS_ERROR;
1522: RETURN ;
1523:
1524: END IF;
1525:

Line 1543: p_return_status := FND_API.G_RET_STS_ERROR;

1539: p_message_name => 'AR_AAPI_NO_CUSTOMER_ID',
1540: p_token1_name => 'PAYMENT_SCHEDULE_ID',
1541: p_token1_value => to_char(p_adj_rec.payment_schedule_id)
1542: ) ;
1543: p_return_status := FND_API.G_RET_STS_ERROR;
1544: RETURN ;
1545:
1546: END IF;
1547:

Line 1583: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1579: /*-----------------------------------------------+
1580: | Set unexpected error message and status |
1581: +-----------------------------------------------*/
1582: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Payschd');
1583: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1584: RETURN;
1585: END ;
1586:
1587: IF ( l_count <> 1 ) THEN

Line 1599: p_return_status := FND_API.G_RET_STS_ERROR;

1595: p_token1_value => to_char(p_adj_rec.customer_trx_line_id),
1596: p_token2_name => 'CUSTOMER_TRX_ID',
1597: p_token2_value => to_char(p_adj_rec.customer_trx_id)
1598: ) ;
1599: p_return_status := FND_API.G_RET_STS_ERROR;
1600: RETURN ;
1601:
1602: END IF ;
1603:

Line 1622: p_return_status := FND_API.G_RET_STS_ERROR;

1618: p_token1_value => to_char(p_adj_rec.customer_trx_line_id),
1619: p_token2_name => 'TYPE',
1620: p_token2_value => p_ps_rec.class
1621: ) ;
1622: p_return_status := FND_API.G_RET_STS_ERROR;
1623: RETURN ;
1624: END IF;
1625:
1626: END IF;

Line 1648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1644: /*-----------------------------------------------+
1645: | Set unexpected error message and status |
1646: +-----------------------------------------------*/
1647: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Validate_Payschd' );
1648: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1649: RETURN;
1650:
1651: END Validate_Payschd;
1652:

Line 1669: | fnd_api.g_exc_unexpected_error |

1665: | |
1666: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1667: | arp_util.disable_debug |
1668: | arp_util.enable_debug |
1669: | fnd_api.g_exc_unexpected_error |
1670: | fnd_api.g_ret_sts_error |
1671: | fnd_api.g_ret_sts_error |
1672: | fnd_api.g_ret_sts_success |
1673: | fnd_api.to_boolean |

Line 1670: | fnd_api.g_ret_sts_error |

1666: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1667: | arp_util.disable_debug |
1668: | arp_util.enable_debug |
1669: | fnd_api.g_exc_unexpected_error |
1670: | fnd_api.g_ret_sts_error |
1671: | fnd_api.g_ret_sts_error |
1672: | fnd_api.g_ret_sts_success |
1673: | fnd_api.to_boolean |
1674: | |

Line 1671: | fnd_api.g_ret_sts_error |

1667: | arp_util.disable_debug |
1668: | arp_util.enable_debug |
1669: | fnd_api.g_exc_unexpected_error |
1670: | fnd_api.g_ret_sts_error |
1671: | fnd_api.g_ret_sts_error |
1672: | fnd_api.g_ret_sts_success |
1673: | fnd_api.to_boolean |
1674: | |
1675: | ARGUMENTS : IN: |

Line 1672: | fnd_api.g_ret_sts_success |

1668: | arp_util.enable_debug |
1669: | fnd_api.g_exc_unexpected_error |
1670: | fnd_api.g_ret_sts_error |
1671: | fnd_api.g_ret_sts_error |
1672: | fnd_api.g_ret_sts_success |
1673: | fnd_api.to_boolean |
1674: | |
1675: | ARGUMENTS : IN: |
1676: | p_ps_rec |

Line 1673: | fnd_api.to_boolean |

1669: | fnd_api.g_exc_unexpected_error |
1670: | fnd_api.g_ret_sts_error |
1671: | fnd_api.g_ret_sts_error |
1672: | fnd_api.g_ret_sts_success |
1673: | fnd_api.to_boolean |
1674: | |
1675: | ARGUMENTS : IN: |
1676: | p_ps_rec |
1677: | OUT: |

Line 1716: p_return_status := FND_API.G_RET_STS_SUCCESS;

1712: /*------------------------------------------+
1713: | Initialize the return status to SUCCESS |
1714: +------------------------------------------*/
1715:
1716: p_return_status := FND_API.G_RET_STS_SUCCESS;
1717: Begin
1718: select invoice_currency_code into l_currency_code
1719: from ra_customer_trx
1720: where customer_trx_id=p_adj_rec.customer_trx_id;

Line 1734: p_return_status := FND_API.G_RET_STS_ERROR;

1730: p_message_name => 'ARTA_ARTADESM_INVALID_AMOUNT'
1731: ) ;
1732:
1733:
1734: p_return_status := FND_API.G_RET_STS_ERROR;
1735:
1736:
1737: END If;
1738: exception

Line 1740: p_return_status := FND_API.G_RET_STS_ERROR;

1736:
1737: END If;
1738: exception
1739: when others then
1740: p_return_status := FND_API.G_RET_STS_ERROR;
1741: aapi_message(
1742: p_application_name =>'AR',
1743: p_message_name => 'ARTA_ARTADESM_INVALID_AMOUNT'
1744: ) ;

Line 1770: p_return_status := FND_API.G_RET_STS_ERROR ;

1766: aapi_message(
1767: p_application_name =>'AR',
1768: p_message_name => 'AR_AAPI_ADR_ZERO_INV'
1769: ) ;
1770: p_return_status := FND_API.G_RET_STS_ERROR ;
1771: RETURN ;
1772: END IF;
1773: p_adj_rec.amount := - p_ps_rec.amount_due_remaining ;
1774: ELSE

Line 1781: p_return_status := FND_API.G_RET_STS_ERROR;

1777: aapi_message(
1778: p_application_name =>'AR',
1779: p_message_name => 'AR_TW_VAL_AMT_ADJ_INV'
1780: ) ;
1781: p_return_status := FND_API.G_RET_STS_ERROR;
1782: RETURN;
1783: END IF;
1784: END IF;
1785: END IF;

Line 1800: p_return_status := FND_API.G_RET_STS_ERROR;

1796: aapi_message(
1797: p_application_name =>'AR',
1798: p_message_name => 'AR_AAPI_ADJ_AMOUNT_ZERO'
1799: ) ;
1800: p_return_status := FND_API.G_RET_STS_ERROR;
1801: RETURN;
1802: END IF;
1803:
1804: /*------------------------------------------------+

Line 1818: l_approved_flag := FND_API.G_TRUE ;

1814: p_adj_rec.created_from LIKE 'SPLIT_MERGE%' OR
1815: p_adj_rec.created_from LIKE 'DMS_INTERFACE%' OR
1816: p_adj_rec.created_from LIKE 'ENHANCED_CASH%' )
1817: THEN
1818: l_approved_flag := FND_API.G_TRUE ;
1819: ELSE
1820: ar_adjvalidate_pub.Within_approval_limits (
1821: p_adj_rec.amount,
1822: p_ps_rec.invoice_currency_code,

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

1822: p_ps_rec.invoice_currency_code,
1823: l_approved_flag,
1824: l_return_status
1825: ) ;
1826: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1827: THEN
1828: p_return_status := l_return_status ;
1829: RETURN;
1830: END IF ;

Line 1840: IF ( l_approved_flag = FND_API.G_TRUE )

1836: +--------------------------------------------------*/
1837:
1838: IF ( p_adj_rec.status IS NULL or p_adj_rec.status = ' ' )
1839: THEN
1840: IF ( l_approved_flag = FND_API.G_TRUE )
1841: THEN
1842: p_adj_rec.status := 'A' ;
1843: ELSE
1844: p_adj_rec.status := 'W' ;

Line 1860: p_return_status := FND_API.G_RET_STS_ERROR ;

1856: p_message_name => 'AR_AAPI_INVALID_CREATE_STATUS',
1857: p_token1_name => 'STATUS',
1858: p_token1_value => p_adj_rec.status
1859: ) ;
1860: p_return_status := FND_API.G_RET_STS_ERROR ;
1861: RETURN ;
1862: END IF;
1863:
1864: /*-----------------------------------------------------+

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

1865: | Handle the case for setting status to W if outside |
1866: | approval limits during creation of Adjustments |
1867: +-----------------------------------------------------*/
1868:
1869: IF ( l_approved_flag = FND_API.G_FALSE AND p_adj_rec.status = 'A' )
1870: THEN
1871: p_adj_rec.status := 'W' ;
1872: END IF;
1873:

Line 1893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1889: /*-----------------------------------------------+
1890: | Set unexpected error message and status |
1891: +-----------------------------------------------*/
1892: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Amount');
1893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1894: RETURN;
1895:
1896: END Validate_Amount;
1897:

Line 1913: | fnd_api.g_exc_unexpected_error |

1909: | |
1910: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1911: | arp_util.disable_debug |
1912: | arp_util.enable_debug |
1913: | fnd_api.g_exc_unexpected_error |
1914: | fnd_api.g_ret_sts_error |
1915: | fnd_api.g_ret_sts_error |
1916: | fnd_api.g_ret_sts_success |
1917: | fnd_api.to_boolean |

Line 1914: | fnd_api.g_ret_sts_error |

1910: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1911: | arp_util.disable_debug |
1912: | arp_util.enable_debug |
1913: | fnd_api.g_exc_unexpected_error |
1914: | fnd_api.g_ret_sts_error |
1915: | fnd_api.g_ret_sts_error |
1916: | fnd_api.g_ret_sts_success |
1917: | fnd_api.to_boolean |
1918: | |

Line 1915: | fnd_api.g_ret_sts_error |

1911: | arp_util.disable_debug |
1912: | arp_util.enable_debug |
1913: | fnd_api.g_exc_unexpected_error |
1914: | fnd_api.g_ret_sts_error |
1915: | fnd_api.g_ret_sts_error |
1916: | fnd_api.g_ret_sts_success |
1917: | fnd_api.to_boolean |
1918: | |
1919: | ARGUMENTS : IN: |

Line 1916: | fnd_api.g_ret_sts_success |

1912: | arp_util.enable_debug |
1913: | fnd_api.g_exc_unexpected_error |
1914: | fnd_api.g_ret_sts_error |
1915: | fnd_api.g_ret_sts_error |
1916: | fnd_api.g_ret_sts_success |
1917: | fnd_api.to_boolean |
1918: | |
1919: | ARGUMENTS : IN: |
1920: | |

Line 1917: | fnd_api.to_boolean |

1913: | fnd_api.g_exc_unexpected_error |
1914: | fnd_api.g_ret_sts_error |
1915: | fnd_api.g_ret_sts_error |
1916: | fnd_api.g_ret_sts_success |
1917: | fnd_api.to_boolean |
1918: | |
1919: | ARGUMENTS : IN: |
1920: | |
1921: | OUT: |

Line 1956: p_return_status := FND_API.G_RET_STS_ERROR;

1952: /*------------------------------------------+
1953: | Initialize the return status to ERROR |
1954: +------------------------------------------*/
1955:
1956: p_return_status := FND_API.G_RET_STS_ERROR;
1957:
1958: l_found := FALSE ;
1959:
1960: FOR l_index IN 1..G_RCVTRX_TBL.COUNT LOOP

Line 2059: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2055: /*---------------------------------------------+
2056: |Set unexpected error message and status |
2057: +---------------------------------------------*/
2058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2059: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2060: RETURN;
2061: END ;
2062:
2063: IF ( l_count <> 1 )

Line 2106: p_return_status := FND_API.G_RET_STS_SUCCESS ;

2102: +-----------------------------------------------*/
2103:
2104: p_adj_rec.set_of_books_id := arp_global.set_of_books_id ;
2105:
2106: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2107:
2108: IF PG_DEBUG in ('Y', 'C') THEN
2109: arp_util.debug('Validate_Rcvtrxccid()-', G_MSG_MEDIUM);
2110: END IF;

Line 2124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2120: /*-----------------------------------------------+
2121: | Set unexpected error message and status |
2122: +-----------------------------------------------*/
2123: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Rcvtrxccid');
2124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2125:
2126: RETURN;
2127:
2128: END Validate_Rcvtrxccid;

Line 2178: p_return_status := FND_API.G_RET_STS_ERROR;

2174: /*------------------------------------------+
2175: | Initialize the return status to ERROR |
2176: +------------------------------------------*/
2177:
2178: p_return_status := FND_API.G_RET_STS_ERROR;
2179:
2180: /*------------------------------------------+
2181: | The dates should not be null |
2182: +-----------------------------------------*/

Line 2330: p_return_status := FND_API.G_RET_STS_SUCCESS;

2326: ) ;
2327: RETURN;
2328: END IF;
2329: ------------------------------------------------------------ */
2330: p_return_status := FND_API.G_RET_STS_SUCCESS;
2331:
2332: IF PG_DEBUG in ('Y', 'C') THEN
2333: arp_util.debug('Validate_dates()-', G_MSG_MEDIUM);
2334: END IF;

Line 2348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2344: /*-----------------------------------------------+
2345: | Set unexpected error message and status |
2346: +-----------------------------------------------*/
2347: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_dates' );
2348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2349:
2350: RETURN;
2351:
2352: END Validate_dates;

Line 2369: | fnd_api.g_exc_unexpected_error |

2365: | |
2366: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2367: | arp_util.disable_debug |
2368: | arp_util.enable_debug |
2369: | fnd_api.g_exc_unexpected_error |
2370: | fnd_api.g_ret_sts_error |
2371: | fnd_api.g_ret_sts_error |
2372: | fnd_api.g_ret_sts_success |
2373: | fnd_api.to_boolean |

Line 2370: | fnd_api.g_ret_sts_error |

2366: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2367: | arp_util.disable_debug |
2368: | arp_util.enable_debug |
2369: | fnd_api.g_exc_unexpected_error |
2370: | fnd_api.g_ret_sts_error |
2371: | fnd_api.g_ret_sts_error |
2372: | fnd_api.g_ret_sts_success |
2373: | fnd_api.to_boolean |
2374: | |

Line 2371: | fnd_api.g_ret_sts_error |

2367: | arp_util.disable_debug |
2368: | arp_util.enable_debug |
2369: | fnd_api.g_exc_unexpected_error |
2370: | fnd_api.g_ret_sts_error |
2371: | fnd_api.g_ret_sts_error |
2372: | fnd_api.g_ret_sts_success |
2373: | fnd_api.to_boolean |
2374: | |
2375: | ARGUMENTS : IN: |

Line 2372: | fnd_api.g_ret_sts_success |

2368: | arp_util.enable_debug |
2369: | fnd_api.g_exc_unexpected_error |
2370: | fnd_api.g_ret_sts_error |
2371: | fnd_api.g_ret_sts_error |
2372: | fnd_api.g_ret_sts_success |
2373: | fnd_api.to_boolean |
2374: | |
2375: | ARGUMENTS : IN: |
2376: | OUT: |

Line 2373: | fnd_api.to_boolean |

2369: | fnd_api.g_exc_unexpected_error |
2370: | fnd_api.g_ret_sts_error |
2371: | fnd_api.g_ret_sts_error |
2372: | fnd_api.g_ret_sts_success |
2373: | fnd_api.to_boolean |
2374: | |
2375: | ARGUMENTS : IN: |
2376: | OUT: |
2377: | p_return_status |

Line 2412: p_return_status := FND_API.G_RET_STS_SUCCESS;

2408: /*------------------------------------------+
2409: | Initialize the return status to SUCCESS |
2410: +------------------------------------------*/
2411:
2412: p_return_status := FND_API.G_RET_STS_SUCCESS;
2413:
2414: /*------------------------------------------------+
2415: | Document sequences are only applicable if the |
2416: | unique seq number option is not equal to N |

Line 2430: p_return_status := FND_API.G_RET_STS_ERROR;

2426: p_message_name => 'AR_AAPI_DOC_SEQ_NOT_REQD',
2427: p_token1_name => 'DOCUMENT_SEQ',
2428: p_token1_value => to_char(p_adj_rec.doc_sequence_value)
2429: );
2430: p_return_status := FND_API.G_RET_STS_ERROR;
2431: END IF;
2432: RETURN ;
2433: END IF;
2434:

Line 2469: p_return_status := FND_API.G_RET_STS_ERROR;

2465: p_message_name => 'AR_AAPI_DOC_SEQ_NOT_REQD',
2466: p_token1_name => 'DOCUMENT_SEQ',
2467: p_token1_value => to_char(p_adj_rec.doc_sequence_value)
2468: );
2469: p_return_status := FND_API.G_RET_STS_ERROR;
2470: RETURN ;
2471: END IF;
2472:
2473: /*-----------------------------------------+

Line 2510: p_return_status := FND_API.G_RET_STS_ERROR;

2506: aapi_message(
2507: p_application_name =>'FND',
2508: p_message_name => 'UNIQUE-NO VALUE'
2509: );
2510: p_return_status := FND_API.G_RET_STS_ERROR;
2511: RETURN ;
2512: END IF;
2513:
2514: IF PG_DEBUG in ('Y', 'C') THEN

Line 2534: p_return_status := FND_API.G_RET_STS_ERROR;

2530: aapi_message(
2531: p_application_name =>'FND',
2532: p_message_name => 'UNIQUE-ALWAYS USED'
2533: );
2534: p_return_status := FND_API.G_RET_STS_ERROR;
2535: ELSE
2536: p_adj_rec.doc_sequence_id := NULL;
2537: p_adj_rec.doc_sequence_value := NULL;
2538: END IF;

Line 2550: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2546: /*-----------------------------------------------+
2547: | Set unexpected error message and status |
2548: +-----------------------------------------------*/
2549: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_doc_seq' );
2550: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2551: RETURN;
2552:
2553: END Validate_doc_seq;
2554:

Line 2569: | fnd_api.g_exc_unexpected_error |

2565: | |
2566: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2567: | arp_util.disable_debug |
2568: | arp_util.enable_debug |
2569: | fnd_api.g_exc_unexpected_error |
2570: | fnd_api.g_ret_sts_error |
2571: | fnd_api.g_ret_sts_error |
2572: | fnd_api.g_ret_sts_success |
2573: | fnd_api.to_boolean |

Line 2570: | fnd_api.g_ret_sts_error |

2566: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2567: | arp_util.disable_debug |
2568: | arp_util.enable_debug |
2569: | fnd_api.g_exc_unexpected_error |
2570: | fnd_api.g_ret_sts_error |
2571: | fnd_api.g_ret_sts_error |
2572: | fnd_api.g_ret_sts_success |
2573: | fnd_api.to_boolean |
2574: | |

Line 2571: | fnd_api.g_ret_sts_error |

2567: | arp_util.disable_debug |
2568: | arp_util.enable_debug |
2569: | fnd_api.g_exc_unexpected_error |
2570: | fnd_api.g_ret_sts_error |
2571: | fnd_api.g_ret_sts_error |
2572: | fnd_api.g_ret_sts_success |
2573: | fnd_api.to_boolean |
2574: | |
2575: | ARGUMENTS : IN: |

Line 2572: | fnd_api.g_ret_sts_success |

2568: | arp_util.enable_debug |
2569: | fnd_api.g_exc_unexpected_error |
2570: | fnd_api.g_ret_sts_error |
2571: | fnd_api.g_ret_sts_error |
2572: | fnd_api.g_ret_sts_success |
2573: | fnd_api.to_boolean |
2574: | |
2575: | ARGUMENTS : IN: |
2576: | |

Line 2573: | fnd_api.to_boolean |

2569: | fnd_api.g_exc_unexpected_error |
2570: | fnd_api.g_ret_sts_error |
2571: | fnd_api.g_ret_sts_error |
2572: | fnd_api.g_ret_sts_success |
2573: | fnd_api.to_boolean |
2574: | |
2575: | ARGUMENTS : IN: |
2576: | |
2577: | OUT: |

Line 2610: p_return_status := FND_API.G_RET_STS_ERROR;

2606: /*------------------------------------------+
2607: | Initialize the return status to ERROR |
2608: +------------------------------------------*/
2609:
2610: p_return_status := FND_API.G_RET_STS_ERROR;
2611:
2612: /*------------------------------------------+
2613: | Validate only is value is provided |
2614: +------------------------------------------*/

Line 2649: p_return_status := FND_API.G_RET_STS_SUCCESS ;

2645: END IF;
2646:
2647: END IF ;
2648:
2649: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2650:
2651: IF PG_DEBUG in ('Y', 'C') THEN
2652: arp_util.debug('Validate_Reason_Code()-', G_MSG_MEDIUM);
2653: END IF;

Line 2667: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2663: /*-----------------------------------------------+
2664: | Set unexpected error message and status |
2665: +-----------------------------------------------*/
2666: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Reason_code' );
2667: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2668:
2669: RETURN;
2670:
2671: END Validate_Reason_code;

Line 2718: p_return_status := FND_API.G_RET_STS_SUCCESS;

2714: /*------------------------------------------+
2715: | Initialize the return status to SUCCESS |
2716: +------------------------------------------*/
2717:
2718: p_return_status := FND_API.G_RET_STS_SUCCESS;
2719:
2720: /*------------------------------------------+
2721: | Get the flexfield name |
2722: +------------------------------------------*/

Line 2744: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2740: /*-----------------------------------------------+
2741: | Set unexpected error message and status |
2742: +-----------------------------------------------*/
2743: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
2744: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2745: RETURN;
2746: END ;
2747:
2748:

Line 2773: p_return_status := FND_API.G_RET_STS_ERROR;

2769: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_adj_rec.attribute15);
2770:
2771: IF ( NOT fnd_flex_descval.validate_desccols ('AR', l_flex_name) )
2772: THEN
2773: p_return_status := FND_API.G_RET_STS_ERROR;
2774: aapi_message(
2775: p_application_name =>'AR',
2776: p_message_name => 'AR_AAPI_INVALID_DESC_FLEX'
2777: ) ;

Line 2794: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2790: /*-----------------------------------------------+
2791: | Set unexpected error message and status |
2792: +-----------------------------------------------*/
2793: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Desc_Flexfield' );
2794: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795:
2796: RETURN;
2797:
2798: END Validate_Desc_Flexfield;

Line 2813: | fnd_api.g_exc_unexpected_error |

2809: | |
2810: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2811: | arp_util.disable_debug |
2812: | arp_util.enable_debug |
2813: | fnd_api.g_exc_unexpected_error |
2814: | fnd_api.g_ret_sts_error |
2815: | fnd_api.g_ret_sts_error |
2816: | fnd_api.g_ret_sts_success |
2817: | fnd_api.to_boolean |

Line 2814: | fnd_api.g_ret_sts_error |

2810: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2811: | arp_util.disable_debug |
2812: | arp_util.enable_debug |
2813: | fnd_api.g_exc_unexpected_error |
2814: | fnd_api.g_ret_sts_error |
2815: | fnd_api.g_ret_sts_error |
2816: | fnd_api.g_ret_sts_success |
2817: | fnd_api.to_boolean |
2818: | |

Line 2815: | fnd_api.g_ret_sts_error |

2811: | arp_util.disable_debug |
2812: | arp_util.enable_debug |
2813: | fnd_api.g_exc_unexpected_error |
2814: | fnd_api.g_ret_sts_error |
2815: | fnd_api.g_ret_sts_error |
2816: | fnd_api.g_ret_sts_success |
2817: | fnd_api.to_boolean |
2818: | |
2819: | ARGUMENTS : IN: |

Line 2816: | fnd_api.g_ret_sts_success |

2812: | arp_util.enable_debug |
2813: | fnd_api.g_exc_unexpected_error |
2814: | fnd_api.g_ret_sts_error |
2815: | fnd_api.g_ret_sts_error |
2816: | fnd_api.g_ret_sts_success |
2817: | fnd_api.to_boolean |
2818: | |
2819: | ARGUMENTS : IN: |
2820: | p_adj_rec |

Line 2817: | fnd_api.to_boolean |

2813: | fnd_api.g_exc_unexpected_error |
2814: | fnd_api.g_ret_sts_error |
2815: | fnd_api.g_ret_sts_error |
2816: | fnd_api.g_ret_sts_success |
2817: | fnd_api.to_boolean |
2818: | |
2819: | ARGUMENTS : IN: |
2820: | p_adj_rec |
2821: | OUT: |

Line 2850: p_return_status := FND_API.G_RET_STS_SUCCESS;

2846: /*------------------------------------------+
2847: | Initialize the return status to SUCCESS |
2848: +------------------------------------------*/
2849:
2850: p_return_status := FND_API.G_RET_STS_SUCCESS;
2851:
2852: IF ( p_adj_rec.created_from IS NULL OR
2853: p_adj_rec.created_from = ' ' )
2854: THEN

Line 2862: p_return_status := FND_API.G_RET_STS_ERROR;

2858: aapi_message(
2859: p_application_name =>'AR',
2860: p_message_name => 'AR_AAPI_NO_CREATED_FROM'
2861: ) ;
2862: p_return_status := FND_API.G_RET_STS_ERROR;
2863: RETURN ;
2864: END IF;
2865:
2866:

Line 2884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2880: | Set unexpected error message and status |
2881: +-----------------------------------------------*/
2882: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Created_From'
2883: );
2884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2885: RETURN;
2886:
2887: END Validate_Created_From;
2888:

Line 2903: | fnd_api.g_exc_unexpected_error |

2899: | |
2900: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2901: | arp_util.disable_debug |
2902: | arp_util.enable_debug |
2903: | fnd_api.g_exc_unexpected_error |
2904: | fnd_api.g_ret_sts_error |
2905: | fnd_api.g_ret_sts_error |
2906: | fnd_api.g_ret_sts_success |
2907: | fnd_api.to_boolean |

Line 2904: | fnd_api.g_ret_sts_error |

2900: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2901: | arp_util.disable_debug |
2902: | arp_util.enable_debug |
2903: | fnd_api.g_exc_unexpected_error |
2904: | fnd_api.g_ret_sts_error |
2905: | fnd_api.g_ret_sts_error |
2906: | fnd_api.g_ret_sts_success |
2907: | fnd_api.to_boolean |
2908: | |

Line 2905: | fnd_api.g_ret_sts_error |

2901: | arp_util.disable_debug |
2902: | arp_util.enable_debug |
2903: | fnd_api.g_exc_unexpected_error |
2904: | fnd_api.g_ret_sts_error |
2905: | fnd_api.g_ret_sts_error |
2906: | fnd_api.g_ret_sts_success |
2907: | fnd_api.to_boolean |
2908: | |
2909: | ARGUMENTS : IN: |

Line 2906: | fnd_api.g_ret_sts_success |

2902: | arp_util.enable_debug |
2903: | fnd_api.g_exc_unexpected_error |
2904: | fnd_api.g_ret_sts_error |
2905: | fnd_api.g_ret_sts_error |
2906: | fnd_api.g_ret_sts_success |
2907: | fnd_api.to_boolean |
2908: | |
2909: | ARGUMENTS : IN: |
2910: | OUT: |

Line 2907: | fnd_api.to_boolean |

2903: | fnd_api.g_exc_unexpected_error |
2904: | fnd_api.g_ret_sts_error |
2905: | fnd_api.g_ret_sts_error |
2906: | fnd_api.g_ret_sts_success |
2907: | fnd_api.to_boolean |
2908: | |
2909: | ARGUMENTS : IN: |
2910: | OUT: |
2911: | p_return_status |

Line 2942: p_return_status := FND_API.G_RET_STS_ERROR;

2938: /*------------------------------------------+
2939: | Initialize the return status to ERROR |
2940: +------------------------------------------*/
2941:
2942: p_return_status := FND_API.G_RET_STS_ERROR;
2943:
2944: /*------------------------------------------+
2945: | Validate based on option |
2946: +------------------------------------------*/

Line 2960: p_return_status := FND_API.G_RET_STS_SUCCESS;

2956: G_USSGL_TBL(l_index).ussgl_code)
2957: THEN
2958: p_adj_rec.ussgl_transaction_code_context :=
2959: G_USSGL_TBL(l_index).ussgl_context;
2960: p_return_status := FND_API.G_RET_STS_SUCCESS;
2961: EXIT ;
2962: END IF;
2963:
2964: END LOOP;

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

2962: END IF;
2963:
2964: END LOOP;
2965:
2966: IF ( p_return_status <> FND_API.G_RET_STS_SUCCESS )
2967: THEN
2968: /*-----------------------------------------------+
2969: | Set the message |
2970: +-----------------------------------------------*/

Line 2996: p_return_status := FND_API.G_RET_STS_SUCCESS;

2992: p_token1_value => p_adj_rec.ussgl_transaction_code
2993: ) ;
2994: RETURN;
2995: ELSE
2996: p_return_status := FND_API.G_RET_STS_SUCCESS;
2997: END IF ;
2998: END IF ;
2999:
3000: IF PG_DEBUG in ('Y', 'C') THEN

Line 3016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3012: /*-----------------------------------------------+
3013: | Set unexpected error message and status |
3014: +-----------------------------------------------*/
3015: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Validate_Ussgl_code' );
3016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3017:
3018: RETURN;
3019:
3020: END Validate_Ussgl_code;

Line 3035: | fnd_api.g_exc_unexpected_error |

3031: | |
3032: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3033: | arp_util.disable_debug |
3034: | arp_util.enable_debug |
3035: | fnd_api.g_exc_unexpected_error |
3036: | fnd_api.g_ret_sts_error |
3037: | fnd_api.g_ret_sts_error |
3038: | fnd_api.g_ret_sts_success |
3039: | fnd_api.to_boolean |

Line 3036: | fnd_api.g_ret_sts_error |

3032: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3033: | arp_util.disable_debug |
3034: | arp_util.enable_debug |
3035: | fnd_api.g_exc_unexpected_error |
3036: | fnd_api.g_ret_sts_error |
3037: | fnd_api.g_ret_sts_error |
3038: | fnd_api.g_ret_sts_success |
3039: | fnd_api.to_boolean |
3040: | |

Line 3037: | fnd_api.g_ret_sts_error |

3033: | arp_util.disable_debug |
3034: | arp_util.enable_debug |
3035: | fnd_api.g_exc_unexpected_error |
3036: | fnd_api.g_ret_sts_error |
3037: | fnd_api.g_ret_sts_error |
3038: | fnd_api.g_ret_sts_success |
3039: | fnd_api.to_boolean |
3040: | |
3041: | ARGUMENTS : IN: |

Line 3038: | fnd_api.g_ret_sts_success |

3034: | arp_util.enable_debug |
3035: | fnd_api.g_exc_unexpected_error |
3036: | fnd_api.g_ret_sts_error |
3037: | fnd_api.g_ret_sts_error |
3038: | fnd_api.g_ret_sts_success |
3039: | fnd_api.to_boolean |
3040: | |
3041: | ARGUMENTS : IN: |
3042: | p_adj_rec |

Line 3039: | fnd_api.to_boolean |

3035: | fnd_api.g_exc_unexpected_error |
3036: | fnd_api.g_ret_sts_error |
3037: | fnd_api.g_ret_sts_error |
3038: | fnd_api.g_ret_sts_success |
3039: | fnd_api.to_boolean |
3040: | |
3041: | ARGUMENTS : IN: |
3042: | p_adj_rec |
3043: | |

Line 3076: p_return_status := FND_API.G_RET_STS_SUCCESS;

3072: /*------------------------------------------+
3073: | Initialize the return status to SUCCESS |
3074: +------------------------------------------*/
3075:
3076: p_return_status := FND_API.G_RET_STS_SUCCESS;
3077:
3078: IF ( p_adj_rec.associated_cash_receipt_id IS NOT NULL AND
3079: p_adj_rec.associated_cash_receipt_id <> 0 )
3080: THEN

Line 3103: p_return_status := FND_API.G_RET_STS_ERROR;

3099: p_message_name => 'AR_AAPI_INVALID_RECEIPT_ID',
3100: p_token1_name =>'ASSOCIATED_CASH_RECEIPT_ID',
3101: p_token1_value =>to_char(p_adj_rec.associated_cash_receipt_id)
3102: ) ;
3103: p_return_status := FND_API.G_RET_STS_ERROR;
3104: RETURN;
3105: END IF;
3106:
3107: END IF ;

Line 3127: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3123: /*-----------------------------------------------+
3124: | Set unexpected error message and status |
3125: +-----------------------------------------------*/
3126: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Associated_Receipt');
3127: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3128: RETURN;
3129:
3130: END Validate_Associated_Receipt;
3131: END ar_adjvalidate_pub;