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
64: x_return_status := fnd_api.g_ret_sts_success;
66: -- start input parameter validation now
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);
76:
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:
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;
118: ,validation_date => l_validation_date
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
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
162: , p_encoded => 'F');
163:
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
170: , p_encoded => 'F');
171:
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);
178: end if;
179:
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);
178: end if;
179:
180: fnd_msg_pub.count_and_get(
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);
178: end if;
179:
180: fnd_msg_pub.count_and_get(
181: p_count => x_message_count
176: (fnd_msg_pub.g_msg_lvl_unexp_error))then
177: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);
178: end if;
179:
180: fnd_msg_pub.count_and_get(
181: p_count => x_message_count
182: , p_data => x_message_data
183: , p_encoded => 'F');
184:
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);
254: end if;
255:
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);
254: end if;
255:
256: end get_oeheader_for_salesorder;
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);
254: end if;
255:
256: end get_oeheader_for_salesorder;
257:
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
454: x_return_status := fnd_api.g_ret_sts_success;
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
490: , p_encoded => 'F');
491:
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);
500: end if;
501:
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);
500: end if;
501:
502: fnd_msg_pub.count_and_get(
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);
500: end if;
501:
502: fnd_msg_pub.count_and_get(
503: p_count => x_message_count
498: (fnd_msg_pub.g_msg_lvl_unexp_error))then
499: fnd_msg_pub.add_exc_msg(g_package_name,c_api_name);
500: end if;
501:
502: fnd_msg_pub.count_and_get(
503: p_count => x_message_count
504: , p_data => x_message_data
505: , p_encoded => 'F');
506: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
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
538: x_return_status := fnd_api.g_ret_sts_success;
552:
553:
554: EXCEPTION
555: when others then
556: fnd_msg_pub.count_and_get(
557: p_count => x_message_count
558: , p_data => x_message_data
559: , p_encoded => 'F');
560: