eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSACTION_FLOW_PVT dependencies on FND_API

Line 7: g_miss_date DATE:=to_date(to_char(FND_API.G_MISS_DATE,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS');

3: -- global variables
4: g_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5: g_version_printed BOOLEAN := FALSE;
6: g_pkg_name VARCHAR2(30):='INV_TRANSACTION_FLOW_PVT';
7: g_miss_date DATE:=to_date(to_char(FND_API.G_MISS_DATE,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS');
8:
9: --procedures
10:
11: -- This procedure is used to write logs for debugging.

Line 1055: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1051: END IF;
1052: IF l_num_recs=0 THEN
1053: FND_MESSAGE.SET_NAME('INV','INV_NO_TRX_FLOW_LINE');
1054: FND_MSG_PUB.ADD;
1055: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1056: RETURN ;
1057: END IF;
1058: --clear cache
1059: IF l_out_table.count>0 then

Line 1065: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1061: END IF;
1062: -- get the first record
1063: IF l_num_recs=1 THEN
1064: IF(p_lines_table(1).to_org_id <> p_end_org_id)then
1065: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1066: FND_MESSAGE.SET_NAME('INV','INV_NO_START_NODE');
1067: FND_MSG_PUB.ADD;
1068: RETURN;
1069: ELSE

Line 1071: X_RETURN_STATUS:=FND_API.G_RET_STS_SUCCESS;

1067: FND_MSG_PUB.ADD;
1068: RETURN;
1069: ELSE
1070: x_sorted_table:=p_lines_table;
1071: X_RETURN_STATUS:=FND_API.G_RET_STS_SUCCESS;
1072: IF g_debug=1 THEN
1073: debug('Trx flow has only one node'||l_num_recs,'Create_Sorted_Table');
1074: END IF;
1075: END IF;

Line 1088: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1084: END IF;
1085: END LOOP;
1086: IF l_out_table.count=0 THEN
1087: -- start node not found
1088: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1089: FND_MESSAGE.SET_NAME('INV','INV_NO_START_NODE');
1090: FND_MSG_PUB.ADD;
1091: RETURN;
1092: END IF;

Line 1108: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1104: END IF;
1105: END LOOP;
1106: IF l_out_table.count <> 2 THEN
1107: -- end node not found
1108: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1109: FND_MESSAGE.SET_NAME('INV','INV_INCOMPLETE_FLOW');
1110: FND_MSG_PUB.ADD;
1111: RETURN;
1112: END IF;

Line 1139: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1135: END IF;
1136: END LOOP;
1137: IF l_out_table.count <> (l_index_out+1) THEN
1138: -- connecting node not found
1139: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1140: FND_MESSAGE.SET_NAME('INV','INV_INCOMPLETE_FLOW'); --ACTION SET TOKEN
1141: FND_MSG_PUB.ADD;
1142: RETURN;
1143: END IF;

Line 1155: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1151: THEN
1152: IF g_debug=1 THEN
1153: debug('Cross validation for org/organizations failed','Create_Sorted_Table');
1154: END IF;
1155: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1156: FND_MESSAGE.SET_NAME('INV','INV_INCOMPLETE_FLOW'); --ACTION SET TOKEN
1157: FND_MSG_PUB.ADD;
1158: RETURN;
1159: END IF;

Line 1167: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

1163: THEN
1164: IF g_debug=1 THEN
1165: debug('Cross validation for org/organizations failed','Create_Sorted_Table');
1166: END IF;
1167: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
1168: FND_MESSAGE.SET_NAME('INV','INV_INCOMPLETE_FLOW'); --ACTION SET TOKEN
1169: FND_MSG_PUB.ADD;
1170: RETURN;
1171: END IF;

Line 1174: X_RETURN_STATUS:=FND_API.G_RET_STS_SUCCESS;

1170: RETURN;
1171: END IF;
1172: END IF;
1173:
1174: X_RETURN_STATUS:=FND_API.G_RET_STS_SUCCESS;
1175: x_sorted_table:=l_out_table;
1176: IF g_debug=1 THEN
1177: debug('Sorted table created','Create_Sorted_Table');
1178: END IF;

Line 1213: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1209: P_START_ORG_ID => p_start_org_id,
1210: P_END_ORG_ID => p_end_org_id,
1211: P_LINES_TABLE => p_lines_tab
1212: ) ;
1213: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1214: RETURN FALSE;
1215: END IF;
1216:
1217: --See that all the organizations are not null

Line 1702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1698: ,X_ENABLED_SEGS => l_ENABLED_SEGS
1699: ,P_CONTEXT => l_context
1700: ,P_FLEX_NAME => p_flex_name
1701: );
1702: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1703: RETURN FALSE;
1704: END IF;
1705:
1706: if g_debug=1 then

Line 1752: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1748: ,X_ENABLED_SEGS => l_ENABLED_SEGS
1749: ,P_CONTEXT => l_context
1750: ,P_FLEX_NAME => p_flex_name
1751: );
1752: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1753: RETURN FALSE;
1754: END IF;
1755: if g_debug=1 then
1756: debug(' after 2 call to Txn flow dff','Validate_Dff');

Line 1906: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1902: SAVEPOINT CREATE_IC_TRX_FLOW_SP;
1903: if g_debug=1 then
1904: debug('Inside Create_IC_Transaction_Flow','Create_IC_Transaction_Flow');
1905: end if;
1906: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1907:
1908: --Bug 3439577 fix. Inline branching checks
1909: --for inventory
1910: If (inv_control.get_current_release_level >= INV_Release.Get_J_RELEASE_LEVEL) Then

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: -- validate operating units
1972: IF NOT Validate_Operating_Unit(p_start_org_id) THEN
1973: FND_MESSAGE.SET_NAME('INV','INV_INVALID_START_ORG');
1974: FND_MSG_PUB.ADD;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977: --
1978: IF NOT Validate_Operating_Unit(p_end_org_id) THEN
1979: FND_MESSAGE.SET_NAME('INV','INV_INVALID_END_ORG');

Line 1981: RAISE FND_API.G_EXC_ERROR;

1977: --
1978: IF NOT Validate_Operating_Unit(p_end_org_id) THEN
1979: FND_MESSAGE.SET_NAME('INV','INV_INVALID_END_ORG');
1980: FND_MSG_PUB.ADD;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END IF;
1983: if g_debug=1 then
1984: debug('Start/End OU validated','Create_IC_Transaction_Flow');
1985: end if;

Line 1990: RAISE FND_API.G_EXC_ERROR;

1986: -- Validate Flow Type
1987: IF p_flow_type NOT IN (1,2) THEN
1988: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRX_FLOW_TYPE');
1989: FND_MSG_PUB.ADD;
1990: RAISE FND_API.G_EXC_ERROR;
1991: --Bug 3439577 fix. Inline branching checks
1992: --For Procuring Flow with new accounting (we do not support old accounting for this type),
1993: --you need INV J and Costing J and PO J
1994: --For Shipping Flow with new accounting, you need INV J and Costing J and OM J.

Line 2002: RAISE FND_API.G_EXC_ERROR;

1998: IF p_new_accounting_flag IN ('Y','y')
1999: AND NOT(om_j_installed AND inv_j_installed AND costing_j_installed) THEN
2000: FND_MESSAGE.SET_NAME('INV','INV_NO_NEW_ACCT_FLOW');
2001: FND_MSG_PUB.ADD;
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004: ELSIF p_flow_type = 2 THEN --procuring
2005: IF NOT(po_j_installed AND inv_j_installed AND costing_j_installed) then
2006: FND_MESSAGE.SET_NAME('INV','INV_PROCURING_FLOW_NOT_ALLOWED');

Line 2008: RAISE FND_API.G_EXC_ERROR;

2004: ELSIF p_flow_type = 2 THEN --procuring
2005: IF NOT(po_j_installed AND inv_j_installed AND costing_j_installed) then
2006: FND_MESSAGE.SET_NAME('INV','INV_PROCURING_FLOW_NOT_ALLOWED');
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010: END IF;
2011: -- validate for single ou setup
2012: IF p_start_org_id=p_end_org_id THEN

Line 2016: RAISE FND_API.G_EXC_ERROR;

2012: IF p_start_org_id=p_end_org_id THEN
2013: IF p_flow_type<> 1 THEN
2014: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRX_FLOW_TYPE');
2015: FND_MSG_PUB.ADD;
2016: RAISE FND_API.G_EXC_ERROR;
2017: END IF;
2018: END IF;
2019: if g_debug=1 then
2020: debug('Flow type validated','Create_IC_Transaction_Flow');

Line 2027: RAISE FND_API.G_EXC_ERROR;

2023: IF p_flow_type=1 AND p_organization_id IS NOT NULL THEN
2024: IF NOT Validate_Organization(p_organization_id,p_start_org_id) THEN
2025: FND_MESSAGE.SET_NAME('INV','INV_INVALID_DOC_ORGANIZATION');
2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.G_EXC_ERROR;
2028: END IF;
2029: ELSIF p_flow_type=2 AND p_organization_id IS NOT NULL THEN
2030: IF NOT Validate_Organization(p_organization_id,p_end_org_id) THEN
2031: FND_MESSAGE.SET_NAME('INV','INV_INVALID_DOC_ORGANIZATION');

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029: ELSIF p_flow_type=2 AND p_organization_id IS NOT NULL THEN
2030: IF NOT Validate_Organization(p_organization_id,p_end_org_id) THEN
2031: FND_MESSAGE.SET_NAME('INV','INV_INVALID_DOC_ORGANIZATION');
2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035: END IF;
2036: if g_debug=1 then
2037: debug('From/To Organization validated','Create_IC_Transaction_Flow');

Line 2043: RAISE FND_API.G_EXC_ERROR;

2039: -- Validate Qualifier Code
2040: IF NOT Validate_Qualifier_Code(p_qualifier_code) THEN
2041: FND_MESSAGE.SET_NAME('INV','INV_INVALID_QUALIFIER');
2042: FND_MSG_PUB.ADD;
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: -- Validate Qualifier Value
2046: IF NOT Validate_Qualifier_Value(p_qualifier_code,p_qualifier_value_id,p_flow_type) THEN
2047: FND_MESSAGE.SET_NAME('INV','INV_INVALID_QUALIFIER_VALUE');

Line 2049: RAISE FND_API.G_EXC_ERROR;

2045: -- Validate Qualifier Value
2046: IF NOT Validate_Qualifier_Value(p_qualifier_code,p_qualifier_value_id,p_flow_type) THEN
2047: FND_MESSAGE.SET_NAME('INV','INV_INVALID_QUALIFIER_VALUE');
2048: FND_MSG_PUB.ADD;
2049: RAISE FND_API.G_EXC_ERROR;
2050: END IF;
2051: if g_debug=1 then
2052: debug('Qualifier Code and Value validated','Create_IC_Transaction_Flow');
2053: end if;

Line 2059: RAISE FND_API.G_EXC_ERROR;

2055: IF p_flow_type=1 THEN
2056: IF p_asset_item_pricing_option IS NOT NULL OR p_expense_item_pricing_option IS NOT NULL THEN
2057: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PRICING_OPTION');
2058: FND_MSG_PUB.ADD;
2059: RAISE FND_API.G_EXC_ERROR;
2060: END IF;
2061: ELSE
2062: IF p_asset_item_pricing_option NOT IN(1,2) OR p_expense_item_pricing_option NOT IN (1,2) THEN
2063: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PRICING_OPTION');

Line 2065: RAISE FND_API.G_EXC_ERROR;

2061: ELSE
2062: IF p_asset_item_pricing_option NOT IN(1,2) OR p_expense_item_pricing_option NOT IN (1,2) THEN
2063: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PRICING_OPTION');
2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067: END IF;
2068: if g_debug=1 then
2069: debug('Asset/Expense Item pricing options validated','Create_IC_Transaction_Flow');

Line 2104: RAISE FND_API.G_EXC_ERROR;

2100: )
2101: THEN
2102: FND_MESSAGE.SET_NAME('INV','INV_INVALID_NEW_ACCT_FLAG');
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106: if g_debug=1 then
2107: debug('New Accounting Flag validated','Create_IC_Transaction_Flow');
2108: end if;

