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.GMIVDBL dependencies on GMIGUTL

Line 295: GMIGUTL.DB_ERRNUM := NULL;

291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859
293: );
294:
295: GMIGUTL.DB_ERRNUM := NULL;
296:
297: -- TKW 9/11/2003 B2378017 Moved gmi_item_categories to Create_Item procedure.
298: --Jalaj Srivastava Bug 1735676
299: --Item Categories convergence

Line 312: GMIGUTL.DB_ERRNUM := SQLCODE;

308: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
310: FND_MSG_PUB.ADD;
311:
312: GMIGUTL.DB_ERRNUM := SQLCODE;
313: GMIGUTL.DB_ERRMSG:= SQLERRM;
314: RETURN FALSE;
315:
316: END ic_item_mst_insert;

Line 313: GMIGUTL.DB_ERRMSG:= SQLERRM;

309: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
310: FND_MSG_PUB.ADD;
311:
312: GMIGUTL.DB_ERRNUM := SQLCODE;
313: GMIGUTL.DB_ERRMSG:= SQLERRM;
314: RETURN FALSE;
315:
316: END ic_item_mst_insert;
317:

Line 409: GMIGUTL.DB_ERRNUM := SQLCODE;

405: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
406: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
407: FND_MSG_PUB.ADD;
408:
409: GMIGUTL.DB_ERRNUM := SQLCODE;
410: GMIGUTL.DB_ERRMSG:= SQLERRM;
411:
412: END mtl_item_categories_insert;
413: --END BUG#3151733 Anoop.

Line 410: GMIGUTL.DB_ERRMSG:= SQLERRM;

406: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
407: FND_MSG_PUB.ADD;
408:
409: GMIGUTL.DB_ERRNUM := SQLCODE;
410: GMIGUTL.DB_ERRMSG:= SQLERRM;
411:
412: END mtl_item_categories_insert;
413: --END BUG#3151733 Anoop.
414:

Line 822: GMIGUTL.DB_ERRNUM := NULL;

818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
819: WHERE item_id=p_ic_item_mst_row.item_id;
820: END IF;
821:
822: GMIGUTL.DB_ERRNUM := NULL;
823: RETURN TRUE;
824:
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN

Line 831: GMIGUTL.DB_ERRNUM := SQLCODE;

827: --Jalaj Srivastava Bug 1977956
828: --Do not add error using fnd_msg_pub.add
829: --This is a expected error.
830:
831: GMIGUTL.DB_ERRNUM := SQLCODE;
832: GMIGUTL.DB_ERRMSG:= SQLERRM;
833: RETURN FALSE;
834:
835: WHEN OTHERS THEN

Line 832: GMIGUTL.DB_ERRMSG:= SQLERRM;

828: --Do not add error using fnd_msg_pub.add
829: --This is a expected error.
830:
831: GMIGUTL.DB_ERRNUM := SQLCODE;
832: GMIGUTL.DB_ERRMSG:= SQLERRM;
833: RETURN FALSE;
834:
835: WHEN OTHERS THEN
836: -- Bug 1764383

Line 842: GMIGUTL.DB_ERRNUM := SQLCODE;

838: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
839: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
840: FND_MSG_PUB.ADD;
841:
842: GMIGUTL.DB_ERRNUM := SQLCODE;
843: GMIGUTL.DB_ERRMSG:= SQLERRM;
844: RETURN FALSE;
845:
846: END ic_item_mst_select;

Line 843: GMIGUTL.DB_ERRMSG:= SQLERRM;

839: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
840: FND_MSG_PUB.ADD;
841:
842: GMIGUTL.DB_ERRNUM := SQLCODE;
843: GMIGUTL.DB_ERRMSG:= SQLERRM;
844: RETURN FALSE;
845:
846: END ic_item_mst_select;
847:

Line 976: GMIGUTL.DB_ERRNUM := NULL;

972: , x_ic_lots_mst_row.attribute30
973: , x_ic_lots_mst_row.attribute_category
974: );
975:
976: GMIGUTL.DB_ERRNUM := NULL;
977: RETURN TRUE;
978:
979: EXCEPTION
980: WHEN OTHERS THEN

Line 987: GMIGUTL.DB_ERRNUM := SQLCODE;

983: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
984: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
985: FND_MSG_PUB.ADD;
986:
987: GMIGUTL.DB_ERRNUM := SQLCODE;
988: GMIGUTL.DB_ERRMSG:= SQLERRM;
989: RETURN FALSE;
990: END ic_lots_mst_insert;
991:

Line 988: GMIGUTL.DB_ERRMSG:= SQLERRM;

984: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
985: FND_MSG_PUB.ADD;
986:
987: GMIGUTL.DB_ERRNUM := SQLCODE;
988: GMIGUTL.DB_ERRMSG:= SQLERRM;
989: RETURN FALSE;
990: END ic_lots_mst_insert;
991:
992: FUNCTION ic_lots_mst_select

Line 1001: GMIGUTL.DB_ERRNUM := NULL;

997: SELECT * INTO x_ic_lots_mst_row FROM ic_lots_mst
998: WHERE item_id = p_ic_lots_mst_row.item_id AND
999: lot_no = p_ic_lots_mst_row.lot_no AND
1000: NVL(sublot_no,' ')=NVL(p_ic_lots_mst_row.sublot_no,' ');
1001: GMIGUTL.DB_ERRNUM := NULL;
1002: RETURN TRUE;
1003:
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN

Line 1010: GMIGUTL.DB_ERRNUM := SQLCODE;

1006: --Jalaj Srivastava Bug 1977956
1007: --Do not add error using fnd_msg_pub.add
1008: --This is a expected error.
1009:
1010: GMIGUTL.DB_ERRNUM := SQLCODE;
1011: GMIGUTL.DB_ERRMSG:= SQLERRM;
1012: RETURN FALSE;
1013:
1014: WHEN OTHERS THEN

Line 1011: GMIGUTL.DB_ERRMSG:= SQLERRM;

1007: --Do not add error using fnd_msg_pub.add
1008: --This is a expected error.
1009:
1010: GMIGUTL.DB_ERRNUM := SQLCODE;
1011: GMIGUTL.DB_ERRMSG:= SQLERRM;
1012: RETURN FALSE;
1013:
1014: WHEN OTHERS THEN
1015: -- Bug 1764383

Line 1021: GMIGUTL.DB_ERRNUM := SQLCODE;

1017: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1018: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1019: FND_MSG_PUB.ADD;
1020:
1021: GMIGUTL.DB_ERRNUM := SQLCODE;
1022: GMIGUTL.DB_ERRMSG:= SQLERRM;
1023: RETURN FALSE;
1024: END ic_lots_mst_select;
1025:

Line 1022: GMIGUTL.DB_ERRMSG:= SQLERRM;

1018: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1019: FND_MSG_PUB.ADD;
1020:
1021: GMIGUTL.DB_ERRNUM := SQLCODE;
1022: GMIGUTL.DB_ERRMSG:= SQLERRM;
1023: RETURN FALSE;
1024: END ic_lots_mst_select;
1025:
1026: FUNCTION ic_item_cpg_insert

Line 1056: GMIGUTL.DB_ERRNUM := NULL;

1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login
1054: );
1055:
1056: GMIGUTL.DB_ERRNUM := NULL;
1057: RETURN TRUE;
1058:
1059: EXCEPTION
1060: WHEN OTHERS THEN

Line 1067: GMIGUTL.DB_ERRNUM := SQLCODE;

1063: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1065: FND_MSG_PUB.ADD;
1066:
1067: GMIGUTL.DB_ERRNUM := SQLCODE;
1068: GMIGUTL.DB_ERRMSG:= SQLERRM;
1069: RETURN FALSE;
1070: END ic_item_cpg_insert;
1071:

Line 1068: GMIGUTL.DB_ERRMSG:= SQLERRM;

1064: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1065: FND_MSG_PUB.ADD;
1066:
1067: GMIGUTL.DB_ERRNUM := SQLCODE;
1068: GMIGUTL.DB_ERRMSG:= SQLERRM;
1069: RETURN FALSE;
1070: END ic_item_cpg_insert;
1071:
1072: FUNCTION ic_item_cpg_select

Line 1080: GMIGUTL.DB_ERRNUM := NULL;

1076: BEGIN
1077: SELECT * INTO x_ic_item_cpg_row FROM ic_item_cpg
1078: WHERE item_id = p_ic_item_cpg_row.item_id;
1079:
1080: GMIGUTL.DB_ERRNUM := NULL;
1081: RETURN TRUE;
1082:
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN

Line 1089: GMIGUTL.DB_ERRNUM := SQLCODE;

1085: --Jalaj Srivastava Bug 1977956
1086: --Do not add error using fnd_msg_pub.add
1087: --This is a expected error.
1088:
1089: GMIGUTL.DB_ERRNUM := SQLCODE;
1090: GMIGUTL.DB_ERRMSG:= SQLERRM;
1091: RETURN FALSE;
1092:
1093: WHEN OTHERS THEN

Line 1090: GMIGUTL.DB_ERRMSG:= SQLERRM;

1086: --Do not add error using fnd_msg_pub.add
1087: --This is a expected error.
1088:
1089: GMIGUTL.DB_ERRNUM := SQLCODE;
1090: GMIGUTL.DB_ERRMSG:= SQLERRM;
1091: RETURN FALSE;
1092:
1093: WHEN OTHERS THEN
1094: -- Bug 1764383

Line 1100: GMIGUTL.DB_ERRNUM := SQLCODE;

1096: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1097: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1098: FND_MSG_PUB.ADD;
1099:
1100: GMIGUTL.DB_ERRNUM := SQLCODE;
1101: GMIGUTL.DB_ERRMSG:= SQLERRM;
1102: RETURN FALSE;
1103: END ic_item_cpg_select;
1104:

Line 1101: GMIGUTL.DB_ERRMSG:= SQLERRM;

1097: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1098: FND_MSG_PUB.ADD;
1099:
1100: GMIGUTL.DB_ERRNUM := SQLCODE;
1101: GMIGUTL.DB_ERRMSG:= SQLERRM;
1102: RETURN FALSE;
1103: END ic_item_cpg_select;
1104:
1105: FUNCTION ic_lots_cpg_insert

Line 1137: GMIGUTL.DB_ERRNUM := NULL;

1133: , x_ic_lots_cpg_row.last_updated_by
1134: , x_ic_lots_cpg_row.last_update_login
1135: );
1136:
1137: GMIGUTL.DB_ERRNUM := NULL;
1138: RETURN TRUE;
1139:
1140: EXCEPTION
1141: WHEN OTHERS THEN

Line 1148: GMIGUTL.DB_ERRNUM := SQLCODE;

1144: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1145: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1146: FND_MSG_PUB.ADD;
1147:
1148: GMIGUTL.DB_ERRNUM := SQLCODE;
1149: GMIGUTL.DB_ERRMSG:= SQLERRM;
1150: RETURN FALSE;
1151: END ic_lots_cpg_insert;
1152:

Line 1149: GMIGUTL.DB_ERRMSG:= SQLERRM;

1145: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1146: FND_MSG_PUB.ADD;
1147:
1148: GMIGUTL.DB_ERRNUM := SQLCODE;
1149: GMIGUTL.DB_ERRMSG:= SQLERRM;
1150: RETURN FALSE;
1151: END ic_lots_cpg_insert;
1152:
1153: FUNCTION ic_lots_cpg_select

Line 1161: GMIGUTL.DB_ERRNUM := NULL;

1157:
1158: SELECT * INTO x_ic_lots_cpg_row FROM ic_lots_cpg
1159: WHERE item_id = p_ic_lots_cpg_row.item_id AND
1160: lot_id = p_ic_lots_cpg_row.lot_id;
1161: GMIGUTL.DB_ERRNUM := NULL;
1162: RETURN TRUE;
1163:
1164: EXCEPTION
1165: WHEN NO_DATA_FOUND THEN

Line 1170: GMIGUTL.DB_ERRNUM := SQLCODE;

1166: --Jalaj Srivastava Bug 1977956
1167: --Do not add error using fnd_msg_pub.add
1168: --This is a expected error.
1169:
1170: GMIGUTL.DB_ERRNUM := SQLCODE;
1171: GMIGUTL.DB_ERRMSG:= SQLERRM;
1172: RETURN FALSE;
1173:
1174: WHEN OTHERS THEN

Line 1171: GMIGUTL.DB_ERRMSG:= SQLERRM;

1167: --Do not add error using fnd_msg_pub.add
1168: --This is a expected error.
1169:
1170: GMIGUTL.DB_ERRNUM := SQLCODE;
1171: GMIGUTL.DB_ERRMSG:= SQLERRM;
1172: RETURN FALSE;
1173:
1174: WHEN OTHERS THEN
1175: -- Bug 1764383

Line 1181: GMIGUTL.DB_ERRNUM := SQLCODE;

1177: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1178: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1179: FND_MSG_PUB.ADD;
1180:
1181: GMIGUTL.DB_ERRNUM := SQLCODE;
1182: GMIGUTL.DB_ERRMSG:= SQLERRM;
1183: RETURN FALSE;
1184: END ic_lots_cpg_select;
1185:

Line 1182: GMIGUTL.DB_ERRMSG:= SQLERRM;

1178: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1179: FND_MSG_PUB.ADD;
1180:
1181: GMIGUTL.DB_ERRNUM := SQLCODE;
1182: GMIGUTL.DB_ERRMSG:= SQLERRM;
1183: RETURN FALSE;
1184: END ic_lots_cpg_select;
1185:
1186: FUNCTION ic_lots_sts_select

Line 1194: GMIGUTL.DB_ERRNUM := NULL;

1190:
1191: SELECT * INTO x_ic_lots_sts_row FROM ic_lots_sts
1192: WHERE lot_status= p_ic_lots_sts_row.lot_status;
1193:
1194: GMIGUTL.DB_ERRNUM := NULL;
1195: RETURN TRUE;
1196:
1197: EXCEPTION
1198: WHEN NO_DATA_FOUND THEN

Line 1203: GMIGUTL.DB_ERRNUM := SQLCODE;

1199: --Jalaj Srivastava Bug 1977956
1200: --Do not add error using fnd_msg_pub.add
1201: --This is a expected error.
1202:
1203: GMIGUTL.DB_ERRNUM := SQLCODE;
1204: GMIGUTL.DB_ERRMSG:= SQLERRM;
1205: RETURN FALSE;
1206:
1207: WHEN OTHERS THEN

Line 1204: GMIGUTL.DB_ERRMSG:= SQLERRM;

1200: --Do not add error using fnd_msg_pub.add
1201: --This is a expected error.
1202:
1203: GMIGUTL.DB_ERRNUM := SQLCODE;
1204: GMIGUTL.DB_ERRMSG:= SQLERRM;
1205: RETURN FALSE;
1206:
1207: WHEN OTHERS THEN
1208: -- Bug 1764383

Line 1214: GMIGUTL.DB_ERRNUM := SQLCODE;

1210: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1211: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1212: FND_MSG_PUB.ADD;
1213:
1214: GMIGUTL.DB_ERRNUM := SQLCODE;
1215: GMIGUTL.DB_ERRMSG:= SQLERRM;
1216: RETURN FALSE;
1217: END ic_lots_sts_select;
1218:

Line 1215: GMIGUTL.DB_ERRMSG:= SQLERRM;

1211: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1212: FND_MSG_PUB.ADD;
1213:
1214: GMIGUTL.DB_ERRNUM := SQLCODE;
1215: GMIGUTL.DB_ERRMSG:= SQLERRM;
1216: RETURN FALSE;
1217: END ic_lots_sts_select;
1218:
1219: FUNCTION ic_jrnl_mst_insert

Line 1334: GMIGUTL.DB_ERRNUM := NULL;

1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category
1332: );
1333: END IF;
1334: GMIGUTL.DB_ERRNUM := NULL;
1335: RETURN TRUE;
1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN

Line 1345: GMIGUTL.DB_ERRNUM := SQLCODE;

