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.OZF_QUOTA_THRESHOLD_PVT dependencies on FND_FILE

Line 379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside quota api ....... ' );

375: -- Debug Message
376: IF G_DEBUG THEN
377: OZF_UTILITY_PVT.debug_message('Private QUOTA API: ' || l_api_name || ' start');
378: END IF;
379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside quota api ....... ' );
380: OPEN c_trans_seq;
381: FETCH c_trans_seq INTO l_trans_id;
382: CLOSE c_trans_seq;
383: -- Initialize API return status to SUCCESS

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside rules loop rule id : ' || rule.threshold_rule_id);

400: END IF;
401:
402: FOR rule IN c_threshold_rules_cur
403: LOOP
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside rules loop rule id : ' || rule.threshold_rule_id);
405: FOR budget IN c_threshold_funds(rule.threshold_rule_id)
406: LOOP
407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside budget loop budget id :' || budget.budget_id);
408: l_operation_result_notify := '';

Line 407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside budget loop budget id :' || budget.budget_id);

403: LOOP
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside rules loop rule id : ' || rule.threshold_rule_id);
405: FOR budget IN c_threshold_funds(rule.threshold_rule_id)
406: LOOP
407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside budget loop budget id :' || budget.budget_id);
408: l_operation_result_notify := '';
409: l_operator_meaning := '';
410: l_notification_result := '';
411: l_alert_no := 0;

Line 419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop :: Product :' || product.item_id );

415: l_quota_ly_sales := 0;
416:
417: FOR product IN c_product_facts(budget.budget_id)
418: LOOP
419: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop :: Product :' || product.item_id );
420: l_operation_result := '';
421: l_alert_str := '';
422: IF budget.comparison_type = 'PERCENT' then
423: IF budget.base_line = 'MONTHLY_QUOTA' THEN

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_value_limit :' || l_value_limit );

471: l_value_limit := product.mtd_sales + product.outst_order + product.back_order + product.current_order;
472: l_alert_str := 'total_ship_alert'; */
473: END IF;
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_value_limit :' || l_value_limit );
476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_base_line_amt :' || l_base_line_amt );
477: --l_base_line_amt is rhs for operation_result imput.
478: operation_result(l_api_version_number,
479: FND_API.G_FALSE,

Line 476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_base_line_amt :' || l_base_line_amt );

472: l_alert_str := 'total_ship_alert'; */
473: END IF;
474:
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_value_limit :' || l_value_limit );
476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside Product loop - l_base_line_amt :' || l_base_line_amt );
477: --l_base_line_amt is rhs for operation_result imput.
478: operation_result(l_api_version_number,
479: FND_API.G_FALSE,
480: l_Msg_Count,

Line 490: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );

486: l_operation_result);
487: IF G_DEBUG THEN
488: OZF_UTILITY_PVT.debug_message('l_operation_result: ' || l_operation_result);
489: END IF;
490: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
491:
492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;

Line 524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside customer loop :: Customer :' || customer.cust_account_id );

520: LOOP
521: l_quota_lysp_sales := l_quota_lysp_sales + customer.lysp_sales;
522: l_quota_lysq_sales := l_quota_lysq_sales + customer.lysq_sales;
523: l_quota_ly_sales := l_quota_ly_sales + customer.ly_sales;
524: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside customer loop :: Customer :' || customer.cust_account_id );
525: l_operation_result := '';
526: l_alert_str := '';
527: IF budget.comparison_type = 'PERCENT' then
528: IF budget.base_line = 'MONTHLY_QUOTA' THEN

Line 579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_value_limit :' || l_value_limit );

575: /*ELSIF budget.value_limit = 'TOTAL_SHIPMENTS' THEN
576: l_value_limit := customer.mtd_sales + customer.outst_order + customer.back_order + customer.current_order;
577: l_alert_str := 'total_ship_alert'; */
578: END IF;
579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_value_limit :' || l_value_limit );
580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_base_line_amt :' || l_base_line_amt );
581:
582: --l_base_line_amt is rhs for operation_result imput.
583: operation_result(l_api_version_number,

Line 580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_base_line_amt :' || l_base_line_amt );

576: l_value_limit := customer.mtd_sales + customer.outst_order + customer.back_order + customer.current_order;
577: l_alert_str := 'total_ship_alert'; */
578: END IF;
579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_value_limit :' || l_value_limit );
580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer - l_base_line_amt :' || l_base_line_amt );
581:
582: --l_base_line_amt is rhs for operation_result imput.
583: operation_result(l_api_version_number,
584: FND_API.G_FALSE,

Line 595: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );

591: l_operation_result);
592: IF G_DEBUG THEN
593: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
594: END IF;
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
596:
597: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysp_sales :' || l_quota_lysp_sales );

616: END IF;
617: END IF;
618:
619: END LOOP;
620: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysp_sales :' || l_quota_lysp_sales );
621: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysq_sales :' || l_quota_lysq_sales );
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_ly_sales :' || l_quota_ly_sales );
623:
624: IF budget.value_limit = 'MTD' OR budget.value_limit = 'QTD'

Line 621: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysq_sales :' || l_quota_lysq_sales );

617: END IF;
618:
619: END LOOP;
620: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysp_sales :' || l_quota_lysp_sales );
621: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysq_sales :' || l_quota_lysq_sales );
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_ly_sales :' || l_quota_ly_sales );
623:
624: IF budget.value_limit = 'MTD' OR budget.value_limit = 'QTD'
625: OR budget.value_limit = 'YTD' THEN

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_ly_sales :' || l_quota_ly_sales );

618:
619: END LOOP;
620: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysp_sales :' || l_quota_lysp_sales );
621: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_lysq_sales :' || l_quota_lysq_sales );
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_quota_ly_sales :' || l_quota_ly_sales );
623:
624: IF budget.value_limit = 'MTD' OR budget.value_limit = 'QTD'
625: OR budget.value_limit = 'YTD' THEN
626: l_quota := 0;

Line 629: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside quota loop ' );

625: OR budget.value_limit = 'YTD' THEN
626: l_quota := 0;
627: FOR quota IN c_quota(budget.owner)
628: LOOP
629: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside quota loop ' );
630: l_operation_result := '';
631: IF budget.comparison_type = 'PERCENT' then
632: IF budget.base_line = 'MONTHLY_QUOTA' THEN
633: IF quota.sequence_number = 1 THEN

Line 699: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_value_limit :' || l_value_limit );

695:
696: END IF;
697:
698:
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_value_limit :' || l_value_limit );
700: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_base_line_amt :' || l_base_line_amt );
701:
702: --l_base_line_amt is rhs for operation_result imput.
703: operation_result(l_api_version_number,

Line 700: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_base_line_amt :' || l_base_line_amt );

696: END IF;
697:
698:
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_value_limit :' || l_value_limit );
700: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quota - l_base_line_amt :' || l_base_line_amt );
701:
702: --l_base_line_amt is rhs for operation_result imput.
703: operation_result(l_api_version_number,
704: FND_API.G_FALSE,

Line 715: FND_FILE.PUT_LINE(FND_FILE.LOG,'budget.operator_code :' || budget.operator_code );

711: l_operation_result);
712: IF G_DEBUG THEN
713: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
714: END IF;
715: FND_FILE.PUT_LINE(FND_FILE.LOG,'budget.operator_code :' || budget.operator_code );
716: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
717:
718: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
719: RAISE FND_API.G_EXC_ERROR;

Line 716: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );

712: IF G_DEBUG THEN
713: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
714: END IF;
715: FND_FILE.PUT_LINE(FND_FILE.LOG,'budget.operator_code :' || budget.operator_code );
716: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
717:
718: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;

Line 741: FND_FILE.PUT_LINE(FND_FILE.LOG,' budget.alert_type:' || budget.alert_type);

737: END IF;
738: l_operation_result_notify := 'VIOLATED';
739: OZF_UTILITY_PVT.debug_message(' budget.alert_type:' || budget.alert_type);
740: OZF_UTILITY_PVT.debug_message(' l_alert_no:' ||l_alert_no );
741: FND_FILE.PUT_LINE(FND_FILE.LOG,' budget.alert_type:' || budget.alert_type);
742: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_alert_no:' ||l_alert_no );
743: END IF;
744: END LOOP;
745: END IF;

Line 742: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_alert_no:' ||l_alert_no );

738: l_operation_result_notify := 'VIOLATED';
739: OZF_UTILITY_PVT.debug_message(' budget.alert_type:' || budget.alert_type);
740: OZF_UTILITY_PVT.debug_message(' l_alert_no:' ||l_alert_no );
741: FND_FILE.PUT_LINE(FND_FILE.LOG,' budget.alert_type:' || budget.alert_type);
742: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_alert_no:' ||l_alert_no );
743: END IF;
744: END LOOP;
745: END IF;
746:

Line 750: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_operation_result_notify : ' || l_operation_result_notify);

746:
747: /* l_opeartion_result is deciding factor in calling verify_notification.
748: if l_opearation_result is 'VIOLATED' then we will call verify_notification
749: else if the l_opearation_result is 'NOT VIOLATED' then we will not call verify_notification*/
750: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_operation_result_notify : ' || l_operation_result_notify);
751: IF l_operation_result_notify = 'VIOLATED' THEN
752: verify_notification( l_api_version_number,
753: FND_API.G_FALSE,
754: l_Msg_Count,

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_notification_result : ' || l_notification_result);

764:
765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_notification_result : ' || l_notification_result);
769: --l_notification_result will drive write_to_log
770: IF G_DEBUG THEN
771: OZF_UTILITY_PVT.debug_message('Notify result: ' || l_notification_result );
772: END IF;

Line 945: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of quota validation : ' );

941: x_retcode := 0;
942:
943: ozf_utility_pvt.write_conc_log(l_msg_data);
944:
945: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of quota validation : ' );
946: -- RAISE FND_API.G_EXC_ERROR;
947: EXCEPTION
948:
949: WHEN FND_API.G_EXC_ERROR THEN

Line 951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);

947: EXCEPTION
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950: --ROLLBACK TO validate_quota_threshold;
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);
952: x_retcode := 1;
953: x_errbuf := substr(l_msg_data,1,1000);
954: ozf_utility_pvt.write_conc_log(l_msg_data);
955:

Line 958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);

954: ozf_utility_pvt.write_conc_log(l_msg_data);
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: --ROLLBACK TO validate_quota_threshold;
958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);
959: x_retcode := 1;
960: x_errbuf := substr(l_msg_data,1,1000);
961: ozf_utility_pvt.write_conc_log(l_msg_data);
962:

Line 965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);

961: ozf_utility_pvt.write_conc_log(l_msg_data);
962:
963: WHEN OTHERS THEN
964: --ROLLBACK TO validate_quota_threshold;
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
966: x_retcode := 1;
967: x_errbuf := substr(l_msg_data,1,1000);
968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);
969: ozf_utility_pvt.write_conc_log(l_msg_data);

Line 968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);

964: --ROLLBACK TO validate_quota_threshold;
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
966: x_retcode := 1;
967: x_errbuf := substr(l_msg_data,1,1000);
968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);
969: ozf_utility_pvt.write_conc_log(l_msg_data);
970:
971: END validate_quota_threshold;
972:

Line 1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);

1288: END IF;
1289:
1290: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1291:
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);

Line 1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);

1289:
1290: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1291:
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);

Line 1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);

1290: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1291:
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);

Line 1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);

1291:
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);
1299:

Line 1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);

1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);
1299:
1300: -- Initialize API return status to SUCCESS

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);

1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);
1299:
1300: -- Initialize API return status to SUCCESS
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);

1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_attribute2: '|| p_attribute2);
1296: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_type: '|| p_alert_type);
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_select_attribute: '|| p_select_attribute);
1298: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_cust_account_id: '|| p_cust_account_id);
1299:
1300: -- Initialize API return status to SUCCESS
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302: l_sql_stmt := '';

Line 1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);

1349: l_ins_csr := DBMS_SQL.open_cursor;
1350: FND_DSQL.set_cursor(l_ins_csr);
1351: l_stmt := FND_DSQL.get_text(FALSE);
1352:
1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);
1354: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1355: FND_DSQL.do_binds;
1356: l_ignore := DBMS_SQL.execute(l_ins_csr);
1357: */

Line 1383: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );

1379: l_sql_str := l_sql_str || ') VALUES (' || l_quota_alert_id || ',''' || TRUNC(SYSDATE) || ''',';
1380: l_sql_str := l_sql_str || p_resource_id || ','''||'PROD'',''' || p_product_attribute || ''',';
1381: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1382:
1383: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1384: FND_DSQL.init;
1385: FND_DSQL.add_text(l_sql_str);
1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);

Line 1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);

1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);
1388: l_stmt := FND_DSQL.get_text(FALSE);
1389:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);
1391: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1392: FND_DSQL.do_binds;
1393: l_ignore := DBMS_SQL.execute(l_ins_csr);
1394:

Line 1407: FND_FILE.PUT_LINE(FND_FILE.LOG,'PROD EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));

1403: p_encoded => FND_API.G_FALSE,
1404: p_count => x_msg_count,
1405: p_data => x_msg_data
1406: );
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,'PROD EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1408: END;
1409:
1410: ELSIF p_alert_for = 'CUST' THEN
1411: BEGIN

Line 1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);

1445: l_ins_csr := DBMS_SQL.open_cursor;
1446: FND_DSQL.set_cursor(l_ins_csr);
1447: l_stmt := FND_DSQL.get_text(FALSE);
1448:
1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1450: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1451: FND_DSQL.do_binds;
1452: l_ignore := DBMS_SQL.execute(l_ins_csr);
1453: */

Line 1480: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );

1476: l_sql_str := l_sql_str || ') VALUES (' || l_quota_alert_id || ',''' || TRUNC(SYSDATE) || ''',';
1477: l_sql_str := l_sql_str || p_resource_id || ','''||'CUST'',''' || p_cust_account_id || ''',';
1478: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1479:
1480: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1481: FND_DSQL.init;
1482: FND_DSQL.add_text(l_sql_str);
1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);

Line 1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);

1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);
1485: l_stmt := FND_DSQL.get_text(FALSE);
1486:
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);
1488: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1489: FND_DSQL.do_binds;
1490: l_ignore := DBMS_SQL.execute(l_ins_csr);
1491:

Line 1504: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUST EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));

1500: p_encoded => FND_API.G_FALSE,
1501: p_count => x_msg_count,
1502: p_data => x_msg_data
1503: );
1504: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUST EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1505: END;
1506:
1507: ELSIF p_alert_for = 'QUOTA' THEN
1508: BEGIN

Line 1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);

1540: l_ins_csr := DBMS_SQL.open_cursor;
1541: FND_DSQL.set_cursor(l_ins_csr);
1542: l_stmt := FND_DSQL.get_text(FALSE);
1543:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1545: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1546: FND_DSQL.do_binds;
1547: l_ignore := DBMS_SQL.execute(l_ins_csr);
1548: */

Line 1564: FND_FILE.PUT_LINE(FND_FILE.LOG,'QUOTA EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));

1560: WHEN NO_DATA_FOUND THEN
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: x_msg_count := 1;
1563: x_msg_data := SUBSTR(SQLERRM, 1, 2000);
1564: FND_FILE.PUT_LINE(FND_FILE.LOG,'QUOTA EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1565:
1566: WHEN OTHERS THEN
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1578: FND_FILE.PUT_LINE(FND_FILE.LOG,'QUOTA EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));

1574: p_encoded => FND_API.G_FALSE,
1575: p_count => x_msg_count,
1576: p_data => x_msg_data
1577: );
1578: FND_FILE.PUT_LINE(FND_FILE.LOG,'QUOTA EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1579: END;
1580: END IF;
1581:
1582:

Line 1603: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_alerts EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));

1599: p_encoded => FND_API.G_FALSE,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data
1602: );
1603: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_alerts EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1604: END update_alerts;
1605:
1606: END OZF_QUOTA_THRESHOLD_PVT;