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

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: EXCEPTION
84: WHEN OTHERS THEN
85: arp_util.debug('Unexpected error '||sqlerrm||
86: ' at AR_RAAPI_UTIL.constant_system_values()+');
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88:
89: END Constant_System_Values;
90:
91: PROCEDURE Initialize_Globals

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_util.debug('Constant_Trx_Values: ' || 'Unexpected error '||sqlerrm||
169: ' at AR_RAAPI_UTIL.constant_system_values()+');
170: END IF;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172:
173: END Constant_Trx_Values;
174:
175: PROCEDURE Validate_Parameters

Line 189: IF FND_API.to_Boolean( p_init_msg_list )

185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('AR_RAAPI_UTIL.Validate_Parameters()+');
187: END IF;
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list )
190: THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: IF FND_API.to_Boolean( p_init_msg_list )
190: THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: Validate_Transaction (p_init_msg_list => FND_API.G_FALSE
195: ,p_rev_adj_rec => p_rev_adj_rec
196: ,p_validation_level => p_validation_level
197: ,x_return_status => x_return_status

Line 194: Validate_Transaction (p_init_msg_list => FND_API.G_FALSE

190: THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: Validate_Transaction (p_init_msg_list => FND_API.G_FALSE
195: ,p_rev_adj_rec => p_rev_adj_rec
196: ,p_validation_level => p_validation_level
197: ,x_return_status => x_return_status
198: ,x_msg_count => x_msg_count

Line 200: IF x_return_status = FND_API.G_RET_STS_SUCCESS

196: ,p_validation_level => p_validation_level
197: ,x_return_status => x_return_status
198: ,x_msg_count => x_msg_count
199: ,x_msg_data => x_msg_data);
200: IF x_return_status = FND_API.G_RET_STS_SUCCESS
201: THEN
202: IF NVL(AR_RAAPI_UTIL.g_last_customer_trx_id,
203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id
204: THEN

Line 207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id
204: THEN
205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);
206: END IF;
207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
208: THEN
209: Validate_Salesreps (p_init_msg_list => FND_API.G_FALSE
210: ,p_rev_adj_rec => p_rev_adj_rec
211: ,x_return_status => x_return_status

Line 209: Validate_Salesreps (p_init_msg_list => FND_API.G_FALSE

205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);
206: END IF;
207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
208: THEN
209: Validate_Salesreps (p_init_msg_list => FND_API.G_FALSE
210: ,p_rev_adj_rec => p_rev_adj_rec
211: ,x_return_status => x_return_status
212: ,x_msg_count => x_msg_count
213: ,x_msg_data => x_msg_data);

Line 214: Validate_Category (p_init_msg_list => FND_API.G_FALSE

210: ,p_rev_adj_rec => p_rev_adj_rec
211: ,x_return_status => x_return_status
212: ,x_msg_count => x_msg_count
213: ,x_msg_data => x_msg_data);
214: Validate_Category (p_init_msg_list => FND_API.G_FALSE
215: ,p_rev_adj_rec => p_rev_adj_rec
216: ,x_return_status => x_return_status
217: ,x_msg_count => x_msg_count
218: ,x_msg_data => x_msg_data);

Line 219: Validate_Item (p_init_msg_list => FND_API.G_FALSE

215: ,p_rev_adj_rec => p_rev_adj_rec
216: ,x_return_status => x_return_status
217: ,x_msg_count => x_msg_count
218: ,x_msg_data => x_msg_data);
219: Validate_Item (p_init_msg_list => FND_API.G_FALSE
220: ,p_rev_adj_rec => p_rev_adj_rec
221: ,x_return_status => x_return_status
222: ,x_msg_count => x_msg_count
223: ,x_msg_data => x_msg_data);

Line 224: Validate_Line (p_init_msg_list => FND_API.G_FALSE

220: ,p_rev_adj_rec => p_rev_adj_rec
221: ,x_return_status => x_return_status
222: ,x_msg_count => x_msg_count
223: ,x_msg_data => x_msg_data);
224: Validate_Line (p_init_msg_list => FND_API.G_FALSE
225: ,p_rev_adj_rec => p_rev_adj_rec
226: ,x_return_status => x_return_status
227: ,x_msg_count => x_msg_count
228: ,x_msg_data => x_msg_data);

Line 242: Validate_Other (p_init_msg_list => FND_API.G_FALSE

238: p_gl_date => p_rev_adj_rec.gl_date);
239: p_rev_adj_rec.gl_date := l_gl_date_valid;
240: END IF;
241:
242: Validate_Other (p_init_msg_list => FND_API.G_FALSE
243: ,p_rev_adj_rec => p_rev_adj_rec
244: ,x_return_status => x_return_status
245: ,x_msg_count => x_msg_count
246: ,x_msg_data => x_msg_data);

Line 263: RAISE FND_API.G_EXC_ERROR;

259: g_to_cust_trx_line_id := p_rev_adj_rec.to_cust_trx_line_id;
260: g_gl_date := p_rev_adj_rec.gl_date;
261: END IF;
262: ELSE
263: RAISE FND_API.G_EXC_ERROR;
264:
265: END IF;
266: EXCEPTION
267: WHEN OTHERS THEN

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_util.debug('Unexpected error '||sqlerrm||
270: ' at AR_RAAPI_UTIL.Validate_Parameters()+');
271: END IF;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273:
274: END Validate_Parameters;
275:
276: PROCEDURE Validate_Transaction

Line 346: IF FND_API.to_Boolean( p_init_msg_list )

342: IF PG_DEBUG in ('Y', 'C') THEN
343: arp_util.debug('AR_RAAPI_UTIL.Validate_Transaction()+');
344: END IF;
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
352: THEN
353: --
354: -- Verify the transaction ID

Line 351: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
352: THEN
353: --
354: -- Verify the transaction ID
355: --

Line 368: x_return_status := FND_API.G_RET_STS_ERROR ;

364: FND_MESSAGE.set_name (application => 'AR',
365: name => 'AR_RA_TRX_NOTFOUND');
366: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
367: FND_MSG_PUB.Add;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: ELSE
370: FETCH c_trx_num INTO l_customer_trx_id;
371: IF c_trx_num%FOUND
372: THEN

Line 378: x_return_status := FND_API.G_RET_STS_ERROR ;

374: FND_MESSAGE.set_name (application => 'AR',
375: name => 'AR_RA_TRX_TOO_MANY_ROWS');
376: FND_MESSAGE.set_token('TRX_NUMBER',p_rev_adj_rec.trx_number);
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: END IF;
380: END IF;
381: CLOSE c_trx_num;
382: ELSE

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382: ELSE
383: FND_MESSAGE.set_name (application => 'AR',
384: name => 'AR_RA_NO_TRX_NUMBER');
385: FND_MSG_PUB.Add;
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: END IF;
388: ELSE
389: OPEN c_trx_id;
390: FETCH c_trx_id INTO g_customer_trx_id;

Line 397: x_return_status := FND_API.G_RET_STS_ERROR ;

393: FND_MESSAGE.set_name (application => 'AR',
394: name => 'AR_TAPI_TRANS_NOT_EXIST');
395: FND_MESSAGE.set_token('CUSTOMER_TRX_ID',p_rev_adj_rec.customer_trx_id);
396: FND_MSG_PUB.Add;
397: x_return_status := FND_API.G_RET_STS_ERROR ;
398: END IF;
399: CLOSE c_trx_id;
400: END IF;
401: ELSE

Line 407: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL AND

403: END IF;
404: OPEN c_trx_type;
405: FETCH c_trx_type INTO l_trx_type, l_prev_trx_id;
406: CLOSE c_trx_type;
407: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL AND
408: g_customer_trx_id IS NOT NULL)
409: THEN
410: IF l_trx_type = 'CB'
411: THEN

Line 414: x_return_status := FND_API.G_RET_STS_ERROR ;

410: IF l_trx_type = 'CB'
411: THEN
412: FND_MESSAGE.set_name('AR','AR_RA_CB_DISALLOWED');
413: FND_MSG_PUB.Add;
414: x_return_status := FND_API.G_RET_STS_ERROR ;
415: END IF;
416: -- Bug # 4096889
417: -- ORASHID
418: -- IF l_trx_type = 'DM'

Line 422: -- x_return_status := FND_API.G_RET_STS_ERROR ;

418: -- IF l_trx_type = 'DM'
419: -- THEN
420: -- FND_MESSAGE.set_name('AR','AR_RA_DM_DISALLOWED');
421: -- FND_MSG_PUB.Add;
422: -- x_return_status := FND_API.G_RET_STS_ERROR ;
423: -- END IF;
424: IF l_trx_type = 'BR'
425: THEN
426: FND_MESSAGE.set_name('AR','AR_RA_BR_DISALLOWED');

Line 428: x_return_status := FND_API.G_RET_STS_ERROR ;

424: IF l_trx_type = 'BR'
425: THEN
426: FND_MESSAGE.set_name('AR','AR_RA_BR_DISALLOWED');
427: FND_MSG_PUB.Add;
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: END IF;
430: -- Bug # 4096889
431: -- ORASHID
432: -- IF l_trx_type = 'DEP'

Line 436: -- x_return_status := FND_API.G_RET_STS_ERROR ;

432: -- IF l_trx_type = 'DEP'
433: -- THEN
434: -- FND_MESSAGE.set_name('AR','AR_RA_DEP_DISALLOWED');
435: -- FND_MSG_PUB.Add;
436: -- x_return_status := FND_API.G_RET_STS_ERROR ;
437: -- END IF;
438: IF l_trx_type = 'GUAR'
439: THEN
440: FND_MESSAGE.set_name('AR','AR_RA_GUAR_DISALLOWED');

Line 442: x_return_status := FND_API.G_RET_STS_ERROR ;

438: IF l_trx_type = 'GUAR'
439: THEN
440: FND_MESSAGE.set_name('AR','AR_RA_GUAR_DISALLOWED');
441: FND_MSG_PUB.Add;
442: x_return_status := FND_API.G_RET_STS_ERROR ;
443: END IF;
444: /* 5011151 - Only allow revenue adjustments on
445: credit memos if they are on-account or use_inv_acct=N */
446: IF l_trx_type = 'CM' AND

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: THEN
453: /* raise error */
454: FND_MESSAGE.set_name('AR','AR_RA_CM_DISALLOWED');
455: FND_MSG_PUB.Add;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;
458: END IF;
459: END IF;
460: -- Bug # 4096889

Line 494: (p_encoded => FND_API.G_FALSE,

490: END IF;
491: END IF;
492: END IF;
493: FND_MSG_PUB.Count_And_Get
494: (p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data);
497: EXCEPTION
498: WHEN OTHERS THEN

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug('Validate_Transaction: ' || 'Unexpected error '||sqlerrm||
501: ' at AR_RAAPI_UTIL.Validate_Transaction()+');
502: END IF;
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END Validate_Transaction;
505:
506:
507: PROCEDURE Validate_Salesreps

Line 612: IF FND_API.to_Boolean( p_init_msg_list )

608: IF PG_DEBUG in ('Y', 'C') THEN
609: arp_util.debug('AR_RAAPI_UTIL.Validate_Salesreps()+');
610: END IF;
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616: --

Line 649: x_return_status := FND_API.G_RET_STS_ERROR ;

645: p_app_short_name => 'AR'));
646: FND_MESSAGE.set_token('SALESREP_NUMBER',
647: p_rev_adj_rec.from_salesrep_number);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_ERROR ;
650: END IF;
651: CLOSE c_salesrep_num;
652: END IF;
653: ELSE

Line 663: x_return_status := FND_API.G_RET_STS_ERROR ;

659: name => 'AR_TAPI_INVALID_SALESREP_ID');
660: FND_MESSAGE.set_token('SALESREP_ID',
661: p_rev_adj_rec.from_salesrep_id);
662: FND_MSG_PUB.Add;
663: x_return_status := FND_API.G_RET_STS_ERROR ;
664: END IF;
665: CLOSE c_salesrep_id;
666: END IF;
667: END IF;

Line 728: x_return_status := FND_API.G_RET_STS_ERROR ;

724: ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME',l_org_id));
725: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
726: --end anuj
727: FND_MSG_PUB.Add;
728: x_return_status := FND_API.G_RET_STS_ERROR ;
729: END IF;
730: END IF;
731: --END IF; -- commented for bug 3067675
732: --

Line 756: x_return_status := FND_API.G_RET_STS_ERROR ;

752: name => gl_public_sector.get_message_name
753: (p_message_name => 'AR_RA_NO_TO_SALESREP',
754: p_app_short_name => 'AR'));
755: FND_MSG_PUB.Add;
756: x_return_status := FND_API.G_RET_STS_ERROR ;
757: ELSE
758: OPEN c_salesrep_num (p_rev_adj_rec.to_salesrep_number);
759: FETCH c_salesrep_num INTO g_to_salesrep_id;
760: IF c_salesrep_num%NOTFOUND

Line 772: x_return_status := FND_API.G_RET_STS_ERROR ;

768: p_app_short_name => 'AR'));
769: FND_MESSAGE.set_token('SALESREP_NUMBER',
770: p_rev_adj_rec.to_salesrep_number);
771: FND_MSG_PUB.Add;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: END IF;
774: CLOSE c_salesrep_num;
775: END IF;
776: ELSE

