DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on FND_MESSAGE

Line 712: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');

708: null,
709: null);
710: END IF;
711: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
712: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
713: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
714: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
715: fnd_msg_pub.add();
716: END IF;

Line 713: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);

709: null);
710: END IF;
711: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
712: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
713: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
714: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
715: fnd_msg_pub.add();
716: END IF;
717: END IF; -- (Y_SPEC_ID <> 0)...

Line 714: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);

710: END IF;
711: IF ((low_value_tab(i) = -99999) OR (high_value_tab(i) = -99999)) THEN
712: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
713: fnd_message.set_token('ENTITY1', prec.SPEC_CHAR_UOM);
714: fnd_message.set_token('ENTITY2', prec.PLAN_CHAR_UOM);
715: fnd_msg_pub.add();
716: END IF;
717: END IF; -- (Y_SPEC_ID <> 0)...
718: END LOOP;

Line 837: X_message := FND_MESSAGE.GET;

833: EXCEPTION
834: WHEN OTHERS THEN
835: -- write exceptions to action log;
836: X_ERROR := FALSE;
837: X_message := FND_MESSAGE.GET;
838: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
839: X_CREATION_DATE,char_id_tab(i),
840: operator_tab(i),low_value_tab(i),
841: high_value_tab(i),X_message,

Line 884: X_message := FND_MESSAGE.GET;

880: EXCEPTION
881: WHEN OTHERS THEN
882: -- write exceptions to action log;
883: X_ERROR := FALSE;
884: X_message := FND_MESSAGE.GET;
885: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
886: X_CREATION_DATE,char_id_tab(i),
887: operator_tab(i),low_value_tab(i),
888: high_value_tab(i),X_message,

Line 932: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');

928:
929: EXCEPTION
930: WHEN fail_setting_lot_status THEN
931:
932: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');
933: X_message := FND_MESSAGE.GET;
934: X_message := X_message ||X_msg_data;
935:
936: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,

Line 933: X_message := FND_MESSAGE.GET;

929: EXCEPTION
930: WHEN fail_setting_lot_status THEN
931:
932: FND_MESSAGE.SET_NAME('QA', 'QA_LOT_STATUS_ACTION_FAIL');
933: X_message := FND_MESSAGE.GET;
934: X_message := X_message ||X_msg_data;
935:
936: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
937: X_CREATION_DATE,char_id_tab(i),

Line 944: X_message := FND_MESSAGE.GET;

940: result,X_CONCURRENT);
941: WHEN OTHERS THEN
942: -- write exceptions to action log;
943: X_ERROR := FALSE;
944: X_message := FND_MESSAGE.GET;
945: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
946: X_CREATION_DATE,char_id_tab(i),
947: operator_tab(i),low_value_tab(i),
948: high_value_tab(i),X_message,

Line 992: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');

988:
989: EXCEPTION
990: WHEN fail_setting_serial_status THEN
991:
992: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');
993: X_message := FND_MESSAGE.GET;
994: X_message := X_message || X_msg_data;
995:
996: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,

Line 993: X_message := FND_MESSAGE.GET;

989: EXCEPTION
990: WHEN fail_setting_serial_status THEN
991:
992: FND_MESSAGE.SET_NAME('QA', 'QA_SERIAL_STATUS_ACTION_FAIL');
993: X_message := FND_MESSAGE.GET;
994: X_message := X_message || X_msg_data;
995:
996: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
997: X_CREATION_DATE,char_id_tab(i),

Line 1004: X_message := FND_MESSAGE.GET;

1000: result,X_CONCURRENT);
1001: WHEN OTHERS THEN
1002: -- write exceptions to action log;
1003: X_ERROR := FALSE;
1004: X_message := FND_MESSAGE.GET;
1005: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1006: X_CREATION_DATE,char_id_tab(i),
1007: operator_tab(i),low_value_tab(i),
1008: high_value_tab(i),X_message,

Line 1044: X_message := FND_MESSAGE.GET;

1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: -- write exceptions to action log;
1043: X_ERROR := FALSE;
1044: X_message := FND_MESSAGE.GET;
1045: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1046: X_CREATION_DATE,char_id_tab(i),
1047: operator_tab(i),low_value_tab(i),
1048: high_value_tab(i),X_message,

Line 1073: X_message := FND_MESSAGE.GET;

1069: EXCEPTION
1070: WHEN po_api_failed THEN
1071: -- write exceptions to action log;
1072: X_ERROR := FALSE;
1073: X_message := FND_MESSAGE.GET;
1074: X_message := X_message || X_msg_data;
1075: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1076: X_CREATION_DATE,char_id_tab(i),
1077: operator_tab(i),low_value_tab(i),

Line 1119: X_message := FND_MESSAGE.GET;

1115: EXCEPTION
1116: WHEN OTHERS THEN
1117: -- write exceptions to action log;
1118: X_ERROR := FALSE;
1119: X_message := FND_MESSAGE.GET;
1120: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1121: X_CREATION_DATE,char_id_tab(i),
1122: operator_tab(i),low_value_tab(i),
1123: high_value_tab(i),X_message,

Line 1172: X_message := FND_MESSAGE.GET;

1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: -- write exceptions to action log;
1171: X_ERROR := FALSE;
1172: X_message := FND_MESSAGE.GET;
1173: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1174: X_CREATION_DATE,char_id_tab(i),
1175: operator_tab(i),low_value_tab(i),
1176: high_value_tab(i),X_message,

Line 1576: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');

1572:
1573: WHEN null_txn_id THEN
1574: --dbms_output.put_line('x progress is '||to_char(x_progress));
1575: X_ERROR := FALSE;
1576: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');
1577: X_message := FND_MESSAGE.GET;
1578: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1579: X_CREATION_DATE,char_id_tab(i),
1580: operator_tab(i),low_value_tab(i),

Line 1577: X_message := FND_MESSAGE.GET;

1573: WHEN null_txn_id THEN
1574: --dbms_output.put_line('x progress is '||to_char(x_progress));
1575: X_ERROR := FALSE;
1576: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_NULL_TXN_ID');
1577: X_message := FND_MESSAGE.GET;
1578: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1579: X_CREATION_DATE,char_id_tab(i),
1580: operator_tab(i),low_value_tab(i),
1581: high_value_tab(i),X_message,

Line 1587: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');

1583:
1584: WHEN column_missing THEN
1585: --dbms_output.put_line('x progress is '||to_char(x_progress));
1586: X_ERROR := FALSE;
1587: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');
1588: X_message := FND_MESSAGE.GET;
1589: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1590: X_CREATION_DATE,char_id_tab(i),
1591: operator_tab(i),low_value_tab(i),

Line 1588: X_message := FND_MESSAGE.GET;

1584: WHEN column_missing THEN
1585: --dbms_output.put_line('x progress is '||to_char(x_progress));
1586: X_ERROR := FALSE;
1587: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_COL_MISSING');
1588: X_message := FND_MESSAGE.GET;
1589: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1590: X_CREATION_DATE,char_id_tab(i),
1591: operator_tab(i),low_value_tab(i),
1592: high_value_tab(i),X_message,

Line 1598: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');

1594:
1595: WHEN fail_po_insertion THEN
1596: --dbms_output.put_line('x progress is '||to_char(x_progress));
1597: X_ERROR := FALSE;
1598: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');
1599: X_message := FND_MESSAGE.GET;
1600: X_message := X_message || X_msg_data;
1601: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1602: X_CREATION_DATE,char_id_tab(i),

Line 1599: X_message := FND_MESSAGE.GET;

1595: WHEN fail_po_insertion THEN
1596: --dbms_output.put_line('x progress is '||to_char(x_progress));
1597: X_ERROR := FALSE;
1598: FND_MESSAGE.SET_NAME('QA', 'QA_PO_INSP_ACTION_FAIL');
1599: X_message := FND_MESSAGE.GET;
1600: X_message := X_message || X_msg_data;
1601: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1602: X_CREATION_DATE,char_id_tab(i),
1603: operator_tab(i),low_value_tab(i),

Line 1609: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');

1605: result,X_CONCURRENT);
1606:
1607: WHEN fail_serial_insertion THEN
1608: X_ERROR := FALSE;
1609: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');
1610: X_message := FND_MESSAGE.GET;
1611: X_message := X_message || X_msg_data;
1612: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1613: X_CREATION_DATE,char_id_tab(i),

Line 1610: X_message := FND_MESSAGE.GET;

1606:
1607: WHEN fail_serial_insertion THEN
1608: X_ERROR := FALSE;
1609: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_SER_INSERT_FAIL');
1610: X_message := FND_MESSAGE.GET;
1611: X_message := X_message || X_msg_data;
1612: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1613: X_CREATION_DATE,char_id_tab(i),
1614: operator_tab(i),low_value_tab(i),

Line 1620: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');

1616: result,X_CONCURRENT);
1617:
1618: WHEN fail_lot_insertion THEN
1619: X_ERROR := FALSE;
1620: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');
1621: X_message := FND_MESSAGE.GET;
1622: X_message := X_message || X_msg_data;
1623: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1624: X_CREATION_DATE,char_id_tab(i),

Line 1621: X_message := FND_MESSAGE.GET;

1617:
1618: WHEN fail_lot_insertion THEN
1619: X_ERROR := FALSE;
1620: FND_MESSAGE.SET_NAME('QA', 'QA_WMS_LOT_INSERT_FAIL');
1621: X_message := FND_MESSAGE.GET;
1622: X_message := X_message || X_msg_data;
1623: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1624: X_CREATION_DATE,char_id_tab(i),
1625: operator_tab(i),low_value_tab(i),

Line 1634: X_message := FND_MESSAGE.GET;

1630: WHEN OTHERS THEN
1631: --dbms_output.put_line('x progress is '||to_char(x_progress));
1632: -- write exceptions to action log;
1633: X_ERROR := FALSE;
1634: X_message := FND_MESSAGE.GET;
1635: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1636: X_CREATION_DATE,char_id_tab(i),
1637: operator_tab(i),low_value_tab(i),
1638: high_value_tab(i),X_message,

Line 1743: -- build the message for request_log by concatenating fnd_message and user input text message.

1739:
1740: -- get user id
1741: user_id := NVL(FND_PROFILE.VALUE('USER_ID'), 0);
1742:
1743: -- build the message for request_log by concatenating fnd_message and user input text message.
1744:
1745: -- Commented the usage of the cursor get_user_message and added code to use the cursor
1746: -- my_message, as the cursor get_user_message was showing up the message of the first
1747: -- trigger action of an element only in the EAM work requests even though the second or

Line 1762: request_log := fnd_message.get_string('QA', 'QA_WORK_REQUEST_LOG');

1758: OPEN MY_MESSAGE(pca_id_tab(i));
1759: FETCH MY_MESSAGE INTO X_MESSAGE, X_ASSIGN_TYPE;
1760: CLOSE MY_MESSAGE;
1761:
1762: request_log := fnd_message.get_string('QA', 'QA_WORK_REQUEST_LOG');
1763: request_log := request_log || ' ' || x_message;
1764:
1765:
1766:

Line 1941: X_message := FND_MESSAGE.GET;

1937: EXCEPTION
1938: WHEN OTHERS THEN
1939: -- write exceptions to action log;
1940: X_ERROR := FALSE;
1941: X_message := FND_MESSAGE.GET;
1942: INSERT_ACTION_LOG(Y_PLAN_ID,X_COLLECTION_ID,
1943: X_CREATION_DATE,char_id_tab(i),
1944: operator_tab(i),low_value_tab(i),
1945: high_value_tab(i),X_message,