413: RETURN -1;
414: END IF;
415:
416: IF x_committed = 1 THEN
417: y_committed := fnd_api.g_true;
418: ELSE
419: y_committed := fnd_api.g_false;
420: END IF;
421:
415:
416: IF x_committed = 1 THEN
417: y_committed := fnd_api.g_true;
418: ELSE
419: y_committed := fnd_api.g_false;
420: END IF;
421:
422: --
423: -- Some input can be -1, if that's the case, set to null
457: --
458:
459: qa_results_pub.insert_row(
460: p_api_version => 1.0,
461: p_init_msg_list => fnd_api.g_true,
462: p_org_id => x_org_id,
463: p_plan_id => x_plan_id,
464: p_spec_id => y_spec_id,
465: p_transaction_number => null,
476: x_return_status => return_status,
477: x_action_result => action_result);
478:
479: IF qa_validation_api.no_errors(error_array) AND
480: return_status <> FND_API.G_RET_STS_ERROR AND
481: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RETURN 0;
483: ELSE
484: get_error_messages(error_array, x_plan_id, x_messages);
477: x_action_result => action_result);
478:
479: IF qa_validation_api.no_errors(error_array) AND
480: return_status <> FND_API.G_RET_STS_ERROR AND
481: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RETURN 0;
483: ELSE
484: get_error_messages(error_array, x_plan_id, x_messages);
485: END IF;
580: RETURN -1;
581: END IF;
582:
583: IF x_committed = 1 THEN
584: y_committed := fnd_api.g_true;
585: ELSE
586: y_committed := fnd_api.g_false;
587: END IF;
588:
582:
583: IF x_committed = 1 THEN
584: y_committed := fnd_api.g_true;
585: ELSE
586: y_committed := fnd_api.g_false;
587: END IF;
588:
589: --
590: -- Some input can be -1, if that's the case, set to null
631: initialize_seq_elements(x_plan_id, elements);
632:
633: qa_results_pub.insert_row(
634: p_api_version => 1.0,
635: p_init_msg_list => fnd_api.g_true,
636: p_org_id => x_org_id,
637: p_plan_id => x_plan_id,
638: p_spec_id => y_spec_id,
639: p_transaction_number => x_transaction_number,
650: x_return_status => return_status,
651: x_action_result => action_result);
652:
653: IF qa_validation_api.no_errors(error_array) AND
654: return_status <> FND_API.G_RET_STS_ERROR AND
655: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
656: get_action_messages(message_array, x_plan_id, x_messages);
657: RETURN 0;
658: ELSE
651: x_action_result => action_result);
652:
653: IF qa_validation_api.no_errors(error_array) AND
654: return_status <> FND_API.G_RET_STS_ERROR AND
655: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
656: get_action_messages(message_array, x_plan_id, x_messages);
657: RETURN 0;
658: ELSE
659: get_error_messages(error_array, x_plan_id, x_messages);
762: RETURN -1;
763: END IF;
764: */
765: IF x_committed = 1 THEN
766: y_committed := fnd_api.g_true;
767: ELSE
768: y_committed := fnd_api.g_false;
769: END IF;
770:
764: */
765: IF x_committed = 1 THEN
766: y_committed := fnd_api.g_true;
767: ELSE
768: y_committed := fnd_api.g_false;
769: END IF;
770:
771: --
772: -- Some input can be -1, if that's the case, set to null
850: -- again at the time of the data insertion
851: --
852: qa_results_pub.insert_row(
853: p_api_version => 1.0,
854: p_init_msg_list => fnd_api.g_true,
855: p_org_id => x_org_id,
856: p_plan_id => x_plan_id,
857: p_spec_id => y_spec_id,
858: p_transaction_number => x_transaction_number,
872: p_ssqr_operation => l_ssqr_operation,
873: p_last_update_date => p_last_update_date);
874:
875: IF qa_validation_api.no_errors(error_array) AND
876: return_status <> FND_API.G_RET_STS_ERROR AND
877: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
878: get_action_messages(message_array, x_plan_id, x_messages);
879:
880: --create relationship with parent
873: p_last_update_date => p_last_update_date);
874:
875: IF qa_validation_api.no_errors(error_array) AND
876: return_status <> FND_API.G_RET_STS_ERROR AND
877: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
878: get_action_messages(message_array, x_plan_id, x_messages);
879:
880: --create relationship with parent
881:
1056: -- RETURN -1;
1057: --END IF;
1058:
1059: IF x_committed = 1 THEN
1060: y_committed := fnd_api.g_true;
1061: ELSE
1062: y_committed := fnd_api.g_false;
1063: END IF;
1064:
1058:
1059: IF x_committed = 1 THEN
1060: y_committed := fnd_api.g_true;
1061: ELSE
1062: y_committed := fnd_api.g_false;
1063: END IF;
1064:
1065: --
1066: -- Some input can be -1, if that's the case, set to null
1101: END IF;
1102:
1103: qa_results_pub.update_row(
1104: p_api_version => 1.0,
1105: p_init_msg_list => fnd_api.g_true,
1106: p_commit => y_committed,
1107: p_plan_id => x_plan_id,
1108: p_spec_id => y_spec_id,
1109: p_org_id => x_org_id,
1130: get_action_messages(message_array, x_plan_id, x_messages);
1131:
1132:
1133: RETURN 0;
1134: ELSIF return_status <> FND_API.G_RET_STS_ERROR AND
1135: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: get_error_messages(error_array, x_plan_id, x_messages);
1137: END IF;
1138:
1131:
1132:
1133: RETURN 0;
1134: ELSIF return_status <> FND_API.G_RET_STS_ERROR AND
1135: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: get_error_messages(error_array, x_plan_id, x_messages);
1137: END IF;
1138:
1139: RETURN -1;
1288: RETURN -1;
1289: END IF;
1290:
1291: IF x_committed = 1 THEN
1292: y_committed := fnd_api.g_true;
1293: ELSE
1294: y_committed := fnd_api.g_false;
1295: END IF;
1296:
1290:
1291: IF x_committed = 1 THEN
1292: y_committed := fnd_api.g_true;
1293: ELSE
1294: y_committed := fnd_api.g_false;
1295: END IF;
1296:
1297: --
1298: -- Some input can be -1, if that's the case, set to null
1350: -- again at the time of the data updation
1351: --
1352: qa_results_pub.update_row(
1353: p_api_version => 1.0,
1354: p_init_msg_list => fnd_api.g_true,
1355: p_commit => y_committed,
1356: p_plan_id => x_plan_id,
1357: p_spec_id => y_spec_id,
1358: p_org_id => x_org_id,
1526: x_collection_id, x_occurrence);
1527: END IF;
1528:
1529: RETURN 0;
1530: ELSIF return_status <> FND_API.G_RET_STS_ERROR AND
1531: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1532: get_error_messages(error_array, x_plan_id, x_messages);
1533: END IF;
1534:
1527: END IF;
1528:
1529: RETURN 0;
1530: ELSIF return_status <> FND_API.G_RET_STS_ERROR AND
1531: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1532: get_error_messages(error_array, x_plan_id, x_messages);
1533: END IF;
1534:
1535: RETURN -1;
1835: BEGIN
1836:
1837: qa_results_pub.enable_and_fire_action (
1838: p_api_version => 1.0,
1839: p_commit => FND_API.G_TRUE,
1840: p_collection_id => q_collection_id,
1841: x_return_status => q_return_status,
1842: x_msg_count => q_msg_count,
1843: x_msg_data => q_msg_data);