Line 786: x_return_status := FND_API.G_RET_STS_ERROR ;

782: name => 'AR_TAPI_INVALID_SALESREP_ID');
783: FND_MESSAGE.set_token('SALESREP_ID',
784: p_rev_adj_rec.to_salesrep_id);
785: FND_MSG_PUB.Add;
786: x_return_status := FND_API.G_RET_STS_ERROR ;
787: END IF;
788: CLOSE c_salesrep_id;
789: END IF;
790: END IF;

Line 817: x_return_status := FND_API.G_RET_STS_ERROR ;

813: THEN
814: FND_MESSAGE.set_name (application => 'AR',
815: name => 'AR_INVALID_SALESGROUP_ID');
816: FND_MSG_PUB.Add;
817: x_return_status := FND_API.G_RET_STS_ERROR ;
818: END IF;
819: CLOSE c_salesgroup_id;
820: END IF;
821: END IF;

Line 826: (p_encoded => FND_API.G_FALSE,

822: END IF;
823: /* END bug 3067675 */
824:
825: FND_MSG_PUB.Count_And_Get
826: (p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data);
829: EXCEPTION
830: WHEN OTHERS THEN

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831: IF PG_DEBUG in ('Y', 'C') THEN
832: arp_util.debug('Validate_Salesreps: ' || 'Unexpected error '||sqlerrm||
833: ' at AR_RAAPI_UTIL.Validate_Salesreps()+');
834: END IF;
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END Validate_Salesreps;
837:
838: PROCEDURE Validate_Category
839: (p_init_msg_list IN VARCHAR2

Line 849: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */

845:
846: l_segment_rec Segment_Rec_Type;
847: l_cat_count NUMBER;
848:
849: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */
850: CURSOR c_category_segs (p_segment_rec Segment_Rec_Type) IS
851: SELECT category_id
852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)

Line 853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)

849: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */
850: CURSOR c_category_segs (p_segment_rec Segment_Rec_Type) IS
851: SELECT category_id
852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)

Line 854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)

850: CURSOR c_category_segs (p_segment_rec Segment_Rec_Type) IS
851: SELECT category_id
852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)

Line 855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)

851: SELECT category_id
852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)

Line 856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)

852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)

Line 857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)

853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)

Line 858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)

854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)

Line 859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)

855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)

Line 860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)

856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)

Line 861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)

857: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)

Line 862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)

858: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)

Line 863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)

859: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)

Line 864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)

860: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)

Line 865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)

861: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)

Line 866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)

862: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)

Line 867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)

863: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)

Line 868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)

864: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)

Line 869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)

865: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
873: AND structure_id = g_category_structure_id;

Line 870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)

866: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
873: AND structure_id = g_category_structure_id;
874:

Line 871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)

867: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
873: AND structure_id = g_category_structure_id;
874:
875: CURSOR c_category_id(p_category_id NUMBER) IS

Line 872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)

868: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
869: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
870: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
871: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
872: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
873: AND structure_id = g_category_structure_id;
874:
875: CURSOR c_category_id(p_category_id NUMBER) IS
876: SELECT category_id

Line 905: IF FND_API.to_Boolean( p_init_msg_list )

901: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
902: END IF;
903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF FND_API.to_Boolean( p_init_msg_list )
906: THEN
907: FND_MSG_PUB.initialize;
908: END IF;
909: --

Line 982: x_return_status := FND_API.G_RET_STS_ERROR ;

978: l_segment_rec.segment16||l_segment_rec.segment17||
979: l_segment_rec.segment18||l_segment_rec.segment19||
980: l_segment_rec.segment20);
981: FND_MSG_PUB.Add;
982: x_return_status := FND_API.G_RET_STS_ERROR ;
983: END IF;
984: CLOSE c_category_segs;
985: ELSIF p_rev_adj_rec.line_selection_mode = 'C'
986: THEN

Line 990: x_return_status := FND_API.G_RET_STS_ERROR ;

986: THEN
987: FND_MESSAGE.set_name (application => 'AR',
988: name => 'AR_RA_NO_FROM_CATEGORY');
989: FND_MSG_PUB.Add;
990: x_return_status := FND_API.G_RET_STS_ERROR ;
991: END IF;
992: ELSE
993: OPEN c_category_id(p_rev_adj_rec.from_category_id);
994: FETCH c_category_id INTO g_from_category_id;

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR ;

997: FND_MESSAGE.set_name (application => 'AR',
998: name => 'AR_RA_INVALID_CATEGORY_ID');
999: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1000: FND_MSG_PUB.Add;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: END IF;
1003: CLOSE c_category_id;
1004: END IF;
1005: IF g_from_category_id IS NOT NULL

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR ;

1012: FND_MESSAGE.set_name (application => 'AR',
1013: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1014: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.from_category_id);
1015: FND_MSG_PUB.Add;
1016: x_return_status := FND_API.G_RET_STS_ERROR ;
1017: END IF;
1018: END IF;
1019: END IF;
1020: --

