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.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 413: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

409: END Get_Header_Id;
410:
411: Procedure create_mtl_sales_orders_bulk (
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
414: p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE,
415: x_message_data OUT NOCOPY VARCHAR2,
416: x_message_count OUT NOCOPY NUMBER,
417: x_return_status OUT NOCOPY VARCHAR2) IS

Line 427: if not fnd_api.compatible_api_call(

423: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
424:
425: BEGIN
426: -- check for api call compatibility
427: if not fnd_api.compatible_api_call(
428: c_api_version_number,
429: p_api_version_number,
430: c_api_name,
431: g_package_name) then

Line 432: raise fnd_api.g_exc_unexpected_error ;

428: c_api_version_number,
429: p_api_version_number,
430: c_api_name,
431: g_package_name) then
432: raise fnd_api.g_exc_unexpected_error ;
433: end if;
434:
435: -- initialize message list
436: if fnd_api.to_boolean(p_init_msg_list) then

Line 436: if fnd_api.to_boolean(p_init_msg_list) then

432: raise fnd_api.g_exc_unexpected_error ;
433: end if;
434:
435: -- initialize message list
436: if fnd_api.to_boolean(p_init_msg_list) then
437: fnd_msg_pub.initialize;
438: end if;
439:
440: -- initialize return status to success

Line 441: x_return_status := fnd_api.g_ret_sts_success;

437: fnd_msg_pub.initialize;
438: end if;
439:
440: -- initialize return status to success
441: x_return_status := fnd_api.g_ret_sts_success;
442:
443:
444: FORALL i IN p_header_rec.order_number.FIRST..p_header_rec.order_number.LAST
445: INSERT INTO MTL_SALES_ORDERS

Line 471: when fnd_api.g_exc_unexpected_error then

467: 'N',
468: 'Y');
469:
470: EXCEPTION
471: when fnd_api.g_exc_unexpected_error then
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473:
474: fnd_msg_pub.count_and_get(
475: p_count => x_message_count

Line 472: x_return_status := fnd_api.g_ret_sts_unexp_error;

468: 'Y');
469:
470: EXCEPTION
471: when fnd_api.g_exc_unexpected_error then
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473:
474: fnd_msg_pub.count_and_get(
475: p_count => x_message_count
476: , p_data => x_message_data

Line 482: x_return_status := fnd_api.g_ret_sts_unexp_error;

478:
479: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
480:
481: when others then
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483:
484: if (fnd_msg_pub.check_msg_level
485: (fnd_msg_pub.g_msg_lvl_unexp_error))then
486: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);

Line 500: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

496:
497:
498: PROCEDURE delete_mtl_sales_orders_bulk(
499: p_api_version_number IN NUMBER,
500: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE,
502: x_message_data OUT NOCOPY VARCHAR2,
503: x_message_count OUT NOCOPY NUMBER,
504: x_return_status OUT NOCOPY VARCHAR2) IS

Line 511: if not fnd_api.compatible_api_call(

507: c_api_version_number CONSTANT NUMBER := 1.0 ;
508: c_api_name CONSTANT VARCHAR2(50):= 'DELETE_MTL_SALES_ORDERS_BULK';
509: BEGIN
510: -- check for api call compatibility
511: if not fnd_api.compatible_api_call(
512: c_api_version_number,
513: p_api_version_number,
514: c_api_name,
515: g_package_name) then

Line 516: raise fnd_api.g_exc_unexpected_error ;

512: c_api_version_number,
513: p_api_version_number,
514: c_api_name,
515: g_package_name) then
516: raise fnd_api.g_exc_unexpected_error ;
517: end if;
518:
519: -- initialize message list
520: if fnd_api.to_boolean(p_init_msg_list) then

Line 520: if fnd_api.to_boolean(p_init_msg_list) then

516: raise fnd_api.g_exc_unexpected_error ;
517: end if;
518:
519: -- initialize message list
520: if fnd_api.to_boolean(p_init_msg_list) then
521: fnd_msg_pub.initialize;
522: end if;
523:
524: -- initialize return status to success

Line 525: x_return_status := fnd_api.g_ret_sts_success;

521: fnd_msg_pub.initialize;
522: end if;
523:
524: -- initialize return status to success
525: x_return_status := fnd_api.g_ret_sts_success;
526:
527: --Delete MTL Sales Order Records
528: /*Bug3575085:Changed the sequence of the sub-query from b.name,a.order_number
529: to a.order_number,b.name*/

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: , p_data => x_message_data
546: , p_encoded => 'F');
547:
548: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:
551: END delete_mtl_sales_orders_bulk;
552:
553: end inv_salesorder ;