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 102: IF NOT FND_API.Compatible_API_Call( l_api_version,

98: +--------------------------------------------------*/
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_util.debug('create_request: ' || 'Checking call compatibility');
101: END IF;
102: IF NOT FND_API.Compatible_API_Call( l_api_version,
103: p_api_version,
104: l_api_name,
105: G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 116: IF FND_API.to_Boolean( p_init_msg_list ) THEN

112:
113: IF PG_DEBUG in ('Y', 'C') THEN
114: arp_util.debug('create_request: ' || 'Initializing message list');
115: END IF;
116: IF FND_API.to_Boolean( p_init_msg_list ) THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119:
120: /*-----------------------------------------+

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 135: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

131: +---------------------------------------------*/
132:
133: -- Begin SSA change
134: l_org_id := p_org_id;
135: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
136: ar_mo_cache_utils.set_org_context_in_api
137: (
138: p_org_id =>l_org_id,
139: p_return_status =>l_org_return_status

Line 144: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: );
141: -- End SSA change
142: -- ORASHID 26-FEB-2004
143:
144: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: ELSE
147:
148:

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

141: -- End SSA change
142: -- ORASHID 26-FEB-2004
143:
144: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: ELSE
147:
148:
149: /*------------------------------------------+

Line 190: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN

186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_util.debug ('create_request: ' || 'Done with validate_request_parameters');
188: END IF;
189:
190: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS THEN
191: IF PG_DEBUG in ('Y', 'C') THEN
192: arp_util.debug ('create_request: ' || 'Failed validation routine. Raising exception');
193: END IF;
194: raise validation_failed;

Line 247: IF FND_API.To_Boolean( p_commit ) THEN

243: /*--------------------------------+
244: | Standard check of p_commit |
245: +--------------------------------*/
246:
247: IF FND_API.To_Boolean( p_commit ) THEN
248: IF PG_DEBUG in ('Y', 'C') THEN
249: arp_util.debug('create_request: ' || 'committing');
250: END IF;
251: Commit;

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()-');
256: END IF;
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_util.debug ('create_request: ' || 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
262: arp_util.debug('create_request: ' || SQLERRM, G_MSG_ERROR);
263: END IF;

Line 261: arp_util.debug ('create_request: ' || 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');

257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_util.debug ('create_request: ' || 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
262: arp_util.debug('create_request: ' || SQLERRM, G_MSG_ERROR);
263: END IF;
264: ROLLBACK TO Create_request_PVT;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

261: arp_util.debug ('create_request: ' || 'Exception FND_API.G_EXC_UNEXPECTED_ERROR');
262: arp_util.debug('create_request: ' || SQLERRM, G_MSG_ERROR);
263: END IF;
264: ROLLBACK TO Create_request_PVT;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
266:
267: -- Display_Parameters;
268: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,

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

264: ROLLBACK TO Create_request_PVT;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
266:
267: -- Display_Parameters;
268: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: WHEN creation_failed THEN

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: arp_util.debug('create_request: ' || 'Exception creation_failed');
275: arp_util.debug('create_request: ' || SQLERRM, G_MSG_ERROR);
276: END IF;
277: -- ROLLBACK TO Create_request_cm;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: -- Display_Parameters;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,

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

277: -- ROLLBACK TO Create_request_cm;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: -- Display_Parameters;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data);
284:
285: WHEN validation_failed THEN

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

291: /* bug 2290738 - returns the validation status, rather than the 'unexpected' status */
292: x_return_status := l_val_return_status;
293:
294: -- Display_Parameters;
295: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data);
298:
299: WHEN OTHERS THEN

Line 313: x_return_status := FND_API.G_RET_STS_ERROR ;

309: ROLLBACK TO Create_request_pvt;
310:
311: --If only one error message on the stack, retrieve it
312:
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314:
315: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
316: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
317: FND_MSG_PUB.Add;

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

315: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
316: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
317: FND_MSG_PUB.Add;
318:
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
320: p_count => x_msg_count,
321: p_data => x_msg_data);
322:
323: END create_request;

Line 377: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

373: END IF;
374:
375: -- Begin SSA change
376: l_org_id := p_org_id;
377: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
378: ar_mo_cache_utils.set_org_context_in_api
379: (
380: p_org_id =>l_org_id,
381: p_return_status =>l_org_return_status

Line 400: l_val_return_status := FND_API.G_RET_STS_ERROR ;

396: FND_MESSAGE.SET_NAME('AR','AR_TAPI_TRANS_NOT_EXIST');
397: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
398:
399: FND_MSG_PUB.Add;
400: l_val_return_status := FND_API.G_RET_STS_ERROR ;
401: return;
402: END IF;
403:
404: /*-----------------------------------------+

Line 416: l_val_return_status := FND_API.G_RET_STS_ERROR ;

412: arp_util.debug ('validate_request_parameters: ' || 'Invalid line_credit_flag');
413: END IF;
414: FND_MESSAGE.SET_NAME('AR','AR_CMWF_API_INVALID_VALUE');
415: FND_MSG_PUB.Add;
416: l_val_return_status := FND_API.G_RET_STS_ERROR ;
417: return;
418: ELSE
419: /* If dispute is at line level, there has to be atleast one line */
420: IF p_line_credit_flag = 'Y' AND p_cm_line_tbl.count = 0 THEN

Line 424: l_val_return_status := FND_API.G_RET_STS_ERROR ;

420: IF p_line_credit_flag = 'Y' AND p_cm_line_tbl.count = 0 THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_util.debug ('validate_request_parameters: ' || 'line_credit_flag is Y and there are no lines');
423: END IF;
424: l_val_return_status := FND_API.G_RET_STS_ERROR ;
425: FND_MESSAGE.SET_NAME('AR','AR_CMWF_API_NO_LINES_INFO ');
426: FND_MSG_PUB.Add;
427: return;
428: END IF;

Line 447: l_val_return_status := FND_API.G_RET_STS_ERROR ;

443: IF PG_DEBUG in ('Y', 'C') THEN
444: arp_util.debug('validate_request_parameters: ' || 'CM trx type id = ' || to_char(l_credit_memo_type_id));
445: END IF;
446: IF l_credit_memo_type_id IS NULL THEN
447: l_val_return_status := FND_API.G_RET_STS_ERROR ;
448: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
449: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : no CM trx type id defined.');
450: FND_MSG_PUB.Add;
451: return;

Line 511: l_val_return_status := FND_API.G_RET_STS_ERROR ;

507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_util.debug('validate_request_parameters: ' || 'Over application flag is N and amount remaining is more than amount requested');
509: END IF;
510:
511: l_val_return_status := FND_API.G_RET_STS_ERROR ;
512: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
513: FND_MSG_PUB.Add;
514: return;
515: END IF;

Line 549: l_val_return_status := FND_API.G_RET_STS_ERROR ;

545: WHERE lookup_type ='CREDIT_MEMO_REASON'
546: AND lookup_code = p_cm_reason_code ;
547:
548: IF l_count_reason_code = 0 THEN
549: l_val_return_status := FND_API.G_RET_STS_ERROR ;
550: FND_MESSAGE.SET_NAME('AR','AR_RAXTRX-1719');
551: FND_MSG_PUB.Add;
552: return;
553: END IF;

Line 579: l_val_return_status := FND_API.G_RET_STS_ERROR ;

575: END IF;
576: FND_MESSAGE.SET_NAME('AR','AR_TAPI_LINE_NOT_EXIST');
577: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
578: FND_MSG_PUB.Add;
579: l_val_return_status := FND_API.G_RET_STS_ERROR ;
580: return;
581: END IF;
582:
583: /*-------------------------------------------------------------------------+

Line 623: l_val_return_status := FND_API.G_RET_STS_ERROR ;

619: arp_util.debug('validate_request_parameters: ' || 'Over application is not allowed. raising exception');
620: END IF;
621: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
622: FND_MSG_PUB.Add;
623: l_val_return_status := FND_API.G_RET_STS_ERROR ;
624: return;
625: END IF;
626: END IF;
627: */

Line 651: l_val_return_status := FND_API.G_RET_STS_ERROR ;

647: END IF;
648: -- Put error message on stack
649: FND_MESSAGE.SET_NAME ('AR','AR_DISPUTE_BEFORE_TRX_DATE');
650: FND_MSG_PUB.Add;
651: l_val_return_status := FND_API.G_RET_STS_ERROR ;
652: return;
653: END IF;
654:
655: END IF;

Line 657: l_val_return_status := FND_API.G_RET_STS_SUCCESS;

653: END IF;
654:
655: END IF;
656: -- END Bug 6358930
657: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
658: IF PG_DEBUG in ('Y', 'C') THEN
659: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters()-');
660: END IF;
661:

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

668:
669: PROCEDURE get_request_status (
670: -- standard API parameters
671: p_api_version IN NUMBER,
672: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
673: x_msg_count OUT NOCOPY NUMBER,
674: x_msg_data OUT NOCOPY VARCHAR2,
675: x_return_status OUT NOCOPY VARCHAR2,
676: -- CREDIT MEMO REQUEST PARAMETERS

Line 777: IF NOT FND_API.Compatible_API_Call( l_api_version,

773: +--------------------------------------------------*/
774: IF PG_DEBUG in ('Y', 'C') THEN
775: arp_util.debug ('get_request_status: ' || 'Standard call to check for call compatibility');
776: END IF;
777: IF NOT FND_API.Compatible_API_Call( l_api_version,
778: p_api_version,
779: l_api_name,
780: G_PKG_NAME)
781: THEN

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: p_api_version,
779: l_api_name,
780: G_PKG_NAME)
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: /*--------------------------------------------------------------+
786: | Initialize message list if p_init_msg_list is set to TRUE |

Line 791: IF FND_API.to_Boolean( p_init_msg_list ) THEN

787: +--------------------------------------------------------------*/
788: IF PG_DEBUG in ('Y', 'C') THEN
789: arp_util.debug ('get_request_status: ' || 'Initializing message list');
790: END IF;
791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
792: FND_MSG_PUB.initialize;
793: END IF;
794:
795: /*-----------------------------------------+

Line 799: x_return_status := FND_API.G_RET_STS_SUCCESS;

795: /*-----------------------------------------+
796: | Initialize return status to SUCCESS |
797: +-----------------------------------------*/
798:
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:
801: /*---------------------------------------------+
802: | ========== Start of API Body ========== |
803: +---------------------------------------------*/

Line 843: x_return_status := FND_API.G_RET_STS_ERROR;

839: /* bug 2290738 : check if x_cm_customer_trx_id is null that means the CM was not created
840: raise an error */
841:
842: if x_cm_customer_trx_id is null then
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: FND_MESSAGE.SET_NAME( 'AR','GENERIC_MESSAGE');
845: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Could not find credit memo, unknown failure.');
846: FND_MSG_PUB.ADD;
847: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

843: x_return_status := FND_API.G_RET_STS_ERROR;
844: FND_MESSAGE.SET_NAME( 'AR','GENERIC_MESSAGE');
845: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error : Could not find credit memo, unknown failure.');
846: FND_MSG_PUB.ADD;
847: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data);
850: return;
851: end if;

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

851: end if;
852:
853: EXCEPTION
854: WHEN no_data_found THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: FND_MESSAGE.SET_NAME( 'AR','AR_CMWF_API_INVALID_REQUEST_ID');
857: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
858: FND_MSG_PUB.ADD;
859:

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

858: FND_MSG_PUB.ADD;
859:
860: -- Display_Parameters;
861:
862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
863: p_count => x_msg_count,
864: p_data => x_msg_data);
865: END;
866:

Line 969: x_return_status := FND_API.G_RET_STS_SUCCESS;

965: EXIT WHEN notes_cur%notfound;
966: END LOOP;
967: CLOSE notes_cur;
968:
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970: IF PG_DEBUG in ('Y', 'C') THEN
971: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
972: END IF;
973:

Line 975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

971: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
972: END IF;
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: IF PG_DEBUG in ('Y', 'C') THEN
977: arp_util.debug('get_request_status : unexpected error');
978: arp_util.debug('get_request_status: ' || SQLERRM, G_MSG_ERROR);
979: END IF;

Line 980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

976: IF PG_DEBUG in ('Y', 'C') THEN
977: arp_util.debug('get_request_status : unexpected error');
978: arp_util.debug('get_request_status: ' || SQLERRM, G_MSG_ERROR);
979: END IF;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
981:
982: -- Display_Parameters;
983: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,

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

979: END IF;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
981:
982: -- Display_Parameters;
983: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data);
986:
987: WHEN OTHERS THEN

Line 996: x_return_status := FND_API.G_RET_STS_ERROR ;

992: +-------------------------------------------------------*/
993: IF PG_DEBUG in ('Y', 'C') THEN
994: arp_util.debug ('get_request_status: ' || 'Exception OTHERS');
995: END IF;
996: x_return_status := FND_API.G_RET_STS_ERROR ;
997: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
998: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
999:
1000: -- Display_Parameters;

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

997: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
998: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
999:
1000: -- Display_Parameters;
1001: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1002: p_count => x_msg_count,
1003: p_data => x_msg_data);
1004:
1005: END get_request_status;