Line 1095: x_return_status := FND_API.G_RET_STS_ERROR ;

1091: l_segment_rec.segment16||l_segment_rec.segment17||
1092: l_segment_rec.segment18||l_segment_rec.segment19||
1093: l_segment_rec.segment20);
1094: FND_MSG_PUB.Add;
1095: x_return_status := FND_API.G_RET_STS_ERROR ;
1096: END IF;
1097: CLOSE c_category_segs;
1098: ELSE
1099: FND_MESSAGE.set_name (application => 'AR',

Line 1102: x_return_status := FND_API.G_RET_STS_ERROR ;

1098: ELSE
1099: FND_MESSAGE.set_name (application => 'AR',
1100: name => 'AR_RA_NO_TO_CATEGORY');
1101: FND_MSG_PUB.Add;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: END IF;
1104: ELSE
1105: OPEN c_category_id(p_rev_adj_rec.to_category_id);
1106: FETCH c_category_id INTO g_to_category_id;

Line 1113: x_return_status := FND_API.G_RET_STS_ERROR ;

1109: FND_MESSAGE.set_name (application => 'AR',
1110: name => 'AR_RA_INVALID_CATEGORY_ID');
1111: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1112: FND_MSG_PUB.Add;
1113: x_return_status := FND_API.G_RET_STS_ERROR ;
1114: END IF;
1115: CLOSE c_category_id;
1116: END IF;
1117: IF g_to_category_id IS NOT NULL

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR ;

1124: FND_MESSAGE.set_name (application => 'AR',
1125: name => 'AR_RA_CATEGORY_NOT_ON_TRX');
1126: FND_MESSAGE.set_token('CATEGORY_ID', p_rev_adj_rec.to_category_id);
1127: FND_MSG_PUB.Add;
1128: x_return_status := FND_API.G_RET_STS_ERROR ;
1129: END IF;
1130: END IF;
1131: END IF;
1132: END IF;

Line 1134: (p_encoded => FND_API.G_FALSE,

1130: END IF;
1131: END IF;
1132: END IF;
1133: FND_MSG_PUB.Count_And_Get
1134: (p_encoded => FND_API.G_FALSE,
1135: p_count => x_msg_count,
1136: p_data => x_msg_data);
1137: EXCEPTION
1138: WHEN TOO_MANY_ROWS THEN

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR ;

1149: l_segment_rec.segment16||l_segment_rec.segment17||
1150: l_segment_rec.segment18||l_segment_rec.segment19||
1151: l_segment_rec.segment20);
1152: FND_MSG_PUB.Add;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: WHEN OTHERS THEN
1155: IF PG_DEBUG in ('Y', 'C') THEN
1156: arp_util.debug('Validate_Category: ' || 'Unexpected error '||sqlerrm||
1157: ' at AR_RAAPI_UTIL.Validate_Category()+');

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: IF PG_DEBUG in ('Y', 'C') THEN
1156: arp_util.debug('Validate_Category: ' || 'Unexpected error '||sqlerrm||
1157: ' at AR_RAAPI_UTIL.Validate_Category()+');
1158: END IF;
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END Validate_Category;
1161:
1162: PROCEDURE Validate_Item
1163: (p_init_msg_list IN VARCHAR2

Line 1173: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */

1169:
1170: l_segment_rec Segment_Rec_Type;
1171: l_item_count NUMBER;
1172:
1173: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */
1174: CURSOR c_item_segs (p_segment_rec Segment_Rec_Type) IS
1175: SELECT inventory_item_id
1176: FROM mtl_system_items
1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)

Line 1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)

1173: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */
1174: CURSOR c_item_segs (p_segment_rec Segment_Rec_Type) IS
1175: SELECT inventory_item_id
1176: FROM mtl_system_items
1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)

Line 1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)

1174: CURSOR c_item_segs (p_segment_rec Segment_Rec_Type) IS
1175: SELECT inventory_item_id
1176: FROM mtl_system_items
1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)

Line 1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)

1175: SELECT inventory_item_id
1176: FROM mtl_system_items
1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)

Line 1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)

1176: FROM mtl_system_items
1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)

Line 1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)

1177: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)

Line 1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)

1178: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)

Line 1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)

1179: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)

Line 1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)

1180: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)
1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)

Line 1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)

1181: AND NVL(segment5,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment5,FND_API.G_MISS_CHAR)
1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)

Line 1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)

1182: AND NVL(segment6,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment6,FND_API.G_MISS_CHAR)
1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)

Line 1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)

1183: AND NVL(segment7,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment7,FND_API.G_MISS_CHAR)
1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)

Line 1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)

1184: AND NVL(segment8,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment8,FND_API.G_MISS_CHAR)
1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)

Line 1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)

1185: AND NVL(segment9,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment9,FND_API.G_MISS_CHAR)
1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)

Line 1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)

1186: AND NVL(segment10,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment10,FND_API.G_MISS_CHAR)
1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)

Line 1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)

1187: AND NVL(segment11,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment11,FND_API.G_MISS_CHAR)
1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)

Line 1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)

1188: AND NVL(segment12,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment12,FND_API.G_MISS_CHAR)
1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)

Line 1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)

1189: AND NVL(segment13,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment13,FND_API.G_MISS_CHAR)
1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
1197: AND organization_id = g_inv_org_id;

Line 1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)

1190: AND NVL(segment14,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment14,FND_API.G_MISS_CHAR)
1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
1197: AND organization_id = g_inv_org_id;
1198:

Line 1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)

1191: AND NVL(segment15,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment15,FND_API.G_MISS_CHAR)
1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
1197: AND organization_id = g_inv_org_id;
1198:
1199: CURSOR c_item_id(p_item_id NUMBER) IS

Line 1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)

1192: AND NVL(segment16,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment16,FND_API.G_MISS_CHAR)
1193: AND NVL(segment17,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment17,FND_API.G_MISS_CHAR)
1194: AND NVL(segment18,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment18,FND_API.G_MISS_CHAR)
1195: AND NVL(segment19,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment19,FND_API.G_MISS_CHAR)
1196: AND NVL(segment20,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment20,FND_API.G_MISS_CHAR)
1197: AND organization_id = g_inv_org_id;
1198:
1199: CURSOR c_item_id(p_item_id NUMBER) IS
1200: SELECT inventory_item_id

