1367: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
1368:
1369: IF NVL(TmpFIDtlInsTab.COUNT,0) > 0 THEN
1370:
1371: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
1372:
1373: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab,
1374: lv_return_status,
1375: x_msg_count,
1369: IF NVL(TmpFIDtlInsTab.COUNT,0) > 0 THEN
1370:
1371: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
1372:
1373: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab,
1374: lv_return_status,
1375: x_msg_count,
1376: x_msg_data);
1377:
1382: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
1383:
1384: IF NVL(TmpFIDtlUpdTab.COUNT,0) > 0 THEN
1385:
1386: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
1387:
1388: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
1389: lv_return_status, x_msg_count, x_msg_data);
1390:
1384: IF NVL(TmpFIDtlUpdTab.COUNT,0) > 0 THEN
1385:
1386: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
1387:
1388: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
1389: lv_return_status, x_msg_count, x_msg_data);
1390:
1391: END IF;
1392:
2773:
2774: IF nvl(TmpRevTab.COUNT,0) > 0 THEN
2775:
2776: Print_message(
2777: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
2778:
2779: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
2780: lv_return_status,
2781: x_msg_count,
2775:
2776: Print_message(
2777: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
2778:
2779: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
2780: lv_return_status,
2781: x_msg_count,
2782: x_msg_data);
2783:
2787:
2788: IF nvl(TmpUpdTab.COUNT,0) > 0 THEN
2789:
2790: Print_message(
2791: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
2792:
2793: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
2794: lv_return_status,
2795: x_msg_count,
2789:
2790: Print_message(
2791: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
2792:
2793: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
2794: lv_return_status,
2795: x_msg_count,
2796: x_msg_data);
2797:
5589: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
5590:
5591: IF TmpFIDtlInsTab.COUNT > 0 THEN
5592:
5593: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
5594:
5595: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab,
5596: lv_return_status,
5597: x_msg_count,
5591: IF TmpFIDtlInsTab.COUNT > 0 THEN
5592:
5593: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
5594:
5595: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab,
5596: lv_return_status,
5597: x_msg_count,
5598: x_msg_data);
5599: END IF;
5603: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
5604:
5605: IF TmpFIDtlUpdTab.COUNT > 0 THEN
5606:
5607: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
5608:
5609: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
5610: lv_return_status,
5611: x_msg_count,
5605: IF TmpFIDtlUpdTab.COUNT > 0 THEN
5606:
5607: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
5608:
5609: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
5610: lv_return_status,
5611: x_msg_count,
5612: x_msg_data);
5613: END IF;
6582:
6583: IF TmpRevTab.COUNT > 0 THEN
6584:
6585: Print_message(
6586: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows ');
6587:
6588: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
6589: lv_return_status,
6590: x_msg_count,
6584:
6585: Print_message(
6586: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows ');
6587:
6588: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
6589: lv_return_status,
6590: x_msg_count,
6591: x_msg_data);
6592:
6596:
6597: IF TmpUpdTab.COUNT > 0 THEN
6598:
6599: Print_message(
6600: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows ');
6601:
6602: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
6603: lv_return_status,
6604: x_msg_count,
6598:
6599: Print_message(
6600: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows ');
6601:
6602: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
6603: lv_return_status,
6604: x_msg_count,
6605: x_msg_data);
6606: END IF;
7337:
7338: IF TmpRevTab.COUNT > 0 THEN
7339:
7340: Print_message(
7341: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows ');
7342:
7343: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
7344: lv_return_status,
7345: x_msg_count,
7339:
7340: Print_message(
7341: 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows ');
7342:
7343: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpRevTab,
7344: lv_return_status,
7345: x_msg_count,
7346: x_msg_data);
7347:
7351:
7352: IF TmpUpdTab.COUNT > 0 THEN
7353:
7354: Print_message(
7355: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows ');
7356:
7357: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
7358: lv_return_status,
7359: x_msg_count,
7353:
7354: Print_message(
7355: 'Calling PA_FORECAST_DTLS_PKG.Update_Rows ');
7356:
7357: PA_FORECAST_DTLS_PKG.Update_Rows(TmpUpdTab,
7358: lv_return_status,
7359: x_msg_count,
7360: x_msg_data);
7361: END IF;
10327: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
10328:
10329: IF TmpFIDtlInsTab.COUNT > 0 THEN
10330:
10331: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
10332:
10333: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab, lv_return_status,
10334: x_msg_count,
10335: x_msg_data);
10329: IF TmpFIDtlInsTab.COUNT > 0 THEN
10330:
10331: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Insert_Rows');
10332:
10333: PA_FORECAST_DTLS_PKG.Insert_Rows(TmpFIDtlInsTab, lv_return_status,
10334: x_msg_count,
10335: x_msg_data);
10336: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
10337:
10343: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
10344:
10345: IF TmpFIDtlUpdTab.COUNT > 0 THEN
10346:
10347: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
10348:
10349: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
10350: lv_return_status,
10351: x_msg_count,
10345: IF TmpFIDtlUpdTab.COUNT > 0 THEN
10346:
10347: Print_message( 'Calling PA_FORECAST_DTLS_PKG.Update_Rows');
10348:
10349: PA_FORECAST_DTLS_PKG.Update_Rows(TmpFIDtlUpdTab,
10350: lv_return_status,
10351: x_msg_count,
10352: x_msg_data);
10353: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
15287: print_message('End calling PA_FORECAST_HDR_PKG.Insert_Rows');
15288: end if;
15289:
15290: if (nvl(lt_FIDtlInsTab.count,0) <> 0) then
15291: print_message('Start calling PA_FORECAST_DTLS_PKG.Insert_Rows');
15292: PA_FORECAST_DTLS_PKG.Insert_Rows(
15293: lt_FIDtlInsTab,
15294: x_return_status,
15295: x_msg_count,
15288: end if;
15289:
15290: if (nvl(lt_FIDtlInsTab.count,0) <> 0) then
15291: print_message('Start calling PA_FORECAST_DTLS_PKG.Insert_Rows');
15292: PA_FORECAST_DTLS_PKG.Insert_Rows(
15293: lt_FIDtlInsTab,
15294: x_return_status,
15295: x_msg_count,
15296: x_msg_data);
15293: lt_FIDtlInsTab,
15294: x_return_status,
15295: x_msg_count,
15296: x_msg_data);
15297: print_message('End calling PA_FORECAST_DTLS_PKG.Insert_Rows');
15298: end if;
15299:
15300: EXCEPTION
15301: WHEN OTHERS THEN