DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on GMD_DEBUG

Line 1107: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1103: WHEN app_exception.record_lock_exception THEN
1104: ROLLBACK TO SAVEPOINT update_formula;
1105: X_return_status := FND_API.g_ret_sts_error;
1106: IF (l_debug = 'Y') THEN
1107: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1108: END IF;
1109: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1110: 'TABLE_NAME',
1111: 'FM_FORM_MST_B',

Line 1124: gmd_debug.put_line ('In GMDERESB.pls - Status update failure section');

1120: WHEN STATUS_UPDATE_FAILURE THEN
1121: ROLLBACK TO SAVEPOINT update_formula;
1122: X_return_status := FND_API.g_ret_sts_error;
1123: IF (l_debug = 'Y') THEN
1124: gmd_debug.put_line ('In GMDERESB.pls - Status update failure section');
1125: END IF;
1126:
1127: WHEN OTHERS THEN
1128: ROLLBACK TO SAVEPOINT update_formula;

Line 1309: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1305: WHEN app_exception.record_lock_exception THEN
1306: ROLLBACK TO SAVEPOINT update_operation;
1307: X_return_status := FND_API.g_ret_sts_error;
1308: IF (l_debug = 'Y') THEN
1309: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1310: END IF;
1311: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1312: 'TABLE_NAME',
1313: 'GMD_OPERATIONS_B',

Line 1495: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1491: WHEN app_exception.record_lock_exception THEN
1492: ROLLBACK TO SAVEPOINT update_routing;
1493: X_return_status := FND_API.g_ret_sts_error;
1494: IF (l_debug = 'Y') THEN
1495: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1496: END IF;
1497: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1498: 'TABLE_NAME',
1499: 'GMD_ROUTINGS_B',

Line 1598: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1594: END IF;
1595: CLOSE Cur_get_status_type;
1596:
1597: IF (l_debug= 'Y') THEN
1598: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1599: 'The to status type = '||l_status_type);
1600: END IF;
1601:
1602: /* Bug # 2353561 - Shyam Sitaram */

Line 1610: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1606: IF (l_status_type IN ('800','900','1000') ) THEN
1607: IF GMD_ERES_UTILS.check_recipe_validity_eres (p_recipe_id
1608: ,p_to_status) THEN
1609: IF (l_debug= 'Y') THEN
1610: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1611: 'VR eres sig is required and it has be done manually ');
1612: END IF;
1613:
1614: RAISE VR_ERES_REQ;

Line 1639: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1635: END IF;
1636: END IF;
1637:
1638: IF (l_debug= 'Y') THEN
1639: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1640: 'About to lock this recipe '||p_recipe_id);
1641: END IF;
1642:
1643: SELECT 'x'

Line 1650: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1646: WHERE recipe_id = p_recipe_id
1647: FOR UPDATE OF recipe_status nowait;
1648:
1649: IF (l_debug= 'Y') THEN
1650: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1651: 'About to update recipe with status = '||p_to_status);
1652: END IF;
1653:
1654: UPDATE gmd_recipes_b

Line 1669: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1665: ,p_event_key => p_recipe_id
1666: ,p_status => l_erec_reqd);
1667:
1668: IF (l_debug= 'Y') THEN
1669: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1670: 'Checks if recipe esig is req ');
1671: END IF;
1672:
1673: IF (l_esig_reqd OR l_erec_reqd) THEN

Line 1678: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1674:
1675: IF (l_esig_reqd) THEN
1676:
1677: IF (l_debug= 'Y') THEN
1678: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1679: 'Esig is req with pending sts = '|| p_pending_status);
1680: END IF;
1681:
1682: OPEN Cur_get_status_desc (p_from_status);

Line 1703: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1699:
1700: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1701:
1702: IF (l_debug= 'Y') THEN
1703: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1704: 'Raising Esig event ');
1705: END IF;
1706:
1707: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_RECP_USR_LBL');

Line 1735: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||

1731: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1732: ,p_parameter_value7=>-1);
1733:
1734: IF (l_debug= 'Y') THEN
1735: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1736: 'After Raise Esig event ');
1737: END IF;
1738:
1739: IF l_esig_reqd THEN

Line 1797: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

1793: WHEN app_exception.record_lock_exception THEN
1794: ROLLBACK TO SAVEPOINT update_recipe;
1795: X_return_status := FND_API.g_ret_sts_error;
1796: IF (l_debug = 'Y') THEN
1797: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1798: END IF;
1799: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1800: 'TABLE_NAME',
1801: 'GMD_RECIPES_B',

Line 2011: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

2007: WHEN app_exception.record_lock_exception THEN
2008: ROLLBACK TO SAVEPOINT update_validity;
2009: X_return_status := FND_API.g_ret_sts_error;
2010: IF (l_debug = 'Y') THEN
2011: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2012: END IF;
2013: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2014: 'TABLE_NAME',
2015: 'GMD_RECIPE_VALIDITY_RULES',

Line 2172: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');

2168: WHEN app_exception.record_lock_exception THEN
2169: ROLLBACK TO SAVEPOINT update_substitution;
2170: X_return_status := FND_API.g_ret_sts_error;
2171: IF (l_debug = 'Y') THEN
2172: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2173: END IF;
2174: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2175: 'TABLE_NAME',
2176: 'GMD_ITEM_SUBSTITUTION_HDR_B',