Line 2124: RAISE FND_API.G_EXC_ERROR;

2120: P_START_DATE => p_start_date,
2121: P_END_DATE => p_end_date
2122: )
2123: THEN
2124: RAISE FND_API.G_EXC_ERROR;
2125: END IF;
2126: if g_debug=1 then
2127: debug('Header validated for duplicate','Create_IC_Transaction_Flow');
2128: end if;

Line 2144: RAISE FND_API.G_EXC_ERROR;

2140: P_START_DATE => p_start_date,
2141: P_REF_DATE => p_ref_date
2142: )
2143: THEN
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146: if g_debug=1 then
2147: debug('Start date validated','Create_IC_Transaction_Flow');
2148: end if;

Line 2165: RAISE FND_API.G_EXC_ERROR;

2161: P_END_DATE => p_end_date,
2162: P_REF_DATE => p_ref_date
2163: )
2164: THEN
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: if g_debug=1 then
2168: debug('End date validated','Create_IC_Transaction_Flow');
2169: end if;

Line 2183: RAISE FND_API.G_EXC_ERROR;

2179: P_END_ORG_ID => p_end_org_id,
2180: P_NEW_ACCOUNTING_FLAG => p_new_accounting_flag
2181: )
2182: THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185: ELSE
2186: -- nodes cannot be created for single ou setups
2187: IF p_lines_tab.count>0 THEN

Line 2190: RAISE FND_API.G_EXC_ERROR;

2186: -- nodes cannot be created for single ou setups
2187: IF p_lines_tab.count>0 THEN
2188: FND_MESSAGE.SET_NAME('INV','INV_TRX_NODE_NOT_ALLOWED');
2189: FND_MSG_PUB.ADD;
2190: RAISE FND_API.G_EXC_ERROR;
2191: END IF;
2192: END IF;
2193: if g_debug=1 then
2194: debug('All lines validated','Create_IC_Transaction_Flow');

Line 2220: RAISE FND_API.G_EXC_ERROR;

2216: P_ATTRIBUTE14 => p_attribute14,
2217: P_ATTRIBUTE15 => p_attribute15,
2218: P_ATTRIBUTE_CATEGORY => p_attribute_category
2219: ) THEN
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222: if g_debug=1 then
2223: debug('attribute columns for header validated','Create_IC_Transaction_Flow');
2224: end if;

Line 2249: RAISE FND_API.G_EXC_ERROR;

2245: P_ATTRIBUTE14 => p_lines_tab(l_index).Attribute14,
2246: P_ATTRIBUTE15 => p_lines_tab(l_index).Attribute15,
2247: P_ATTRIBUTE_CATEGORY => p_lines_tab(l_index).Attribute_Category
2248: ) THEN
2249: RAISE FND_API.G_EXC_ERROR;
2250: END IF;
2251:
2252: END LOOP;
2253: if g_debug=1 then

Line 2341: WHEN FND_API.G_EXC_ERROR THEN

2337: COMMIT;
2338: END IF;
2339:
2340: EXCEPTION
2341: WHEN FND_API.G_EXC_ERROR THEN
2342: x_return_status:=FND_API.G_RET_STS_ERROR;
2343: ROLLBACK TO CREATE_IC_TRX_FLOW_SP;
2344: FND_MSG_PUB.COUNT_AND_GET(
2345: P_ENCODED=>'T',

Line 2342: x_return_status:=FND_API.G_RET_STS_ERROR;

2338: END IF;
2339:
2340: EXCEPTION
2341: WHEN FND_API.G_EXC_ERROR THEN
2342: x_return_status:=FND_API.G_RET_STS_ERROR;
2343: ROLLBACK TO CREATE_IC_TRX_FLOW_SP;
2344: FND_MSG_PUB.COUNT_AND_GET(
2345: P_ENCODED=>'T',
2346: P_COUNT=>X_MSG_COUNT,

Line 2349: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2345: P_ENCODED=>'T',
2346: P_COUNT=>X_MSG_COUNT,
2347: P_DATA=>X_MSG_DATA);
2348: WHEN OTHERS THEN
2349: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2350: ROLLBACK TO CREATE_IC_TRX_FLOW_SP;
2351: FND_MSG_PUB.COUNT_AND_GET(
2352: P_ENCODED=>'T',
2353: P_COUNT=>X_MSG_COUNT,

Line 2413: x_return_status:=FND_API.G_RET_STS_SUCCESS;

2409: debug('p_end_date='||p_end_date,'Update_IC_Transaction_Flow');
2410: debug('p_ref_date='||p_ref_date,'Update_IC_Transaction_Flow');
2411: end if;
2412: SAVEPOINT UPDATE_IC_TRX_FLOW_SP;
2413: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2414: -- accuire lock for header
2415: BEGIN
2416: SELECT START_ORG_ID,END_ORG_ID,FLOW_TYPE,ORGANIZATION_ID,
2417: QUALIFIER_CODE,QUALIFIER_VALUE_ID,START_DATE,END_DATE

Line 2435: RAISE FND_API.G_EXC_ERROR;

2431: debug('Failed to accuire lock for header','Update_IC_Transaction_Flow');
2432: end if;
2433: FND_MESSAGE.SET_NAME('INV','INV_LOCK_FAILED');
2434: FND_MSG_PUB.ADD;
2435: RAISE FND_API.G_EXC_ERROR;
2436: END;
2437:
2438: -- accuire lock for lines
2439: BEGIN

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: debug('Failed to accuire lock for lines','Update_IC_Transaction_Flow');
2454: end if;
2455: FND_MESSAGE.SET_NAME('INV','INV_LOCK_FAILED');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;
2458: END;
2459: IF p_start_date <> l_start_date THEN
2460: -- do the validation
2461: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(

Line 2473: RAISE FND_API.G_EXC_ERROR;

2469: P_START_DATE => p_start_date,
2470: P_REF_DATE => p_ref_date
2471: )
2472: THEN
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475: END IF;
2476:
2477: IF nvl(p_end_date,sysdate) <> nvl(l_end_date,sysdate) THEN

Line 2492: RAISE FND_API.G_EXC_ERROR;

2488: P_END_DATE => p_end_date,
2489: P_REF_DATE => p_ref_date
2490: )
2491: THEN
2492: RAISE FND_API.G_EXC_ERROR;
2493: END IF;
2494: END IF;
2495: --
2496: --validate the attributes for the header before update

Line 2516: RAISE FND_API.G_EXC_ERROR;

2512: P_ATTRIBUTE14 => p_attribute14,
2513: P_ATTRIBUTE15 => p_attribute15,
2514: P_ATTRIBUTE_CATEGORY => p_attribute_category
2515: ) THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518: if g_debug=1 then
2519: debug('attribute columns for header validated','Update_IC_Transaction_Flow');
2520: end if;

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: P_ATTRIBUTE14 => p_lines_tab(l_index).Attribute14,
2542: P_ATTRIBUTE15 => p_lines_tab(l_index).Attribute15,
2543: P_ATTRIBUTE_CATEGORY => p_lines_tab(l_index).Attribute_Category
2544: ) THEN
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;
2547:
2548: END LOOP;
2549: if g_debug=1 then

Line 2622: WHEN FND_API.G_EXC_ERROR THEN

2618: commit;
2619: END IF;
2620:
2621: EXCEPTION
2622: WHEN FND_API.G_EXC_ERROR THEN
2623: x_return_status:=FND_API.G_RET_STS_ERROR;
2624: ROLLBACK TO UPDATE_IC_TRX_FLOW_SP;
2625: FND_MSG_PUB.COUNT_AND_GET(
2626: P_ENCODED=>'T',

Line 2623: x_return_status:=FND_API.G_RET_STS_ERROR;

2619: END IF;
2620:
2621: EXCEPTION
2622: WHEN FND_API.G_EXC_ERROR THEN
2623: x_return_status:=FND_API.G_RET_STS_ERROR;
2624: ROLLBACK TO UPDATE_IC_TRX_FLOW_SP;
2625: FND_MSG_PUB.COUNT_AND_GET(
2626: P_ENCODED=>'T',
2627: P_COUNT=>X_MSG_COUNT,

Line 2630: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2626: P_ENCODED=>'T',
2627: P_COUNT=>X_MSG_COUNT,
2628: P_DATA=>X_MSG_DATA);
2629: WHEN OTHERS THEN
2630: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2631: ROLLBACK TO UPDATE_IC_TRX_FLOW_SP;
2632: FND_MSG_PUB.COUNT_AND_GET(
2633: P_ENCODED=>'T',
2634: P_COUNT=>X_MSG_COUNT,

Line 2691: x_return_status:=FND_API.G_RET_STS_SUCCESS;

2687: end if;
2688:
2689: SAVEPOINT UPDATE_IC_TRX_FLOW_HDR_SP;
2690:
2691: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2692:
2693: -- accuire lock for header
2694: BEGIN
2695: SELECT START_ORG_ID,END_ORG_ID,FLOW_TYPE,ORGANIZATION_ID,

Line 2714: RAISE FND_API.G_EXC_ERROR;

2710: debug('Failed to accuire lock for header','Update_IC_Txn_Flow_hdr');
2711: end if;
2712: FND_MESSAGE.SET_NAME('INV','INV_LOCK_FAILED');
2713: FND_MSG_PUB.ADD;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END;
2716:
2717: IF p_start_date <> l_start_date THEN
2718: -- do the validation

Line 2731: RAISE FND_API.G_EXC_ERROR;

2727: P_START_DATE => p_start_date,
2728: P_REF_DATE => p_ref_date
2729: )
2730: THEN
2731: RAISE FND_API.G_EXC_ERROR;
2732: END IF;
2733: END IF;
2734:
2735: IF nvl(p_end_date,sysdate) <> nvl(l_end_date,sysdate) THEN

Line 2750: RAISE FND_API.G_EXC_ERROR;

2746: P_END_DATE => p_end_date,
2747: P_REF_DATE => p_ref_date
2748: )
2749: THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752: END IF;
2753: --
2754: --validate the attributes for the header before update

Line 2774: RAISE FND_API.G_EXC_ERROR;

2770: P_ATTRIBUTE14 => p_attribute14,
2771: P_ATTRIBUTE15 => p_attribute15,
2772: P_ATTRIBUTE_CATEGORY => p_attribute_category
2773: ) THEN
2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2776: if g_debug=1 then
2777: debug('attribute columns for header validated','Update_IC_Txn_Flow_hdr');
2778: end if;

Line 2817: WHEN FND_API.G_EXC_ERROR THEN

2813: commit;
2814: END IF;
2815:
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status:=FND_API.G_RET_STS_ERROR;
2819: ROLLBACK TO UPDATE_IC_TRX_FLOW_HDR_SP;
2820: FND_MSG_PUB.COUNT_AND_GET(
2821: P_ENCODED=>'T',

Line 2818: x_return_status:=FND_API.G_RET_STS_ERROR;

2814: END IF;
2815:
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status:=FND_API.G_RET_STS_ERROR;
2819: ROLLBACK TO UPDATE_IC_TRX_FLOW_HDR_SP;
2820: FND_MSG_PUB.COUNT_AND_GET(
2821: P_ENCODED=>'T',
2822: P_COUNT=>X_MSG_COUNT,

Line 2825: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2821: P_ENCODED=>'T',
2822: P_COUNT=>X_MSG_COUNT,
2823: P_DATA=>X_MSG_DATA);
2824: WHEN OTHERS THEN
2825: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2826: ROLLBACK TO UPDATE_IC_TRX_FLOW_HDR_SP;
2827: FND_MSG_PUB.COUNT_AND_GET(
2828: P_ENCODED=>'T',
2829: P_COUNT=>X_MSG_COUNT,

Line 2867: x_return_status:=FND_API.G_RET_STS_SUCCESS;

2863: end if;
2864:
2865:
2866: SAVEPOINT UPDATE_IC_TRX_FLOW_LINE_SP;
2867: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2868:
2869: -- accuire lock for lines
2870: BEGIN
2871: SELECT FROM_ORG_ID

Line 2889: RAISE FND_API.G_EXC_ERROR;

2885: debug('Failed to accuire lock for lines','Update_IC_Txn_Flow_line');
2886: end if;
2887: FND_MESSAGE.SET_NAME('INV','INV_LOCK_FAILED');
2888: FND_MSG_PUB.ADD;
2889: RAISE FND_API.G_EXC_ERROR;
2890: END;
2891:
2892: --
2893: --Validate the flex columns for lines

Line 2913: RAISE FND_API.G_EXC_ERROR;

2909: P_ATTRIBUTE14 => p_Attribute14,
2910: P_ATTRIBUTE15 => p_Attribute15,
2911: P_ATTRIBUTE_CATEGORY => p_Attribute_Category
2912: ) THEN
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915:
2916: if g_debug=1 then
2917: debug('attribute columns for lines validated','Update_IC_Txn_Flow_line');

Line 2953: WHEN FND_API.G_EXC_ERROR THEN

2949: commit;
2950: END IF;
2951:
2952: EXCEPTION
2953: WHEN FND_API.G_EXC_ERROR THEN
2954: x_return_status:=FND_API.G_RET_STS_ERROR;
2955: ROLLBACK TO UPDATE_IC_TRX_FLOW_LINE_SP;
2956: FND_MSG_PUB.COUNT_AND_GET(
2957: P_ENCODED=>'T',

Line 2954: x_return_status:=FND_API.G_RET_STS_ERROR;

2950: END IF;
2951:
2952: EXCEPTION
2953: WHEN FND_API.G_EXC_ERROR THEN
2954: x_return_status:=FND_API.G_RET_STS_ERROR;
2955: ROLLBACK TO UPDATE_IC_TRX_FLOW_LINE_SP;
2956: FND_MSG_PUB.COUNT_AND_GET(
2957: P_ENCODED=>'T',
2958: P_COUNT=>X_MSG_COUNT,

Line 2961: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2957: P_ENCODED=>'T',
2958: P_COUNT=>X_MSG_COUNT,
2959: P_DATA=>X_MSG_DATA);
2960: WHEN OTHERS THEN
2961: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2962: ROLLBACK TO UPDATE_IC_TRX_FLOW_LINE_SP;
2963: FND_MSG_PUB.COUNT_AND_GET(
2964: P_ENCODED=>'T',
2965: P_COUNT=>X_MSG_COUNT,