DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on FND_FILE

Line 1076: FND_FILE.PUT(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

Line 1279: FND_FILE.PUT(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

Line 1465: FND_FILE.PUT(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

Line 1747: FND_FILE.PUT(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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