Line 1077: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then

1073: l_val_return_status => l_val_return_status,
1074: p_dispute_date => p_dispute_date);
1075:
1076: /*4556000*/
1077: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1078: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1079: IF PG_DEBUG in ('Y', 'C') THEN
1080: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1081: END IF;

Line 1078: l_val_return_status:=FND_API.G_RET_STS_ERROR;

1074: p_dispute_date => p_dispute_date);
1075:
1076: /*4556000*/
1077: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1078: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1079: IF PG_DEBUG in ('Y', 'C') THEN
1080: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1081: END IF;
1082: return;

Line 1115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1111: Validate_Line_Int_Flex(
1112: p_desc_flex_rec => interface_line_rec,
1113: p_desc_flex_name => 'RA_INTERFACE_LINES',
1114: p_return_status => x_return_status );
1115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1116: THEN
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug ('validate_request_parameters:'||'Err. Line Transaction FF Validation');
1119: END IF;

Line 1123: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1119: END IF;
1120: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1121: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
1122: FND_MSG_PUB.Add;
1123: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1124: return;
1125: END IF;
1126: p_cm_line_tbl(i).interface_line_context:=interface_line_rec.interface_line_context;
1127: p_cm_line_tbl(i).interface_line_attribute1:=interface_line_rec.interface_line_attribute1;

