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.

[Home] [Help]

APPS.INV_SALESORDER dependencies on FND_API

Line 25: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

21:
22:
23: Procedure create_salesorder (
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: p_segment1 IN NUMBER,
27: p_segment2 IN VARCHAR2,
28: p_segment3 IN VARCHAR2,
29: p_validate_full IN NUMBER DEFAULT 1,

Line 50: if not fnd_api.compatible_api_call(

46: l_so_id NUMBER;
47: BEGIN
48:
49: -- check for api call compatibility
50: if not fnd_api.compatible_api_call(
51: c_api_version_number,
52: p_api_version_number,
53: c_api_name,
54: g_package_name) then

Line 55: raise fnd_api.g_exc_unexpected_error ;

51: c_api_version_number,
52: p_api_version_number,
53: c_api_name,
54: g_package_name) then
55: raise fnd_api.g_exc_unexpected_error ;
56: end if;
57:
58: -- initialize message list
59: if fnd_api.to_boolean(p_init_msg_list) then

Line 59: if fnd_api.to_boolean(p_init_msg_list) then

55: raise fnd_api.g_exc_unexpected_error ;
56: end if;
57:
58: -- initialize message list
59: if fnd_api.to_boolean(p_init_msg_list) then
60: fnd_msg_pub.initialize;
61: end if;
62:
63: -- initialize return status to success

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60: fnd_msg_pub.initialize;
61: end if;
62:
63: -- initialize return status to success
64: x_return_status := fnd_api.g_ret_sts_success;
65:
66: -- start input parameter validation now
67: -- validate if order number is passed in (segment 1)
68: if ( p_segment1 is NULL ) then

Line 71: raise fnd_api.g_exc_error ;

67: -- validate if order number is passed in (segment 1)
68: if ( p_segment1 is NULL ) then
69: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
70: fnd_msg_pub.add;
71: raise fnd_api.g_exc_error ;
72: else
73: -- convert this to varchar since the flexfield table stores as char(240)
74: l_segment1 := to_char(p_segment1);
75: end if;

Line 81: raise fnd_api.g_exc_error ;

77: -- validate if order type is passed in (segment 2)
78: if ( p_segment2 is NULL ) then
79: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
80: fnd_msg_pub.add;
81: raise fnd_api.g_exc_error ;
82: elsif ( p_segment2 is NOT NULL) then
83: l_segment2 := p_segment2;
84: end if;
85:

Line 90: raise fnd_api.g_exc_error ;

86: -- validate if order source is passed in
87: if ( p_segment3 is NULL ) then
88: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
89: fnd_msg_pub.add;
90: raise fnd_api.g_exc_error ;
91: else
92: l_segment3 := p_segment3 ;
93: end if;
94:

Line 123: raise fnd_api.g_exc_error ;

119: ,n_segments => 3
120: ,segments => l_segment_arr
121: ,combination_id => x_salesorder_id) ) then
122: fnd_msg_pub.add ;
123: raise fnd_api.g_exc_error ;
124: end if;
125: else
126: -- check if sales order already exists
127: BEGIN

Line 156: when fnd_api.g_exc_error then

152:
153: end if;
154:
155: EXCEPTION
156: when fnd_api.g_exc_error then
157: x_return_status := fnd_api.g_ret_sts_error ;
158:
159: fnd_msg_pub.count_and_get(
160: p_count => x_message_count

Line 157: x_return_status := fnd_api.g_ret_sts_error ;

153: end if;
154:
155: EXCEPTION
156: when fnd_api.g_exc_error then
157: x_return_status := fnd_api.g_ret_sts_error ;
158:
159: fnd_msg_pub.count_and_get(
160: p_count => x_message_count
161: , p_data => x_message_data

Line 164: when fnd_api.g_exc_unexpected_error then

160: p_count => x_message_count
161: , p_data => x_message_data
162: , p_encoded => 'F');
163:
164: when fnd_api.g_exc_unexpected_error then
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166:
167: fnd_msg_pub.count_and_get(
168: p_count => x_message_count

Line 165: x_return_status := fnd_api.g_ret_sts_unexp_error;

161: , p_data => x_message_data
162: , p_encoded => 'F');
163:
164: when fnd_api.g_exc_unexpected_error then
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166:
167: fnd_msg_pub.count_and_get(
168: p_count => x_message_count
169: , p_data => x_message_data

Line 173: x_return_status := fnd_api.g_ret_sts_unexp_error;

169: , p_data => x_message_data
170: , p_encoded => 'F');
171:
172: when others then
173: x_return_status := fnd_api.g_ret_sts_unexp_error;
174:
175: if (fnd_msg_pub.check_msg_level
176: (fnd_msg_pub.g_msg_lvl_unexp_error))then
177: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);

Line 214: x_return_status := fnd_api.g_ret_sts_success;

210:
211: BEGIN
212:
213: -- initialize return status to success
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: -- initialize x_oe_order_id to -1, assume default that SO row not created by OOM
217: x_oe_header_id := -1 ;
218:

Line 239: when fnd_api.g_exc_error then

235: l_order_type,
236: l_order_source);
237:
238: EXCEPTION
239: when fnd_api.g_exc_error then
240: x_return_status := fnd_api.g_ret_sts_error ;
241:
242: when fnd_api.g_exc_unexpected_error then
243: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 240: x_return_status := fnd_api.g_ret_sts_error ;

236: l_order_source);
237:
238: EXCEPTION
239: when fnd_api.g_exc_error then
240: x_return_status := fnd_api.g_ret_sts_error ;
241:
242: when fnd_api.g_exc_unexpected_error then
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244:

Line 242: when fnd_api.g_exc_unexpected_error then

