14: p_desc IN VARCHAR2
15: ) RETURN VARCHAR2 IS
16: BEGIN
17: IF LENGTHB(p_value) NOT BETWEEN p_min AND p_max THEN /* bug 4002567*/
18: ITG_Debug.msg('cs', 'Length check failed for field '||p_desc);
19: ITG_MSG.data_value_error(p_value, p_min, p_max);
20: RAISE FND_API.G_EXC_ERROR;
21: END IF;
22: RETURN p_value;
1198:
1199: g_action := 'UOM sync';
1200:
1201: SAVEPOINT Sync_UOM_ALL;
1202: ITG_Debug.setup(
1203: p_reset => TRUE,
1204: p_pkg_name => G_PKG_NAME,
1205: p_proc_name => l_api_name);
1206:
1207:
1208: -- Now in wrapper FND_MSG_PUB.Initialize;
1209:
1210: /* NOTE: Add more tracing, esp. called procedures */
1211: ITG_Debug.msg('SUA', 'Top of procedure.');
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1208: -- Now in wrapper FND_MSG_PUB.Initialize;
1209:
1210: /* NOTE: Add more tracing, esp. called procedures */
1211: ITG_Debug.msg('SUA', 'Top of procedure.');
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1209:
1210: /* NOTE: Add more tracing, esp. called procedures */
1211: ITG_Debug.msg('SUA', 'Top of procedure.');
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1210: /* NOTE: Add more tracing, esp. called procedures */
1211: ITG_Debug.msg('SUA', 'Top of procedure.');
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1211: ITG_Debug.msg('SUA', 'Top of procedure.');
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1212: ITG_Debug.msg('SUA', 'p_task', p_task);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1218: ITG_Debug.msg('SUA', 'p_description', p_description);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);
1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);
1227:
1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, TRUE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);
1227:
1228: l_dt_creation := NVL(p_dt_creation, SYSDATE);
1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, TRUE);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);
1227:
1228: l_dt_creation := NVL(p_dt_creation, SYSDATE);
1229: l_dt_expiration := NVL(p_dt_expiration,l_dt_creation+3650);
1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);
1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);
1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);
1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);
1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);
1227:
1228: l_dt_creation := NVL(p_dt_creation, SYSDATE);
1229: l_dt_expiration := NVL(p_dt_expiration,l_dt_creation+3650);
1230:
1271: END IF;
1272:
1273: COMMIT WORK;
1274:
1275: ITG_Debug.msg('SUA', 'Done.');
1276:
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO Sync_UOM_ALL;
1283: WHEN OTHERS THEN
1284: ROLLBACK TO Sync_UOM_ALL;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: ITG_msg.unexpected_error(g_action);
1287: itg_debug.msg('Unexpected error (UOMSync) - ' || substr(SQLERRM,1,255),true);
1288:
1289: -- Removed FND_MSG_PUB.Count_And_Get
1290:
1291: END Sync_UOM_ALL;