1341: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1343: FND_MSG_PUB.ADD;
1344:
1345: GMIGUTL.DB_ERRNUM := SQLCODE;
1346: GMIGUTL.DB_ERRMSG:= SQLERRM;
1347: RETURN FALSE;
1348: END ic_jrnl_mst_insert;
1349:

Line 1346: GMIGUTL.DB_ERRMSG:= SQLERRM;

1342: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1343: FND_MSG_PUB.ADD;
1344:
1345: GMIGUTL.DB_ERRNUM := SQLCODE;
1346: GMIGUTL.DB_ERRMSG:= SQLERRM;
1347: RETURN FALSE;
1348: END ic_jrnl_mst_insert;
1349:
1350: FUNCTION ic_jrnl_mst_select

Line 1366: GMIGUTL.DB_ERRNUM := NULL;

1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;
1365: END IF;
1366: GMIGUTL.DB_ERRNUM := NULL;
1367: RETURN TRUE;
1368:
1369: EXCEPTION
1370: WHEN NO_DATA_FOUND THEN

Line 1375: GMIGUTL.DB_ERRNUM := SQLCODE;

1371: --Jalaj Srivastava Bug 1977956
1372: --Do not add error using fnd_msg_pub.add
1373: --This is a expected error.
1374:
1375: GMIGUTL.DB_ERRNUM := SQLCODE;
1376: GMIGUTL.DB_ERRMSG:= SQLERRM;
1377: RETURN FALSE;
1378:
1379: WHEN OTHERS THEN

Line 1376: GMIGUTL.DB_ERRMSG:= SQLERRM;

1372: --Do not add error using fnd_msg_pub.add
1373: --This is a expected error.
1374:
1375: GMIGUTL.DB_ERRNUM := SQLCODE;
1376: GMIGUTL.DB_ERRMSG:= SQLERRM;
1377: RETURN FALSE;
1378:
1379: WHEN OTHERS THEN
1380: -- Bug 1764383

Line 1386: GMIGUTL.DB_ERRNUM := SQLCODE;

1382: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1383: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1384: FND_MSG_PUB.ADD;
1385:
1386: GMIGUTL.DB_ERRNUM := SQLCODE;
1387: GMIGUTL.DB_ERRMSG:= SQLERRM;
1388: RETURN FALSE;
1389: END ic_jrnl_mst_select;
1390:

Line 1387: GMIGUTL.DB_ERRMSG:= SQLERRM;

1383: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1384: FND_MSG_PUB.ADD;
1385:
1386: GMIGUTL.DB_ERRNUM := SQLCODE;
1387: GMIGUTL.DB_ERRMSG:= SQLERRM;
1388: RETURN FALSE;
1389: END ic_jrnl_mst_select;
1390:
1391: FUNCTION ic_adjs_jnl_insert

Line 1477: GMIGUTL.DB_ERRNUM := NULL;

1473: , x_ic_adjs_jnl_row.acctg_unit_id
1474: , x_ic_adjs_jnl_row.acct_id
1475: );
1476:
1477: GMIGUTL.DB_ERRNUM := NULL;
1478: RETURN TRUE;
1479:
1480: EXCEPTION
1481: WHEN OTHERS THEN

Line 1488: GMIGUTL.DB_ERRNUM := SQLCODE;

1484: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1485: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1486: FND_MSG_PUB.ADD;
1487:
1488: GMIGUTL.DB_ERRNUM := SQLCODE;
1489: GMIGUTL.DB_ERRMSG:= SQLERRM;
1490: RETURN FALSE;
1491: END ic_adjs_jnl_insert;
1492:

Line 1489: GMIGUTL.DB_ERRMSG:= SQLERRM;

1485: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1486: FND_MSG_PUB.ADD;
1487:
1488: GMIGUTL.DB_ERRNUM := SQLCODE;
1489: GMIGUTL.DB_ERRMSG:= SQLERRM;
1490: RETURN FALSE;
1491: END ic_adjs_jnl_insert;
1492:
1493: FUNCTION sy_reas_cds_select

Line 1501: GMIGUTL.DB_ERRNUM := NULL;

1497: BEGIN
1498: SELECT * INTO x_sy_reas_cds_row FROM sy_reas_cds
1499: WHERE reason_code = p_sy_reas_cds_row.reason_code;
1500:
1501: GMIGUTL.DB_ERRNUM := NULL;
1502: RETURN TRUE;
1503:
1504: EXCEPTION
1505: WHEN NO_DATA_FOUND THEN

Line 1510: GMIGUTL.DB_ERRNUM := SQLCODE;

1506: --Jalaj Srivastava Bug 1977956
1507: --Do not add error using fnd_msg_pub.add
1508: --This is a expected error.
1509:
1510: GMIGUTL.DB_ERRNUM := SQLCODE;
1511: GMIGUTL.DB_ERRMSG:= SQLERRM;
1512: RETURN FALSE;
1513:
1514: WHEN OTHERS THEN

Line 1511: GMIGUTL.DB_ERRMSG:= SQLERRM;

1507: --Do not add error using fnd_msg_pub.add
1508: --This is a expected error.
1509:
1510: GMIGUTL.DB_ERRNUM := SQLCODE;
1511: GMIGUTL.DB_ERRMSG:= SQLERRM;
1512: RETURN FALSE;
1513:
1514: WHEN OTHERS THEN
1515: -- Bug 1764383

