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 1665: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1676: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1684: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1692: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1700: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1721: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 1749: FND_API.G_RET_STS_SUCCESS

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

Line 1754: (p_encoded => FND_API.G_FALSE,

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

Line 1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1892: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1896: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1908: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1911: (p_encoded => FND_API.G_FALSE,

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

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1982: IF PG_DEBUG in ('Y', 'C') THEN
1983: arp_util.debug('Total_Selected_Line_Value: ' || 'Unexpected error '||sqlerrm||
1984: ' at AR_RAAPI_UTIL.Total_Selected_Line_Value()+');
1985: END IF;
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987: END Total_Selected_Line_Value ;
1988:
1989: /* Bug 2560048 RAM-C: new out parameter p_acctd_amount_out provided for use
1990: by collectibility - it is assumed that a salesrep_id will never be passed

Line 2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_util.debug('Adjustable_Revenue: ' || 'Unexpected error '||sqlerrm||
2271: ' at AR_RAAPI_UTIL.Adjustable_Revenue()+');
2272: END IF;
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274:
2275: END Adjustable_Revenue;
2276:
2277: PROCEDURE Validate_Amount

Line 2371: IF FND_API.to_Boolean( p_init_msg_list )

2367: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean( p_init_msg_list )
2372: THEN
2373: FND_MSG_PUB.initialize;
2374: END IF;
2375: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2375: x_return_status := FND_API.G_RET_STS_SUCCESS;

2371: IF FND_API.to_Boolean( p_init_msg_list )
2372: THEN
2373: FND_MSG_PUB.initialize;
2374: END IF;
2375: x_return_status := FND_API.G_RET_STS_SUCCESS;
2376: IF NVL(g_last_customer_trx_id,p_customer_trx_id - 1) <> p_customer_trx_id
2377: THEN
2378: constant_trx_values(p_customer_trx_id);
2379: END IF;

Line 2474: x_return_status := FND_API.G_RET_STS_ERROR ;

2470: g_trx_currency||' '||
2471: TO_CHAR(l_adjustable_revenue,g_trx_curr_format));
2472: END IF;
2473: FND_MSG_PUB.Add;
2474: x_return_status := FND_API.G_RET_STS_ERROR ;
2475: FND_MSG_PUB.Count_And_Get
2476: (p_encoded => FND_API.G_FALSE,
2477: p_count => x_msg_count,
2478: p_data => x_msg_data);

Line 2476: (p_encoded => FND_API.G_FALSE,

2472: END IF;
2473: FND_MSG_PUB.Add;
2474: x_return_status := FND_API.G_RET_STS_ERROR ;
2475: FND_MSG_PUB.Count_And_Get
2476: (p_encoded => FND_API.G_FALSE,
2477: p_count => x_msg_count,
2478: p_data => x_msg_data);
2479: WHEN invalid_zero THEN
2480: FND_MESSAGE.set_name

Line 2483: x_return_status := FND_API.G_RET_STS_ERROR ;

2479: WHEN invalid_zero THEN
2480: FND_MESSAGE.set_name
2481: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2482: FND_MSG_PUB.Add;
2483: x_return_status := FND_API.G_RET_STS_ERROR ;
2484: FND_MSG_PUB.Count_And_Get
2485: (p_encoded => FND_API.G_FALSE,
2486: p_count => x_msg_count,
2487: p_data => x_msg_data);

Line 2485: (p_encoded => FND_API.G_FALSE,

2481: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
2482: FND_MSG_PUB.Add;
2483: x_return_status := FND_API.G_RET_STS_ERROR ;
2484: FND_MSG_PUB.Count_And_Get
2485: (p_encoded => FND_API.G_FALSE,
2486: p_count => x_msg_count,
2487: p_data => x_msg_data);
2488: WHEN adjusted_by_other_user THEN
2489: FND_MESSAGE.set_name

Line 2492: x_return_status := FND_API.G_RET_STS_ERROR ;

2488: WHEN adjusted_by_other_user THEN
2489: FND_MESSAGE.set_name
2490: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2491: FND_MSG_PUB.Add;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get
2494: (p_encoded => FND_API.G_FALSE,
2495: p_count => x_msg_count,
2496: p_data => x_msg_data);

Line 2494: (p_encoded => FND_API.G_FALSE,

2490: (application => 'AR', name => 'AR_RA_ADJUSTED_BY_OTHER_USER');
2491: FND_MSG_PUB.Add;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get
2494: (p_encoded => FND_API.G_FALSE,
2495: p_count => x_msg_count,
2496: p_data => x_msg_data);
2497: WHEN OTHERS THEN
2498: IF PG_DEBUG in ('Y', 'C') THEN

Line 2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2498: IF PG_DEBUG in ('Y', 'C') THEN
2499: arp_util.debug('Validate_Amount: ' || 'Unexpected error '||sqlerrm||
2500: ' at AR_RAAPI_UTIL.Validate_Amount()+');
2501: END IF;
2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2503:
2504: END Validate_Amount;
2505:
2506: FUNCTION Revalidate_GL_Dates

Line 2560: RETURN FND_API.G_FALSE;

2556: l_change_count := l_change_count + 1;
2557: END IF;
2558: ELSE
2559: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2560: RETURN FND_API.G_FALSE;
2561: END IF;
2562: END LOOP;
2563: IF l_change_count > 0
2564: THEN

Line 2566: (p_encoded => FND_API.G_FALSE,

2562: END LOOP;
2563: IF l_change_count > 0
2564: THEN
2565: FND_MSG_PUB.Count_And_Get
2566: (p_encoded => FND_API.G_FALSE,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: RETURN FND_API.G_FALSE;
2570: ELSE

Line 2569: RETURN FND_API.G_FALSE;

2565: FND_MSG_PUB.Count_And_Get
2566: (p_encoded => FND_API.G_FALSE,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: RETURN FND_API.G_FALSE;
2570: ELSE
2571: RETURN FND_API.G_TRUE;
2572: END IF;
2573: EXCEPTION

Line 2571: RETURN FND_API.G_TRUE;

2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: RETURN FND_API.G_FALSE;
2570: ELSE
2571: RETURN FND_API.G_TRUE;
2572: END IF;
2573: EXCEPTION
2574: WHEN OTHERS THEN
2575: IF PG_DEBUG in ('Y', 'C') THEN

Line 2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2575: IF PG_DEBUG in ('Y', 'C') THEN
2576: arp_util.debug('Revalidate_GL_Dates: ' || 'Unexpected error '||sqlerrm||
2577: ' at AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: END Revalidate_GL_Dates;
2581:
2582: FUNCTION Deferred_GL_Date (p_start_date IN DATE,
2583: p_period_seq_no IN NUMBER)

Line 2654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2650: IF PG_DEBUG in ('Y', 'C') THEN
2651: arp_util.debug('Deferred_GL_Date: ' || 'Unexpected error '||sqlerrm||
2652: ' at AR_RAAPI_UTIL.Deferred_GL_Date()+');
2653: END IF;
2654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END Deferred_GL_Date;
2656:
2657: --
2658: -- Read only functions to allow client access to globals

Line 2663: RETURN FND_API.G_RET_STS_SUCCESS;

2659: --
2660: FUNCTION G_RET_STS_SUCCESS
2661: RETURN VARCHAR2 IS
2662: BEGIN
2663: RETURN FND_API.G_RET_STS_SUCCESS;
2664: END G_RET_STS_SUCCESS;
2665:
2666: FUNCTION G_RET_STS_ERROR
2667: RETURN VARCHAR2 IS

Line 2669: RETURN FND_API.G_RET_STS_ERROR;

2665:
2666: FUNCTION G_RET_STS_ERROR
2667: RETURN VARCHAR2 IS
2668: BEGIN
2669: RETURN FND_API.G_RET_STS_ERROR;
2670: END G_RET_STS_ERROR;
2671:
2672: FUNCTION G_TRUE
2673: RETURN VARCHAR2 IS

Line 2675: RETURN FND_API.G_TRUE;

2671:
2672: FUNCTION G_TRUE
2673: RETURN VARCHAR2 IS
2674: BEGIN
2675: RETURN FND_API.G_TRUE;
2676: END G_TRUE;
2677:
2678: FUNCTION G_VALID_LEVEL_NONE
2679: RETURN VARCHAR2 IS

Line 2681: RETURN FND_API.G_VALID_LEVEL_NONE;

2677:
2678: FUNCTION G_VALID_LEVEL_NONE
2679: RETURN VARCHAR2 IS
2680: BEGIN
2681: RETURN FND_API.G_VALID_LEVEL_NONE;
2682: END G_VALID_LEVEL_NONE;
2683:
2684: FUNCTION G_VALID_LEVEL_FULL
2685: RETURN VARCHAR2 IS

Line 2687: RETURN FND_API.G_VALID_LEVEL_FULL;

2683:
2684: FUNCTION G_VALID_LEVEL_FULL
2685: RETURN VARCHAR2 IS
2686: BEGIN
2687: RETURN FND_API.G_VALID_LEVEL_FULL;
2688: END G_VALID_LEVEL_FULL;
2689:
2690: FUNCTION G_FALSE
2691: RETURN VARCHAR2 IS

Line 2693: RETURN FND_API.G_FALSE;

2689:
2690: FUNCTION G_FALSE
2691: RETURN VARCHAR2 IS
2692: BEGIN
2693: RETURN FND_API.G_FALSE;
2694: END G_FALSE;
2695:
2696: FUNCTION chart_of_accounts_id
2697: RETURN NUMBER IS