238: EXCEPTION
239: when fnd_api.g_exc_error then
240: x_return_status := fnd_api.g_ret_sts_error ;
241:
242: when fnd_api.g_exc_unexpected_error then
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244:
245: when no_data_found then
246: x_return_status := fnd_api.g_ret_sts_success ;

Line 243: x_return_status := fnd_api.g_ret_sts_unexp_error;

239: when fnd_api.g_exc_error then
240: x_return_status := fnd_api.g_ret_sts_error ;
241:
242: when fnd_api.g_exc_unexpected_error then
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244:
245: when no_data_found then
246: x_return_status := fnd_api.g_ret_sts_success ;
247:

Line 246: x_return_status := fnd_api.g_ret_sts_success ;

242: when fnd_api.g_exc_unexpected_error then
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244:
245: when no_data_found then
246: x_return_status := fnd_api.g_ret_sts_success ;
247:
248: when others then
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250:

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error;

245: when no_data_found then
246: x_return_status := fnd_api.g_ret_sts_success ;
247:
248: when others then
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250:
251: if (fnd_msg_pub.check_msg_level
252: (fnd_msg_pub.g_msg_lvl_unexp_error))then
253: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);

Line 426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

422: END Get_Header_Id;
423:
424: Procedure create_mtl_sales_orders_bulk (
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
427: p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE,
428: x_message_data OUT NOCOPY VARCHAR2,
429: x_message_count OUT NOCOPY NUMBER,
430: x_return_status OUT NOCOPY VARCHAR2) IS

Line 440: if not fnd_api.compatible_api_call(

436: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
437:
438: BEGIN
439: -- check for api call compatibility
440: if not fnd_api.compatible_api_call(
441: c_api_version_number,
442: p_api_version_number,
443: c_api_name,
444: g_package_name) then

Line 445: raise fnd_api.g_exc_unexpected_error ;

441: c_api_version_number,
442: p_api_version_number,
443: c_api_name,
444: g_package_name) then
445: raise fnd_api.g_exc_unexpected_error ;
446: end if;
447:
448: -- initialize message list
449: if fnd_api.to_boolean(p_init_msg_list) then

Line 449: if fnd_api.to_boolean(p_init_msg_list) then

445: raise fnd_api.g_exc_unexpected_error ;
446: end if;
447:
448: -- initialize message list
449: if fnd_api.to_boolean(p_init_msg_list) then
450: fnd_msg_pub.initialize;
451: end if;
452:
453: -- initialize return status to success

Line 454: x_return_status := fnd_api.g_ret_sts_success;

450: fnd_msg_pub.initialize;
451: end if;
452:
453: -- initialize return status to success
454: x_return_status := fnd_api.g_ret_sts_success;
455:
456:
457: FORALL i IN p_header_rec.order_number.FIRST..p_header_rec.order_number.LAST
458: INSERT INTO MTL_SALES_ORDERS

Line 484: when fnd_api.g_exc_unexpected_error then

480: 'N',
481: 'Y');
482:
483: EXCEPTION
484: when fnd_api.g_exc_unexpected_error then
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486:
487: fnd_msg_pub.count_and_get(
488: p_count => x_message_count

Line 485: x_return_status := fnd_api.g_ret_sts_unexp_error;

481: 'Y');
482:
483: EXCEPTION
484: when fnd_api.g_exc_unexpected_error then
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486:
487: fnd_msg_pub.count_and_get(
488: p_count => x_message_count
489: , p_data => x_message_data

Line 495: x_return_status := fnd_api.g_ret_sts_unexp_error;

491:
492: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
493:
494: when others then
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496:
497: if (fnd_msg_pub.check_msg_level
498: (fnd_msg_pub.g_msg_lvl_unexp_error))then
499: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);

Line 513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

509:
510:
511: PROCEDURE delete_mtl_sales_orders_bulk(
512: p_api_version_number IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
514: p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE,
515: x_message_data OUT NOCOPY VARCHAR2,
516: x_message_count OUT NOCOPY NUMBER,
517: x_return_status OUT NOCOPY VARCHAR2) IS

Line 524: if not fnd_api.compatible_api_call(

520: c_api_version_number CONSTANT NUMBER := 1.0 ;
521: c_api_name CONSTANT VARCHAR2(50):= 'DELETE_MTL_SALES_ORDERS_BULK';
522: BEGIN
523: -- check for api call compatibility
524: if not fnd_api.compatible_api_call(
525: c_api_version_number,
526: p_api_version_number,
527: c_api_name,
528: g_package_name) then

Line 529: raise fnd_api.g_exc_unexpected_error ;

525: c_api_version_number,
526: p_api_version_number,
527: c_api_name,
528: g_package_name) then
529: raise fnd_api.g_exc_unexpected_error ;
530: end if;
531:
532: -- initialize message list
533: if fnd_api.to_boolean(p_init_msg_list) then

Line 533: if fnd_api.to_boolean(p_init_msg_list) then

529: raise fnd_api.g_exc_unexpected_error ;
530: end if;
531:
532: -- initialize message list
533: if fnd_api.to_boolean(p_init_msg_list) then
534: fnd_msg_pub.initialize;
535: end if;
536:
537: -- initialize return status to success

Line 538: x_return_status := fnd_api.g_ret_sts_success;

534: fnd_msg_pub.initialize;
535: end if;
536:
537: -- initialize return status to success
538: x_return_status := fnd_api.g_ret_sts_success;
539:
540: --Delete MTL Sales Order Records
541: /*Bug3575085:Changed the sequence of the sub-query from b.name,a.order_number
542: to a.order_number,b.name*/

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: , p_data => x_message_data
559: , p_encoded => 'F');
560:
561: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: END delete_mtl_sales_orders_bulk;
565:
566: end inv_salesorder ;