Line 1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1162: p_desc_flex_rec => p_desc_flex_rec,
1163: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1164: p_return_status => x_return_status );
1165:
1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1167: THEN
1168: IF PG_DEBUG in ('Y', 'C') THEN
1169: arp_util.debug ('validate_request_parameters:'||'Err. Line Information FF Validation');
1170: END IF;

Line 1174: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1170: END IF;
1171: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1172: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_LINE_ID',p_cm_line_tbl(i).customer_trx_line_id);
1173: FND_MSG_PUB.Add;
1174: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1175: return;
1176: END IF;
1177: p_cm_line_tbl(i).attribute_category:=p_desc_flex_rec.attribute_category;
1178: p_cm_line_tbl(i).attribute1:=p_desc_flex_rec.attribute1;

Line 1225: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1221: p_desc_flex_rec => p_interface_attribute_rec,
1222: p_desc_flex_name => 'RA_INTERFACE_HEADER',
1223: p_return_status => x_return_status );
1224:
1225: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1226: THEN
1227: IF PG_DEBUG in ('Y', 'C') THEN
1228: arp_util.debug ('validate_request_parameters:'||'Err. Invoice Transaction FF Validation');
1229: END IF;

Line 1233: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1229: END IF;
1230: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_DESC_FLEX');
1231: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
1232: FND_MSG_PUB.Add;
1233: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1234: return;
1235: END IF;
1236: END IF;
1237: END IF;

Line 1252: l_val_return_status := FND_API.G_RET_STS_ERROR ;

1248: WHEN NO_DATA_FOUND THEN
1249: FND_MESSAGE.SET_NAME('AR','AR_INAPI_INVALID_BATCH_SOURCE');
1250: FND_MESSAGE.SET_TOKEN('CUSTOMER_TRX_ID',p_customer_trx_id);
1251: FND_MSG_PUB.Add;
1252: l_val_return_status := FND_API.G_RET_STS_ERROR ;
1253: return;
1254: END;
1255: END;
1256:

Line 1298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

Line 1306: l_val_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1327: l_val_return_status := FND_API.G_RET_STS_SUCCESS;

1323: p_attribute_rec.attribute13:=p_desc_flex_rec.attribute13;
1324: p_attribute_rec.attribute14:=p_desc_flex_rec.attribute14;
1325: p_attribute_rec.attribute15:=p_desc_flex_rec.attribute15;
1326:
1327: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
1328: IF PG_DEBUG in ('Y', 'C') THEN
1329: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters(OVERLOADED)-');
1330: END IF;
1331:

Line 1359: p_return_status := FND_API.G_RET_STS_SUCCESS;

1355: BEGIN
1356: IF PG_DEBUG = 'Y' THEN
1357: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_Int_Desc_Flex ()+');
1358: END IF;
1359: p_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
1361: OPEN desc_flex_exists;
1362: FETCH desc_flex_exists INTO l_flex_exists;
1363: IF desc_flex_exists%NOTFOUND THEN

Line 1365: p_return_status := FND_API.G_RET_STS_ERROR;

1361: OPEN desc_flex_exists;
1362: FETCH desc_flex_exists INTO l_flex_exists;
1363: IF desc_flex_exists%NOTFOUND THEN
1364: CLOSE desc_flex_exists;
1365: p_return_status := FND_API.G_RET_STS_ERROR;
1366: return;
1367: END IF;
1368: CLOSE desc_flex_exists;
1369:

Line 1408: p_return_status := FND_API.G_RET_STS_ERROR;

1404:
1405:
1406: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1407: THEN
1408: p_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;
1410:
1411: l_count := fnd_flex_descval.segment_count;
1412:

Line 1479: p_return_status := FND_API.G_RET_STS_SUCCESS;

1475: BEGIN
1476: IF PG_DEBUG = 'Y' THEN
1477: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_LINE_Int_Flex ()+');
1478: END IF;
1479: p_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481: OPEN desc_flex_exists;
1482: FETCH desc_flex_exists INTO l_flex_exists;
1483: IF desc_flex_exists%NOTFOUND THEN

Line 1485: p_return_status := FND_API.G_RET_STS_ERROR;

1481: OPEN desc_flex_exists;
1482: FETCH desc_flex_exists INTO l_flex_exists;
1483: IF desc_flex_exists%NOTFOUND THEN
1484: CLOSE desc_flex_exists;
1485: p_return_status := FND_API.G_RET_STS_ERROR;
1486: return;
1487: END IF;
1488: CLOSE desc_flex_exists;
1489:

Line 1528: p_return_status := FND_API.G_RET_STS_ERROR;

1524:
1525:
1526: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
1527: THEN
1528: p_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:
1531: l_count := fnd_flex_descval.segment_count;
1532: