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.INVKBCGN dependencies on FND_MESSAGE

Line 311: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

307: END LOOP;
308: current_error_code := to_char(SQLCODE);
309:
310: if NOT REC then
311: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
312: PUT_LINE( fnd_message.get );
313: current_error_code := to_char(SQLCODE);
314: end if; /* if NOT REC then */
315:

Line 312: PUT_LINE( fnd_message.get );

308: current_error_code := to_char(SQLCODE);
309:
310: if NOT REC then
311: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
312: PUT_LINE( fnd_message.get );
313: current_error_code := to_char(SQLCODE);
314: end if; /* if NOT REC then */
315:
316: -- call to report conc pgm report

Line 398: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

394:
395: END LOOP;
396: current_error_code := to_char(SQLCODE);
397: if NOT REC then
398: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
399: PUT_LINE( fnd_message.get );
400: current_error_code := to_char(SQLCODE);
401: end if;
402:

Line 399: PUT_LINE( fnd_message.get );

395: END LOOP;
396: current_error_code := to_char(SQLCODE);
397: if NOT REC then
398: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
399: PUT_LINE( fnd_message.get );
400: current_error_code := to_char(SQLCODE);
401: end if;
402:
403: -- call to report conc pgm report

Line 641: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

637: End loop;
638: current_error_code := to_char(SQLCODE);
639:
640: if NOT Rec then
641: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
642: PUT_LINE( fnd_message.get );
643: current_error_code := to_char(SQLCODE);
644: end if;
645: if dbms_sql.is_open(d_sql_p) then

Line 642: PUT_LINE( fnd_message.get );

638: current_error_code := to_char(SQLCODE);
639:
640: if NOT Rec then
641: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
642: PUT_LINE( fnd_message.get );
643: current_error_code := to_char(SQLCODE);
644: end if;
645: if dbms_sql.is_open(d_sql_p) then
646: dbms_sql.close_cursor(d_sql_p);

Line 845: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

841: End loop;
842: current_error_code := to_char(SQLCODE);
843:
844: if NOT Rec then
845: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
846: PUT_LINE( fnd_message.get );
847: current_error_code := to_char(SQLCODE);
848: end if;
849: if dbms_sql.is_open(d_sql_p) then

Line 846: PUT_LINE( fnd_message.get );

842: current_error_code := to_char(SQLCODE);
843:
844: if NOT Rec then
845: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
846: PUT_LINE( fnd_message.get );
847: current_error_code := to_char(SQLCODE);
848: end if;
849: if dbms_sql.is_open(d_sql_p) then
850: dbms_sql.close_cursor(d_sql_p);

Line 1049: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

1045: END LOOP;
1046: END IF;
1047: current_error_code := to_char(SQLCODE);
1048: if NOT REC then
1049: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
1050: PUT_LINE( fnd_message.get );
1051: end if;
1052: current_error_code := to_char(SQLCODE);
1053: Exception

Line 1050: PUT_LINE( fnd_message.get );

1046: END IF;
1047: current_error_code := to_char(SQLCODE);
1048: if NOT REC then
1049: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
1050: PUT_LINE( fnd_message.get );
1051: end if;
1052: current_error_code := to_char(SQLCODE);
1053: Exception
1054: when others then

Line 1224: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');

1220: end if;
1221: End loop;
1222: current_error_code := to_char(SQLCODE);
1223: if NOT Rec then
1224: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
1225: PUT_LINE( fnd_message.get );
1226: end if;
1227: current_error_code := to_char(SQLCODE);
1228: if dbms_sql.is_open(d_sql_p) then

Line 1225: PUT_LINE( fnd_message.get );

1221: End loop;
1222: current_error_code := to_char(SQLCODE);
1223: if NOT Rec then
1224: FND_MESSAGE.set_name('INV', 'INV_NO_PULLSEQ_SELECTED');
1225: PUT_LINE( fnd_message.get );
1226: end if;
1227: current_error_code := to_char(SQLCODE);
1228: if dbms_sql.is_open(d_sql_p) then
1229: dbms_sql.close_cursor(d_sql_p);

Line 1472: PUT_LINE( fnd_message.get );

1468: if INV_kanban_PVT.Ok_To_Create_Kanban_Cards(X_Pull_sequence_id ) then
1469: l_create_kanban:=TRUE;
1470: ELSE
1471: l_create_kanban:=FALSE;
1472: PUT_LINE( fnd_message.get );
1473: END IF;
1474: END IF; --end of ekanban profile code by javakat
1475: /*changes made to the if clause to fix bug 11800873*/
1476: --IF l_create_kanban AND l_pull_seq_rec.number_of_cards >0 THEN

Line 1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');

1528: into l_org_code
1529: from mtl_parameters
1530: where ORGANIZATION_ID = X_org_id;
1531:
1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

1529: from mtl_parameters
1530: where ORGANIZATION_ID = X_org_id;
1531:
1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );

Line 1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1530: where ORGANIZATION_ID = X_org_id;
1531:
1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );
1538: else

Line 1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);

1531:
1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );
1538: else
1539: PUT_LINE( fnd_message.get );

Line 1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

1532: FND_MESSAGE.set_name('INV','INV_KANBAN_CARDS_CREATED');
1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );
1538: else
1539: PUT_LINE( fnd_message.get );
1540: end if;

Line 1537: PUT_LINE( fnd_message.get );

1533: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1534: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );
1538: else
1539: PUT_LINE( fnd_message.get );
1540: end if;
1541: Exception

Line 1539: PUT_LINE( fnd_message.get );

1535: FND_MESSAGE.SET_TOKEN('SUB_CODE',X_subinv);
1536: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1537: PUT_LINE( fnd_message.get );
1538: else
1539: PUT_LINE( fnd_message.get );
1540: end if;
1541: Exception
1542: WHEN end_of_code THEN
1543: NULL;

Line 1668: FND_MESSAGE.set_name('INV','INV_NO_LOCATOR_SEGMENTS_FOUND');

1664: end Loop;
1665: X_where := v_where;
1666:
1667: if NOT Rec then
1668: FND_MESSAGE.set_name('INV','INV_NO_LOCATOR_SEGMENTS_FOUND');
1669: PUT_LINE( fnd_message.get );
1670: current_error_code := to_char(SQLCODE);
1671: end if;
1672: Exception

Line 1669: PUT_LINE( fnd_message.get );

1665: X_where := v_where;
1666:
1667: if NOT Rec then
1668: FND_MESSAGE.set_name('INV','INV_NO_LOCATOR_SEGMENTS_FOUND');
1669: PUT_LINE( fnd_message.get );
1670: current_error_code := to_char(SQLCODE);
1671: end if;
1672: Exception
1673: when others then

Line 1761: FND_MESSAGE.set_name('INV','INV_NO_ITEM_SEGMENTS_FOUND');

1757: end Loop;
1758: X_where := v_where;
1759:
1760: if NOT Rec then
1761: FND_MESSAGE.set_name('INV','INV_NO_ITEM_SEGMENTS_FOUND');
1762: PUT_LINE( fnd_message.get );
1763: current_error_code := to_char(SQLCODE);
1764: end if;
1765: Exception

Line 1762: PUT_LINE( fnd_message.get );

1758: X_where := v_where;
1759:
1760: if NOT Rec then
1761: FND_MESSAGE.set_name('INV','INV_NO_ITEM_SEGMENTS_FOUND');
1762: PUT_LINE( fnd_message.get );
1763: current_error_code := to_char(SQLCODE);
1764: end if;
1765: Exception
1766: when others then

Line 1798: FND_MESSAGE.set_name('FLM', 'FLM_SET_NLS_PARAM');

1794: WHERE NSP.parameter = 'NLS_LANGUAGE'
1795: AND NSP.value = FL.nls_language;
1796: EXCEPTION
1797: WHEN NO_DATA_FOUND THEN
1798: FND_MESSAGE.set_name('FLM', 'FLM_SET_NLS_PARAM');
1799: fnd_file.put_line(fnd_file.log, fnd_message.get);
1800: END;
1801:
1802: l_add_layout := fnd_request.add_layout ('INV', 'INVKBCPR_XML', l_language, l_territory, 'RTF');

Line 1799: fnd_file.put_line(fnd_file.log, fnd_message.get);

1795: AND NSP.value = FL.nls_language;
1796: EXCEPTION
1797: WHEN NO_DATA_FOUND THEN
1798: FND_MESSAGE.set_name('FLM', 'FLM_SET_NLS_PARAM');
1799: fnd_file.put_line(fnd_file.log, fnd_message.get);
1800: END;
1801:
1802: l_add_layout := fnd_request.add_layout ('INV', 'INVKBCPR_XML', l_language, l_territory, 'RTF');
1803: ELSE

Line 1834: PUT_LINE( fnd_message.get );

1830: NULL, /* p_kanban_card_id */
1831: X_REPORT_ID /* p_report_id */
1832: );
1833:
1834: PUT_LINE( fnd_message.get );
1835: if v_req_id = 0 then
1836: delete from MTL_KANBAN_CARD_PRINT_TEMP
1837: where
1838: report_id = X_REPORT_ID;

Line 2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');

2092: from mtl_kanban_pull_sequences where pull_sequence_id = p_Pull_sequence_id;
2093:
2094: if ( (l_plan_eff_date <= trunc(sysdate) and nvl(l_future_size,nvl(l_size,0)) = 0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_size,0)=0) ) then
2095: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

2093:
2094: if ( (l_plan_eff_date <= trunc(sysdate) and nvl(l_future_size,nvl(l_size,0)) = 0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_size,0)=0) ) then
2095: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2101: X_return_msg:= fnd_message.get;

Line 2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

2094: if ( (l_plan_eff_date <= trunc(sysdate) and nvl(l_future_size,nvl(l_size,0)) = 0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_size,0)=0) ) then
2095: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2101: X_return_msg:= fnd_message.get;
2102: X_return_status:='E';

Line 2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

2095: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2101: X_return_msg:= fnd_message.get;
2102: X_return_status:='E';
2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then

Line 2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

2096: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2101: X_return_msg:= fnd_message.get;
2102: X_return_status:='E';
2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then
2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);

Line 2101: X_return_msg:= fnd_message.get;

2097: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2098: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2099: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2100: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2101: X_return_msg:= fnd_message.get;
2102: X_return_status:='E';
2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then
2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');

Line 2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');

2101: X_return_msg:= fnd_message.get;
2102: X_return_status:='E';
2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then
2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

2102: X_return_status:='E';
2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then
2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2110: X_return_msg:= fnd_message.get;

Line 2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

2103: elsif ((l_plan_eff_date <= trunc(sysdate) and nvl(l_future_num_card,nvl(l_num_card,0)) =0) or (l_plan_eff_date > trunc(sysdate) and nvl(l_num_card,0)=0)) then
2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2110: X_return_msg:= fnd_message.get;
2111: X_return_status:='E';

Line 2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

2104: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2110: X_return_msg:= fnd_message.get;
2111: X_return_status:='E';
2112: else

Line 2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

2105: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2110: X_return_msg:= fnd_message.get;
2111: X_return_status:='E';
2112: else
2113: INVKBCGN.create_kanban_cards(

Line 2110: X_return_msg:= fnd_message.get;

2106: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2107: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2108: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2109: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2110: X_return_msg:= fnd_message.get;
2111: X_return_status:='E';
2112: else
2113: INVKBCGN.create_kanban_cards(
2114: errbuf => l_error_msg

Line 2147: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN');

2143: --Read variable no_of_cards_created
2144: If no_of_cards_created >0 AND TRUNC(l_ret_code )=1 THEN
2145: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2146: If p_print_cards = 2 then
2147: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN');
2148: else
2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');
2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);

Line 2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');

2145: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2146: If p_print_cards = 2 then
2147: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN');
2148: else
2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');
2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

Line 2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);

2147: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN');
2148: else
2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');
2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

2148: else
2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');
2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2156: X_return_msg:= fnd_message.get;

Line 2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

2149: FND_MESSAGE.set_name('FLM','FLM_NUM_CARDS_GEN_AND_PRINT');
2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2156: X_return_msg:= fnd_message.get;
2157: X_return_status:='S';

Line 2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

2150: end if;
2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2156: X_return_msg:= fnd_message.get;
2157: X_return_status:='S';
2158: END IF;

Line 2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

2151: FND_MESSAGE.SET_TOKEN('NUM',no_of_cards_created);
2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2156: X_return_msg:= fnd_message.get;
2157: X_return_status:='S';
2158: END IF;
2159: --Bug#16058961-Added less than condition

Line 2156: X_return_msg:= fnd_message.get;

2152: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2153: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2154: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2155: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2156: X_return_msg:= fnd_message.get;
2157: X_return_status:='S';
2158: END IF;
2159: --Bug#16058961-Added less than condition
2160: If no_of_cards_created <=0 AND TRUNC(l_ret_code )=1 THEN

Line 2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');

2158: END IF;
2159: --Bug#16058961-Added less than condition
2160: If no_of_cards_created <=0 AND TRUNC(l_ret_code )=1 THEN
2161: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');
2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

2159: --Bug#16058961-Added less than condition
2160: If no_of_cards_created <=0 AND TRUNC(l_ret_code )=1 THEN
2161: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');
2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2167: X_return_msg:= fnd_message.get;

Line 2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

2160: If no_of_cards_created <=0 AND TRUNC(l_ret_code )=1 THEN
2161: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');
2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2167: X_return_msg:= fnd_message.get;
2168: X_return_status:='S';

Line 2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

2161: Get_Pull_sequence_Tokens(p_Pull_sequence_id,l_org_code,l_item_name,l_subinventory,l_loc_name);
2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');
2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2167: X_return_msg:= fnd_message.get;
2168: X_return_status:='S';
2169: END IF;

Line 2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

2162: FND_MESSAGE.set_name('FLM','FLM_NO_CARDS_GEN');
2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2167: X_return_msg:= fnd_message.get;
2168: X_return_status:='S';
2169: END IF;
2170: End if;

Line 2167: X_return_msg:= fnd_message.get;

2163: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
2164: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
2165: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
2166: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
2167: X_return_msg:= fnd_message.get;
2168: X_return_status:='S';
2169: END IF;
2170: End if;
2171: EXCEPTION

Line 2173: FND_MESSAGE.set_name('FLM','FLM_GEN_CARD_AFT_PS_SAVE');

2169: END IF;
2170: End if;
2171: EXCEPTION
2172: WHEN NO_DATA_FOUND THEN
2173: FND_MESSAGE.set_name('FLM','FLM_GEN_CARD_AFT_PS_SAVE');
2174: X_return_msg:= fnd_message.get;
2175: X_return_status:='E';
2176: WHEN OTHERS THEN
2177: X_return_msg:= 'Unhandled exception while generating cards : '||sqlerrm(sqlcode);

Line 2174: X_return_msg:= fnd_message.get;

2170: End if;
2171: EXCEPTION
2172: WHEN NO_DATA_FOUND THEN
2173: FND_MESSAGE.set_name('FLM','FLM_GEN_CARD_AFT_PS_SAVE');
2174: X_return_msg:= fnd_message.get;
2175: X_return_status:='E';
2176: WHEN OTHERS THEN
2177: X_return_msg:= 'Unhandled exception while generating cards : '||sqlerrm(sqlcode);
2178: X_return_status:='E';