DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on FND_API

Line 359: IF l_return_status = FND_API.G_RET_STS_SUCCESS

355: p_cplv_tbl => l_cplv_tbl_in,
356: x_cplv_tbl => l_cplv_tbl_out);
357: -- Bug 5227077 --
358: x_return_status :=l_return_status;
359: IF l_return_status = FND_API.G_RET_STS_SUCCESS
360: THEN
361: IF l_cplv_tbl_out.COUNT > 0 THEN
362: x_cpl_id := l_cplv_tbl_out(l_cplv_tbl_out.FIRST).id;
363: END IF;

Line 1132: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1128: ,x_msg_data => l_msg_data
1129: ,x_flag => l_flag);
1130:
1131: -- Bug 5227077 --
1132: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1133: FOR i in 1..fnd_msg_pub.count_msg
1134: Loop
1135: fnd_msg_pub.get
1136: (

Line 1159: p_encoded => fnd_api.g_false);

1155: p_token1 => 'Line No ',
1156: p_token1_value => l_line_number);
1157:
1158: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1159: p_encoded => fnd_api.g_false);
1160: x_msg_tbl(l_tot_msg_count).status := 'E';
1161: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1162: l_tot_msg_count := l_tot_msg_count + 1;
1163: l_msg_data := NULL;

Line 1215: p_encoded => fnd_api.g_false);

1211: p_token1 => 'ATTRIBUTE',
1212: p_token1_value => 'Bill To Address');
1213:
1214: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1215: p_encoded => fnd_api.g_false);
1216:
1217: x_msg_tbl(l_tot_msg_count).status := 'S';
1218: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1219: l_tot_msg_count := l_tot_msg_count + 1;

Line 1235: p_encoded => fnd_api.g_false);

1231: p_token1 => 'Line No ',
1232: p_token1_value => l_line_number);
1233:
1234: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1235: p_encoded => fnd_api.g_false);
1236:
1237: x_msg_tbl(l_tot_msg_count).status := 'E';
1238: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1239: l_tot_msg_count := l_tot_msg_count + 1;

Line 1280: p_encoded => fnd_api.g_false);

1276: p_token1_value => 'Ship To Address');
1277:
1278: -- fnd_msg_pub.initialize;
1279: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1280: p_encoded => fnd_api.g_false);
1281: x_msg_tbl(l_tot_msg_count).status := 'S';
1282: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1283: l_tot_msg_count := l_tot_msg_count + 1;
1284: l_msg_data := NULL;

Line 1339: p_encoded => fnd_api.g_false);

1335: p_token1_value => 'Bill To Address');
1336:
1337: -- fnd_msg_pub.initialize;
1338: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1339: p_encoded => fnd_api.g_false);
1340: x_msg_tbl(l_tot_msg_count).status := 'S';
1341: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1342: l_tot_msg_count := l_tot_msg_count + 1;
1343: l_msg_data := NULL;

Line 1357: p_encoded => fnd_api.g_false);

1353: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'));
1354:
1355: -- fnd_msg_pub.initialize;
1356: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1357: p_encoded => fnd_api.g_false);
1358: x_msg_tbl(l_tot_msg_count).status := 'S';
1359: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1360: l_tot_msg_count := l_tot_msg_count + 1;
1361: l_msg_data := NULL;

Line 1398: p_encoded => fnd_api.g_false);

1394: p_token3 => 'TOKEN3',
1395: p_token3_value => l_temp_line_number);
1396: -- fnd_msg_pub.initialize;
1397: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1398: p_encoded => fnd_api.g_false);
1399: x_msg_tbl(l_tot_msg_count).status := 'S';
1400: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1401: l_tot_msg_count := l_tot_msg_count + 1;
1402: l_msg_data := NULL;

Line 1428: p_encoded => fnd_api.g_false);

1424: p_token3 => 'TOKEN3',
1425: p_token3_value => l_temp_line_number);
1426: -- fnd_msg_pub.initialize;
1427: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1428: p_encoded => fnd_api.g_false);
1429: x_msg_tbl(l_tot_msg_count).status := 'S';
1430: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1431: l_tot_msg_count := l_tot_msg_count + 1;
1432: l_msg_data := NULL;

Line 1540: p_encoded => fnd_api.g_false);

1536: p_token3 => 'TOKEN3',
1537: p_token3_value => l_temp_line_number);
1538: -- fnd_msg_pub.initialize;
1539: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1540: p_encoded => fnd_api.g_false);
1541: x_msg_tbl(l_tot_msg_count).status := 'S';
1542: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1543: l_tot_msg_count := l_tot_msg_count + 1;
1544: l_msg_data := NULL;

Line 1563: p_encoded => fnd_api.g_false);

1559: p_token3 => 'TOKEN3',
1560: p_token3_value => l_temp_line_number);
1561: -- fnd_msg_pub.initialize;
1562: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1563: p_encoded => fnd_api.g_false);
1564: x_msg_tbl(l_tot_msg_count).status := 'S';
1565: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1566: l_tot_msg_count := l_tot_msg_count + 1;
1567: l_msg_data := NULL;

Line 1640: p_encoded => fnd_api.g_false);

1636: p_token1_value => 'Ship To Address');
1637:
1638: -- fnd_msg_pub.initialize;
1639: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1640: p_encoded => fnd_api.g_false);
1641: x_msg_tbl(l_tot_msg_count).status := 'S';
1642: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1643: l_tot_msg_count := l_tot_msg_count + 1;
1644: l_msg_data := NULL;

Line 1656: p_encoded => fnd_api.g_false);

1652: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'));
1653:
1654: -- fnd_msg_pub.initialize;
1655: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1656: p_encoded => fnd_api.g_false);
1657: x_msg_tbl(l_tot_msg_count).status := 'S';
1658: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1659: l_tot_msg_count := l_tot_msg_count + 1;
1660: l_msg_data := NULL;

Line 1773: p_encoded => fnd_api.g_false);

1769: p_token3 => 'TOKEN3',
1770: p_token3_value => l_temp_line_number);
1771: -- fnd_msg_pub.initialize;
1772: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1773: p_encoded => fnd_api.g_false);
1774: x_msg_tbl(l_tot_msg_count).status := 'S';
1775: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1776: l_tot_msg_count := l_tot_msg_count + 1;
1777: l_msg_data := NULL;

Line 1796: p_encoded => fnd_api.g_false);

1792: p_token3 => 'TOKEN3',
1793: p_token3_value => l_temp_line_number);
1794: -- fnd_msg_pub.initialize;
1795: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1796: p_encoded => fnd_api.g_false);
1797: x_msg_tbl(l_tot_msg_count).status := 'S';
1798: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1799: l_tot_msg_count := l_tot_msg_count + 1;
1800: l_msg_data := NULL;

Line 1875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS)

1871: x_return_status => l_return_status -- 5219132 --
1872: );
1873: -- Bug 5219132 --
1874:
1875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS)
1876: THEN
1877: FOR i in 1..fnd_msg_pub.count_msg
1878: Loop
1879: fnd_msg_pub.get

Line 1920: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1916: p_ctcv_tbl => l_ctcv_tbl_in,
1917: x_ctcv_tbl => l_ctcv_tbl_out);
1918:
1919:
1920: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1921: -- Bug 5227077 --
1922: FOR i in 1..fnd_msg_pub.count_msg
1923: Loop
1924: fnd_msg_pub.get

Line 1946: p_encoded => fnd_api.g_false);

1942: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1943: p_token1 => 'ATTRIBUTE',
1944: p_token1_value => 'Bill To Contact');
1945: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1946: p_encoded => fnd_api.g_false);
1947: x_msg_tbl(l_tot_msg_count).status := 'S';
1948: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1949: l_tot_msg_count := l_tot_msg_count + 1;
1950: l_msg_data := NULL;

Line 1965: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1961: x_msg_data => l_msg_data,
1962: p_ctcv_tbl => l_ctcv_tbl_in,
1963: x_ctcv_tbl => l_ctcv_tbl_out);
1964:
1965: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1966: -- Bug 5227077 --
1967: FOR i in 1..fnd_msg_pub.count_msg
1968: Loop
1969: fnd_msg_pub.get

Line 1991: p_encoded => fnd_api.g_false);

1987: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1988: p_token1 => 'ATTRIBUTE',
1989: p_token1_value => 'Bill To Contact');
1990: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1991: p_encoded => fnd_api.g_false);
1992: x_msg_tbl(l_tot_msg_count).status := 'S';
1993: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1994: l_tot_msg_count := l_tot_msg_count + 1;
1995: l_msg_data := NULL;

Line 2012: p_encoded => fnd_api.g_false);

2008: p_token1 => 'Line No ',
2009: p_token1_value => l_line_number);
2010:
2011: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2012: p_encoded => fnd_api.g_false);
2013:
2014: x_msg_tbl(l_tot_msg_count).status := 'W'; -- Bug 5219132
2015: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2016: l_tot_msg_count := l_tot_msg_count + 1;

Line 2190: p_encoded => fnd_api.g_false);

2186: p_token1 => 'ATTRIBUTE',
2187: p_token1_value => 'Tax');
2188: --fnd_msg_pub.initialize;
2189: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2190: p_encoded => fnd_api.g_false);
2191: x_msg_tbl(l_tot_msg_count).status := 'S';
2192: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2193: l_tot_msg_count := l_tot_msg_count + 1;
2194: l_msg_data := NULL;

Line 2246: p_encoded => fnd_api.g_false);

2242: p_token1 => 'ATTRIBUTE',
2243: p_token1_value => 'Tax Code');
2244: --fnd_msg_pub.initialize;
2245: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2246: p_encoded => fnd_api.g_false);
2247: x_msg_tbl(l_tot_msg_count).status := 'S';
2248: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2249: l_tot_msg_count := l_tot_msg_count + 1;
2250: l_msg_data := NULL;

Line 2290: p_encoded => fnd_api.g_false);

2286: p_token2_value => l_line_number
2287: );
2288:
2289: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2290: p_encoded => fnd_api.g_false);
2291: x_msg_tbl(l_tot_msg_count).status := 'E';
2292: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2293: l_tot_msg_count := l_tot_msg_count + 1;
2294: l_msg_data := NULL;

Line 2333: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2329: x_msg_count => l_msg_count,
2330: x_msg_data => l_msg_data);
2331:
2332: -- Bug 5227077 --
2333: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2334: FOR i in 1..fnd_msg_pub.count_msg
2335: Loop
2336: fnd_msg_pub.get
2337: (

Line 2365: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2361: x_msg_data => l_msg_data
2362: );
2363:
2364: -- Bug 5227077 --
2365: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2366: FOR i in 1..fnd_msg_pub.count_msg
2367: Loop
2368: fnd_msg_pub.get
2369: (

Line 2414: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2410: ,x_bil_sch_out_tbl => l_bil_sch_out_tbl
2411: ,x_return_status => l_return_status
2412: );
2413:
2414: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2415: FOR i in 1..fnd_msg_pub.count_msg
2416: Loop
2417: fnd_msg_pub.get
2418: (

Line 2439: p_encoded => fnd_api.g_false);

2435: p_token1 => 'ATTRIBUTE',
2436: p_token1_value => 'Billing Schedule');
2437: --fnd_msg_pub.initialize;
2438: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2439: p_encoded => fnd_api.g_false);
2440: x_msg_tbl(l_tot_msg_count).status := 'S';
2441: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2442: l_tot_msg_count := l_tot_msg_count + 1;
2443: l_msg_data := NULL;

Line 2477: p_encoded => fnd_api.g_false);

2473: p_token1 => 'ATTRIBUTE',
2474: p_token1_value => 'Bill To Address');
2475: --fnd_msg_pub.initialize;
2476: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2477: p_encoded => fnd_api.g_false);
2478: x_msg_tbl(l_tot_msg_count).status := 'S';
2479: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2480: l_tot_msg_count := l_tot_msg_count + 1;
2481: l_msg_data := NULL;

Line 2496: p_encoded => fnd_api.g_false);

2492: p_token1 => 'ATTRIBUTE',
2493: p_token1_value => 'Billing Profile');
2494:
2495: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2496: p_encoded => fnd_api.g_false);
2497: x_msg_tbl(l_tot_msg_count).status := 'E';
2498: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2499: l_tot_msg_count := l_tot_msg_count + 1;
2500: l_msg_data := NULL;

Line 2526: p_encoded => fnd_api.g_false);

2522: p_token1_value => 'Accounting Rule');
2523:
2524: --fnd_msg_pub.initialize;
2525: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2526: p_encoded => fnd_api.g_false);
2527: x_msg_tbl(l_tot_msg_count).status := 'S';
2528: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2529: l_tot_msg_count := l_tot_msg_count + 1;
2530: l_msg_data := NULL;

Line 2559: p_encoded => fnd_api.g_false);

2555: p_token2_value => l_line_number
2556: );
2557:
2558: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2559: p_encoded => fnd_api.g_false);
2560: x_msg_tbl(l_tot_msg_count).status := 'E';
2561: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2562: l_tot_msg_count := l_tot_msg_count + 1;
2563: l_msg_data := NULL;

Line 2583: p_encoded => fnd_api.g_false);

2579: p_token1_value => 'Accounting Rule');
2580:
2581: --fnd_msg_pub.initialize;
2582: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2583: p_encoded => fnd_api.g_false);
2584: x_msg_tbl(l_tot_msg_count).status := 'S';
2585: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2586: l_tot_msg_count := l_tot_msg_count + 1;
2587: l_msg_data := NULL;

Line 2623: p_encoded => fnd_api.g_false);

2619: p_token2_value => l_line_number
2620: );
2621:
2622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2623: p_encoded => fnd_api.g_false);
2624: x_msg_tbl(l_tot_msg_count).status := 'E';
2625: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2626: l_tot_msg_count := l_tot_msg_count + 1;
2627: l_msg_data := NULL;

Line 2655: p_encoded => fnd_api.g_false);

2651: p_token1_value => 'Invoicing Rule');
2652:
2653: --fnd_msg_pub.initialize;
2654: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2655: p_encoded => fnd_api.g_false);
2656: x_msg_tbl(l_tot_msg_count).status := 'S';
2657: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2658: l_tot_msg_count := l_tot_msg_count + 1;
2659: l_msg_data := NULL;

Line 2661: Elsif NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2657: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2658: l_tot_msg_count := l_tot_msg_count + 1;
2659: l_msg_data := NULL;
2660: -- Bug 5227077 --
2661: Elsif NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2662: FOR i in 1..fnd_msg_pub.count_msg
2663: Loop
2664: fnd_msg_pub.get
2665: (

Line 2702: p_encoded => fnd_api.g_false);

2698: p_token2 => 'Line No ',
2699: p_token2_value => l_line_number
2700: );
2701: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2702: p_encoded => fnd_api.g_false);
2703: x_msg_tbl(l_tot_msg_count).status := 'E';
2704: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2705: l_tot_msg_count := l_tot_msg_count + 1;
2706: l_msg_data := NULL;

Line 2727: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2723: x_return_status => l_return_status,
2724: x_msg_count => l_msg_count,
2725: x_msg_data => l_msg_data
2726: );
2727: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2728: FOR i in 1..fnd_msg_pub.count_msg
2729: Loop
2730: fnd_msg_pub.get
2731: (

Line 2753: p_encoded => fnd_api.g_false);

2749: p_token1 => 'ATTRIBUTE',
2750: p_token1_value => 'Invoicing Rule');
2751:
2752: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2753: p_encoded => fnd_api.g_false);
2754: x_msg_tbl(l_tot_msg_count).status := 'S';
2755: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2756: l_tot_msg_count := l_tot_msg_count + 1;
2757: l_msg_data := NULL;

Line 2788: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2784: x_msg_count => l_msg_count,
2785: x_msg_data => l_msg_data,
2786: p_scrv_tbl => l_scrv_tbl_in);
2787: -- Bug 527077 --
2788: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2789: FOR i in 1..fnd_msg_pub.count_msg
2790: Loop
2791: fnd_msg_pub.get
2792: (

Line 2826: p_encoded => fnd_api.g_false);

2822: p_token1 => 'ATTRIBUTE',
2823: p_token1_value => 'Sales Credit');
2824:
2825: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2826: p_encoded => fnd_api.g_false);
2827: x_msg_tbl(l_tot_msg_count).status := 'S';
2828: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2829: l_tot_msg_count := l_tot_msg_count + 1;
2830: l_msg_data := NULL;

Line 2832: Elsif not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2828: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2829: l_tot_msg_count := l_tot_msg_count + 1;
2830: l_msg_data := NULL;
2831: -- Bug 5227077 --
2832: Elsif not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2833: FOR i in 1..fnd_msg_pub.count_msg
2834: Loop
2835: fnd_msg_pub.get
2836: (

Line 2914: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2910: p_cust_account_id => l_line_cust_acct,
2911: x_return_status => l_return_status,
2912: x_msg_data => l_msg_data );
2913: -- Bug 5227077 --
2914: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2915: FOR i in 1..fnd_msg_pub.count_msg
2916: Loop
2917: fnd_msg_pub.get
2918: (

Line 2957: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2953: x_return_status => l_return_status,
2954: x_msg_data => l_msg_data );
2955:
2956: -- Bug 5227077 --
2957: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2958: FOR i in 1..fnd_msg_pub.count_msg
2959: Loop
2960: fnd_msg_pub.get
2961: (

Line 3013: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3009: x_return_status => l_return_status,
3010: x_msg_data => l_msg_data );
3011:
3012: -- Bug 5227077 --
3013: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3014: FOR i in 1..fnd_msg_pub.count_msg
3015: Loop
3016: fnd_msg_pub.get
3017: (

Line 3059: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3055: p_cust_account_id => l_header_cust_acct,
3056: x_return_status => l_return_status,
3057: x_msg_data => l_msg_data );
3058: -- Bug 5227077 --
3059: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3060: FOR i in 1..fnd_msg_pub.count_msg
3061: Loop
3062: fnd_msg_pub.get
3063: (

Line 3091: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3087: x_return_status => l_return_status,
3088: x_msg_data => l_msg_data);
3089:
3090: -- Bug 5227077 --
3091: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3092: FOR i in 1..fnd_msg_pub.count_msg
3093: Loop
3094: fnd_msg_pub.get
3095: (

Line 3151: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3147: x_return_status => l_return_status,
3148: x_msg_data => l_msg_data );
3149:
3150: -- Bug 5227077 --
3151: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3152: FOR i in 1..fnd_msg_pub.count_msg
3153: Loop
3154: fnd_msg_pub.get
3155: (

Line 3189: p_encoded => fnd_api.g_false);

3185: p_token1 => 'ATTRIBUTE',
3186: p_token1_value => 'Payment Method');
3187:
3188: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3189: p_encoded => fnd_api.g_false);
3190: x_msg_tbl(l_tot_msg_count).status := 'S';
3191: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3192: l_tot_msg_count := l_tot_msg_count + 1;
3193: l_msg_data := NULL;

Line 3215: p_encoded => fnd_api.g_false);

3211: p_token1 => 'ATTRIBUTE',
3212: p_token1_value => 'Price UOM');
3213:
3214: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3215: p_encoded => fnd_api.g_false);
3216:
3217: x_msg_tbl(l_tot_msg_count).status := 'S';
3218: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3219: l_tot_msg_count := l_tot_msg_count + 1;

Line 3238: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,p_encoded => fnd_api.g_false);

3234: ,l_validate_result => l_validate_result);
3235:
3236: IF NVL(l_validate_result,'N') IN ('U' ,'N') then -- Unexpected Error
3237: fnd_msg_pub.initialize;
3238: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,p_encoded => fnd_api.g_false);
3239: OKC_API.SET_MESSAGE(
3240: p_app_name => 'OKS', --G_APP_NAME_OKS,
3241: p_msg_name => 'OKS_INVALID_PRICE_LIST');
3242: x_msg_tbl(l_tot_msg_count).status := 'E';

Line 3268: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3264: l_return_status,
3265: l_msg_count,
3266: l_msg_data);
3267: -- Bug 5227077 --
3268: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3269: FOR i in 1..fnd_msg_pub.count_msg
3270: Loop
3271: fnd_msg_pub.get
3272: (

Line 3302: p_encoded => fnd_api.g_false);

3298: p_token1 => 'ATTRIBUTE',
3299: p_token1_value => 'Price List');
3300:
3301: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3302: p_encoded => fnd_api.g_false);
3303: x_msg_tbl(l_tot_msg_count).status := 'S';
3304: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3305: l_tot_msg_count := l_tot_msg_count + 1;
3306: l_msg_data := NULL;

Line 3318: p_encoded => fnd_api.g_false);

3314: p_token1 => 'ATTRIBUTE',
3315: p_token1_value => 'Price List');
3316:
3317: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3318: p_encoded => fnd_api.g_false);
3319: x_msg_tbl(l_tot_msg_count).status := 'S';
3320: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3321: l_tot_msg_count := l_tot_msg_count + 1;
3322: l_msg_data := NULL;

Line 3334: p_encoded => fnd_api.g_false);

3330: p_token1 => 'ATTRIBUTE',
3331: p_token1_value => 'Price List');
3332:
3333: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3334: p_encoded => fnd_api.g_false);
3335: x_msg_tbl(l_tot_msg_count).status := 'S';
3336: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3337: l_tot_msg_count := l_tot_msg_count + 1;
3338: l_msg_data := NULL;

Line 3381: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3377: x_klnv_tbl => l_klnv_tbl_out,
3378: p_validate_yn => 'N'
3379: );
3380: --errorout('Return status -'||l_return_status);
3381: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3382:
3383: FOR i in 1..fnd_msg_pub.count_msg
3384: Loop
3385: fnd_msg_pub.get

Line 3430: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3426: x_msg_data => l_msg_data
3427: );
3428:
3429:
3430: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3431:
3432: FOR i in 1..fnd_msg_pub.count_msg
3433: Loop
3434: fnd_msg_pub.get

Line 3454: IF l_header_price_list IS NOT NULL and l_return_status = FND_API.G_RET_STS_SUCCESS

3450: END IF;
3451:
3452: -- 8/23/2005 hkamdar R12 Partial Period
3453:
3454: IF l_header_price_list IS NOT NULL and l_return_status = FND_API.G_RET_STS_SUCCESS
3455: then
3456: -- Bug 4668385 --
3457: l_input_details.line_id := l_cle_id;
3458: If l_okc_lines_rec.lse_id = '46' Then

Line 3514: If l_header_dates is not null and l_return_status = FND_API.G_RET_STS_SUCCESS then

3510: -- BUg 5381082 --
3511: END IF;
3512: -- End 8/23/2005 hkamdar R12 Partial Period
3513:
3514: If l_header_dates is not null and l_return_status = FND_API.G_RET_STS_SUCCESS then
3515: --Fix for bug#3424479
3516: -- FIX DONE FOR USAGE CONTRACT SHOWING INCORRECT MESSAGE WHEN CASCADING DATES.
3517: -- ADDED CHECK FOR USAGE LINE lse_id <> 12
3518: -- GCHADHA 8-JULY-2004

Line 3535: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3531: p_service_Line_Id => l_cle_id,
3532: p_New_Start_Date => header_dates_rec.start_date,
3533: p_New_End_Date => header_dates_rec.end_date );
3534:
3535: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3536:
3537: FOR i in 1..fnd_msg_pub.count_msg
3538: Loop
3539: fnd_msg_pub.get

Line 3570: p_encoded => fnd_api.g_false);

3566: p_token2_value => l_line_number
3567: );
3568:
3569: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3570: p_encoded => fnd_api.g_false);
3571: x_msg_tbl(l_tot_msg_count).status := 'W';
3572: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3573: l_tot_msg_count := l_tot_msg_count + 1;
3574: l_msg_data := NULL;

Line 3597: p_encoded => fnd_api.g_false);

3593: x_msg_tbl(l_tot_msg_count).status := 'S';
3594: END IF;
3595:
3596: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3597: p_encoded => fnd_api.g_false);
3598: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3599: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3600: l_tot_msg_count := l_tot_msg_count + 1;
3601: l_msg_data := NULL;

Line 3623: p_encoded => fnd_api.g_false);

3619: p_token1_value => 'Date');
3620: x_msg_tbl(l_tot_msg_count).status := 'S';
3621: END IF;
3622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3623: p_encoded => fnd_api.g_false);
3624: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3625: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3626: l_tot_msg_count := l_tot_msg_count + 1;
3627: l_msg_data := NULL;

Line 3643: p_encoded => fnd_api.g_false);

3639: p_token2_value => l_line_number
3640: );
3641:
3642: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3643: p_encoded => fnd_api.g_false);
3644: x_msg_tbl(l_tot_msg_count).status := 'E';
3645: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3646: l_tot_msg_count := l_tot_msg_count + 1;
3647: l_msg_data := NULL;

Line 3653: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3649: END IF;
3650:
3651: close LINEcov_cur;
3652:
3653: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3654:
3655: OKS_PM_PROGRAMS_PVT.ADJUST_PM_PROGRAM_SCHEDULE
3656: (p_api_version => l_api_version,
3657: p_init_msg_list => l_init_msg_list,

Line 3666: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3662: x_msg_count => l_msg_count,
3663: x_msg_data => l_msg_data
3664: );
3665: -- Bug 5227077 --
3666: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3667: FOR i in 1..fnd_msg_pub.count_msg
3668: Loop
3669: fnd_msg_pub.get
3670: (

Line 3700: p_encoded => fnd_api.g_false);

3696: p_token2_value => l_line_number
3697: );
3698:
3699: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3700: p_encoded => fnd_api.g_false);
3701: x_msg_tbl(l_tot_msg_count).status := 'W';
3702: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3703: l_tot_msg_count := l_tot_msg_count + 1;
3704: l_msg_data := NULL;

Line 3726: p_encoded => fnd_api.g_false);

3722: x_msg_tbl(l_tot_msg_count).status := 'S';
3723: END IF;
3724:
3725: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3726: p_encoded => fnd_api.g_false);
3727: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3728: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3729: l_tot_msg_count := l_tot_msg_count + 1;
3730: l_msg_data := NULL;

Line 3754: p_encoded => fnd_api.g_false);

3750: x_msg_tbl(l_tot_msg_count).status := 'S';
3751:
3752: END IF;
3753: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3754: p_encoded => fnd_api.g_false);
3755: --x_msg_tbl(l_tot_msg_count).status := 'S';
3756: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3757: l_tot_msg_count := l_tot_msg_count + 1;
3758: l_msg_data := NULL;

Line 3783: p_encoded => fnd_api.g_false);

3779: p_token1_value => 'Date');
3780: x_msg_tbl(l_tot_msg_count).status := 'S';
3781: END IF;
3782: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3783: p_encoded => fnd_api.g_false);
3784: --x_msg_tbl(l_tot_msg_count).status := 'S';
3785: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3786: l_tot_msg_count := l_tot_msg_count + 1;
3787: l_msg_data := NULL;

Line 3915: p_encoded => fnd_api.g_false);

3911: p_token1 => 'ATTRIBUTE',
3912: p_token1_value => 'Recalculate Tax');
3913:
3914: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3915: p_encoded => fnd_api.g_false);
3916: x_msg_tbl(l_tot_msg_count).status := 'S';
3917: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3918: l_tot_msg_count := l_tot_msg_count + 1;
3919: l_msg_data := NULL;

Line 4066: p_encoded => fnd_api.g_false);

4062: p_token1 => 'ATTRIBUTE',
4063: p_token1_value => 'Recalculate Tax');
4064:
4065: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4066: p_encoded => fnd_api.g_false);
4067: x_msg_tbl(l_tot_msg_count).status := 'S';
4068: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4069: l_tot_msg_count := l_tot_msg_count + 1;
4070: l_msg_data := NULL;

Line 4125: p_encoded => fnd_api.g_false);

4121: p_token1 => 'ATTRIBUTE',
4122: p_token1_value => 'Recalculate Tax');
4123:
4124: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4125: p_encoded => fnd_api.g_false);
4126: x_msg_tbl(l_tot_msg_count).status := 'S';
4127: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4128: l_tot_msg_count := l_tot_msg_count + 1;
4129: l_msg_data := NULL;

Line 4171: p_encoded => fnd_api.g_false);

4167: i:=header_lines_tbl.next(i);
4168: END LOOP;
4169:
4170: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4171: p_encoded => fnd_api.g_false);
4172:
4173: /*
4174: If l_okc_lines_rec.lse_id <> '14' then
4175:

Line 4187: p_encoded => fnd_api.g_false

4183: x_msg_tbl(l_tot_msg_count).status := l_return_status;
4184: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4185:
4186: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,
4187: p_encoded => fnd_api.g_false
4188: );
4189: END LOOP;
4190: End If;
4191:

Line 4365: p_encoded => fnd_api.g_false);

4361: p_token1 => 'ATTRIBUTE',
4362: p_token1_value => 'Invoicing Text');
4363:
4364: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4365: p_encoded => fnd_api.g_false);
4366: x_msg_tbl(l_tot_msg_count).status := 'S';
4367: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4368: l_tot_msg_count := l_tot_msg_count + 1;
4369: l_msg_data := NULL;

Line 4390: p_encoded => fnd_api.g_false);

4386: p_token1 => 'ATTRIBUTE',
4387: p_token1_value => 'Renewal');
4388:
4389: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4390: p_encoded => fnd_api.g_false);
4391: x_msg_tbl(l_tot_msg_count).status := 'S';
4392: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4393: l_tot_msg_count := l_tot_msg_count + 1;
4394: l_msg_data := NULL;

Line 4427: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4423: ,x_msg_data => l_msg_data
4424: ,x_flag => l_flag);
4425:
4426:
4427: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4428: FOR i in 1..fnd_msg_pub.count_msg
4429: Loop
4430: fnd_msg_pub.get
4431: (

Line 4454: p_encoded => fnd_api.g_false);

4450: p_token1_value => l_sub_line_seq_number);
4451:
4452:
4453: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4454: p_encoded => fnd_api.g_false);
4455: x_msg_tbl(l_tot_msg_count).status := 'E';
4456: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4457: l_tot_msg_count := l_tot_msg_count + 1;
4458: l_msg_data := NULL;

Line 4509: p_encoded => fnd_api.g_false);

4505: END IF;
4506: END IF;
4507: ----new
4508: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4509: p_encoded => fnd_api.g_false);
4510: -- x_msg_tbl(l_tot_msg_count).status := 'S';
4511: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4512: l_tot_msg_count := l_tot_msg_count + 1;
4513: l_msg_data := NULL;

Line 4535: p_encoded => fnd_api.g_false);

4531: END IF;
4532:
4533: ----new
4534: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4535: p_encoded => fnd_api.g_false);
4536: x_msg_tbl(l_tot_msg_count).status := 'S';
4537: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4538: l_tot_msg_count := l_tot_msg_count + 1;
4539: l_msg_data := NULL;

Line 4573: p_encoded => fnd_api.g_false);

4569: p_token1 => 'ATTRIBUTE',
4570: p_token1_value => 'Price UOM');
4571:
4572: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4573: p_encoded => fnd_api.g_false);
4574: x_msg_tbl(l_tot_msg_count).status := 'S';
4575: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4576: l_tot_msg_count := l_tot_msg_count + 1;
4577: l_msg_data := NULL;

Line 4588: p_encoded => fnd_api.g_false);

4584: p_token1 => 'ATTRIBUTE',
4585: p_token1_value => 'Price UOM');
4586:
4587: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4588: p_encoded => fnd_api.g_false);
4589: ----errorout_gsi('Subline_common_attribute UOM msg '||l_msg_data);
4590: x_msg_tbl(l_tot_msg_count).status := 'E';
4591: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4592: l_tot_msg_count := l_tot_msg_count + 1;

Line 4747: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4743: ,p_price_uom => l_line_price_uom -- 8/23/05 hkamdar R12 Partial Period
4744: ,x_return_status => l_return_status
4745: );
4746: -- Bug 5227077 --
4747: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4748:
4749: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: end if;
4751: -- Bug 5227077 --

Line 5170: p_encoded => fnd_api.g_false);

5166:
5167: -- END GCHADHA --
5168:
5169: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
5170: p_encoded => fnd_api.g_false);
5171: WHILE l_msg_data IS NOT NULL
5172: LOOP
5173: IF x_msg_tbl.count=0 THEN
5174: l_tot_msg_count:=1 ;

Line 5185: p_encoded => fnd_api.g_false);

5181: x_msg_tbl(l_tot_msg_count).status := l_return_status;
5182: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5183:
5184: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,
5185: p_encoded => fnd_api.g_false);
5186: END LOOP;
5187:
5188: END IF;
5189: --new

Line 5251: p_init_msg_list => FND_API.G_FALSE,

5247:
5248: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
5249: (
5250: p_api_version => 1.0,
5251: p_init_msg_list => FND_API.G_FALSE,
5252: p_commit => FND_API.G_FALSE,
5253: x_return_status => l_return_status,
5254: x_msg_count => l_msg_count,
5255: x_msg_data => l_msg_data,

Line 5252: p_commit => FND_API.G_FALSE,

5248: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
5249: (
5250: p_api_version => 1.0,
5251: p_init_msg_list => FND_API.G_FALSE,
5252: p_commit => FND_API.G_FALSE,
5253: x_return_status => l_return_status,
5254: x_msg_count => l_msg_count,
5255: x_msg_data => l_msg_data,
5256: p_payer => l_payer,

Line 5362: ,p_init_msg_list => FND_API.G_TRUE

5358: -- Create Transaction Extension Id
5359: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
5360: (
5361: p_api_version => 1.0
5362: ,p_init_msg_list => FND_API.G_TRUE
5363: ,p_commit => FND_API.G_FALSE
5364: ,x_return_status => l_return_status
5365: ,x_msg_count => l_msg_count
5366: ,x_msg_data => l_msg_data

Line 5363: ,p_commit => FND_API.G_FALSE

5359: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
5360: (
5361: p_api_version => 1.0
5362: ,p_init_msg_list => FND_API.G_TRUE
5363: ,p_commit => FND_API.G_FALSE
5364: ,x_return_status => l_return_status
5365: ,x_msg_count => l_msg_count
5366: ,x_msg_data => l_msg_data
5367: ,p_payer => l_payer