Line 1223: IF FND_API.to_Boolean( p_init_msg_list )

1219: THEN
1220: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
1221: END IF;
1222: -- Initialize message list if p_init_msg_list is set to TRUE.
1223: IF FND_API.to_Boolean( p_init_msg_list )
1224: THEN
1225: FND_MSG_PUB.initialize;
1226: END IF;
1227: --

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR ;

1296: l_segment_rec.segment16||l_segment_rec.segment17||
1297: l_segment_rec.segment18||l_segment_rec.segment19||
1298: l_segment_rec.segment20);
1299: FND_MSG_PUB.Add;
1300: x_return_status := FND_API.G_RET_STS_ERROR ;
1301: END IF;
1302: CLOSE c_item_segs;
1303: ELSIF p_rev_adj_rec.line_selection_mode = 'I'
1304: THEN

Line 1308: x_return_status := FND_API.G_RET_STS_ERROR ;

1304: THEN
1305: FND_MESSAGE.set_name (application => 'AR',
1306: name => 'AR_RA_NO_FROM_ITEM');
1307: FND_MSG_PUB.Add;
1308: x_return_status := FND_API.G_RET_STS_ERROR ;
1309: END IF;
1310: ELSE
1311: OPEN c_item_id(p_rev_adj_rec.from_inventory_item_id);
1312: FETCH c_item_id INTO g_from_inventory_item_id;

Line 1319: x_return_status := FND_API.G_RET_STS_ERROR ;

1315: FND_MESSAGE.set_name (application => 'AR',
1316: name => 'AR_RA_INVALID_ITEM_ID');
1317: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1318: FND_MSG_PUB.Add;
1319: x_return_status := FND_API.G_RET_STS_ERROR ;
1320: END IF;
1321: close c_item_id;
1322: END IF;
1323: IF g_from_inventory_item_id IS NOT NULL

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR ;

1330: FND_MESSAGE.set_name (application => 'AR',
1331: name => 'AR_RA_ITEM_NOT_ON_TRX');
1332: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.from_inventory_item_id);
1333: FND_MSG_PUB.Add;
1334: x_return_status := FND_API.G_RET_STS_ERROR ;
1335: END IF;
1336: END IF;
1337: END IF;
1338: --

Line 1414: x_return_status := FND_API.G_RET_STS_ERROR ;

1410: l_segment_rec.segment16||l_segment_rec.segment17||
1411: l_segment_rec.segment18||l_segment_rec.segment19||
1412: l_segment_rec.segment20);
1413: FND_MSG_PUB.Add;
1414: x_return_status := FND_API.G_RET_STS_ERROR ;
1415: END IF;
1416: CLOSE c_item_segs;
1417: ELSE
1418: FND_MESSAGE.set_name (application => 'AR',

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR ;

1417: ELSE
1418: FND_MESSAGE.set_name (application => 'AR',
1419: name => 'AR_RA_NO_TO_ITEM');
1420: FND_MSG_PUB.Add;
1421: x_return_status := FND_API.G_RET_STS_ERROR ;
1422: END IF;
1423: ELSE
1424: OPEN c_item_id(p_rev_adj_rec.to_inventory_item_id);
1425: FETCH c_item_id INTO g_to_inventory_item_id;

Line 1432: x_return_status := FND_API.G_RET_STS_ERROR ;

1428: FND_MESSAGE.set_name (application => 'AR',
1429: name => 'AR_RA_INVALID_ITEM_ID');
1430: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1431: FND_MSG_PUB.Add;
1432: x_return_status := FND_API.G_RET_STS_ERROR ;
1433: END IF;
1434: CLOSE c_item_id;
1435: END IF;
1436: IF g_to_inventory_item_id IS NOT NULL

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR ;

1443: FND_MESSAGE.set_name (application => 'AR',
1444: name => 'AR_RA_ITEM_NOT_ON_TRX');
1445: FND_MESSAGE.set_token('ITEM_ID',p_rev_adj_rec.to_inventory_item_id);
1446: FND_MSG_PUB.Add;
1447: x_return_status := FND_API.G_RET_STS_ERROR ;
1448: END IF;
1449: END IF;
1450: END IF;
1451: END IF;

Line 1453: (p_encoded => FND_API.G_FALSE,

1449: END IF;
1450: END IF;
1451: END IF;
1452: FND_MSG_PUB.Count_And_Get
1453: (p_encoded => FND_API.G_FALSE,
1454: p_count => x_msg_count,
1455: p_data => x_msg_data);
1456: EXCEPTION
1457: WHEN TOO_MANY_ROWS THEN

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR ;

1468: l_segment_rec.segment16||l_segment_rec.segment17||
1469: l_segment_rec.segment18||l_segment_rec.segment19||
1470: l_segment_rec.segment20);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: WHEN OTHERS THEN
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: arp_util.debug('Validate_Item: ' || 'Unexpected error '||sqlerrm||
1476: ' at AR_RAAPI_UTIL.Validate_Item()+');

Line 1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: arp_util.debug('Validate_Item: ' || 'Unexpected error '||sqlerrm||
1476: ' at AR_RAAPI_UTIL.Validate_Item()+');
1477: END IF;
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END Validate_Item;
1480:
1481: PROCEDURE Validate_Line
1482: (p_init_msg_list IN VARCHAR2

Line 1508: IF FND_API.to_Boolean( p_init_msg_list )

1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_util.debug('AR_RAAPI_UTIL.Validate_Line()+');
1506: END IF;
1507: -- Initialize message list if p_init_msg_list is set to TRUE.
1508: IF FND_API.to_Boolean( p_init_msg_list )
1509: THEN
1510: FND_MSG_PUB.initialize;
1511: END IF;
1512: --

Line 1527: x_return_status := FND_API.G_RET_STS_ERROR ;

1523: FND_MESSAGE.set_name (application => 'AR',
1524: name => 'AR_RA_LINE_NOT_ON_TRX');
1525: FND_MESSAGE.set_token('LINE_NUMBER', p_rev_adj_rec.from_line_number);
1526: FND_MSG_PUB.Add;
1527: x_return_status := FND_API.G_RET_STS_ERROR ;
1528: END IF;
1529: CLOSE c_line_num;
1530: ELSIF p_rev_adj_rec.line_selection_mode = 'L'
1531: THEN

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR ;

1531: THEN
1532: FND_MESSAGE.set_name (application => 'AR',
1533: name => 'AR_RA_NO_FROM_LINE');
1534: FND_MSG_PUB.Add;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: END IF;
1537: ELSE
1538: OPEN c_line_id(p_rev_adj_rec.from_cust_trx_line_id);
1539: FETCH c_line_id INTO g_from_cust_trx_line_id;

Line 1547: x_return_status := FND_API.G_RET_STS_ERROR ;

1543: name => 'AR_RA_INVALID_LINE_ID');
1544: FND_MESSAGE.set_token('CUST_TRX_LINE_ID',
1545: p_rev_adj_rec.from_cust_trx_line_id);
1546: FND_MSG_PUB.Add;
1547: x_return_status := FND_API.G_RET_STS_ERROR ;
1548: END IF;
1549: CLOSE c_line_id;
1550: END IF;
1551:

Line 1553: (p_encoded => FND_API.G_FALSE,

1549: CLOSE c_line_id;
1550: END IF;
1551:
1552: FND_MSG_PUB.Count_And_Get
1553: (p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data);
1556: EXCEPTION
1557: WHEN OTHERS THEN

Line 1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1558: IF PG_DEBUG in ('Y', 'C') THEN
1559: arp_util.debug('Validate_Line: ' || 'Unexpected error '||sqlerrm||
1560: ' at AR_RAAPI_UTIL.Validate_Line()+');
1561: END IF;
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END Validate_Line;
1564:
1565: /* Bug 2146970 - changed main in parameter from p_rev_adj_rec to p_gl_date
1566: and converted from procedure to function */

Line 1666: IF FND_API.to_Boolean( p_init_msg_list )

1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_util.debug('AR_RAAPI_UTIL.Validate_Other()+');
1664: END IF;
1665: -- Initialize message list if p_init_msg_list is set to TRUE.
1666: IF FND_API.to_Boolean( p_init_msg_list )
1667: THEN
1668: FND_MSG_PUB.initialize;
1669: END IF;
1670: IF p_rev_adj_rec.adjustment_type NOT IN ('UN','EA','SA','NR')

Line 1677: x_return_status := FND_API.G_RET_STS_ERROR ;

1673: FND_MESSAGE.set_name (application => 'AR',
1674: name => 'AR_RA_INVALID_ADJUST_TYPE');
1675: FND_MESSAGE.set_token('ADJUST_TYPE', p_rev_adj_rec.adjustment_type);
1676: FND_MSG_PUB.Add;
1677: x_return_status := FND_API.G_RET_STS_ERROR ;
1678: END IF;
1679: IF p_rev_adj_rec.sales_credit_type NOT IN ('R','N','B')
1680: THEN
1681: FND_MESSAGE.set_name (application => 'AR',

Line 1685: x_return_status := FND_API.G_RET_STS_ERROR ;

1681: FND_MESSAGE.set_name (application => 'AR',
1682: name => 'AR_RA_INVALID_SALESCRED_TYPE');
1683: FND_MESSAGE.set_token('SALESCRED_TYPE', p_rev_adj_rec.sales_credit_type);
1684: FND_MSG_PUB.Add;
1685: x_return_status := FND_API.G_RET_STS_ERROR ;
1686: END IF;
1687: IF p_rev_adj_rec.amount_mode NOT IN ('T','A','P')
1688: THEN
1689: FND_MESSAGE.set_name (application => 'AR',

Line 1693: x_return_status := FND_API.G_RET_STS_ERROR ;

1689: FND_MESSAGE.set_name (application => 'AR',
1690: name => 'AR_RA_INVALID_AMOUNT_MODE');
1691: FND_MESSAGE.set_token('AMOUNT_MODE', p_rev_adj_rec.amount_mode);
1692: FND_MSG_PUB.Add;
1693: x_return_status := FND_API.G_RET_STS_ERROR ;
1694: END IF;
1695: IF p_rev_adj_rec.line_selection_mode NOT IN ('A','C','I','S')
1696: THEN
1697: FND_MESSAGE.set_name (application => 'AR',

Line 1701: x_return_status := FND_API.G_RET_STS_ERROR ;

1697: FND_MESSAGE.set_name (application => 'AR',
1698: name => 'AR_RA_INVALID_LINE_MODE');
1699: FND_MESSAGE.set_token('LINE_MODE', p_rev_adj_rec.line_selection_mode);
1700: FND_MSG_PUB.Add;
1701: x_return_status := FND_API.G_RET_STS_ERROR ;
1702: END IF;
1703: IF AR_Revenue_Adjustment_PVT.g_update_db_flag = 'Y'
1704: THEN
1705: /* Bug 4304865 - separate lookup for sales credit adjustments */

Line 1722: x_return_status := FND_API.G_RET_STS_ERROR ;

1718: FND_MESSAGE.set_name (application => 'AR',
1719: name => 'AR_RA_INVALID_REASON');
1720: FND_MESSAGE.set_token('REASON_CODE', p_rev_adj_rec.reason_code);
1721: FND_MSG_PUB.Add;
1722: x_return_status := FND_API.G_RET_STS_ERROR ;
1723: END IF;
1724: END IF;
1725:
1726: --

Line 1749: IF NVL(l_df_return_status,FND_API.G_RET_STS_SUCCESS) <>

1745: l_attribute_rec,
1746: 'AR_REVENUE_ADJUSTMENTS',
1747: l_df_return_status
1748: );
1749: IF NVL(l_df_return_status,FND_API.G_RET_STS_SUCCESS) <>
1750: FND_API.G_RET_STS_SUCCESS
1751: THEN
1752: x_return_status := l_df_return_status;
1753: END IF;

Line 1750: FND_API.G_RET_STS_SUCCESS

1746: 'AR_REVENUE_ADJUSTMENTS',
1747: l_df_return_status
1748: );
1749: IF NVL(l_df_return_status,FND_API.G_RET_STS_SUCCESS) <>
1750: FND_API.G_RET_STS_SUCCESS
1751: THEN
1752: x_return_status := l_df_return_status;
1753: END IF;
1754: FND_MSG_PUB.Count_And_Get

Line 1755: (p_encoded => FND_API.G_FALSE,

1751: THEN
1752: x_return_status := l_df_return_status;
1753: END IF;
1754: FND_MSG_PUB.Count_And_Get
1755: (p_encoded => FND_API.G_FALSE,
1756: p_count => x_msg_count,
1757: p_data => x_msg_data);
1758: EXCEPTION
1759: WHEN OTHERS THEN

Line 1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1760: IF PG_DEBUG in ('Y', 'C') THEN
1761: arp_util.debug('Validate_Other: ' || 'Unexpected error '||sqlerrm||
1762: ' at AR_RAAPI_UTIL.Validate_Other()+');
1763: END IF;
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END Validate_Other;
1766:
1767: --
1768: -- Public function to return the cost center for a given salesrep

Line 1893: IF FND_API.to_Boolean( p_init_msg_list )

1889: THEN
1890: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
1891: END IF;
1892: -- Initialize message list if p_init_msg_list is set to TRUE.
1893: IF FND_API.to_Boolean( p_init_msg_list )
1894: THEN
1895: FND_MSG_PUB.initialize;
1896: END IF;
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

1893: IF FND_API.to_Boolean( p_init_msg_list )
1894: THEN
1895: FND_MSG_PUB.initialize;
1896: END IF;
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;
1898: OPEN c_salesrep_totals;
1899: FETCH c_salesrep_totals INTO l_revenue_percent_total,
1900: l_non_revenue_percent_total;
1901: CLOSE c_salesrep_totals;

Line 1909: x_return_status := FND_API.G_RET_STS_ERROR ;

1905: AND l_non_revenue_percent_total = 0)
1906: THEN
1907: FND_MESSAGE.set_name('AR','AR_RA_NO_SELECTED_SALESCRED');
1908: FND_MSG_PUB.Add;
1909: x_return_status := FND_API.G_RET_STS_ERROR ;
1910: END IF;
1911: FND_MSG_PUB.Count_And_Get
1912: (p_encoded => FND_API.G_FALSE,
1913: p_count => x_msg_count,

Line 1912: (p_encoded => FND_API.G_FALSE,

1908: FND_MSG_PUB.Add;
1909: x_return_status := FND_API.G_RET_STS_ERROR ;
1910: END IF;
1911: FND_MSG_PUB.Count_And_Get
1912: (p_encoded => FND_API.G_FALSE,
1913: p_count => x_msg_count,
1914: p_data => x_msg_data);
1915: EXCEPTION
1916: WHEN OTHERS THEN

Line 1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1917: IF PG_DEBUG in ('Y', 'C') THEN
1918: arp_util.debug('Validate_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1919: ' at AR_RAAPI_UTIL.Validate_Sales_Credits()+');
1920: END IF;
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END Validate_Sales_Credits;
1923:
1924: FUNCTION Total_Selected_Line_Value
1925: (p_customer_trx_line_id IN NUMBER

Line 1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug('Total_Selected_Line_Value: ' || 'Unexpected error '||sqlerrm||
1985: ' at AR_RAAPI_UTIL.Total_Selected_Line_Value()+');
1986: END IF;
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END Total_Selected_Line_Value ;
1989:
1990: /* 7365097 - Centralized some credit memo processing logic
1991: so that it can be neatly included in both adjustable_revenue

Line 2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2346: IF PG_DEBUG in ('Y', 'C') THEN
2347: arp_util.debug('Adjustable_Revenue: ' || 'Unexpected error '||sqlerrm||
2348: ' at AR_RAAPI_UTIL.Adjustable_Revenue()+');
2349: END IF;
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351:
2352: END Adjustable_Revenue;
2353:
2354: /* 7365097 - New function for calculating adjustable_revenue

Line 2529: IF FND_API.to_Boolean( p_init_msg_list )

2525: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
2526: END IF;
2527:
2528: -- Initialize message list if p_init_msg_list is set to TRUE.
2529: IF FND_API.to_Boolean( p_init_msg_list )
2530: THEN
2531: FND_MSG_PUB.initialize;
2532: END IF;
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2533: x_return_status := FND_API.G_RET_STS_SUCCESS;

2529: IF FND_API.to_Boolean( p_init_msg_list )
2530: THEN
2531: FND_MSG_PUB.initialize;
2532: END IF;
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534: IF NVL(g_last_customer_trx_id,p_customer_trx_id - 1) <> p_customer_trx_id
2535: THEN
2536: constant_trx_values(p_customer_trx_id);
2537: END IF;

Line 2633: x_return_status := FND_API.G_RET_STS_ERROR ;

2629: g_trx_currency||' '||
2630: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2631: END IF;
2632: FND_MSG_PUB.Add;
2633: x_return_status := FND_API.G_RET_STS_ERROR ;
2634: FND_MSG_PUB.Count_And_Get
2635: (p_encoded => FND_API.G_FALSE,
2636: p_count => x_msg_count,
2637: p_data => x_msg_data);

Line 2635: (p_encoded => FND_API.G_FALSE,

2631: END IF;
2632: FND_MSG_PUB.Add;
2633: x_return_status := FND_API.G_RET_STS_ERROR ;
2634: FND_MSG_PUB.Count_And_Get
2635: (p_encoded => FND_API.G_FALSE,
2636: p_count => x_msg_count,
2637: p_data => x_msg_data);
2638: WHEN invalid_zero THEN
2639: FND_MESSAGE.set_name

Line 2642: x_return_status := FND_API.G_RET_STS_ERROR ;

2638: WHEN invalid_zero THEN
2639: FND_MESSAGE.set_name
2640: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2641: FND_MSG_PUB.Add;
2642: x_return_status := FND_API.G_RET_STS_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data);

Line 2644: (p_encoded => FND_API.G_FALSE,

2640: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2641: FND_MSG_PUB.Add;
2642: x_return_status := FND_API.G_RET_STS_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data);
2647: WHEN adjusted_by_other_user THEN
2648: FND_MESSAGE.set_name

Line 2651: x_return_status := FND_API.G_RET_STS_ERROR ;

2647: WHEN adjusted_by_other_user THEN
2648: FND_MESSAGE.set_name
2649: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2650: FND_MSG_PUB.Add;
2651: x_return_status := FND_API.G_RET_STS_ERROR ;
2652: FND_MSG_PUB.Count_And_Get
2653: (p_encoded => FND_API.G_FALSE,
2654: p_count => x_msg_count,
2655: p_data => x_msg_data);

Line 2653: (p_encoded => FND_API.G_FALSE,

2649: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2650: FND_MSG_PUB.Add;
2651: x_return_status := FND_API.G_RET_STS_ERROR ;
2652: FND_MSG_PUB.Count_And_Get
2653: (p_encoded => FND_API.G_FALSE,
2654: p_count => x_msg_count,
2655: p_data => x_msg_data);
2656: WHEN OTHERS THEN
2657: IF PG_DEBUG in ('Y', 'C') THEN

Line 2661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2657: IF PG_DEBUG in ('Y', 'C') THEN
2658: arp_util.debug('Validate_Amount: ' || 'Unexpected error '||sqlerrm||
2659: ' at AR_RAAPI_UTIL.Validate_Amount()+');
2660: END IF;
2661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2662:
2663: END Validate_Amount;
2664:
2665: FUNCTION Revalidate_GL_Dates

Line 2720: RETURN FND_API.G_FALSE;

2716: l_change_count := l_change_count + 1;
2717: END IF;
2718: ELSE
2719: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2720: RETURN FND_API.G_FALSE;
2721: END IF;
2722: END LOOP;
2723: IF l_change_count > 0
2724: THEN

Line 2726: (p_encoded => FND_API.G_FALSE,

2722: END LOOP;
2723: IF l_change_count > 0
2724: THEN
2725: FND_MSG_PUB.Count_And_Get
2726: (p_encoded => FND_API.G_FALSE,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729: RETURN FND_API.G_FALSE;
2730: ELSE

Line 2729: RETURN FND_API.G_FALSE;

2725: FND_MSG_PUB.Count_And_Get
2726: (p_encoded => FND_API.G_FALSE,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729: RETURN FND_API.G_FALSE;
2730: ELSE
2731: RETURN FND_API.G_TRUE;
2732: END IF;
2733: EXCEPTION

Line 2731: RETURN FND_API.G_TRUE;

2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729: RETURN FND_API.G_FALSE;
2730: ELSE
2731: RETURN FND_API.G_TRUE;
2732: END IF;
2733: EXCEPTION
2734: WHEN OTHERS THEN
2735: IF PG_DEBUG in ('Y', 'C') THEN

Line 2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2735: IF PG_DEBUG in ('Y', 'C') THEN
2736: arp_util.debug('Revalidate_GL_Dates: ' || 'Unexpected error '||sqlerrm||
2737: ' at AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2738: END IF;
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END Revalidate_GL_Dates;
2741:
2742: FUNCTION Deferred_GL_Date (p_start_date IN DATE,
2743: p_period_seq_no IN NUMBER)

Line 2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2810: IF PG_DEBUG in ('Y', 'C') THEN
2811: arp_util.debug('Deferred_GL_Date: ' || 'Unexpected error '||sqlerrm||
2812: ' at AR_RAAPI_UTIL.Deferred_GL_Date()+');
2813: END IF;
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815: END Deferred_GL_Date;
2816:
2817: --
2818: -- Read only functions to allow client access to globals

Line 2823: RETURN FND_API.G_RET_STS_SUCCESS;

2819: --
2820: FUNCTION G_RET_STS_SUCCESS
2821: RETURN VARCHAR2 IS
2822: BEGIN
2823: RETURN FND_API.G_RET_STS_SUCCESS;
2824: END G_RET_STS_SUCCESS;
2825:
2826: FUNCTION G_RET_STS_ERROR
2827: RETURN VARCHAR2 IS

Line 2829: RETURN FND_API.G_RET_STS_ERROR;

2825:
2826: FUNCTION G_RET_STS_ERROR
2827: RETURN VARCHAR2 IS
2828: BEGIN
2829: RETURN FND_API.G_RET_STS_ERROR;
2830: END G_RET_STS_ERROR;
2831:
2832: FUNCTION G_TRUE
2833: RETURN VARCHAR2 IS

Line 2835: RETURN FND_API.G_TRUE;

2831:
2832: FUNCTION G_TRUE
2833: RETURN VARCHAR2 IS
2834: BEGIN
2835: RETURN FND_API.G_TRUE;
2836: END G_TRUE;
2837:
2838: FUNCTION G_VALID_LEVEL_NONE
2839: RETURN VARCHAR2 IS

Line 2841: RETURN FND_API.G_VALID_LEVEL_NONE;

2837:
2838: FUNCTION G_VALID_LEVEL_NONE
2839: RETURN VARCHAR2 IS
2840: BEGIN
2841: RETURN FND_API.G_VALID_LEVEL_NONE;
2842: END G_VALID_LEVEL_NONE;
2843:
2844: FUNCTION G_VALID_LEVEL_FULL
2845: RETURN VARCHAR2 IS

Line 2847: RETURN FND_API.G_VALID_LEVEL_FULL;

2843:
2844: FUNCTION G_VALID_LEVEL_FULL
2845: RETURN VARCHAR2 IS
2846: BEGIN
2847: RETURN FND_API.G_VALID_LEVEL_FULL;
2848: END G_VALID_LEVEL_FULL;
2849:
2850: FUNCTION G_FALSE
2851: RETURN VARCHAR2 IS

Line 2853: RETURN FND_API.G_FALSE;

2849:
2850: FUNCTION G_FALSE
2851: RETURN VARCHAR2 IS
2852: BEGIN
2853: RETURN FND_API.G_FALSE;
2854: END G_FALSE;
2855:
2856: FUNCTION chart_of_accounts_id
2857: RETURN NUMBER IS