DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_MESSAGE

Line 839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');

835: FETCH l_cur INTO l_rec;
836: IF l_cur%notfound THEN
837: CLOSE l_cur;
838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
843: rollback to approve_address_req;

Line 840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);

836: IF l_cur%notfound THEN
837: CLOSE l_cur;
838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
843: rollback to approve_address_req;
844: RETURN;

Line 850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');

846: CLOSE l_cur;
847:
848: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
854: rollback to approve_address_req;

Line 851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);

847:
848: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
854: rollback to approve_address_req;
855: RETURN;

Line 863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

859: FETCH l_cur2 INTO l_rec2;
860: IF l_cur2%notfound THEN
861: CLOSE l_cur2;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
867: rollback to approve_address_req;

Line 864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

860: IF l_cur2%notfound THEN
861: CLOSE l_cur2;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
867: rollback to approve_address_req;
868: RETURN;

Line 1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');

1003: FETCH l_cur INTO l_rec;
1004: IF l_cur%notfound THEN
1005: CLOSE l_cur;
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1011: rollback to approve_contact_req;

Line 1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);

1004: IF l_cur%notfound THEN
1005: CLOSE l_cur;
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1011: rollback to approve_contact_req;
1012: RETURN;

Line 1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');

1014: CLOSE l_cur;
1015:
1016: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1022: rollback to approve_contact_req;

Line 1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);

1015:
1016: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1022: rollback to approve_contact_req;
1023: RETURN;

Line 1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1027: FETCH l_cur2 INTO l_rec2;
1028: IF l_cur2%notfound THEN
1029: CLOSE l_cur2;
1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1035: rollback to approve_contact_req;

Line 1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1028: IF l_cur2%notfound THEN
1029: CLOSE l_cur2;
1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1035: rollback to approve_contact_req;
1036: RETURN;

Line 1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');

1147: FETCH l_cur INTO l_rec;
1148: IF l_cur%notfound THEN
1149: CLOSE l_cur;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1155: rollback to approve_bus_class_req;

Line 1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);

1148: IF l_cur%notfound THEN
1149: CLOSE l_cur;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1155: rollback to approve_bus_class_req;
1156: RETURN;

Line 1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');

1158: CLOSE l_cur;
1159:
1160: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1166: rollback to approve_bus_class_req;

Line 1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);

1159:
1160: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1166: rollback to approve_bus_class_req;
1167: RETURN;

Line 1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1171: FETCH l_cur2 INTO l_rec2;
1172: IF l_cur2%notfound THEN
1173: CLOSE l_cur2;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1179: rollback to approve_bus_class_req;

Line 1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1172: IF l_cur2%notfound THEN
1173: CLOSE l_cur2;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1179: rollback to approve_bus_class_req;
1180: RETURN;

Line 1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');

1254: FETCH l_cur INTO l_rec;
1255: IF l_cur%notfound THEN
1256: CLOSE l_cur;
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1262: rollback to approve_ps_req;

Line 1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1255: IF l_cur%notfound THEN
1256: CLOSE l_cur;
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1262: rollback to approve_ps_req;
1263: RETURN;

Line 1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');

1265: CLOSE l_cur;
1266:
1267: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1273: rollback to approve_ps_req;

Line 1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1266:
1267: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1273: rollback to approve_ps_req;
1274: RETURN;

Line 1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');

1275: END IF;
1276:
1277: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1283: rollback to approve_ps_req;

Line 1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1276:
1277: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1283: rollback to approve_ps_req;
1284: RETURN;

Line 1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1288: FETCH l_cur2 INTO l_rec2;
1289: IF l_cur2%notfound THEN
1290: CLOSE l_cur2;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1296: rollback to approve_ps_req;

Line 1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1289: IF l_cur2%notfound THEN
1290: CLOSE l_cur2;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1296: rollback to approve_ps_req;
1297: RETURN;