DBA Data[Home] [Help]

APPS.ITG_SYNCUOMINBOUND_PVT dependencies on ITG_DEBUG

Line 18: ITG_Debug.msg('cs', 'Length check failed for field '||p_desc);

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;

Line 1202: ITG_Debug.setup(

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:

Line 1211: ITG_Debug.msg('SUA', 'Top of procedure.');

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);

Line 1212: ITG_Debug.msg('SUA', 'p_task', p_task);

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);

Line 1213: ITG_Debug.msg('SUA', 'p_syncind', p_syncind);

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);

Line 1214: ITG_Debug.msg('SUA', 'p_uom', p_uom);

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);

Line 1215: ITG_Debug.msg('SUA', 'p_uomcode', p_uomcode);

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);

Line 1216: ITG_Debug.msg('SUA', 'p_uomclass', p_uomclass);

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);

Line 1217: ITG_Debug.msg('SUA', 'p_buomflag', p_buomflag);

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);

Line 1218: ITG_Debug.msg('SUA', 'p_description', p_description);

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);

Line 1219: ITG_Debug.msg('SUA', 'p_defconflg', p_defconflg);

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);

Line 1220: ITG_Debug.msg('SUA', 'p_fromcode', p_fromcode, 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);

Line 1221: ITG_Debug.msg('SUA', 'p_touomcode', p_touomcode, 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);

Line 1222: ITG_Debug.msg('SUA', 'p_itemid', p_itemid);

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);

Line 1223: ITG_Debug.msg('SUA', 'p_fromfactor', p_fromfactor, TRUE);

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:

Line 1224: ITG_Debug.msg('SUA', 'p_tofactor', p_tofactor, TRUE);

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);

Line 1225: ITG_Debug.msg('SUA', 'p_dt_creation', p_dt_creation);

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);

Line 1226: ITG_Debug.msg('SUA', 'p_dt_expiration', p_dt_expiration);

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:

Line 1275: ITG_Debug.msg('SUA', 'Done.');

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;

Line 1287: itg_debug.msg('Unexpected error (UOMSync) - ' || substr(SQLERRM,1,255),true);

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;