Line 1521: GMIGUTL.DB_ERRNUM := SQLCODE;

1517: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1518: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1519: FND_MSG_PUB.ADD;
1520:
1521: GMIGUTL.DB_ERRNUM := SQLCODE;
1522: GMIGUTL.DB_ERRMSG:= SQLERRM;
1523: RETURN FALSE;
1524: END sy_reas_cds_select;
1525:

Line 1522: GMIGUTL.DB_ERRMSG:= SQLERRM;

1518: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1519: FND_MSG_PUB.ADD;
1520:
1521: GMIGUTL.DB_ERRNUM := SQLCODE;
1522: GMIGUTL.DB_ERRMSG:= SQLERRM;
1523: RETURN FALSE;
1524: END sy_reas_cds_select;
1525:
1526:

Line 1618: GMIGUTL.DB_ERRNUM := NULL;

1614: , p_ic_item_cnv_row.last_update_date
1615: );
1616:
1617:
1618: GMIGUTL.DB_ERRNUM := NULL;
1619: RETURN TRUE;
1620:
1621: EXCEPTION
1622: WHEN OTHERS THEN

Line 1629: GMIGUTL.DB_ERRNUM := SQLCODE;

1625: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1627: FND_MSG_PUB.ADD;
1628:
1629: GMIGUTL.DB_ERRNUM := SQLCODE;
1630: GMIGUTL.DB_ERRMSG:= SQLERRM;
1631: RETURN FALSE;
1632: END ic_item_cnv_insert;
1633:

Line 1630: GMIGUTL.DB_ERRMSG:= SQLERRM;

1626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1627: FND_MSG_PUB.ADD;
1628:
1629: GMIGUTL.DB_ERRNUM := SQLCODE;
1630: GMIGUTL.DB_ERRMSG:= SQLERRM;
1631: RETURN FALSE;
1632: END ic_item_cnv_insert;
1633:
1634: FUNCTION sy_uoms_mst_select

Line 1642: GMIGUTL.DB_ERRNUM := NULL;

1638: BEGIN
1639: SELECT * INTO x_sy_uoms_mst_row FROM sy_uoms_mst
1640: WHERE um_code = p_sy_uoms_mst_row.um_code AND delete_mark=0;
1641:
1642: GMIGUTL.DB_ERRNUM := NULL;
1643: RETURN TRUE;
1644:
1645: EXCEPTION
1646: WHEN NO_DATA_FOUND THEN

Line 1651: GMIGUTL.DB_ERRNUM := SQLCODE;

1647: --Jalaj Srivastava Bug 1977956
1648: --Do not add error using fnd_msg_pub.add
1649: --This is a expected error.
1650:
1651: GMIGUTL.DB_ERRNUM := SQLCODE;
1652: GMIGUTL.DB_ERRMSG:= SQLERRM;
1653: RETURN FALSE;
1654:
1655: WHEN OTHERS THEN

Line 1652: GMIGUTL.DB_ERRMSG:= SQLERRM;

1648: --Do not add error using fnd_msg_pub.add
1649: --This is a expected error.
1650:
1651: GMIGUTL.DB_ERRNUM := SQLCODE;
1652: GMIGUTL.DB_ERRMSG:= SQLERRM;
1653: RETURN FALSE;
1654:
1655: WHEN OTHERS THEN
1656: -- Bug 1764383

Line 1662: GMIGUTL.DB_ERRNUM := SQLCODE;

1658: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1659: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1660: FND_MSG_PUB.ADD;
1661:
1662: GMIGUTL.DB_ERRNUM := SQLCODE;
1663: GMIGUTL.DB_ERRMSG:= SQLERRM;
1664: RETURN FALSE;
1665: END sy_uoms_mst_select;
1666:

Line 1663: GMIGUTL.DB_ERRMSG:= SQLERRM;

1659: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1660: FND_MSG_PUB.ADD;
1661:
1662: GMIGUTL.DB_ERRNUM := SQLCODE;
1663: GMIGUTL.DB_ERRMSG:= SQLERRM;
1664: RETURN FALSE;
1665: END sy_uoms_mst_select;
1666:
1667: FUNCTION sy_uoms_typ_select

Line 1675: GMIGUTL.DB_ERRNUM := NULL;

1671: BEGIN
1672: SELECT * INTO x_sy_uoms_typ_row FROM sy_uoms_typ
1673: WHERE um_type = p_sy_uoms_typ_row.um_type AND delete_mark=0;
1674:
1675: GMIGUTL.DB_ERRNUM := NULL;
1676: RETURN TRUE;
1677:
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN

Line 1684: GMIGUTL.DB_ERRNUM := SQLCODE;

1680: --Jalaj Srivastava Bug 1977956
1681: --Do not add error using fnd_msg_pub.add
1682: --This is a expected error.
1683:
1684: GMIGUTL.DB_ERRNUM := SQLCODE;
1685: GMIGUTL.DB_ERRMSG:= SQLERRM;
1686: RETURN FALSE;
1687:
1688: WHEN OTHERS THEN

Line 1685: GMIGUTL.DB_ERRMSG:= SQLERRM;

1681: --Do not add error using fnd_msg_pub.add
1682: --This is a expected error.
1683:
1684: GMIGUTL.DB_ERRNUM := SQLCODE;
1685: GMIGUTL.DB_ERRMSG:= SQLERRM;
1686: RETURN FALSE;
1687:
1688: WHEN OTHERS THEN
1689: -- Bug 1764383

Line 1695: GMIGUTL.DB_ERRNUM := SQLCODE;

1691: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1693: FND_MSG_PUB.ADD;
1694:
1695: GMIGUTL.DB_ERRNUM := SQLCODE;
1696: GMIGUTL.DB_ERRMSG:= SQLERRM;
1697: RETURN FALSE;
1698: END sy_uoms_typ_select;
1699:

Line 1696: GMIGUTL.DB_ERRMSG:= SQLERRM;

1692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1693: FND_MSG_PUB.ADD;
1694:
1695: GMIGUTL.DB_ERRNUM := SQLCODE;
1696: GMIGUTL.DB_ERRMSG:= SQLERRM;
1697: RETURN FALSE;
1698: END sy_uoms_typ_select;
1699:
1700:

Line 1713: GMIGUTL.DB_ERRNUM := NULL;

1709: BEGIN
1710: SELECT * INTO x_ic_whse_mst_row FROM ic_whse_mst
1711: WHERE whse_code = p_ic_whse_mst_row.whse_code AND delete_mark=0;
1712:
1713: GMIGUTL.DB_ERRNUM := NULL;
1714: RETURN TRUE;
1715:
1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN

Line 1722: GMIGUTL.DB_ERRNUM := SQLCODE;

1718: --Jalaj Srivastava Bug 1977956
1719: --Do not add error using fnd_msg_pub.add
1720: --This is a expected error.
1721:
1722: GMIGUTL.DB_ERRNUM := SQLCODE;
1723: GMIGUTL.DB_ERRMSG:= SQLERRM;
1724: RETURN FALSE;
1725:
1726: WHEN OTHERS THEN

Line 1723: GMIGUTL.DB_ERRMSG:= SQLERRM;

1719: --Do not add error using fnd_msg_pub.add
1720: --This is a expected error.
1721:
1722: GMIGUTL.DB_ERRNUM := SQLCODE;
1723: GMIGUTL.DB_ERRMSG:= SQLERRM;
1724: RETURN FALSE;
1725:
1726: WHEN OTHERS THEN
1727: -- Bug 1764383

Line 1733: GMIGUTL.DB_ERRNUM := SQLCODE;

1729: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1731: FND_MSG_PUB.ADD;
1732:
1733: GMIGUTL.DB_ERRNUM := SQLCODE;
1734: GMIGUTL.DB_ERRMSG:= SQLERRM;
1735: RETURN FALSE;
1736: END ic_whse_mst_select;
1737:

Line 1734: GMIGUTL.DB_ERRMSG:= SQLERRM;

1730: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1731: FND_MSG_PUB.ADD;
1732:
1733: GMIGUTL.DB_ERRNUM := SQLCODE;
1734: GMIGUTL.DB_ERRMSG:= SQLERRM;
1735: RETURN FALSE;
1736: END ic_whse_mst_select;
1737:
1738: FUNCTION ic_loct_inv_select

Line 1751: GMIGUTL.DB_ERRNUM := NULL;

1747: location = NVL(p_ic_loct_inv_row.location, location) AND
1748: ROWNUM = 1
1749: AND delete_mark=0;
1750:
1751: GMIGUTL.DB_ERRNUM := NULL;
1752: RETURN TRUE;
1753:
1754: EXCEPTION
1755: WHEN NO_DATA_FOUND

Line 1758: GMIGUTL.DB_ERRNUM := SQLCODE;

1754: EXCEPTION
1755: WHEN NO_DATA_FOUND
1756: THEN
1757: x_ic_loct_inv_row.loct_onhand:= NULL;
1758: GMIGUTL.DB_ERRNUM := SQLCODE;
1759: GMIGUTL.DB_ERRMSG:= SQLERRM;
1760: RETURN FALSE;
1761:
1762: WHEN OTHERS THEN

Line 1759: GMIGUTL.DB_ERRMSG:= SQLERRM;

1755: WHEN NO_DATA_FOUND
1756: THEN
1757: x_ic_loct_inv_row.loct_onhand:= NULL;
1758: GMIGUTL.DB_ERRNUM := SQLCODE;
1759: GMIGUTL.DB_ERRMSG:= SQLERRM;
1760: RETURN FALSE;
1761:
1762: WHEN OTHERS THEN
1763: -- Bug 1764383

Line 1769: GMIGUTL.DB_ERRNUM := SQLCODE;

1765: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1766: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1767: FND_MSG_PUB.ADD;
1768:
1769: GMIGUTL.DB_ERRNUM := SQLCODE;
1770: GMIGUTL.DB_ERRMSG:= SQLERRM;
1771: RETURN FALSE;
1772: END ic_loct_inv_select;
1773:

Line 1770: GMIGUTL.DB_ERRMSG:= SQLERRM;

1766: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1767: FND_MSG_PUB.ADD;
1768:
1769: GMIGUTL.DB_ERRNUM := SQLCODE;
1770: GMIGUTL.DB_ERRMSG:= SQLERRM;
1771: RETURN FALSE;
1772: END ic_loct_inv_select;
1773:
1774: FUNCTION qc_grad_mst_select

Line 1782: GMIGUTL.DB_ERRNUM := NULL;

1778: BEGIN
1779: SELECT * INTO x_qc_grad_mst_row FROM qc_grad_mst
1780: WHERE qc_grade = p_qc_grad_mst_row.qc_grade AND delete_mark=0;
1781:
1782: GMIGUTL.DB_ERRNUM := NULL;
1783: RETURN TRUE;
1784:
1785: EXCEPTION
1786: WHEN NO_DATA_FOUND THEN

Line 1791: GMIGUTL.DB_ERRNUM := SQLCODE;

1787: --Jalaj Srivastava Bug 1977956
1788: --Do not add error using fnd_msg_pub.add
1789: --This is a expected error.
1790:
1791: GMIGUTL.DB_ERRNUM := SQLCODE;
1792: GMIGUTL.DB_ERRMSG:= SQLERRM;
1793: RETURN FALSE;
1794:
1795: WHEN OTHERS THEN

Line 1792: GMIGUTL.DB_ERRMSG:= SQLERRM;

1788: --Do not add error using fnd_msg_pub.add
1789: --This is a expected error.
1790:
1791: GMIGUTL.DB_ERRNUM := SQLCODE;
1792: GMIGUTL.DB_ERRMSG:= SQLERRM;
1793: RETURN FALSE;
1794:
1795: WHEN OTHERS THEN
1796: -- Bug 1764383

Line 1802: GMIGUTL.DB_ERRNUM := SQLCODE;

1798: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1799: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1800: FND_MSG_PUB.ADD;
1801:
1802: GMIGUTL.DB_ERRNUM := SQLCODE;
1803: GMIGUTL.DB_ERRMSG:= SQLERRM;
1804: RETURN FALSE;
1805: END qc_grad_mst_select;
1806:

Line 1803: GMIGUTL.DB_ERRMSG:= SQLERRM;

1799: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1800: FND_MSG_PUB.ADD;
1801:
1802: GMIGUTL.DB_ERRNUM := SQLCODE;
1803: GMIGUTL.DB_ERRMSG:= SQLERRM;
1804: RETURN FALSE;
1805: END qc_grad_mst_select;
1806:
1807: FUNCTION qc_actn_mst_select

Line 1815: GMIGUTL.DB_ERRNUM := NULL;

1811: BEGIN
1812: SELECT * INTO x_qc_actn_mst_row FROM qc_actn_mst
1813: WHERE action_code = p_qc_actn_mst_row.action_code AND delete_mark=0;
1814:
1815: GMIGUTL.DB_ERRNUM := NULL;
1816: RETURN TRUE;
1817:
1818: EXCEPTION
1819: WHEN NO_DATA_FOUND THEN

Line 1824: GMIGUTL.DB_ERRNUM := SQLCODE;

1820: --Jalaj Srivastava Bug 1977956
1821: --Do not add error using fnd_msg_pub.add
1822: --This is a expected error.
1823:
1824: GMIGUTL.DB_ERRNUM := SQLCODE;
1825: GMIGUTL.DB_ERRMSG:= SQLERRM;
1826: RETURN FALSE;
1827:
1828: WHEN OTHERS THEN

Line 1825: GMIGUTL.DB_ERRMSG:= SQLERRM;

1821: --Do not add error using fnd_msg_pub.add
1822: --This is a expected error.
1823:
1824: GMIGUTL.DB_ERRNUM := SQLCODE;
1825: GMIGUTL.DB_ERRMSG:= SQLERRM;
1826: RETURN FALSE;
1827:
1828: WHEN OTHERS THEN
1829: -- Bug 1764383

Line 1835: GMIGUTL.DB_ERRNUM := SQLCODE;

1831: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1832: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1833: FND_MSG_PUB.ADD;
1834:
1835: GMIGUTL.DB_ERRNUM := SQLCODE;
1836: GMIGUTL.DB_ERRMSG:= SQLERRM;
1837: RETURN FALSE;
1838: END qc_actn_mst_select;
1839:

Line 1836: GMIGUTL.DB_ERRMSG:= SQLERRM;

1832: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1833: FND_MSG_PUB.ADD;
1834:
1835: GMIGUTL.DB_ERRNUM := SQLCODE;
1836: GMIGUTL.DB_ERRMSG:= SQLERRM;
1837: RETURN FALSE;
1838: END qc_actn_mst_select;
1839:
1840: FUNCTION po_vend_mst_select

Line 1849: GMIGUTL.DB_ERRNUM := NULL;

1845: SELECT * INTO x_po_vend_mst_row FROM po_vend_mst
1846: WHERE vendor_no=p_po_vend_mst_row.vendor_no AND delete_mark=0 AND
1847: rownum=1;
1848:
1849: GMIGUTL.DB_ERRNUM := NULL;
1850: RETURN TRUE;
1851:
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN

Line 1858: GMIGUTL.DB_ERRNUM := SQLCODE;

1854: --Jalaj Srivastava Bug 1977956
1855: --Do not add error using fnd_msg_pub.add
1856: --This is a expected error.
1857:
1858: GMIGUTL.DB_ERRNUM := SQLCODE;
1859: GMIGUTL.DB_ERRMSG:= SQLERRM;
1860: RETURN FALSE;
1861:
1862: WHEN OTHERS THEN

Line 1859: GMIGUTL.DB_ERRMSG:= SQLERRM;

1855: --Do not add error using fnd_msg_pub.add
1856: --This is a expected error.
1857:
1858: GMIGUTL.DB_ERRNUM := SQLCODE;
1859: GMIGUTL.DB_ERRMSG:= SQLERRM;
1860: RETURN FALSE;
1861:
1862: WHEN OTHERS THEN
1863: -- Bug 1764383

Line 1869: GMIGUTL.DB_ERRNUM := SQLCODE;

