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

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

13: /*Bg 7367350 Added new parameter for internal comment handling*/
14: PROCEDURE create_request (
15: -- standard API parameters
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

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

14: PROCEDURE create_request (
15: -- standard API parameters
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,

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

15: -- standard API parameters
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: -- credit memo request parameters

Line 106: IF NOT FND_API.Compatible_API_Call( l_api_version,

102: +--------------------------------------------------*/
103: IF PG_DEBUG in ('Y', 'C') THEN
104: arp_util.debug( 'Checking call compatibility');
105: END IF;
106: IF NOT FND_API.Compatible_API_Call( l_api_version,
107: p_api_version,
108: l_api_name,
109: G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: IF NOT FND_API.Compatible_API_Call( l_api_version,
107: p_api_version,
108: l_api_name,
109: G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: /*--------------------------------------------------------------+
114: | Initialize message list if p_init_msg_list is set to TRUE |

Line 120: IF FND_API.to_Boolean( p_init_msg_list ) THEN

116:
117: IF PG_DEBUG in ('Y', 'C') THEN
118: arp_util.debug( 'Initializing message list');
119: END IF;
120: IF FND_API.to_Boolean( p_init_msg_list ) THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:
124: /*-----------------------------------------+

Line 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug ( 'Initializing return status to success');
130: END IF;
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: /*---------------------------------------------+
134: | ========== Start of API Body ========== |
135: +---------------------------------------------*/

Line 139: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

135: +---------------------------------------------*/
136:
137: -- Begin SSA change
138: l_org_id := p_org_id;
139: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
140: ar_mo_cache_utils.set_org_context_in_api
141: (
142: p_org_id =>l_org_id,
143: p_return_status =>l_org_return_status

Line 148: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

144: );
145: -- End SSA change
146: -- ORASHID 26-FEB-2004
147:
148: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: ELSE
151:
152:

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: -- End SSA change
146: -- ORASHID 26-FEB-2004
147:
148: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: ELSE
151:
152:
153: /*------------------------------------------+

Line 202: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN

198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_util.debug ( 'Done with validate_request_parameters');
200: END IF;
201:
202: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
203: IF PG_DEBUG in ('Y', 'C') THEN
204: arp_util.debug ( 'Failed validation routine. Raising exception');
205: END IF;
206: raise validation_failed;

Line 261: IF FND_API.To_Boolean( p_commit ) THEN

257: /*--------------------------------+
258: | Standard check of p_commit |
259: +--------------------------------*/
260:
261: IF FND_API.To_Boolean( p_commit ) THEN
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug( 'committing');
264: END IF;
265: Commit;

Line 286: x_return_status :=FND_API.G_RET_STS_ERROR;

282: arp_util.debug('Creating the Credit memo in Complete Status ');
283: arp_util.debug('Issue at the time of signature generation for localization');
284: arp_util.debug('Message : '||p_return_message);
285: x_msg_data := p_return_message;
286: x_return_status :=FND_API.G_RET_STS_ERROR;
287:
288: END IF;
289: EXCEPTION
290: WHEN OTHERS THEN

Line 302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

298: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()-');
299: END IF;
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug ( 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
305: arp_util.debug( SQLERRM, G_MSG_ERROR);
306: END IF;

Line 304: arp_util.debug ( 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');

300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug ( 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
305: arp_util.debug( SQLERRM, G_MSG_ERROR);
306: END IF;
307: ROLLBACK TO Create_request_PVT;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

304: arp_util.debug ( 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
305: arp_util.debug( SQLERRM, G_MSG_ERROR);
306: END IF;
307: ROLLBACK TO Create_request_PVT;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
309:
310: -- Display_Parameters;
311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count,

Line 311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

307: ROLLBACK TO Create_request_PVT;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
309:
310: -- Display_Parameters;
311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: WHEN creation_failed THEN

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: arp_util.debug( 'Exception creation_failed');
318: arp_util.debug( SQLERRM, G_MSG_ERROR);
319: END IF;
320: -- ROLLBACK TO Create_request_cm;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322:
323: -- Display_Parameters;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count,

Line 324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

320: -- ROLLBACK TO Create_request_cm;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322:
323: -- Display_Parameters;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count,
326: p_data => x_msg_data);
327:
328: WHEN validation_failed THEN

Line 338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

334: /* bug 2290738 - returns the validation status, rather than the 'unexpected' status */
335: x_return_status := l_val_return_status;
336:
337: -- Display_Parameters;
338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341:
342: WHEN OTHERS THEN

Line 356: x_return_status := FND_API.G_RET_STS_ERROR ;

352: ROLLBACK TO Create_request_pvt;
353:
354: --If only one error message on the stack, retrieve it
355:
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
360: FND_MSG_PUB.Add;

Line 362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

358: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
360: FND_MSG_PUB.Add;
361:
362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: END create_request;

Line 420: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

416: END IF;
417:
418: -- Begin SSA change
419: l_org_id := p_org_id;
420: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
421: ar_mo_cache_utils.set_org_context_in_api
422: (
423: p_org_id =>l_org_id,
424: p_return_status =>l_org_return_status

Line 443: l_val_return_status := FND_API.G_RET_STS_ERROR ;

439: FND_MESSAGE.SET_NAME('AR','AR_TAPI_TRANS_NOT_EXIST');
440: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
441:
442: FND_MSG_PUB.Add;
443: l_val_return_status := FND_API.G_RET_STS_ERROR ;
444: return;
445: END IF;
446:
447: /*-----------------------------------------+

Line 459: l_val_return_status := FND_API.G_RET_STS_ERROR ;

455: arp_util.debug ( 'Invalid line_credit_flag');
456: END IF;
457: FND_MESSAGE.SET_NAME('AR','AR_CMWF_API_INVALID_VALUE');
458: FND_MSG_PUB.Add;
459: l_val_return_status := FND_API.G_RET_STS_ERROR ;
460: return;
461: ELSE
462: /* If dispute is at line level, there has to be atleast one line */
463: IF p_line_credit_flag = 'Y' AND p_cm_line_tbl.count = 0 THEN

Line 467: l_val_return_status := FND_API.G_RET_STS_ERROR ;

463: IF p_line_credit_flag = 'Y' AND p_cm_line_tbl.count = 0 THEN
464: IF PG_DEBUG in ('Y', 'C') THEN
465: arp_util.debug ( 'line_credit_flag is Y and there are no lines');
466: END IF;
467: l_val_return_status := FND_API.G_RET_STS_ERROR ;
468: FND_MESSAGE.SET_NAME('AR','AR_CMWF_API_NO_LINES_INFO ');
469: FND_MSG_PUB.Add;
470: return;
471: END IF;

Line 490: l_val_return_status := FND_API.G_RET_STS_ERROR ;

486: IF PG_DEBUG in ('Y', 'C') THEN
487: arp_util.debug( 'CM trx type id = ' || to_char(l_credit_memo_type_id));
488: END IF;
489: IF l_credit_memo_type_id IS NULL THEN
490: l_val_return_status := FND_API.G_RET_STS_ERROR ;
491: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
492: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : no CM trx type id defined.');
493: FND_MSG_PUB.Add;
494: return;

Line 554: l_val_return_status := FND_API.G_RET_STS_ERROR ;

550: IF PG_DEBUG in ('Y', 'C') THEN
551: arp_util.debug( 'Over application flag is N and amount remaining is more than amount requested');
552: END IF;
553:
554: l_val_return_status := FND_API.G_RET_STS_ERROR ;
555: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
556: FND_MSG_PUB.Add;
557: return;
558: END IF;

Line 592: l_val_return_status := FND_API.G_RET_STS_ERROR ;

588: WHERE lookup_type ='CREDIT_MEMO_REASON'
589: AND lookup_code = p_cm_reason_code ;
590:
591: IF l_count_reason_code = 0 THEN
592: l_val_return_status := FND_API.G_RET_STS_ERROR ;
593: FND_MESSAGE.SET_NAME('AR','AR_RAXTRX-1719');
594: FND_MSG_PUB.Add;
595: return;
596: END IF;

Line 622: l_val_return_status := FND_API.G_RET_STS_ERROR ;

618: END IF;
619: FND_MESSAGE.SET_NAME('AR','AR_TAPI_LINE_NOT_EXIST');
620: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
621: FND_MSG_PUB.Add;
622: l_val_return_status := FND_API.G_RET_STS_ERROR ;
623: return;
624: END IF;
625:
626: /*-------------------------------------------------------------------------+

Line 666: l_val_return_status := FND_API.G_RET_STS_ERROR ;

662: arp_util.debug('validate_request_parameters: ' || 'Over application is not allowed. raising exception');
663: END IF;
664: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
665: FND_MSG_PUB.Add;
666: l_val_return_status := FND_API.G_RET_STS_ERROR ;
667: return;
668: END IF;
669: END IF;
670: */

Line 694: l_val_return_status := FND_API.G_RET_STS_ERROR ;

690: END IF;
691: -- Put error message on stack
692: FND_MESSAGE.SET_NAME ('AR','AR_DISPUTE_BEFORE_TRX_DATE');
693: FND_MSG_PUB.Add;
694: l_val_return_status := FND_API.G_RET_STS_ERROR ;
695: return;
696: END IF;
697:
698: END IF;

Line 700: l_val_return_status := FND_API.G_RET_STS_SUCCESS;

696: END IF;
697:
698: END IF;
699: -- END Bug 6358930
700: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
701: IF PG_DEBUG in ('Y', 'C') THEN
702: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters()-');
703: END IF;
704:

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

711:
712: PROCEDURE get_request_status (
713: -- standard API parameters
714: p_api_version IN NUMBER,
715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716: x_msg_count OUT NOCOPY NUMBER,
717: x_msg_data OUT NOCOPY VARCHAR2,
718: x_return_status OUT NOCOPY VARCHAR2,
719: -- CREDIT MEMO REQUEST PARAMETERS

Line 820: IF NOT FND_API.Compatible_API_Call( l_api_version,

816: +--------------------------------------------------*/
817: IF PG_DEBUG in ('Y', 'C') THEN
818: arp_util.debug ('get_request_status: ' || 'Standard call to check for call compatibility');
819: END IF;
820: IF NOT FND_API.Compatible_API_Call( l_api_version,
821: p_api_version,
822: l_api_name,
823: G_PKG_NAME)
824: THEN

Line 825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

821: p_api_version,
822: l_api_name,
823: G_PKG_NAME)
824: THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827:
828: /*--------------------------------------------------------------+
829: | Initialize message list if p_init_msg_list is set to TRUE |

Line 834: IF FND_API.to_Boolean( p_init_msg_list ) THEN

830: +--------------------------------------------------------------*/
831: IF PG_DEBUG in ('Y', 'C') THEN
832: arp_util.debug ('get_request_status: ' || 'Initializing message list');
833: END IF;
834: IF FND_API.to_Boolean( p_init_msg_list ) THEN
835: FND_MSG_PUB.initialize;
836: END IF;
837:
838: /*-----------------------------------------+

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: /*-----------------------------------------+
839: | Initialize return status to SUCCESS |
840: +-----------------------------------------*/
841:
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: /*---------------------------------------------+
845: | ========== Start of API Body ========== |
846: +---------------------------------------------*/

Line 886: x_return_status := FND_API.G_RET_STS_ERROR;

882: /* bug 2290738 : check if x_cm_customer_trx_id is null that means the CM was not created
883: raise an error */
884:
885: if x_cm_customer_trx_id is null then
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: FND_MESSAGE.SET_NAME( 'AR','GENERIC_MESSAGE');
888: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Could not find credit memo, unknown failure.');
889: FND_MSG_PUB.ADD;
890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

886: x_return_status := FND_API.G_RET_STS_ERROR;
887: FND_MESSAGE.SET_NAME( 'AR','GENERIC_MESSAGE');
888: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Could not find credit memo, unknown failure.');
889: FND_MSG_PUB.ADD;
890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
891: p_count => x_msg_count,
892: p_data => x_msg_data);
893: return;
894: end if;

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

894: end if;
895:
896: EXCEPTION
897: WHEN no_data_found THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899: FND_MESSAGE.SET_NAME( 'AR','AR_CMWF_API_INVALID_REQUEST_ID');
900: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
901: FND_MSG_PUB.ADD;
902:

Line 905: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

901: FND_MSG_PUB.ADD;
902:
903: -- Display_Parameters;
904:
905: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
906: p_count => x_msg_count,
907: p_data => x_msg_data);
908: END;
909:

Line 1012: x_return_status := FND_API.G_RET_STS_SUCCESS;

1008: EXIT WHEN notes_cur%notfound;
1009: END LOOP;
1010: CLOSE notes_cur;
1011:
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
1015: END IF;
1016:

Line 1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1014: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
1015: END IF;
1016:
1017: EXCEPTION
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: IF PG_DEBUG in ('Y', 'C') THEN
1020: arp_util.debug('get_request_status : unexpected error');
1021: arp_util.debug('get_request_status: ' || SQLERRM, G_MSG_ERROR);
1022: END IF;

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: IF PG_DEBUG in ('Y', 'C') THEN
1020: arp_util.debug('get_request_status : unexpected error');
1021: arp_util.debug('get_request_status: ' || SQLERRM, G_MSG_ERROR);
1022: END IF;
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: -- Display_Parameters;
1026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,

Line 1026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1022: END IF;
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: -- Display_Parameters;
1026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data);
1029:
1030: WHEN OTHERS THEN

Line 1039: x_return_status := FND_API.G_RET_STS_ERROR ;

1035: +-------------------------------------------------------*/
1036: IF PG_DEBUG in ('Y', 'C') THEN
1037: arp_util.debug ('get_request_status: ' || 'Exception OTHERS');
1038: END IF;
1039: x_return_status := FND_API.G_RET_STS_ERROR ;
1040: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1041: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
1042:
1043: -- Display_Parameters;

Line 1044: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1040: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1041: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
1042:
1043: -- Display_Parameters;
1044: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1045: p_count => x_msg_count,
1046: p_data => x_msg_data);
1047:
1048: END get_request_status;

Line 1119: l_val_return_status:=FND_API.G_RET_STS_ERROR;

1115: b.auto_trx_numbering_flag = 'Y'));
1116:
1117: fnd_message.set_name('AR', 'AR_INAPI_TRX_NUM_NOT_REQUIRED');
1118: FND_MSG_PUB.Add;
1119: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1120: return;
1121: EXCEPTION
1122: WHEN NO_DATA_FOUND THEN
1123: NULL;

Line 1128: l_val_return_status:=FND_API.G_RET_STS_ERROR;

1124: WHEN OTHERS THEN
1125: IF PG_DEBUG in ('Y', 'C') THEN
1126: arp_util.debug ('Error at time of validating for trx number' || sqlerrm);
1127: END IF;
1128: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1129: return;
1130: END;
1131: END IF;
1132: arp_util.debug ('Before old validate_request_parameters');

Line 1151: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then

1147: l_val_return_status => l_val_return_status,
1148: p_dispute_date => p_dispute_date);
1149:
1150: /*4556000*/
1151: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1152: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1153: IF PG_DEBUG in ('Y', 'C') THEN
1154: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1155: END IF;

Line 1152: l_val_return_status:=FND_API.G_RET_STS_ERROR;

1148: p_dispute_date => p_dispute_date);
1149:
1150: /*4556000*/
1151: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1152: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1153: IF PG_DEBUG in ('Y', 'C') THEN
1154: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1155: END IF;
1156: return;

Line 1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1185: Validate_Line_Int_Flex(
1186: p_desc_flex_rec => interface_line_rec,
1187: p_desc_flex_name => 'RA_INTERFACE_LINES',
1188: p_return_status => x_return_status );
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1190: THEN
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_util.debug ( 'Err. Line Transaction FF Validation');
1193: END IF;

Line 1197: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1193: END IF;
1194: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1195: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
1196: FND_MSG_PUB.Add;
1197: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1198: return;
1199: END IF;
1200: p_cm_line_tbl(i).interface_line_context:=interface_line_rec.interface_line_context;
1201: p_cm_line_tbl(i).interface_line_attribute1:=interface_line_rec.interface_line_attribute1;

Line 1240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1236: p_desc_flex_rec => p_desc_flex_rec,
1237: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1238: p_return_status => x_return_status );
1239:
1240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1241: THEN
1242: IF PG_DEBUG in ('Y', 'C') THEN
1243: arp_util.debug ( 'Err. Line Information FF Validation');
1244: END IF;

Line 1248: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1244: END IF;
1245: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1246: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
1247: FND_MSG_PUB.Add;
1248: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1249: return;
1250: END IF;
1251: p_cm_line_tbl(i).attribute_category:=p_desc_flex_rec.attribute_category;
1252: p_cm_line_tbl(i).attribute1:=p_desc_flex_rec.attribute1;

Line 1299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1295: p_desc_flex_rec => p_interface_attribute_rec,
1296: p_desc_flex_name => 'RA_INTERFACE_HEADER',
1297: p_return_status => x_return_status );
1298:
1299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1300: THEN
1301: IF PG_DEBUG in ('Y', 'C') THEN
1302: arp_util.debug ( 'Err. Invoice Transaction FF Validation');
1303: END IF;

Line 1307: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1303: END IF;
1304: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1305: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
1306: FND_MSG_PUB.Add;
1307: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1308: return;
1309: END IF;
1310: END IF;
1311: END IF;

Line 1326: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1322: WHEN NO_DATA_FOUND THEN
1323: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_BATCH_SOURCE');
1324: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
1325: FND_MSG_PUB.Add;
1326: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1327: return;
1328: END;
1329: END;
1330:

Line 1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1368: p_desc_flex_rec => p_desc_flex_rec,
1369: p_desc_flex_name => 'RA_CUSTOMER_TRX',
1370: p_return_status => x_return_status );
1371:
1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1373: THEN
1374: IF PG_DEBUG in ('Y', 'C') THEN
1375: arp_util.debug ( 'Err. Transaction Information FF Validation');
1376: END IF;

Line 1380: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1376: END IF;
1377: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1378: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
1379: FND_MSG_PUB.Add;
1380: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1381: return;
1382: END IF;
1383: END IF;
1384: p_attribute_rec.attribute_category:=p_desc_flex_rec.attribute_category;

Line 1401: l_val_return_status := FND_API.G_RET_STS_SUCCESS;

1397: p_attribute_rec.attribute13:=p_desc_flex_rec.attribute13;
1398: p_attribute_rec.attribute14:=p_desc_flex_rec.attribute14;
1399: p_attribute_rec.attribute15:=p_desc_flex_rec.attribute15;
1400:
1401: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters(OVERLOADED)-');
1404: END IF;
1405:

Line 1433: p_return_status := FND_API.G_RET_STS_SUCCESS;

1429: BEGIN
1430: IF PG_DEBUG = 'Y' THEN
1431: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_Int_Desc_Flex ()+');
1432: END IF;
1433: p_return_status := FND_API.G_RET_STS_SUCCESS;
1434:
1435: OPEN desc_flex_exists;
1436: FETCH desc_flex_exists INTO l_flex_exists;
1437: IF desc_flex_exists%NOTFOUND THEN

Line 1439: p_return_status := FND_API.G_RET_STS_ERROR;

1435: OPEN desc_flex_exists;
1436: FETCH desc_flex_exists INTO l_flex_exists;
1437: IF desc_flex_exists%NOTFOUND THEN
1438: CLOSE desc_flex_exists;
1439: p_return_status := FND_API.G_RET_STS_ERROR;
1440: return;
1441: END IF;
1442: CLOSE desc_flex_exists;
1443:

Line 1482: p_return_status := FND_API.G_RET_STS_ERROR;

1478:
1479:
1480: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1481: THEN
1482: p_return_status := FND_API.G_RET_STS_ERROR;
1483: END IF;
1484:
1485: l_count := fnd_flex_descval.segment_count;
1486:

Line 1553: p_return_status := FND_API.G_RET_STS_SUCCESS;

1549: BEGIN
1550: IF PG_DEBUG = 'Y' THEN
1551: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_LINE_Int_Flex ()+');
1552: END IF;
1553: p_return_status := FND_API.G_RET_STS_SUCCESS;
1554:
1555: OPEN desc_flex_exists;
1556: FETCH desc_flex_exists INTO l_flex_exists;
1557: IF desc_flex_exists%NOTFOUND THEN

Line 1559: p_return_status := FND_API.G_RET_STS_ERROR;

1555: OPEN desc_flex_exists;
1556: FETCH desc_flex_exists INTO l_flex_exists;
1557: IF desc_flex_exists%NOTFOUND THEN
1558: CLOSE desc_flex_exists;
1559: p_return_status := FND_API.G_RET_STS_ERROR;
1560: return;
1561: END IF;
1562: CLOSE desc_flex_exists;
1563:

Line 1602: p_return_status := FND_API.G_RET_STS_ERROR;

1598:
1599:
1600: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1601: THEN
1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604:
1605: l_count := fnd_flex_descval.segment_count;
1606: