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.GMI_ALLOCATE_INVENTORY_PVT dependencies on FND_API

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: /*Initialize return status to success
150: ====================================*/
151: GMI_Reservation_Util.PrintLn('(Alloc PVT) GMIVALIB.pls Alloc Inventory Pvt');
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: /*Standard Start OF API savepoint
156: ================================*/
157: SAVEPOINT allocate_line;

Line 208: RAISE FND_API.G_EXC_ERROR;

204: /* dbms_output.put_line('allocation horizon is out - using '|| p_op_alot_prm.alloc_horizon); */
205: GMI_RESERVATION_UTIL.println('Allocation Horizon error: Scheduled ship date falls outside the allocation horizon');
206: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: /*If order UM differs from inventory UM, conversion is required.
212: The allocations are recorded as transactions written in the inventory UM

Line 359: IF(l_batch_rec.from_lot_no <> FND_API.G_MISS_CHAR AND

355: GMI_RESERVATION_UTIL.PrintLn('QC Grade to be used is '|| p_allocation_rec.prefqc_grade);
356:
357: GMI_RESERVATION_UTIL.PrintLn('Using a shelf date of '|| l_shelf_date );
358:
359: IF(l_batch_rec.from_lot_no <> FND_API.G_MISS_CHAR AND
360: nvl (l_batch_rec.from_lot_no,'%$%') <> '%$%')
361: THEN
362: l_where_clause := l_where_clause || ' and lot_no >= ';
363: l_where_clause := l_where_clause || '''' ;

Line 367: IF (l_batch_rec.to_lot_no <> FND_API.G_MISS_CHAR AND

363: l_where_clause := l_where_clause || '''' ;
364: l_where_clause := l_where_clause || l_batch_rec.from_lot_no ;
365: l_where_clause := l_where_clause || '''';
366:
367: IF (l_batch_rec.to_lot_no <> FND_API.G_MISS_CHAR AND
368: nvl (l_batch_rec.to_lot_no,'%$%') <> '%$%')
369: THEN
370: IF( l_batch_rec.from_lot_no <> l_batch_rec.to_lot_no)
371: THEN

Line 380: IF(l_batch_rec.to_lot_no <> FND_API.G_MISS_CHAR AND

376: l_lots_specified := 0;
377: END IF;
378:
379:
380: IF(l_batch_rec.to_lot_no <> FND_API.G_MISS_CHAR AND
381: nvl (l_batch_rec.to_lot_no,'%$%') <> '%$%')
382: THEN
383: l_where_clause := l_where_clause || ' and lot_no <= ';
384: l_where_clause := l_where_clause || '''' ;

Line 406: IF (l_batch_rec.from_sublot_no <> FND_API.G_MISS_CHAR and

402: RETURN;
403: END IF;
404:
405:
406: IF (l_batch_rec.from_sublot_no <> FND_API.G_MISS_CHAR and
407: nvl(l_batch_rec.from_sublot_no,'%$%') <> '%$%')
408: THEN
409: l_where_clause := l_where_clause || ' and sublot_no >= ';
410: l_where_clause := l_where_clause || '''' ;

Line 415: IF (l_batch_rec.to_sublot_no <> FND_API.G_MISS_CHAR and

411: l_where_clause := l_where_clause || l_batch_rec.from_sublot_no ;
412: l_where_clause := l_where_clause || '''';
413: END IF;
414:
415: IF (l_batch_rec.to_sublot_no <> FND_API.G_MISS_CHAR and
416: nvl(l_batch_rec.to_sublot_no,'%$%') <> '%$%')
417: THEN
418: l_where_clause := l_where_clause || ' and sublot_no <= ';
419: l_where_clause := l_where_clause || '''' ;

Line 428: IF ( TO_CHAR(l_batch_rec.from_creation_date) <> FND_API.G_MISS_CHAR AND

424: GMI_RESERVATION_UTIL.PrintLn('From creation date'|| l_batch_rec.from_creation_date);
425: GMI_RESERVATION_UTIL.PrintLn('to_char(from creation date)'|| to_char(l_batch_rec.from_creation_date));
426: GMI_RESERVATION_UTIL.PrintLn('(Auto_Alloc) 3 WHERE clause is now '|| l_where_clause);
427:
428: IF ( TO_CHAR(l_batch_rec.from_creation_date) <> FND_API.G_MISS_CHAR AND
429: TO_CHAR(l_batch_rec.from_creation_date, 'DD-MON-YYYY') <> ' ')
430: THEN
431: l_from_creation_date := TO_CHAR(l_batch_rec.from_creation_date,'DD-MON-YYYY');
432:

Line 447: IF ( TO_CHAR(l_batch_rec.to_creation_date) <> FND_API.G_MISS_CHAR AND

443: END IF;
444:
445: GMI_RESERVATION_UTIL.PrintLn('(Auto_alloc)4 WHERE clause is now '|| l_where_clause);
446:
447: IF ( TO_CHAR(l_batch_rec.to_creation_date) <> FND_API.G_MISS_CHAR AND
448: TO_CHAR(l_batch_rec.to_creation_date, 'DD-MON-YYYY') <> ' ')
449: THEN
450: l_to_creation_date := TO_CHAR((l_batch_rec.to_creation_date + 1),'DD-MON-YYYY');
451:

Line 464: IF ( TO_CHAR(l_batch_rec.from_expiration_date) <> FND_API.G_MISS_CHAR AND

460: l_where_clause := l_where_clause || '''';
461: l_where_clause := l_where_clause || ')';
462: END IF;
463:
464: IF ( TO_CHAR(l_batch_rec.from_expiration_date) <> FND_API.G_MISS_CHAR AND
465: TO_CHAR(l_batch_rec.from_expiration_date, 'DD-MON-YYYY') <> ' ')
466: THEN
467: l_from_expiration_date := TO_CHAR(l_batch_rec.from_expiration_date,'DD-MON-YYYY');
468:

Line 484: IF ( TO_CHAR(l_batch_rec.to_expiration_date) <> FND_API.G_MISS_CHAR AND

480: END IF;
481:
482: GMI_RESERVATION_UTIL.PrintLn('(Auto_Alloc) 5 WHERE clause is now '|| l_where_clause);
483:
484: IF ( TO_CHAR(l_batch_rec.to_expiration_date) <> FND_API.G_MISS_CHAR AND
485: TO_CHAR(l_batch_rec.to_expiration_date, 'DD-MON-YYYY') <> ' ')
486: THEN
487: l_to_expiration_date := TO_CHAR((l_batch_rec.to_expiration_date+1),'DD-MON-YYYY');
488:

Line 502: IF ( l_batch_rec.lot_status <> FND_API.G_MISS_CHAR AND

498: l_where_clause := l_where_clause || ')';
499: END IF;
500:
501:
502: IF ( l_batch_rec.lot_status <> FND_API.G_MISS_CHAR AND
503: nvl(l_batch_rec.lot_status,'%$%') <> '%$%')
504: THEN
505: l_where_clause := l_where_clause || ' and lot_status = ';
506: l_where_clause := l_where_clause || '''' ;

Line 511: IF ( l_batch_rec.location <> FND_API.G_MISS_CHAR AND

507: l_where_clause := l_where_clause || l_batch_rec.lot_status;
508: l_where_clause := l_where_clause || '''';
509: END IF;
510:
511: IF ( l_batch_rec.location <> FND_API.G_MISS_CHAR AND
512: nvl(l_batch_rec.location,'%$%') <> '%$%')
513: THEN
514: l_where_clause := l_where_clause || ' and location = ';
515: l_where_clause := l_where_clause || '''' ;

Line 854: p_init_msg_list => FND_API.G_TRUE,

850: GMI_Reservation_Util.PrintLn('(Alloc PVT) inserting trans ' );
851: GMI_SHIPPING_UTIL.print_debug(l_tran_rec,'inserting');
852: GMI_TRANS_ENGINE_PUB.create_pending_transaction
853: (p_api_version => 1.0,
854: p_init_msg_list => FND_API.G_TRUE,
855: p_commit => FND_API.G_FALSE,
856: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
857: p_tran_rec => l_tran_rec,
858: x_tran_row => l_tran_row,

Line 855: p_commit => FND_API.G_FALSE,

851: GMI_SHIPPING_UTIL.print_debug(l_tran_rec,'inserting');
852: GMI_TRANS_ENGINE_PUB.create_pending_transaction
853: (p_api_version => 1.0,
854: p_init_msg_list => FND_API.G_TRUE,
855: p_commit => FND_API.G_FALSE,
856: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
857: p_tran_rec => l_tran_rec,
858: x_tran_row => l_tran_row,
859: x_return_status => l_return_status,

Line 856: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

852: GMI_TRANS_ENGINE_PUB.create_pending_transaction
853: (p_api_version => 1.0,
854: p_init_msg_list => FND_API.G_TRUE,
855: p_commit => FND_API.G_FALSE,
856: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
857: p_tran_rec => l_tran_rec,
858: x_tran_row => l_tran_row,
859: x_return_status => l_return_status,
860: x_msg_count => l_msg_count,

Line 864: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

860: x_msg_count => l_msg_count,
861: x_msg_data => l_msg_data
862: );
863:
864: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: CLOSE ic_inventory_view_c1;
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: /* dbms_output.put_line('unexpected error back from txn engine'); */

Line 866: RAISE FND_API.G_EXC_ERROR;

862: );
863:
864: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: CLOSE ic_inventory_view_c1;
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: /* dbms_output.put_line('unexpected error back from txn engine'); */
869: CLOSE ic_inventory_view_c1;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 867: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

863:
864: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
865: CLOSE ic_inventory_view_c1;
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: /* dbms_output.put_line('unexpected error back from txn engine'); */
869: CLOSE ic_inventory_view_c1;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: /* dbms_output.put_line('unexpected error back from txn engine'); */
869: CLOSE ic_inventory_view_c1;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872: END IF; /* ===== END OF ALLOCATION */
873: END IF; /* result_flag = 1 OR l_grade_qcmatch_flag = 0*/
874: --2722339 EMC Auto Alloc QC Spec Match Project

Line 967: WHEN FND_API.G_EXC_ERROR THEN

963: ====================*/
964:
965: EXCEPTION
966:
967: WHEN FND_API.G_EXC_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
970: , p_count => x_msg_count
971: , p_data => x_msg_data

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964:
965: EXCEPTION
966:
967: WHEN FND_API.G_EXC_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
970: , p_count => x_msg_count
971: , p_data => x_msg_data
972: );

Line 969: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

965: EXCEPTION
966:
967: WHEN FND_API.G_EXC_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
970: , p_count => x_msg_count
971: , p_data => x_msg_data
972: );
973:

Line 974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

970: , p_count => x_msg_count
971: , p_data => x_msg_data
972: );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
977: , p_count => x_msg_count
978: , p_data => x_msg_data

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

971: , p_data => x_msg_data
972: );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );

Line 976: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

972: );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980: WHEN OTHERS THEN

Line 981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980: WHEN OTHERS THEN
981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982:
983: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
984: , l_api_name
985: );

Line 987: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

983: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
984: , l_api_name
985: );
986:
987: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
988: , p_count => x_msg_count
989: , p_data => x_msg_data
990: );
991:

Line 1049: x_return_status := FND_API.G_RET_STS_SUCCESS;

1045: /* dbms_output.put_line('start of balance_default_lot '); */
1046: /* dbms_output.put_line('one and two are ' || p_default_qty1 || ' and ' || p_default_qty2); */
1047: /*Initialize return status to success
1048: ====================================*/
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: IC$DEFAULT_LOCT := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
1052:
1053: /* dbms_output.put_line('DEFAULT LOT retrieved as '|| IC$DEFAULT_LOCT); */

Line 1106: p_init_msg_list => FND_API.G_TRUE,

1102: l_tran_rec.create_lot_index := 0;
1103: /* dbms_output.put_line('write a NEW default LOT txn'); */
1104: GMI_TRANS_ENGINE_PUB.create_pending_transaction
1105: (p_api_version => 1.0,
1106: p_init_msg_list => FND_API.G_TRUE,
1107: p_commit => FND_API.G_FALSE,
1108: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1109: p_tran_rec => l_tran_rec,
1110: x_tran_row => l_tran_row,

Line 1107: p_commit => FND_API.G_FALSE,

1103: /* dbms_output.put_line('write a NEW default LOT txn'); */
1104: GMI_TRANS_ENGINE_PUB.create_pending_transaction
1105: (p_api_version => 1.0,
1106: p_init_msg_list => FND_API.G_TRUE,
1107: p_commit => FND_API.G_FALSE,
1108: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1109: p_tran_rec => l_tran_rec,
1110: x_tran_row => l_tran_row,
1111: x_return_status => l_return_status,

Line 1108: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1104: GMI_TRANS_ENGINE_PUB.create_pending_transaction
1105: (p_api_version => 1.0,
1106: p_init_msg_list => FND_API.G_TRUE,
1107: p_commit => FND_API.G_FALSE,
1108: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1109: p_tran_rec => l_tran_rec,
1110: x_tran_row => l_tran_row,
1111: x_return_status => l_return_status,
1112: x_msg_count => l_msg_count,

Line 1116: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1112: x_msg_count => l_msg_count,
1113: x_msg_data => l_msg_data
1114: );
1115:
1116: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1119: /* dbms_output.put_line('unexpected error return from txn engine'); */
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: x_msg_data => l_msg_data
1114: );
1115:
1116: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1119: /* dbms_output.put_line('unexpected error return from txn engine'); */
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;

Line 1118: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1114: );
1115:
1116: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1119: /* dbms_output.put_line('unexpected error return from txn engine'); */
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122: ELSE

Line 1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1116: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1119: /* dbms_output.put_line('unexpected error return from txn engine'); */
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122: ELSE
1123: CLOSE ic_tran_pnd_c1;
1124:

Line 1164: p_init_msg_list => FND_API.G_TRUE,

1160: l_tran_rec.create_lot_index := 0;
1161: /* dbms_output.put_line('UPDATE the existing default LOT txn'); */
1162: GMI_TRANS_ENGINE_PUB.update_pending_transaction
1163: (p_api_version => 1.0,
1164: p_init_msg_list => FND_API.G_TRUE,
1165: p_commit => FND_API.G_FALSE,
1166: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1167: p_tran_rec => l_tran_rec,
1168: x_tran_row => l_tran_row,

Line 1165: p_commit => FND_API.G_FALSE,

1161: /* dbms_output.put_line('UPDATE the existing default LOT txn'); */
1162: GMI_TRANS_ENGINE_PUB.update_pending_transaction
1163: (p_api_version => 1.0,
1164: p_init_msg_list => FND_API.G_TRUE,
1165: p_commit => FND_API.G_FALSE,
1166: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1167: p_tran_rec => l_tran_rec,
1168: x_tran_row => l_tran_row,
1169: x_return_status => l_return_status,

Line 1166: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1162: GMI_TRANS_ENGINE_PUB.update_pending_transaction
1163: (p_api_version => 1.0,
1164: p_init_msg_list => FND_API.G_TRUE,
1165: p_commit => FND_API.G_FALSE,
1166: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1167: p_tran_rec => l_tran_rec,
1168: x_tran_row => l_tran_row,
1169: x_return_status => l_return_status,
1170: x_msg_count => l_msg_count,

Line 1180: WHEN FND_API.G_EXC_ERROR THEN

1176: /* EXCEPTION HANDLING
1177: ====================*/
1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1183: , p_count => x_msg_count
1184: , p_data => x_msg_data

Line 1181: x_return_status := FND_API.G_RET_STS_ERROR;

1177: ====================*/
1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1183: , p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );

Line 1182: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1183: , p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );
1186:

Line 1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1183: , p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1190: , p_count => x_msg_count
1191: , p_data => x_msg_data

Line 1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1184: , p_data => x_msg_data
1185: );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );

Line 1189: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1185: );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );
1193: WHEN OTHERS THEN

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195:
1196: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1197: , l_api_name
1198: );

Line 1200: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1196: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1197: , l_api_name
1198: );
1199:
1200: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1201: , p_count => x_msg_count
1202: , p_data => x_msg_data
1203: );
1204: