DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on FND_FILE

Line 1078: FND_FILE.PUT(FND_FILE.LOG,

1074: WHERE formula_id = p_formula_id;
1075: IF p_called_from_form = 'F' THEN
1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1078: FND_FILE.PUT(FND_FILE.LOG,
1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1080: ||' :'||p_object_version||')');
1081: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1082: END IF;

Line 1081: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1078: FND_FILE.PUT(FND_FILE.LOG,
1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1080: ||' :'||p_object_version||')');
1081: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1082: END IF;
1083: END IF; /* IF l_esig_reqd */
1084:
1085: EXCEPTION

Line 1098: FND_FILE.PUT(FND_FILE.LOG, l_text);

1094: l_version_lbl := FND_MESSAGE.GET;
1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1096: ||' :'||p_object_version||')';
1097: IF p_called_from_form = 'F' THEN
1098: FND_FILE.PUT(FND_FILE.LOG, l_text);
1099: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1100: ELSE
1101: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 1099: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1096: ||' :'||p_object_version||')';
1097: IF p_called_from_form = 'F' THEN
1098: FND_FILE.PUT(FND_FILE.LOG, l_text);
1099: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1100: ELSE
1101: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1103: FND_MSG_PUB.add;

Line 1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1149: ELSE
1150: FND_MSG_PUB.add;
1151: END IF;

Line 1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1149: ELSE
1150: FND_MSG_PUB.add;
1151: END IF;
1152: END update_formula_status;

Line 1281: FND_FILE.PUT(FND_FILE.LOG,

1277:
1278: IF p_called_from_form = 'F' THEN
1279: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1281: FND_FILE.PUT(FND_FILE.LOG,
1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1283: ||' :'||p_object_version||')');
1284: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1285: END IF;

Line 1284: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1281: FND_FILE.PUT(FND_FILE.LOG,
1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1283: ||' :'||p_object_version||')');
1284: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1285: END IF;
1286: END IF; /* IF l_esig_reqd */
1287: EXCEPTION
1288: WHEN PENDING_STATUS_ERR OR

Line 1300: FND_FILE.PUT(FND_FILE.LOG, l_text);

1296: l_version_lbl := FND_MESSAGE.GET;
1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1298: ||' :'||p_object_version||')';
1299: IF p_called_from_form = 'F' THEN
1300: FND_FILE.PUT(FND_FILE.LOG, l_text);
1301: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1302: ELSE
1303: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1304: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 1301: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1298: ||' :'||p_object_version||')';
1299: IF p_called_from_form = 'F' THEN
1300: FND_FILE.PUT(FND_FILE.LOG, l_text);
1301: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1302: ELSE
1303: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1304: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1305: FND_MSG_PUB.add;

Line 1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1341: ELSE
1342: FND_MSG_PUB.add;
1343: END IF;

Line 1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1341: ELSE
1342: FND_MSG_PUB.add;
1343: END IF;
1344: END update_operation_status;

Line 1467: FND_FILE.PUT(FND_FILE.LOG,

1463: WHERE routing_id = p_routing_id;
1464: IF p_called_from_form = 'F' THEN
1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1467: FND_FILE.PUT(FND_FILE.LOG,
1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1469: ||' :'||p_object_version||')');
1470: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1471: END IF;

Line 1470: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1467: FND_FILE.PUT(FND_FILE.LOG,
1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1469: ||' :'||p_object_version||')');
1470: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1471: END IF;
1472: END IF; /* IF l_esig_reqd */
1473: EXCEPTION
1474: WHEN PENDING_STATUS_ERR OR

Line 1486: FND_FILE.PUT(FND_FILE.LOG, l_text);

1482: l_version_lbl := FND_MESSAGE.GET;
1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1484: ||' :'||p_object_version||')';
1485: IF p_called_from_form = 'F' THEN
1486: FND_FILE.PUT(FND_FILE.LOG, l_text);
1487: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1488: ELSE
1489: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1490: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 1487: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1484: ||' :'||p_object_version||')';
1485: IF p_called_from_form = 'F' THEN
1486: FND_FILE.PUT(FND_FILE.LOG, l_text);
1487: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1488: ELSE
1489: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1490: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1491: FND_MSG_PUB.add;

Line 1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1527: ELSE
1528: FND_MSG_PUB.add;
1529: END IF;

Line 1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1527: ELSE
1528: FND_MSG_PUB.add;
1529: END IF;
1530: END update_routing_status;

Line 1749: FND_FILE.PUT(FND_FILE.LOG,

1745: WHERE recipe_id = p_recipe_id;
1746: IF p_called_from_form = 'F' THEN
1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1749: FND_FILE.PUT(FND_FILE.LOG,
1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1751: ||' :'||p_object_version||')');
1752: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1753: END IF;

Line 1752: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1749: FND_FILE.PUT(FND_FILE.LOG,
1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1751: ||' :'||p_object_version||')');
1752: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1753: END IF;
1754: END IF; /* IF l_esig_reqd */
1755: EXCEPTION
1756: WHEN PENDING_STATUS_ERR OR

Line 1768: FND_FILE.PUT(FND_FILE.LOG, l_text);

1764: l_version_lbl := FND_MESSAGE.GET;
1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1766: ||' :'||p_object_version||')';
1767: IF p_called_from_form = 'F' THEN
1768: FND_FILE.PUT(FND_FILE.LOG, l_text);
1769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1770: ELSE
1771: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1772: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 1769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1766: ||' :'||p_object_version||')';
1767: IF p_called_from_form = 'F' THEN
1768: FND_FILE.PUT(FND_FILE.LOG, l_text);
1769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1770: ELSE
1771: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1772: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1773: FND_MSG_PUB.add;

Line 1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1792: ELSE
1793: FND_MSG_PUB.add;
1794: END IF;

Line 1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1792: ELSE
1793: FND_MSG_PUB.add;
1794: END IF;
1795: WHEN app_exception.record_lock_exception THEN

Line 1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1829: ELSE
1830: FND_MSG_PUB.add;
1831: END IF;

Line 1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1829: ELSE
1830: FND_MSG_PUB.add;
1831: END IF;
1832: END update_recipe_status;

Line 1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

1984:
1985: IF p_called_from_form = 'F' THEN
1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1990: END IF;
1991: END IF; /* IF l_esig_reqd */
1992: EXCEPTION

Line 1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1985: IF p_called_from_form = 'F' THEN
1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1990: END IF;
1991: END IF; /* IF l_esig_reqd */
1992: EXCEPTION
1993: WHEN PENDING_STATUS_ERR OR

Line 2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

2150:
2151: IF p_called_from_form = 'F' THEN
2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2156: END IF;
2157: END IF; /* IF l_esig_reqd */
2158: EXCEPTION

Line 2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

2151: IF p_called_from_form = 'F' THEN
2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2156: END IF;
2157: END IF; /* IF l_esig_reqd */
2158: EXCEPTION
2159: WHEN PENDING_STATUS_ERR OR