1865: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1866: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1867: FND_MSG_PUB.ADD;
1868:
1869: GMIGUTL.DB_ERRNUM := SQLCODE;
1870: GMIGUTL.DB_ERRMSG:= SQLERRM;
1871: RETURN FALSE;
1872: END po_vend_mst_select;
1873: /*

Line 1870: GMIGUTL.DB_ERRMSG:= SQLERRM;

1866: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1867: FND_MSG_PUB.ADD;
1868:
1869: GMIGUTL.DB_ERRNUM := SQLCODE;
1870: GMIGUTL.DB_ERRMSG:= SQLERRM;
1871: RETURN FALSE;
1872: END po_vend_mst_select;
1873: /*
1874:

Line 1884: GMIGUTL.DB_ERRNUM := NULL;

1880: SELECT * INTO x_ic_xfer_mst_row FROM ic_xfer_mst
1881: WHERE orgn_code = p_ic_xfer_mst_row.orgn_code AND
1882: transfer_no = p_ic_xfer_mst_row.transfer_no;
1883:
1884: GMIGUTL.DB_ERRNUM := NULL;
1885: RETURN TRUE;
1886:
1887: EXCEPTION
1888: WHEN NO_DATA_FOUND THEN

Line 1893: GMIGUTL.DB_ERRNUM := SQLCODE;

1889: --Jalaj Srivastava Bug 1977956
1890: --Do not add error using fnd_msg_pub.add
1891: --This is a expected error.
1892:
1893: GMIGUTL.DB_ERRNUM := SQLCODE;
1894: GMIGUTL.DB_ERRMSG:= SQLERRM;
1895: RETURN FALSE;
1896:
1897: WHEN OTHERS THEN

Line 1894: GMIGUTL.DB_ERRMSG:= SQLERRM;

1890: --Do not add error using fnd_msg_pub.add
1891: --This is a expected error.
1892:
1893: GMIGUTL.DB_ERRNUM := SQLCODE;
1894: GMIGUTL.DB_ERRMSG:= SQLERRM;
1895: RETURN FALSE;
1896:
1897: WHEN OTHERS THEN
1898: -- Bug 1764383

Line 1904: GMIGUTL.DB_ERRNUM := SQLCODE;

1900: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1901: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1902: FND_MSG_PUB.ADD;
1903:
1904: GMIGUTL.DB_ERRNUM := SQLCODE;
1905: GMIGUTL.DB_ERRMSG:= SQLERRM;
1906: RETURN FALSE;
1907: END ic_xfer_mst_select;
1908:

Line 1905: GMIGUTL.DB_ERRMSG:= SQLERRM;

1901: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1902: FND_MSG_PUB.ADD;
1903:
1904: GMIGUTL.DB_ERRNUM := SQLCODE;
1905: GMIGUTL.DB_ERRMSG:= SQLERRM;
1906: RETURN FALSE;
1907: END ic_xfer_mst_select;
1908:
1909:

Line 2059: GMIGUTL.DB_ERRNUM := NULL;

2055: x_ic_xfer_mst_row.last_updated_by ,
2056: x_ic_xfer_mst_row.last_update_date ,
2057: x_ic_xfer_mst_row.last_update_login);
2058:
2059: GMIGUTL.DB_ERRNUM := NULL;
2060: RETURN TRUE;
2061:
2062: EXCEPTION
2063: WHEN OTHERS THEN

Line 2070: GMIGUTL.DB_ERRNUM := SQLCODE;

2066: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2068: FND_MSG_PUB.ADD;
2069:
2070: GMIGUTL.DB_ERRNUM := SQLCODE;
2071: GMIGUTL.DB_ERRMSG:= SQLERRM;
2072: RETURN FALSE;
2073:
2074: END ic_xfer_mst_insert;

Line 2071: GMIGUTL.DB_ERRMSG:= SQLERRM;

2067: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2068: FND_MSG_PUB.ADD;
2069:
2070: GMIGUTL.DB_ERRNUM := SQLCODE;
2071: GMIGUTL.DB_ERRMSG:= SQLERRM;
2072: RETURN FALSE;
2073:
2074: END ic_xfer_mst_insert;
2075:

Line 2154: GMIGUTL.DB_ERRNUM := NULL;

2150: last_update_login = x_ic_xfer_mst_row.last_update_login
2151: WHERE
2152: transfer_no= p_ic_xfer_mst_row.transfer_no AND
2153: orgn_code = p_ic_xfer_mst_row.orgn_code;
2154: GMIGUTL.DB_ERRNUM := NULL;
2155: RETURN TRUE;
2156:
2157: EXCEPTION
2158: WHEN OTHERS THEN

Line 2165: GMIGUTL.DB_ERRNUM := SQLCODE;

2161: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2162: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2163: FND_MSG_PUB.ADD;
2164:
2165: GMIGUTL.DB_ERRNUM := SQLCODE;
2166: GMIGUTL.DB_ERRMSG:= SQLERRM;
2167: RETURN FALSE;
2168:
2169: END ic_xfer_mst_update;

Line 2166: GMIGUTL.DB_ERRMSG:= SQLERRM;

2162: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2163: FND_MSG_PUB.ADD;
2164:
2165: GMIGUTL.DB_ERRNUM := SQLCODE;
2166: GMIGUTL.DB_ERRMSG:= SQLERRM;
2167: RETURN FALSE;
2168:
2169: END ic_xfer_mst_update;
2170: */